Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE30500
Product: Project Accounting (258)
Series: Project
Display Name: PTE_Employee_Expense_HDR_HIST 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: PTE30500
Technical Name: PTE_Employee_Expense_HDR_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PTE_Empl_Expense_Doc_No 
PTE Empl Expense Document No STR30_Item_Number String 30 2 PADOCDT PA Document Date PA_Date Date 8 3 PAYR PA Year INT4 Integer 4 4 EMPLOYID Employee ID STR15_Employee_ID String 15 5 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].USERID AS 'PTE_Employee_Expense_HDR_HIST-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PTE_Employee_Expense_HDR_HIST'].USERID = ['Users Master'].USERID6 PAStartDate PA Start Date DT Date 8 7 PAEnDate PA End Date DT Date 8 8 PACOMM PA Comment STR50 String 50 9 PTE_Total_Quantity PTE Total Quantity DLR17_QTY_RBS0_UTR Currency 17 10 PAEXTCOST PA Extended Cost PA_DLR17_RBS0_STR$ Currency 17 11 OREXTCST Originating Extended Cost DLR17_RBS0_UTR$ Currency 17 12 PAtotcosts PA Total Costs PA_DLR17_RBS0_STR$ Currency 17 13 PAORIGTOTCOSTS PA Originating Total Costs DLR17_RBS0_UTR$ Currency 17 14 PAORIACCRREV PA Originating Accrued Revenues DLR17_RBS0_UTR$ Currency 17 15 PATACRV PA Total Accrued Revenues DLR17_RBS0_UTR$ Currency 17 16 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 17 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 17 18 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 17 19 OR1099AM Originating 1099 Amount DLR17_RBS0_UTR$ Currency 17 20 UN1099AM Unapplied 1099 Amount DLR17_RBS0_UTR$ Currency 17 21 PAVENADDRESSID PA Vendor Address ID STR15_Address_Code String 15 22 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].PYMTRMID AS 'PTE_Employee_Expense_HDR_HIST-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PTE_Employee_Expense_HDR_HIST'].PYMTRMID = ['Payment Terms Master'].PYMTRMID23 DUEDATE Due Date DT Date 8 24 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 25 ORDDLRAT Originating 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 ODISAMTAV Originating Discount Amount Available DLR17_RBS0_UTR$ Currency 17 29 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 30 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 31 BKTPURAM Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 32 OBKPURAMT Originating Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 33 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].SHIPMTHD AS 'PTE_Employee_Expense_HDR_HIST-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PTE_Employee_Expense_HDR_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD34 PRCTDISC Percent Discount INT5_%2 Integer 5 35 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 36 ORTDISAM Originating Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 37 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 38 ORFRTAMT Originating Freight Amount DLR17_RBS0_UTR$ Currency 17 39 MSCCHAMT Misc Charges Amount DLR17_RBS0_UTR$ Currency 17 40 OMISCAMT Originating Misc Charges Amount DLR17_RBS0_UTR$ Currency 17 41 PAPD PA Post Date PA_Date Date 8 42 CARDNAME Card Name STR15_Card_Name String 15 43 CRCRDAMT Credit Card Amount DLR19_RBS0_UTR$ Currency 19 44 ORCCDAMT Originating Credit Card Amount DLR19_RBSO_UTR$ Currency 19 45 CRCARDDT Credit Card Date DATE Date 6 46 CCRCTNUM Credit Card Receipt Number STR20_Document_Number String 20 47 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 48 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 49 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
['PTE_Employee_Expense_HDR_HIST'].TAXSCHID AS 'PTE_Employee_Expense_HDR_HIST-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PTE_Employee_Expense_HDR_HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID50 PAFreight_Taxable_P PA Freight Taxable - Purchase PA_DDL_Tax_Options_Purchase Integer 0 51 FRTSCHID Freight Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].FRTSCHID AS 'PTE_Employee_Expense_HDR_HIST-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PTE_Employee_Expense_HDR_HIST'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID52 FRTTXAMT Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 53 ORFRTTAX Originating Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 54 ORDAVFRT Originating Discount Available Freight DLR17_RBS0_UTR$ Currency 17 55 ODAVPUR Originating Discount Available Purchases DLR17_RBS0_UTR$ Currency 17 56 ORDAVMSC Originating Discount Available Misc DLR17_RBS0_UTR$ Currency 17 57 PAMisc_Taxable_P PA Misc Taxable - Purchase PA_DDL_Tax_Options_Purchase Integer 0 58 MSCSCHID Misc Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].MSCSCHID AS 'PTE_Employee_Expense_HDR_HIST-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PTE_Employee_Expense_HDR_HIST'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID59 MSCTXAMT Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 60 ORMSCTAX Originating Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 61 CHRGAMNT Charge Amount DLR19_RBSO_UTR$ Currency 19 62 OCHGAMT Originating Charge Amount DLR19_RBSO_UTR$ Currency 19 63 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].NOTEINDX AS 'PTE_Employee_Expense_HDR_HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PTE_Employee_Expense_HDR_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX64 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].CURNCYID AS 'PTE_Employee_Expense_HDR_HIST-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE_Employee_Expense_HDR_HIST'].CURNCYID = ['Currency Setup'].CURNCYID65 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].CURRNIDX AS 'PTE_Employee_Expense_HDR_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE_Employee_Expense_HDR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX66 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].RATETPID AS 'PTE_Employee_Expense_HDR_HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PTE_Employee_Expense_HDR_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID67 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].EXGTBLID AS 'PTE_Employee_Expense_HDR_HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PTE_Employee_Expense_HDR_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID68 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 69 EXCHDATE Exchange Date DT_Date Date 6 70 TIME1 Time TM6 Time 6 71 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 72 PAReimbursableAmount PA Reimbursable Amount PA_DLR17_RBS0_STR$ Currency 17 73 PAOrigReimbursableAmt PA Originating Reimbursable Amount PA_DLR17_RBS0_STR$ Currency 17 74 PAREIMBURSTAXAMT PA Reimbursable Tax Amount PA_DLR17_RBS0_STR$ Currency 17 75 PAORIGREIMTAXAMT PA Originating Reimbursable Tax Amount PA_DLR17_RBS0_STR$ Currency 17 76 BCKTXAMT Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 77 OBTAXAMT Originating Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 78 PAREFNO PA Reference Document No. STR17_LBAU String 17 79 Tax_Date Tax Date DT Date 8 80 TaxInvRecvd Tax Invoice Received CB_Tax_Invoice_Received Boolean 0 81 TaxInvReqd Tax Invoice Required CB_Tax_Invoice_Required Boolean 0 82 CAMCBKID Cash Amount Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].CAMCBKID AS 'PTE_Employee_Expense_HDR_HIST-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PTE_Employee_Expense_HDR_HIST'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID83 CDOCNMBR Cash Document Number STR20_Document_Number String 20 84 CAMTDATE Cash Amount Date DT Date 8 85 CASHAMNT Cash Amount DLR19_RBS0_UTR$ Currency 19 86 ORCASAMT Originating Cash Amount DLR19_RBSO_UTR$ Currency 19 87 CHAMCBID Check Amount Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['PTE_Employee_Expense_HDR_HIST'].CHAMCBID AS 'PTE_Employee_Expense_HDR_HIST-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PTE30500 AS ['PTE_Employee_Expense_HDR_HIST']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PTE_Employee_Expense_HDR_HIST'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID88 CHEKNMBR Check Number STR20_Document_Number String 20 89 CHEKDATE Check Date DATE Date 6 90 CHEKAMNT Check Amount DLR19_RBS0_UTR$ Currency 19 91 ORCHKAMT Originating Check Amount DLR19_RBSO_UTR$ Currency 19 92 PATQTY PA Total Quantity DLR17_QTY_RBS0_UTR Currency 17 93 PADocnumber20 PA Document No. STR17_LBAU String 17 94 Workflow_Status Workflow Status Workflow Status Integer 0 95 RTCLCMTD Rate Calculation Method GB Integer 0 96 MCTRXSTT MC Transaction State INT1 Integer 1 97 PAerdocnumber PA Empl Expense Document No. STR30_LBAU String 30 98 TEN99TYPE 1099 Type 1099_Type Integer 0 99 TEN99BOXNUMBER 1099 Box Number DDL_1099_Box Integer 0 100 DEX_ROW_ID int int 10