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 TypeLength
1PApurordnum SearchPA Purchase Order No.STR17_LBAUString17
2ORD SearchOrdLI_Sequence_NumberLong Integer10
3BRKFLD1 SearchBreak Field 1INT1Integer1
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_NumberString30
6BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
7Capital_Item SearchCapital ItemCB_Capital_ItemBoolean0
8CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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)14
10XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
11FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
12ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_TrackInteger0
14MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
15OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
16ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
17OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
18ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
19PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
20PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean0
21PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
22PACogs_Idx SearchPA COGS IDXLI_14Long Integer14
23PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
24PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean0
25PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
26PAprojname SearchPA Project NameSTR30_PTBS Description 1String30
27PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
28PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
29PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
30PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
31PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
32PRICELVL SearchPrice LevelSTR15_LBAUString15
33QTYCMTBASE SearchQTY Committed In BaseDLR17_QTY_RBS0_STRCurrency17
34QTYUNCMTBASE SearchQTY Uncommitted In BaseDLR17_QTY_RBS0_STRCurrency17
35RATECALC SearchRate Calc MethodINTInteger0
36TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
37DEX_ROW_ID Searchintint10

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 *