PA Equipment Log Header History File (PA30200)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Equipment Log Header History File
Physical Name: PA30200
Technical Name: PA_Equipment_Log_HDR_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	PADOCDT	PA Document Date	PA_Date	Date	4	8
4	PAYR	PA Year	INT4	Integer	2	4
5	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Equipment Log Header History File'].USERID AS 'PA Equipment Log Header History File-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Equipment Log Header History File'].USERID = ['Users Master'].USERID
6	BACHNUMB	Batch Number	STR15_LBAU	String	16	15
7	BCHSOURC	Batch Source	STR15	String	16	15
8	TRXSORCE	TRX Source	STR13	String	14	13
9	PAREFNO	PA Reference Document No.	STR17_LBAU	String	18	17
10	PAEQUIPTID	PA Equipment ID	STR15_Equipment_ID	String	16	15
11	PAREPD	PA Reporting Period	INT3	Integer	2	3
12	PAREPDT	PA Reporting Date	PA_Date	Date	4	8
13	PAPeriodEndDate	PA Period End Date	DATE	Date	4	6
14	PACOMM	PA Comment	STR50	String	52	50
15	PAUD1	PA User Defined 1	STR20	String	22	20
16	PAUD2	PA User Defined 2	STR20	String	22	20
17	PATQTY	PA Total Quantity	DLR17_QTY_RBS0_UTR	Currency	10	17
18	PAtotcosts	PA Total Costs	PA_DLR17_RBS0_STR$	Currency	10	17
19	PATACRV	PA Total Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
20	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Equipment Log Header History File'].NOTEINDX AS 'PA Equipment Log Header History File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Equipment Log Header History File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
21	PAreptsuff	PA Reporting Suffix	PA_STR5	String	6	5
22	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
23	PAPD	PA Post Date	PA_Date	Date	4	8
24	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Equipment Log Header History File'].CURNCYID AS 'PA Equipment Log Header History File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Equipment Log Header History File'].CURNCYID = ['Currency Setup'].CURNCYID
25	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Equipment Log Header History File'].CURRNIDX AS 'PA Equipment Log Header History File-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Equipment Log Header History File'].CURRNIDX = ['Currency Setup'].CURRNIDX
26	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 Header History File'].RATETPID AS 'PA Equipment Log Header History File-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['PA Equipment Log Header History File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
27	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 Header History File'].EXGTBLID AS 'PA Equipment Log Header History File-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['PA Equipment Log Header History File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
28	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
29	EXCHDATE	Exchange Date	DT_Date	Date	4	6
30	TIME1	Time	TM6	Time	4	6
31	RTCLCMTD	Rate Calculation Method	GB	Integer	2	0
32	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
33	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
34	PAORIGTOTCOSTS	PA Originating Total Costs	DLR17_RBS0_UTR$	Currency	10	17
35	PAORIACCRREV	PA Originating Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
36	Correcting_Trx_Type	Correcting Trx Type	INT	Integer	2	0
37	PAORIGINLDOCNUM	PA Original Document Number	STR17_LBAU	String	18	17
38	CREATDDT	Created Date	DT	Date	4	8
39	CRUSRID	Created User ID	STR15_User_ID	String	16	15
40	POSTEDDT	Posted Date	DATE	Date	4	6
41	PTDUSRID	Posted User ID	STR15	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Equipment Log Header History File'].PTDUSRID AS 'PA Equipment Log Header History File-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA30200 AS ['PA Equipment Log Header History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Equipment Log Header History File'].PTDUSRID = ['Users Master'].USERID
42	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.