Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE30501
Product: Project Accounting (258)
Series: Project
Display Name: PTE_Employee_Expense_Line_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: PTE30501
Technical Name: PTE_Employee_Expense_Line_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 EMPLOYID Employee ID STR15_Employee_ID String 15 3 PADT PA Date PA_Date Date 8 4 PAPROJNUMBER PA Project Number STR15_LBAU String 15 5 PACOSTCATID PA Cost Category ID STR15_Cost_Category_ID String 15 6 PAitemnumber PA Item Number STR30 String 30 7 PTE_Quantity PTE Quantity PA_DLR15_RBS0_STR Currency 15 8 PABase_Qty PA Base Qty PA_DLR15_RBS0_STR Currency 15 9 PAUnit_of_Measure PA Unit of Measure U_Of_M String 8 10 UOMSCHDL U Of M Schedule STR10_Schedule String 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['PTE_Employee_Expense_Line_HIST'].UOMSCHDL AS 'PTE_Employee_Expense_Line_HIST-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PTE30501 AS ['PTE_Employee_Expense_Line_HIST']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PTE_Employee_Expense_Line_HIST'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
11 PAUNITCOST PA Unit Cost PA_DLR17_RBS0_UTR$ Currency 17 12 ORUNTCST Originating Unit Cost DLR17_RBS0_UTR$ Currency 17 13 PABase_Unit_Cost PA Base Unit Cost PA_DLR17_RBS0_STR$ Currency 17 14 PAORGBSUNITCST PA Originating Base Unit Cost PA_DLR17_RBS0_STR$ Currency 17 15 PAEXTCOST PA Extended Cost PA_DLR17_RBS0_STR$ Currency 17 16 OREXTCST Originating Extended Cost DLR17_RBS0_UTR$ Currency 17 17 PAOverhead_Amount PA Overhead Amount DLR15_RBU$2 Currency 15 18 PAORIGOVHDAMT PA Originating Overhead Amount DLR15_RBU$2 Currency 15 19 PABaseOvhdCost PA Base Overhead Cost DLR17_RBS0_UTR$ Currency 17 20 PAORIGBASEOVRHCST PA Originating Base Overhead Cost DLR15_RBU$2 Currency 15 21 PAOverheaPercentage PA Overhead Percentage DLR5_%2 Currency 8 22 PATOTALOVERH PA Total Overhead DLR17_RBS0_UTR$ Currency 17 23 PAORIGTOTOVRHD PA Originating Total Overhead DLR17_RBS0_UTR$ Currency 17 24 PABILRATE PA Billing Rate DLR17_RBS0_UTR$ Currency 17 25 PAORIGBILLRATE PA Originating Billing Rate DLR17_RBS0_UTR$ Currency 17 26 PA_Base_Billing_Rate PA Base Billing Rate DLR17_RBS0_UTR$ Currency 17 27 PAORIGBSBILLRTE PA Originating Base Billing Rate DLR17_RBS0_UTR$ Currency 17 28 PAMARKPERCENT PA Markup Percentage DLR5_%2 Currency 8 29 PAACREV PA Accrued Revenues DLR17_RBS0_UTR$ Currency 17 30 PAORIACCRREV PA Originating Accrued Revenues DLR17_RBS0_UTR$ Currency 17 31 PAProfitAmount PA Profit Amount DLR17_RBS0_UTR$ Currency 17 32 PAORIGPROFAMT PA Originating Profit Amount DLR17_RBS0_UTR$ Currency 17 33 PAProfitPercent PA Profit Percent DLR5_%2 Currency 8 34 PATotalProfit PA Total Profit DLR17_RBS0_UTR$ Currency 17 35 PAORIGTOTPROF PA Originating Total Profit DLR17_RBS0_UTR$ Currency 17 36 PAProfitType PA Profit Type PA_DDL_Profit_Type Integer 0 37 PASTD_Qty PA STD Qty PA_DLR15_RBS0_STR Currency 15 38 PANC_Qty PA NC Qty PA_DLR15_RBS0_STR Currency 15 39 PANB_Qty PA NB Qty PA_DLR15_RBS0_STR Currency 15 40 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 41 PAREFNO PA Reference Document No. STR17_LBAU String 17 42 PAReference_Line_Seq_N PA Reference Line Seq No LI_Sequence_Number Long Integer 10 43 PAbllngtype PA Billing Type PA_DDL_Billing_Type Integer 0 44 PACONTNUMBER PA Contract Number STR10_LBAU String 10 45 PAbillnoteidx PA Billing Note Index DLR14 Currency 14 46 BKTPURAM Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 47 OBKPURAMT Originating Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 48 PAPurchase_Tax_Options PA Purchase Tax Options PA_DDL_Tax_Options_Purchase Integer 0 49 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 50 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 51 BCKTXAMT Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 52 OBTAXAMT Originating Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 53 ITMTSHID Item Tax Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PTE_Employee_Expense_Line_HIST'].ITMTSHID AS 'PTE_Employee_Expense_Line_HIST-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PTE30501 AS ['PTE_Employee_Expense_Line_HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PTE_Employee_Expense_Line_HIST'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
54 PABilling_StatusN PA Billing Status DDL_Billing_Status Integer 0 55 PAReimbursableAmount PA Reimbursable Amount PA_DLR17_RBS0_STR$ Currency 17 56 PAOrigReimbursableAmt PA Originating Reimbursable Amount PA_DLR17_RBS0_STR$ Currency 17 57 PAROUNDAMT PA Round Amount PA_DLR17_RBS0_STR$ Currency 17 58 PAMCCURNCYID PA MC Currency ID STR15_Currency_ID String 15 59 PA_MC_Billing_Rate PA MC Billing Rate PA_DLR17_RBS0_UTR$ Currency 17 60 PA_MC_Base_Billing_Rate PA MC Base Billing Rate PA_DLR17_RBS0_UTR$ Currency 17 61 PA_MC_Accrued_Revenue PA MC Accrued Revenue PA_DLR17_RBS0_UTR$ Currency 17 62 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE_Employee_Expense_Line_HIST'].CURRNIDX AS 'PTE_Employee_Expense_Line_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PTE30501 AS ['PTE_Employee_Expense_Line_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE_Employee_Expense_Line_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
63 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_Line_HIST'].RATETPID AS 'PTE_Employee_Expense_Line_HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PTE30501 AS ['PTE_Employee_Expense_Line_HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PTE_Employee_Expense_Line_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
64 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_Line_HIST'].EXGTBLID AS 'PTE_Employee_Expense_Line_HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PTE30501 AS ['PTE_Employee_Expense_Line_HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PTE_Employee_Expense_Line_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
65 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 66 EXCHDATE Exchange Date DT_Date Date 6 67 TIME1 Time TM6 Time 6 68 RATECALC Rate Calc Method INT Integer 0 69 PAExpenseType PA Expense Type PA_DDL_Expense_Type Integer 0 70 PAPaymentMethod PA Payment Method PA_DDL_Payment_Method Integer 0 71 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 72 MCTRXSTT MC Transaction State INT1 Integer 1 73 PAtotcosts PA Total Costs PA_DLR17_RBS0_STR$ Currency 17 74 PAORIGTOTCOSTS PA Originating Total Costs DLR17_RBS0_UTR$ Currency 17 75 DEX_ROW_ID int int 10