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_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PDK_EE_Trx_Type 
PDK EE Trx Type Integer PDK_DDL_Trx_Type 0 2 PDK_EE_No PDK EE No. String PDK_Document_Number 30 3 PDK_Ref_Doc_No PDK Reference Document No. String PDK_Document_Number 30 4 PDK_Document_Status PDK Document Status Integer PDK_DDL_Document_Status 0 5 PDK_Trx_Source PDK Trx Source Integer INT1 1 6 PDK_Remote_Change PDK Remote Change Boolean Boolean 0 7 PADOCDT PA Document Date Date PA_Date 8 8 PAYR PA Year Integer INT4 4 9 EMPLOYID Employee ID String STR15_Employee_ID 15 10 PAStartDate PA Start Date Date DT 8 11 PAEnDate PA End Date Date DT 8 12 PACOMM PA Comment String STR50 50 13 PAUD1 PA User Defined 1 String STR20 20 14 PAUD2 PA User Defined 2 String STR20 20 15 PDK_Total_Quantity PDK Total Quantity Currency PDK_DLR19_RBS0 19 16 PAEXTCOST PA Extended Cost Currency PA_DLR17_RBS0_STR$ 17 17 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 18 PAtotcosts PA Total Costs Currency PA_DLR17_RBS0_STR$ 17 19 PATACRV PA Total Accrued Revenues Currency DLR17_RBS0_UTR$ 17 20 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 21 TEN99AMNT 1099 Amount Currency DLR17_RBS0_UTR$ 17 22 PAVENADDRESSID PA Vendor Address ID String STR15_Address_Code 15 23 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 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'].PYMTRMID24 DUEDATE Due Date Date DT 8 25 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 26 DISCDATE Discount Date Date DT 8 27 DISAMTAV Discount Amount Available Currency DLR17_RBS0_UTR$ 17 28 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 29 BKTPURAM Backout Purchases Amount Currency DLR19_RBS0_UTR$ 19 30 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 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'].SHIPMTHD31 PRCTDISC Percent Discount Integer INT5_%2 5 32 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 33 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 34 MSCCHAMT Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 35 UN1099AM Unapplied 1099 Amount Currency DLR17_RBS0_UTR$ 17 36 PAPD PA Post Date Date PA_Date 8 37 CARDNAME Card Name String STR15_Card_Name 15 38 CRCRDAMT Credit Card Amount Currency DLR19_RBS0_UTR$ 19 39 CRCARDDT Credit Card Date Date DATE 6 40 CCRCTNUM Credit Card Receipt Number String STR20_Document_Number 20 41 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 42 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
['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'].TAXSCHID43 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
['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'].TAXSCHID45 FRTTXAMT Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 46 PAMisc_Taxable_P PA Misc Taxable - Purchase Integer PA_DDL_Tax_Options_Purchase 0 47 MSCSCHID Misc Schedule ID String STR15_LBAU 15 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'].TAXSCHID48 MSCTXAMT Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 49 CHRGAMNT Charge Amount Currency DLR19_RBSO_UTR$ 19 50 NOTEID Note ID String STR30 30 51 PDK_Reporting_Suffix PDK Reporting Suffix String PA_STR5 5 52 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 53 MANAGER Manager String STR15_Employee_ID 15 54 Manager_Approval_Status Manager Approval Status Integer PDK_Document_Approval_Status 0 55 SUPERVISOR Supervisor String STR30 30 56 Sup_Approval_Status Supervisor Approval Status Integer PDK_Document_Approval_Status 0 57 Administrator Administrator String STR15_Employee_ID 15 58 Admin_Approval_Status Admin Approval Status Integer PDK_Document_Approval_Status 0 59 CURNCYID Currency ID String STR15_Currency_ID 15 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'].CURNCYID60 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX61 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 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'].RATETPID62 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 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'].EXGTBLID63 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 64 EXCHDATE Exchange Date Date DT_Date 6 65 TIME1 Time Time TM6 6 66 RTCLCMTD Rate Calculation Method Integer GB 0 67 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 68 MCTRXSTT MC Transaction State Integer INT1 1 69 ORDOCAMT Originating Document Amount Currency DLR17_RBS0_STR$ 17 70 OR1099AM Originating 1099 Amount Currency DLR17_RBS0_UTR$ 17 71 ORDDLRAT Originating Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 72 ODISAMTAV Originating Discount Amount Available Currency DLR17_RBS0_UTR$ 17 73 ORDISTKN Originating Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 74 ORDAVFRT Originating Discount Available Freight Currency DLR17_RBS0_UTR$ 17 75 ODAVPUR Originating Discount Available Purchases Currency DLR17_RBS0_UTR$ 17 76 ORDAVMSC Originating Discount Available Misc Currency DLR17_RBS0_UTR$ 17 77 OBKPURAMT Originating Backout Purchases Amount Currency DLR19_RBS0_UTR$ 19 78 ORTDISAM Originating Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 79 PAORIGTOTCOSTS PA Originating Total Costs Currency DLR17_RBS0_UTR$ 17 80 PAORIACCRREV PA Originating Accrued Revenues Currency DLR17_RBS0_UTR$ 17 81 ORCCDAMT Originating Credit Card Amount Currency DLR19_RBSO_UTR$ 19 82 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 83 ORFRTAMT Originating Freight Amount Currency DLR17_RBS0_UTR$ 17 84 ORFRTTAX Originating Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 85 OMISCAMT Originating Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 86 ORMSCTAX Originating Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 87 OCHGAMT Originating Charge Amount Currency DLR19_RBSO_UTR$ 19 88 PAReimbursableAmount PA Reimbursable Amount Currency PA_DLR17_RBS0_STR$ 17 89 PAOrigReimbursableAmt PA Originating Reimbursable Amount Currency PA_DLR17_RBS0_STR$ 17 90 BCKTXAMT Backout Tax Amount Currency DLR17_RBS0_UTR$ 17 91 OBTAXAMT Originating Backout Tax Amount Currency DLR17_RBS0_UTR$ 17 92 PAREIMBURSTAXAMT PA Reimbursable Tax Amount Currency PA_DLR17_RBS0_STR$ 17 93 PAORIGREIMTAXAMT PA Originating Reimbursable Tax Amount Currency PA_DLR17_RBS0_STR$ 17 94 PAerdocnumber PA Empl Expense Document No. String STR30_LBAU 30 95 PAREFNO PA Reference Document No. String STR17_LBAU 17 96 PDK_Proxy_ID PDK Proxy ID String STR15_Employee_ID 15 97 PDK_EE_App_Update PDK EE App Update Integer PDK_DDL_EE_App_Update 0 98 MODIFDT Modified Date Date DT 8 99 Modified_Time Modified Time Time TM6 6 100 Tax_Date Tax Date Date DT 8 101 TaxInvRecvd Tax Invoice Received Boolean CB_Tax_Invoice_Received 0 102 TaxInvReqd Tax Invoice Required Boolean CB_Tax_Invoice_Required 0 103 CAMCBKID Cash Amount Checkbook ID String STR15_Checkbook_ID 15 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'].CHEKBKID104 CDOCNMBR Cash Document Number String STR20_Document_Number 20 105 CAMTDATE Cash Amount Date Date DT 8 106 CASHAMNT Cash Amount Currency DLR19_RBS0_UTR$ 19 107 ORCASAMT Originating Cash Amount Currency DLR19_RBSO_UTR$ 19 108 CHAMCBID Check Amount Checkbook ID String STR15_Checkbook_ID 15 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'].CHEKBKID109 CHEKNMBR Check Number String STR20_Document_Number 20 110 CHEKDATE Check Date Date DATE 6 111 CHEKAMNT Check Amount Currency DLR19_RBS0_UTR$ 19 112 ORCHKAMT Originating Check Amount Currency DLR19_RBSO_UTR$ 19 113 APRVLUSERID Approval User ID String STR15_User_ID 15 114 APPRVLDT Approval Date Date DATE 6 115 TEN99TYPE 1099 Type Integer 1099_Type 0 116 TEN99BOXNUMBER 1099 Box Number Integer DDL_1099_Box 0