PA Equipment Log Detail History File (PA30201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30201

Product: Project Accounting (258)
Series: Project

Display Name: PA Equipment Log Detail History File
Physical Name: PA30201
Technical Name: PA_Equipment_Log_LINE_HIST

Group Display Name: PA Equipment Log Transactions History
Group Technical Name: PA Equipment Log Transactions History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PAEQLTRX	PA Equipment Log TRX Type	PA_DDL_EL_Trx_Typ	Integer	2	0
2	PAEQLOGNO	PA Equipment Log No.	STR17_LBAU	String	18	17
3	PAREFNO	PA Reference Document No.	STR17_LBAU	String	18	17
4	PAEQUIPTID	PA Equipment ID	STR15_Equipment_ID	String	16	15
5	PADT	PA Date	PA_Date	Date	4	8
6	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
7	PACOSTCATID	PA Cost Category ID	STR15_Cost_Category_ID	String	16	15
8	PATB	PA Time Begin	TM6	Time	4	6
9	PATE	PA Time End	TM6	Time	4	6
10	PAQtyQ	PA Quantity	PA_DLR15_RBS0_STR	Currency	10	15
11	PABase_Qty	PA Base Qty	PA_DLR15_RBS0_STR	Currency	10	15
12	PAUnit_of_Measure	PA Unit of Measure	U_Of_M	String	10	8
13	UOMSCHDL	U Of M Schedule	STR10_Schedule	String	12	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['PA Equipment Log Detail History File'].UOMSCHDL AS 'PA Equipment Log Detail History File-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM PA30201 AS ['PA Equipment Log Detail History File'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['PA Equipment Log Detail History File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
14	PAROUNDAMT	PA Round Amount	PA_DLR17_RBS0_STR$	Currency	10	17
15	PAUNITCOST	PA Unit Cost	PA_DLR17_RBS0_UTR$	Currency	10	17
16	ORUNTCST	Originating Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
17	PABase_Unit_Cost	PA Base Unit Cost	PA_DLR17_RBS0_STR$	Currency	10	17
18	PAORGBSUNITCST	PA Originating Base Unit Cost	PA_DLR17_RBS0_STR$	Currency	10	17
19	PAOverhead_Amount	PA Overhead Amount	DLR15_RBU$2	Currency	10	15
20	PABaseOvhdCost	PA Base Overhead Cost	DLR17_RBS0_UTR$	Currency	10	17
21	PAORIGOVHDAMT	PA Originating Overhead Amount	DLR15_RBU$2	Currency	10	15
22	PAORIGBASEOVRHCST	PA Originating Base Overhead Cost	DLR15_RBU$2	Currency	10	15
23	PAOverheaPercentage	PA Overhead Percentage	DLR5_%2	Currency	10	8
24	PATOTALOVERH	PA Total Overhead	DLR17_RBS0_UTR$	Currency	10	17
25	PAORIGTOTOVRHD	PA Originating Total Overhead	DLR17_RBS0_UTR$	Currency	10	17
26	PAEXTCOST	PA Extended Cost	PA_DLR17_RBS0_STR$	Currency	10	17
27	OREXTCST	Originating Extended Cost	DLR17_RBS0_UTR$	Currency	10	17
28	PATOTCST	PA Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
29	PAORIGTOTCOST	PA Originating Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
30	PABILRATE	PA Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
31	PAORIGBILLRATE	PA Originating Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
32	PA_Base_Billing_Rate	PA Base Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
33	PAORIGBSBILLRTE	PA Originating Base Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
34	PAMARKPERCENT	PA Markup Percentage	DLR5_%2	Currency	10	8
35	PAACREV	PA Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
36	PAORIACCRREV	PA Originating Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
37	PASTD_Qty	PA STD Qty	PA_DLR15_RBS0_STR	Currency	10	15
38	PANC_Qty	PA NC Qty	PA_DLR15_RBS0_STR	Currency	10	15
39	PASplit_NC	PA Split NC Qty	DLR15_RBU2	Currency	10	15
40	PANB_Qty	PA NB Qty	PA_DLR15_RBS0_STR	Currency	10	15
41	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
42	PAReference_Line_Seq_N	PA Reference Line Seq No	LI_Sequence_Number	Long Integer	4	10
43	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
44	PAbllngtype	PA Billing Type	PA_DDL_Billing_Type	Integer	2	0
45	PACONTNUMBER	PA Contract Number	STR10_LBAU	String	12	10
46	PAexptdate	PA Export Date	PA_Date	Date	4	8
47	PABilled_QtyN	PA Billed Qty	PA_DLR15_RBS0_STR	Currency	10	15
48	PABilledTax	PA Billed Tax	DLR17_RBS0_STR$	Currency	10	17
49	PABilled_Misc	PA Billed Misc	DLR17_RBS0_UTR$	Currency	10	17
50	PAProfitType	PA Profit Type	PA_DDL_Profit_Type	Integer	2	0
51	PAProfitAmount	PA Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
52	PAORIGPROFAMT	PA Originating Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
53	PAProfitPercent	PA Profit Percent	DLR5_%2	Currency	10	8
54	PATotalProfit	PA Total Profit	DLR17_RBS0_UTR$	Currency	10	17
55	PAORIGTOTPROF	PA Originating Total Profit	DLR17_RBS0_UTR$	Currency	10	17
56	PAApproved_Quantity	PA Approved Quantity	PA_DLR15_RBS0_STR	Currency	10	15
57	PAAPPROVBILLRATE	PA Approved Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
58	PAAPPROVMKUPPCT	PA Approved Markup Percentage	DLR5_%2	Currency	10	8
59	PAApproved_Billing_Amou	PA Approved Billing Amount	DLR17_RBSO_STR$	Currency	10	17
60	PA_Billed_Profit_Amount_	PA Billed Profit Amount Average	DLR17_RBS0_UTR$	Currency	10	17
61	PABilledProfitPercentage	PA Billed Profit Percentage Average	DLR5_%2	Currency	10	8
62	PABilled_Amount	PA Billed Amount	DLR17_RBS0_UTR$	Currency	10	17
63	PABilled_Freight	PA Billed Freight	DLR17_RBS0_UTR$	Currency	10	17
64	PABilled_Discount	PA Billed Discount	DLR17_RBS0_UTR$	Currency	10	17
65	PAWrite_UpDown_Amount	PA Write Up/Down Amount	PA_DLR17_RBS0_STR$	Currency	10	17
66	PAWrite_UpDown_Percenta	PA Write Up/Down Percentage	PA_LI5_%2S	Long Integer	4	5
67	PAApprover_ID	PA Approver ID	STR15	String	16	15
68	PAApprover_Type	PA Approver Type	DDL_Approver_Type	Integer	2	0
69	PAPartial_Bill	PA Partial Bill	CB	Boolean	2	0
70	PABilling_StatusN	PA Billing Status	DDL_Billing_Status	Integer	2	0
71	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	4	14
72	PAUnbilled_AR_Idx	PA Unbilled AR IDX	LI_14	Long Integer	4	14
73	PAUnbilled_Proj_Rev_Idx	PA Unbilled Proj Rev IDX	LI_14	Long Integer	4	14
74	PAOverhead_IDX	PA Overhead IDX	LI_14	Long Integer	4	14
75	PAContra_Account_IDX	PA Contra Account IDX	LI_14	Long Integer	4	14
76	PACogs_Idx	PA COGS IDX	LI_14	Long Integer	4	14
77	RNDDIFF	Rounding Difference	LI_14	Long Integer	4	14
78	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	18	17
79	PACBADDFRMFLY	PA CB From Add On The Fly	CB	Boolean	2	0
80	PA_Billed_Status	PA Billed Status	CB	Boolean	2	0
81	PAMCCURNCYID	PA MC Currency ID	STR15_Currency_ID	String	16	15
82	PA_MC_Billing_Rate	PA MC Billing Rate	PA_DLR17_RBS0_UTR$	Currency	10	17
83	PA_MC_Base_Billing_Rate	PA MC Base Billing Rate	PA_DLR17_RBS0_UTR$	Currency	10	17
84	PA_MC_Accrued_Revenue	PA MC Accrued Revenue	PA_DLR17_RBS0_UTR$	Currency	10	17
85	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Equipment Log Detail History File'].CURRNIDX AS 'PA Equipment Log Detail History File-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PA30201 AS ['PA Equipment Log Detail History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Equipment Log Detail History File'].CURRNIDX = ['Currency Setup'].CURRNIDX
86	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['PA Equipment Log Detail History File'].RATETPID AS 'PA Equipment Log Detail History File-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM PA30201 AS ['PA Equipment Log Detail History File'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['PA Equipment Log Detail History File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
87	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['PA Equipment Log Detail History File'].EXGTBLID AS 'PA Equipment Log Detail History File-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM PA30201 AS ['PA Equipment Log Detail History File'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['PA Equipment Log Detail History File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
88	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
89	EXCHDATE	Exchange Date	DT_Date	Date	4	6
90	TIME1	Time	TM6	Time	4	6
91	RATECALC	Rate Calc Method	INT	Integer	2	0
92	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
93	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
94	Correcting_Trx_Type	Correcting Trx Type	INT	Integer	2	0
95	PAORIGINLDOCNUM	PA Original Document Number	STR17_LBAU	String	18	17
96	PAORIGLINEIMSEQ	PA Original Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
97	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.

azurecurve Products Project Accounting (258)ProjectPA Equipment Log Detail History File (PA30201)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply