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 Group Display Name: PA Purchasing History
Physical Name: PA30601
Technical Name: PA_PO_HIST_LINE
Group Technical Name: PA Purchasing History
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PApurordnum  | PA Purchase Order No. | STR17_LBAU | String | 17 | |
| 2 | ORD | Ord | LI_Sequence_Number | Long Integer | 10 | |
| 3 | BRKFLD1 | Break Field 1 | INT1 | Integer | 1 | |
| 4 | ITEMNMBR | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['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 | ||||||
| 5 | VNDITNUM | Vendor Item Number | Item_Number | String | 30 | |
| 6 | BackoutTradeDiscTax | Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 7 | Capital_Item | Capital Item | CB_Capital_Item | Boolean | 0 | |
| 8 | CURNCYID | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
| 9 | DENXRATE | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 10 | XCHGRATE | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 11 | FRTAMNT | Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 12 | ITMTSHID | Item Tax Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 13 | ITMTRKOP | Item Tracking Option | DDL_Track | Integer | 0 | |
| 14 | MSCCHAMT | Misc Charges Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 15 | OrigBackoutTradeDiscTax | Originating Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 16 | ORFRTAMT | Originating Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 17 | OMISCAMT | Originating Misc Charges Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 18 | ORTDISAM | Originating Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 19 | PAbillnoteidx | PA Billing Note Index | DLR14 | Currency | 14 | |
| 20 | PACBADDFRMFLY | PA CB From Add On The Fly | CB | Boolean | 0 | |
| 21 | PACHGORDNO | PA Change Order Number | STR17_LBAU | String | 17 | |
| 22 | PACogs_Idx | PA COGS IDX | LI_14 | Long Integer | 14 | |
| 23 | PACOSTCATID | PA Cost Category ID | STR15_Cost_Category_ID | String | 15 | |
| 24 | PAIV_Item_Checkbox | PA IV Item Checkbox | PA_CB_IV_Item | Boolean | 0 | |
| 25 | PALineItemSeq | PA Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
| 26 | PAprojname | PA Project Name | STR30_PTBS Description 1 | String | 30 | |
| 27 | PAPROJNUMBER | PA Project Number | STR15_LBAU | String | 15 | |
| 28 | PAProjectType | PA Project Type | PA_DDL_Project_Type | Integer | 0 | |
| 29 | PAPurchase_Tax_Options | PA Purchase Tax Options | PA_DDL_Tax_Options_Purchase | Integer | 0 | |
| 30 | PATU | PA Transaction Usage | PA_DDL_Transaction_Usage | Integer | 0 | |
| 31 | PACGBWIPIDX | PA WIP IDX | LI_14 | Long Integer | 14 | |
| 32 | PRICELVL | Price Level | STR15_LBAU | String | 15 | |
| 33 | QTYCMTBASE | QTY Committed In Base | DLR17_QTY_RBS0_STR | Currency | 17 | |
| 34 | QTYUNCMTBASE | QTY Uncommitted In Base | DLR17_QTY_RBS0_STR | Currency | 17 | |
| 35 | RATECALC | Rate Calc Method | INT | Integer | 0 | |
| 36 | TRDISAMT | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
| 37 | DEX_ROW_ID | int | int | 10 | ||
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. | ||||||