Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30601
Product: Project Accounting (258)
Series:
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. | String | STR17_LBAU | 17 | |
2 | ORD ![]() | Ord | Long Integer | LI_Sequence_Number | 10 | |
3 | BRKFLD1 ![]() | Break Field 1 | Integer | INT1 | 1 | |
4 | ITEMNMBR ![]() | Item Number | String | STR30_Item_Number | 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 | String | Item_Number | 30 | |
6 | BackoutTradeDiscTax ![]() | Backout Trade Discount Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
7 | Capital_Item ![]() | Capital Item | Boolean | CB_Capital_Item | 0 | |
8 | CURNCYID ![]() | Currency ID | String | STR15_Currency_ID | 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 | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
10 | XCHGRATE ![]() | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
11 | FRTAMNT ![]() | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
12 | ITMTSHID ![]() | Item Tax Schedule ID | String | STR15_LBAU | 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 | Integer | DDL_Track | 0 | |
14 | MSCCHAMT ![]() | Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
15 | OrigBackoutTradeDiscTax ![]() | Originating Backout Trade Discount Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
16 | ORFRTAMT ![]() | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
17 | OMISCAMT ![]() | Originating Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
18 | ORTDISAM ![]() | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
19 | PAbillnoteidx ![]() | PA Billing Note Index | Currency | DLR14 | 14 | |
20 | PACBADDFRMFLY ![]() | PA CB From Add On The Fly | Boolean | CB | 0 | |
21 | PACHGORDNO ![]() | PA Change Order Number | String | STR17_LBAU | 17 | |
22 | PACogs_Idx ![]() | PA COGS IDX | Long Integer | LI_14 | 14 | |
23 | PACOSTCATID ![]() | PA Cost Category ID | String | STR15_Cost_Category_ID | 15 | |
24 | PAIV_Item_Checkbox ![]() | PA IV Item Checkbox | Boolean | PA_CB_IV_Item | 0 | |
25 | PALineItemSeq ![]() | PA Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
26 | PAprojname ![]() | PA Project Name | String | STR30_PTBS Description 1 | 30 | |
27 | PAPROJNUMBER ![]() | PA Project Number | String | STR15_LBAU | 15 | |
28 | PAProjectType ![]() | PA Project Type | Integer | PA_DDL_Project_Type | 0 | |
29 | PAPurchase_Tax_Options ![]() | PA Purchase Tax Options | Integer | PA_DDL_Tax_Options_Purchase | 0 | |
30 | PATU ![]() | PA Transaction Usage | Integer | PA_DDL_Transaction_Usage | 0 | |
31 | PACGBWIPIDX ![]() | PA WIP IDX | Long Integer | LI_14 | 14 | |
32 | PRICELVL ![]() | Price Level | String | STR15_LBAU | 15 | |
33 | QTYCMTBASE ![]() | QTY Committed In Base | Currency | DLR17_QTY_RBS0_STR | 17 | |
34 | QTYUNCMTBASE ![]() | QTY Uncommitted In Base | Currency | DLR17_QTY_RBS0_STR | 17 | |
35 | RATECALC ![]() | Rate Calc Method | Integer | INT | 0 | |
36 | TRDISAMT ![]() | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 |