PA Purchase Order Line History (PA30601)

azurecurveProductsProject Accounting (258)ProjectPA Purchase Order Line History (PA30601)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30601

Product: Project Accounting (258)
Series: Project

Display Name: PA Purchase Order Line History
Physical Name: PA30601
Technical Name: PA_PO_HIST_LINE

Group Display Name: PA Purchasing History
Group Technical Name: PA Purchasing History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PApurordnum SearchPA Purchase Order No.STR17_LBAUString1817
2ORD SearchOrdLI_Sequence_NumberLong Integer410
3BRKFLD1 SearchBreak Field 1INT1Integer21
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['PA Purchase Order Line History'].ITEMNMBR AS 'PA Purchase Order Line History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Purchase Order Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR
5VNDITNUM SearchVendor Item NumberItem_NumberString3230
6BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
7Capital_Item SearchCapital ItemCB_Capital_ItemBoolean20
8CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Purchase Order Line History'].CURNCYID AS 'PA Purchase Order Line History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Purchase Order Line History'].CURNCYID = ['Currency Setup'].CURNCYID
9DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
10XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
11FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
12ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Purchase Order Line History'].ITMTSHID AS 'PA Purchase Order Line History-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Purchase Order Line History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
14MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
15OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
16ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
17OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
18ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
19PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
20PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean20
21PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
22PACogs_Idx SearchPA COGS IDXLI_14Long Integer414
23PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
24PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
25PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
26PAprojname SearchPA Project NameSTR30_PTBS Description 1String3230
27PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
28PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
29PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
30PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
31PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer414
32PRICELVL SearchPrice LevelSTR15_LBAUString1615
33QTYCMTBASE SearchQTY Committed In BaseDLR17_QTY_RBS0_STRCurrency1017
34QTYUNCMTBASE SearchQTY Uncommitted In BaseDLR17_QTY_RBS0_STRCurrency1017
35RATECALC SearchRate Calc MethodINTInteger20
36TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
37DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)ProjectPA Purchase Order Line History (PA30601)

Leave a Reply

Your email address will not be published. Required fields are marked *