PA Employee Expense Header History File (PA30500)

azurecurveProductsProject 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAertrxtype SearchPA Empl Expense TRX TypeIntegerPA_DDL_EE_Trx_Typ0
2PAerdocnumber SearchPA Empl Expense Document No.StringSTR30_LBAU30
3PDK_EE_No SearchPDK EE No.StringPDK_Document_Number30
4PADOCDT SearchPA Document DateDatePA_Date8
5PAPD SearchPA Post DateDatePA_Date8
6USERID SearchUser IDStringSTR15_User_ID15
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
7BACHNUMB SearchBatch NumberStringSTR15_LBAU15
8BCHSOURC SearchBatch SourceStringSTR1515
9TRXSORCE SearchTRX SourceStringSTR1313
10SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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
11PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
12PAUD1 SearchPA User Defined 1StringSTR2020
13PAUD2 SearchPA User Defined 2StringSTR2020
14EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
15PAVENADDRESSID SearchPA Vendor Address IDStringSTR15_Address_Code15
16PAStartDate SearchPA Start DateDateDT8
17PAEnDate SearchPA End DateDateDT8
18PAreptsuff SearchPA Reporting SuffixStringPA_STR55
19PAYR SearchPA YearIntegerINT44
20PACOMM SearchPA CommentStringSTR5050
21PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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
22DUEDATE SearchDue DateDateDT8
23DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
24ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
25DISCDATE SearchDiscount DateDateDT8
26DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
27ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
28PRCTDISC SearchPercent DiscountIntegerINT5_%25
29CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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
30CURRNIDX SearchCurrency IndexIntegerINT33
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
31PATQTY SearchPA Total QuantityCurrencyDLR17_QTY_RBS0_UTR17
32PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
33OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
34PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
35PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
36PAREIMBURSTAXAMT SearchPA Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
37PAORIGREIMTAXAMT SearchPA Originating Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
38BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
39PATACRV SearchPA Total Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
40PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
41TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
42ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
43PAFreight_Taxable_P SearchPA Freight Taxable - PurchaseIntegerPA_DDL_Tax_Options_Purchase0
44FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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
45FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
46ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
47FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
48ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
49PAMisc_Taxable_P SearchPA Misc Taxable - PurchaseIntegerPA_DDL_Tax_Options_Purchase0
50MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
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
51MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
52OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
53MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
54ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
55DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
56ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
57TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
58OR1099AM SearchOriginating 1099 AmountCurrencyDLR17_RBS0_UTR$17
59UN1099AM SearchUnapplied 1099 AmountCurrencyDLR17_RBS0_UTR$17
60CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
61ORCASAMT SearchOriginating Cash AmountCurrencyDLR19_RBSO_UTR$19
62CAMCBKID SearchCash Amount Checkbook IDStringSTR15_Checkbook_ID15
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
63CDOCNMBR SearchCash Document NumberStringSTR20_Document_Number20
64CAMTDATE SearchCash Amount DateDateDT8
65CAMPMTNM SearchCash Amount Payment NumberStringSTR20_LBAU20
66CHRGAMNT SearchCharge AmountCurrencyDLR19_RBSO_UTR$19
67OCHGAMT SearchOriginating Charge AmountCurrencyDLR19_RBSO_UTR$19
68CHEKAMNT SearchCheck AmountCurrencyDLR19_RBS0_UTR$19
69ORCHKAMT SearchOriginating Check AmountCurrencyDLR19_RBSO_UTR$19
70CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
71CHEKDATE SearchCheck DateDateDATE6
72CAMPYNBR SearchCheck Amount Payment NumberStringSTR20_LBAU20
73CHAMCBID SearchCheck Amount Checkbook IDStringSTR15_Checkbook_ID15
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
74BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
75OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
76TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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
77TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
78ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
79CARDNAME SearchCard NameStringSTR15_Card_Name15
80CRCRDAMT SearchCredit Card AmountCurrencyDLR19_RBS0_UTR$19
81ORCCDAMT SearchOriginating Credit Card AmountCurrencyDLR19_RBSO_UTR$19
82CRCARDDT SearchCredit Card DateDateDATE6
83CCAMPYNM SearchCredit Card Amount Payment NumberStringSTR20_LBAU20
84CCRCTNUM SearchCredit Card Receipt NumberStringSTR20_Document_Number20
85DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
86ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
87ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
88ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
89ODAVPUR SearchOriginating Discount Available PurchasesCurrencyDLR17_RBS0_UTR$17
90PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
91PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
92RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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
93EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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
94XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
95EXCHDATE SearchExchange DateDateDT_Date6
96TIME1 SearchTimeTimeTM66
97RTCLCMTD SearchRate Calculation MethodIntegerGB0
98DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
99MCTRXSTT SearchMC Transaction StateIntegerINT11
100PApostoDynPM SearchPA Post to Dyn Payables MgmtBooleanPA_CB_Post_PM0
101Tax_Date SearchTax DateDateDT8
102NOTEINDX SearchNote IndexCurrencyDLR1414
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
103TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
104TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
105Correcting_Trx_Type SearchCorrecting Trx TypeIntegerINT0
106PAORIGINLDOCNUM SearchPA Original Document NumberStringSTR17_LBAU17
107TEN99TYPE Search1099 TypeInteger1099_Type0
108TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
109CREATDDT SearchCreated DateDateDT8
110CRUSRID SearchCreated User IDStringSTR15_User_ID15
111POSTEDDT SearchPosted DateDateDATE6
112PSTUSRID SearchPost User IDStringSTR1515
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
azurecurveProductsProject Accounting (258)ProjectPA Employee Expense Header History File (PA30500)

Leave a Reply

Your email address will not be published. Required fields are marked *