PA PO Receipt Line (PA10702)

azurecurve Products Project Accounting (258)ProjectPA PO Receipt Line (PA10702)

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
Physical Name: PA10702
Technical Name: PA_PO_ReceiptLine

Group Display Name: PA Purchasing Transactions
Group Technical Name: PA Purchasing Transactions

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

azurecurve Products Project Accounting (258)ProjectPA PO Receipt Line (PA10702)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply