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