PDK Employee Expense HDR (PDK10500)

azurecurveProductsProject Accounting (258)ProjectPDK Employee Expense HDR (PDK10500)

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

Product: Project Accounting (258)
Series:

Display Name: PDK Employee Expense HDR
Physical Name: PDK10500
Technical Name: PDK_Employee_Expense_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PDK_EE_Trx_Type SearchPDK EE Trx TypeIntegerPDK_DDL_Trx_Type0
2PDK_EE_No SearchPDK EE No.StringPDK_Document_Number30
3PDK_Ref_Doc_No SearchPDK Reference Document No.StringPDK_Document_Number30
4PDK_Document_Status SearchPDK Document StatusIntegerPDK_DDL_Document_Status0
5PDK_Trx_Source SearchPDK Trx SourceIntegerINT11
6PDK_Remote_Change SearchPDK Remote ChangeBooleanBoolean0
7PADOCDT SearchPA Document DateDatePA_Date8
8PAYR SearchPA YearIntegerINT44
9EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
10PAStartDate SearchPA Start DateDateDT8
11PAEnDate SearchPA End DateDateDT8
12PACOMM SearchPA CommentStringSTR5050
13PAUD1 SearchPA User Defined 1StringSTR2020
14PAUD2 SearchPA User Defined 2StringSTR2020
15PDK_Total_Quantity SearchPDK Total QuantityCurrencyPDK_DLR19_RBS019
16PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
17OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
18PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
19PATACRV SearchPA Total Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
20DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
21TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
22PAVENADDRESSID SearchPA Vendor Address IDStringSTR15_Address_Code15
23PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].PYMTRMID AS 'PDK Employee Expense HDR-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PDK Employee Expense HDR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
24DUEDATE SearchDue DateDateDT8
25DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
26DISCDATE SearchDiscount DateDateDT8
27DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
28DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
29BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
30SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].SHIPMTHD AS 'PDK Employee Expense HDR-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PDK Employee Expense HDR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
31PRCTDISC SearchPercent DiscountIntegerINT5_%25
32TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
33FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
34MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
35UN1099AM SearchUnapplied 1099 AmountCurrencyDLR17_RBS0_UTR$17
36PAPD SearchPA Post DateDatePA_Date8
37CARDNAME SearchCard NameStringSTR15_Card_Name15
38CRCRDAMT SearchCredit Card AmountCurrencyDLR19_RBS0_UTR$19
39CRCARDDT SearchCredit Card DateDateDATE6
40CCRCTNUM SearchCredit Card Receipt NumberStringSTR20_Document_Number20
41TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
42TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].TAXSCHID AS 'PDK Employee Expense HDR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PDK Employee Expense HDR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
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
       ['PDK Employee Expense HDR'].FRTSCHID AS 'PDK Employee Expense HDR-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PDK Employee Expense HDR'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
45FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
46PAMisc_Taxable_P SearchPA Misc Taxable - PurchaseIntegerPA_DDL_Tax_Options_Purchase0
47MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].MSCSCHID AS 'PDK Employee Expense HDR-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PDK Employee Expense HDR'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
48MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
49CHRGAMNT SearchCharge AmountCurrencyDLR19_RBSO_UTR$19
50NOTEID SearchNote IDStringSTR3030
51PDK_Reporting_Suffix SearchPDK Reporting SuffixStringPA_STR55
52LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
53MANAGER SearchManagerStringSTR15_Employee_ID15
54Manager_Approval_Status SearchManager Approval StatusIntegerPDK_Document_Approval_Status0
55SUPERVISOR SearchSupervisorStringSTR3030
56Sup_Approval_Status SearchSupervisor Approval StatusIntegerPDK_Document_Approval_Status0
57Administrator SearchAdministratorStringSTR15_Employee_ID15
58Admin_Approval_Status SearchAdmin Approval StatusIntegerPDK_Document_Approval_Status0
59CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].CURNCYID AS 'PDK Employee Expense HDR-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PDK Employee Expense HDR'].CURNCYID = ['Currency Setup'].CURNCYID
60CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].CURRNIDX AS 'PDK Employee Expense HDR-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PDK Employee Expense HDR'].CURRNIDX = ['Currency Setup'].CURRNIDX
61RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].RATETPID AS 'PDK Employee Expense HDR-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PDK Employee Expense HDR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
62EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].EXGTBLID AS 'PDK Employee Expense HDR-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PDK Employee Expense HDR'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
63XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
64EXCHDATE SearchExchange DateDateDT_Date6
65TIME1 SearchTimeTimeTM66
66RTCLCMTD SearchRate Calculation MethodIntegerGB0
67DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
68MCTRXSTT SearchMC Transaction StateIntegerINT11
69ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
70OR1099AM SearchOriginating 1099 AmountCurrencyDLR17_RBS0_UTR$17
71ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
72ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
73ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
74ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
75ODAVPUR SearchOriginating Discount Available PurchasesCurrencyDLR17_RBS0_UTR$17
76ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
77OBKPURAMT SearchOriginating Backout Purchases AmountCurrencyDLR19_RBS0_UTR$19
78ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
79PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
80PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
81ORCCDAMT SearchOriginating Credit Card AmountCurrencyDLR19_RBSO_UTR$19
82ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
83ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
84ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
85OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
86ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
87OCHGAMT SearchOriginating Charge AmountCurrencyDLR19_RBSO_UTR$19
88PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
89PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
90BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
91OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
92PAREIMBURSTAXAMT SearchPA Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
93PAORIGREIMTAXAMT SearchPA Originating Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
94PAerdocnumber SearchPA Empl Expense Document No.StringSTR30_LBAU30
95PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
96PDK_Proxy_ID SearchPDK Proxy IDStringSTR15_Employee_ID15
97PDK_EE_App_Update SearchPDK EE App UpdateIntegerPDK_DDL_EE_App_Update0
98MODIFDT SearchModified DateDateDT8
99Modified_Time SearchModified TimeTimeTM66
100Tax_Date SearchTax DateDateDT8
101TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
102TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
103CAMCBKID SearchCash Amount Checkbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].CAMCBKID AS 'PDK Employee Expense HDR-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PDK Employee Expense HDR'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
104CDOCNMBR SearchCash Document NumberStringSTR20_Document_Number20
105CAMTDATE SearchCash Amount DateDateDT8
106CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
107ORCASAMT SearchOriginating Cash AmountCurrencyDLR19_RBSO_UTR$19
108CHAMCBID SearchCheck Amount Checkbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PDK Employee Expense HDR'].CHAMCBID AS 'PDK Employee Expense HDR-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PDK10500 AS ['PDK Employee Expense HDR']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PDK Employee Expense HDR'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
109CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
110CHEKDATE SearchCheck DateDateDATE6
111CHEKAMNT SearchCheck AmountCurrencyDLR19_RBS0_UTR$19
112ORCHKAMT SearchOriginating Check AmountCurrencyDLR19_RBSO_UTR$19
113APRVLUSERID SearchApproval User IDStringSTR15_User_ID15
114APPRVLDT SearchApproval DateDateDATE6
115TEN99TYPE Search1099 TypeInteger1099_Type0
116TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
azurecurveProductsProject Accounting (258)ProjectPDK Employee Expense HDR (PDK10500)

Leave a Reply

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