Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA10702
Product: Project Accounting (258)
Series: Project
Display Name: PA PO Receipt Line Group Display Name: PA Purchasing Transactions
Physical Name: PA10702
Technical Name: PA_PO_ReceiptLine
Group Technical Name: PA Purchasing Transactions
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | PAVIDN ![]() | PA Vendor Invoice Document No. | STR17_LBAU | String | 18 | 17 |
2 | RCPTLNNM ![]() | Receipt Line Number | LI_Sequence_Number | Long Integer | 4 | 10 |
3 | PApurordnum ![]() | PA Purchase Order No. | STR17_LBAU | String | 18 | 17 |
4 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 32 | 30 |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['PA PO Receipt Line'].ITEMNMBR AS 'PA PO Receipt Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['PA PO Receipt Line'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
5 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA PO Receipt Line'].CURRNIDX AS 'PA PO Receipt Line-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA PO Receipt Line'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
6 | DATEVAL ![]() | DateValue | DATE | Date | 4 | 6 |
7 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
8 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 4 | 6 |
9 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
10 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 16 | 15 |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['PA PO Receipt Line'].EXGTBLID AS 'PA PO Receipt Line-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PA PO Receipt Line'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
11 | ITMTSHID ![]() | Item Tax Schedule ID | STR15_LBAU | String | 16 | 15 |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA PO Receipt Line'].ITMTSHID AS 'PA PO Receipt Line-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA PO Receipt Line'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
12 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 2 | 1 |
13 | ORD ![]() | Ord | LI_Sequence_Number | Long Integer | 4 | 10 |
14 | ORTDISAM ![]() | Originating Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
15 | PAAcctgMethod ![]() | PA Accounting Method | PA_DDL_Accounting_Method | Integer | 2 | 0 |
16 | PAACREV ![]() | PA Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
17 | PA_Base_Billing_Rate ![]() | PA Base Billing Rate | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
18 | PABaseOvhdCost ![]() | PA Base Overhead Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
19 | PABase_Qty ![]() | PA Base Qty | PA_DLR15_RBS0_STR | Currency | 10 | 15 |
20 | PABase_Unit_Cost ![]() | PA Base Unit Cost | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
21 | PAbillnoteidx ![]() | PA Billing Note Index | DLR14 | Currency | 10 | 14 |
22 | PABILRATE ![]() | PA Billing Rate | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
23 | PABilling_StatusN ![]() | PA Billing Status | DDL_Billing_Status | Integer | 2 | 0 |
24 | PAbllngtype ![]() | PA Billing Type | PA_DDL_Billing_Type | Integer | 2 | 0 |
25 | PACBADDFRMFLY ![]() | PA CB From Add On The Fly | CB | Boolean | 2 | 0 |
26 | PACHGORDNO ![]() | PA Change Order Number | STR17_LBAU | String | 18 | 17 |
27 | PACogs_Idx ![]() | PA COGS IDX | LI_14 | Long Integer | 4 | 14 |
28 | PAContra_Account_IDX ![]() | PA Contra Account IDX | LI_14 | Long Integer | 4 | 14 |
29 | PACONTNUMBER ![]() | PA Contract Number | STR10_LBAU | String | 12 | 10 |
30 | PACOSTCATID ![]() | PA Cost Category ID | STR15_Cost_Category_ID | String | 16 | 15 |
31 | PACOSTCATNME ![]() | PA Cost Category Name | STR30_PTBS Description 1 | String | 32 | 30 |
32 | PAIV_Item_Checkbox ![]() | PA IV Item Checkbox | PA_CB_IV_Item | Boolean | 2 | 0 |
33 | PALineItemSeq ![]() | PA Line Item Sequence | LI_Sequence_Number | Long Integer | 4 | 10 |
34 | PAMARKPERCENT ![]() | PA Markup Percentage | DLR5_%2 | Currency | 10 | 8 |
35 | PA_MC_Accrued_Revenue ![]() | PA MC Accrued Revenue | PA_DLR17_RBS0_UTR$ | Currency | 10 | 17 |
36 | PA_MC_Base_Billing_Rate ![]() | PA MC Base Billing Rate | PA_DLR17_RBS0_UTR$ | Currency | 10 | 17 |
37 | PA_MC_Billing_Rate ![]() | PA MC Billing Rate | PA_DLR17_RBS0_UTR$ | Currency | 10 | 17 |
38 | PAMCCURNCYID ![]() | PA MC Currency ID | STR15_Currency_ID | String | 16 | 15 |
39 | PA_MC_VarianceAccruedRev ![]() | PA MC Variance Accrued Revenues | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
40 | PAORIACCRREV ![]() | PA Originating Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
41 | PAORIGBASEOVRHCST ![]() | PA Originating Base Overhead Cost | DLR15_RBU$2 | Currency | 10 | 15 |
42 | PAORIGBILLRATE ![]() | PA Originating Billing Rate | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
43 | PAORIGOVHDAMT ![]() | PA Originating Overhead Amount | DLR15_RBU$2 | Currency | 10 | 15 |
44 | PAORIGPROFAMT ![]() | PA Originating Profit Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
45 | PAOrigSEC ![]() | PA Originating Shipment Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
46 | PAORIGTOTOVRHD ![]() | PA Originating Total Overhead | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
47 | PAORIGTOTPROF ![]() | PA Originating Total Profit | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
48 | PAOrigVarExt ![]() | PA Originating Variance Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
49 | PAOverhead_Amount ![]() | PA Overhead Amount | DLR15_RBU$2 | Currency | 10 | 15 |
50 | PAOverhead_IDX ![]() | PA Overhead IDX | LI_14 | Long Integer | 4 | 14 |
51 | PAOverheaPercentage ![]() | PA Overhead Percentage | DLR5_%2 | Currency | 10 | 8 |
52 | PAPO_Line_Errors ![]() | PA PO Line Errors | ML_PO_Line_Errors | Long Integer | 4 | 0 |
53 | PAProfitAmount ![]() | PA Profit Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
54 | PAProfitPercent ![]() | PA Profit Percent | DLR5_%2 | Currency | 10 | 8 |
55 | PAProfitType ![]() | PA Profit Type | PA_DDL_Profit_Type | Integer | 2 | 0 |
56 | PAPROJNUMBER ![]() | PA Project Number | STR15_LBAU | String | 16 | 15 |
57 | PAProjectType ![]() | PA Project Type | PA_DDL_Project_Type | Integer | 2 | 0 |
58 | PAPurchase_Tax_Options ![]() | PA Purchase Tax Options | PA_DDL_Tax_Options_Purchase | Integer | 2 | 0 |
59 | PAShipmentExtCost ![]() | PA Shipment Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
60 | PATOTALOVERH ![]() | PA Total Overhead | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
61 | PATotalProfit ![]() | PA Total Profit | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
62 | PATU ![]() | PA Transaction Usage | PA_DDL_Transaction_Usage | Integer | 2 | 0 |
63 | PAUnbilled_AR_Idx ![]() | PA Unbilled AR IDX | LI_14 | Long Integer | 4 | 14 |
64 | PAUnbilled_Proj_Rev_Idx ![]() | PA Unbilled Proj Rev IDX | LI_14 | Long Integer | 4 | 14 |
65 | PAUD1 ![]() | PA User Defined 1 | STR20 | String | 22 | 20 |
66 | PAUD2 ![]() | PA User Defined 2 | STR20 | String | 22 | 20 |
67 | PA_Variance_Cost ![]() | PA Variance Cost | Boolean | Boolean | 2 | 0 |
68 | PA_Variance_Accrued_Reve ![]() | PA Variance Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
69 | PA_Variance_QTY_Accrued_ ![]() | PA Variance QTY Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
70 | PACGBWIPIDX ![]() | PA WIP IDX | LI_14 | Long Integer | 4 | 14 |
71 | POTYPE ![]() | PO Type | DDL_POP_PO_Type | Integer | 2 | 0 |
72 | POPTYPE ![]() | POP Type | DDL_POP_Type | Integer | 2 | 0 |
73 | PRICELVL ![]() | Price Level | STR15_LBAU | String | 16 | 15 |
74 | RATECALC ![]() | Rate Calc Method | INT | Integer | 2 | 0 |
75 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 15 |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PA PO Receipt Line'].RATETPID AS 'PA PO Receipt Line-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PA PO Receipt Line'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
76 | receiptdate ![]() | Receipt Date | DT | Date | 4 | 8 |
77 | TIME1 ![]() | Time | TM6 | Time | 4 | 6 |
78 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
79 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 12 | 10 |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['PA PO Receipt Line'].UOMSCHDL AS 'PA PO Receipt Line-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA PO Receipt Line'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
80 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 16 | 15 |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PA PO Receipt Line'].VENDORID AS 'PA PO Receipt Line-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PA10702 AS ['PA PO Receipt Line']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA PO Receipt Line'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
81 | DEX_ROW_ID ![]() | int | int | 10 | 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. |