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