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