PA Employee Expense Header History File (PA30500)

azurecurve Products Project Accounting (258)ProjectPA 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:

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

azurecurve Products Project Accounting (258)ProjectPA Employee Expense Header History File (PA30500)

Leave a Reply Cancel reply