PA Employee Expense Header History File (PA30500)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Employee Expense Header History File
Physical Name: PA30500
Technical Name: PA_Employee_Expense_HDR_HIST

Group Display Name: PA Employee Expense Transactions History
Group Technical Name: PA Employee Expense Transactions History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PAertrxtype	PA Empl Expense TRX Type	PA_DDL_EE_Trx_Typ	Integer	2	0
2	PAerdocnumber	PA Empl Expense Document No.	STR30_LBAU	String	32	30
3	PDK_EE_No	PDK EE No.	PDK_Document_Number	String	32	30
4	PADOCDT	PA Document Date	PA_Date	Date	4	8
5	PAPD	PA Post Date	PA_Date	Date	4	8
6	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Employee Expense Header History File'].USERID AS 'PA Employee Expense Header History File-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Employee Expense Header History File'].USERID = ['Users Master'].USERID
7	BACHNUMB	Batch Number	STR15_LBAU	String	16	15
8	BCHSOURC	Batch Source	STR15	String	16	15
9	TRXSORCE	TRX Source	STR13	String	14	13
10	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	16	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['PA Employee Expense Header History File'].SHIPMTHD AS 'PA Employee Expense Header History File-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['PA Employee Expense Header History File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
11	PAREFNO	PA Reference Document No.	STR17_LBAU	String	18	17
12	PAUD1	PA User Defined 1	STR20	String	22	20
13	PAUD2	PA User Defined 2	STR20	String	22	20
14	EMPLOYID	Employee ID	STR15_Employee_ID	String	16	15
15	PAVENADDRESSID	PA Vendor Address ID	STR15_Address_Code	String	16	15
16	PAStartDate	PA Start Date	DT	Date	4	8
17	PAEnDate	PA End Date	DT	Date	4	8
18	PAreptsuff	PA Reporting Suffix	PA_STR5	String	6	5
19	PAYR	PA Year	INT4	Integer	2	4
20	PACOMM	PA Comment	STR50	String	52	50
21	PYMTRMID	Payment Terms ID	STR20_Payment_Terms_ID	String	22	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['PA Employee Expense Header History File'].PYMTRMID AS 'PA Employee Expense Header History File-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['PA Employee Expense Header History File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
22	DUEDATE	Due Date	DT	Date	4	8
23	DSCDLRAM	Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
24	ORDDLRAT	Originating Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
25	DISCDATE	Discount Date	DT	Date	4	8
26	DISAMTAV	Discount Amount Available	DLR17_RBS0_UTR$	Currency	10	17
27	ODISAMTAV	Originating Discount Amount Available	DLR17_RBS0_UTR$	Currency	10	17
28	PRCTDISC	Percent Discount	INT5_%2	Integer	2	5
29	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Employee Expense Header History File'].CURNCYID AS 'PA Employee Expense Header History File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Employee Expense Header History File'].CURNCYID = ['Currency Setup'].CURNCYID
30	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Employee Expense Header History File'].CURRNIDX AS 'PA Employee Expense Header History File-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Employee Expense Header History File'].CURRNIDX = ['Currency Setup'].CURRNIDX
31	PATQTY	PA Total Quantity	DLR17_QTY_RBS0_UTR	Currency	10	17
32	PAEXTCOST	PA Extended Cost	PA_DLR17_RBS0_STR$	Currency	10	17
33	OREXTCST	Originating Extended Cost	DLR17_RBS0_UTR$	Currency	10	17
34	PAtotcosts	PA Total Costs	PA_DLR17_RBS0_STR$	Currency	10	17
35	PAORIGTOTCOSTS	PA Originating Total Costs	DLR17_RBS0_UTR$	Currency	10	17
36	PAREIMBURSTAXAMT	PA Reimbursable Tax Amount	PA_DLR17_RBS0_STR$	Currency	10	17
37	PAORIGREIMTAXAMT	PA Originating Reimbursable Tax Amount	PA_DLR17_RBS0_STR$	Currency	10	17
38	BKTPURAM	Backout Purchases Amount	DLR19_RBS0_UTR$	Currency	10	19
39	PATACRV	PA Total Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
40	PAORIACCRREV	PA Originating Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
41	TRDISAMT	Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
42	ORTDISAM	Originating Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
43	PAFreight_Taxable_P	PA Freight Taxable - Purchase	PA_DDL_Tax_Options_Purchase	Integer	2	0
44	FRTSCHID	Freight Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Employee Expense Header History File'].FRTSCHID AS 'PA Employee Expense Header History File-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Employee Expense Header History File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
45	FRTAMNT	Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
46	ORFRTAMT	Originating Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
47	FRTTXAMT	Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
48	ORFRTTAX	Originating Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
49	PAMisc_Taxable_P	PA Misc Taxable - Purchase	PA_DDL_Tax_Options_Purchase	Integer	2	0
50	MSCSCHID	Misc Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Employee Expense Header History File'].MSCSCHID AS 'PA Employee Expense Header History File-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Employee Expense Header History File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51	MSCCHAMT	Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
52	OMISCAMT	Originating Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
53	MSCTXAMT	Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
54	ORMSCTAX	Originating Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
55	DOCAMNT	Document Amount	DLR19_RBSO_UTR$	Currency	10	19
56	ORDOCAMT	Originating Document Amount	DLR17_RBS0_STR$	Currency	10	17
57	TEN99AMNT	1099 Amount	DLR17_RBS0_UTR$	Currency	10	17
58	OR1099AM	Originating 1099 Amount	DLR17_RBS0_UTR$	Currency	10	17
59	UN1099AM	Unapplied 1099 Amount	DLR17_RBS0_UTR$	Currency	10	17
60	CASHAMNT	Cash Amount	DLR19_RBS0_UTR$	Currency	10	19
61	ORCASAMT	Originating Cash Amount	DLR19_RBSO_UTR$	Currency	10	19
62	CAMCBKID	Cash Amount Checkbook ID	STR15_Checkbook_ID	String	16	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PA Employee Expense Header History File'].CAMCBKID AS 'PA Employee Expense Header History File-Cash Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PA Employee Expense Header History File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
63	CDOCNMBR	Cash Document Number	STR20_Document_Number	String	22	20
64	CAMTDATE	Cash Amount Date	DT	Date	4	8
65	CAMPMTNM	Cash Amount Payment Number	STR20_LBAU	String	22	20
66	CHRGAMNT	Charge Amount	DLR19_RBSO_UTR$	Currency	10	19
67	OCHGAMT	Originating Charge Amount	DLR19_RBSO_UTR$	Currency	10	19
68	CHEKAMNT	Check Amount	DLR19_RBS0_UTR$	Currency	10	19
69	ORCHKAMT	Originating Check Amount	DLR19_RBSO_UTR$	Currency	10	19
70	CHEKNMBR	Check Number	STR20_Document_Number	String	22	20
71	CHEKDATE	Check Date	DATE	Date	4	6
72	CAMPYNBR	Check Amount Payment Number	STR20_LBAU	String	22	20
73	CHAMCBID	Check Amount Checkbook ID	STR15_Checkbook_ID	String	16	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PA Employee Expense Header History File'].CHAMCBID AS 'PA Employee Expense Header History File-Check Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PA Employee Expense Header History File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
74	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
75	OBTAXAMT	Originating Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
76	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Employee Expense Header History File'].TAXSCHID AS 'PA Employee Expense Header History File-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Employee Expense Header History File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
77	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
78	ORTAXAMT	Originating Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
79	CARDNAME	Card Name	STR15_Card_Name	String	16	15
80	CRCRDAMT	Credit Card Amount	DLR19_RBS0_UTR$	Currency	10	19
81	ORCCDAMT	Originating Credit Card Amount	DLR19_RBSO_UTR$	Currency	10	19
82	CRCARDDT	Credit Card Date	DATE	Date	4	6
83	CCAMPYNM	Credit Card Amount Payment Number	STR20_LBAU	String	22	20
84	CCRCTNUM	Credit Card Receipt Number	STR20_Document_Number	String	22	20
85	DISTKNAM	Discount Taken Amount	DLR17_RBS0_UTR$	Currency	10	17
86	ORDISTKN	Originating Discount Taken Amount	DLR17_RBS0_UTR$	Currency	10	17
87	ORDAVFRT	Originating Discount Available Freight	DLR17_RBS0_UTR$	Currency	10	17
88	ORDAVMSC	Originating Discount Available Misc	DLR17_RBS0_UTR$	Currency	10	17
89	ODAVPUR	Originating Discount Available Purchases	DLR17_RBS0_UTR$	Currency	10	17
90	PAReimbursableAmount	PA Reimbursable Amount	PA_DLR17_RBS0_STR$	Currency	10	17
91	PAOrigReimbursableAmt	PA Originating Reimbursable Amount	PA_DLR17_RBS0_STR$	Currency	10	17
92	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 Employee Expense Header History File'].RATETPID AS 'PA Employee Expense Header History File-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['PA Employee Expense Header History File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
93	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 Employee Expense Header History File'].EXGTBLID AS 'PA Employee Expense Header History File-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['PA Employee Expense Header History File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
94	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
95	EXCHDATE	Exchange Date	DT_Date	Date	4	6
96	TIME1	Time	TM6	Time	4	6
97	RTCLCMTD	Rate Calculation Method	GB	Integer	2	0
98	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
99	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
100	PApostoDynPM	PA Post to Dyn Payables Mgmt	PA_CB_Post_PM	Boolean	2	0
101	Tax_Date	Tax Date	DT	Date	4	8
102	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Employee Expense Header History File'].NOTEINDX AS 'PA Employee Expense Header History File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Employee Expense Header History File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
103	TaxInvRecvd	Tax Invoice Received	CB_Tax_Invoice_Received	Boolean	2	0
104	TaxInvReqd	Tax Invoice Required	CB_Tax_Invoice_Required	Boolean	2	0
105	Correcting_Trx_Type	Correcting Trx Type	INT	Integer	2	0
106	PAORIGINLDOCNUM	PA Original Document Number	STR17_LBAU	String	18	17
107	TEN99TYPE	1099 Type	1099_Type	Integer	2	0
108	TEN99BOXNUMBER	1099 Box Number	DDL_1099_Box	Integer	2	0
109	CREATDDT	Created Date	DT	Date	4	8
110	CRUSRID	Created User ID	STR15_User_ID	String	16	15
111	POSTEDDT	Posted Date	DATE	Date	4	6
112	PSTUSRID	Post User ID	STR15	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Employee Expense Header History File'].PSTUSRID AS 'PA Employee Expense Header History File-Post User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA30500 AS ['PA Employee Expense Header History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Employee Expense Header History File'].PSTUSRID = ['Users Master'].USERID
113	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 Employee Expense Header History File (PA30500)

Leave a Reply Cancel reply