PTE_Employee_Expense_Line_HIST (PTE30501)

azurecurveProductsProject Accounting (258)ProjectPTE_Employee_Expense_Line_HIST (PTE30501)

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_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PTE_Empl_Expense_Doc_No SearchPTE Empl Expense Document NoStringSTR30_Item_Number30
2EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
3PADT SearchPA DateDatePA_Date8
4PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
5PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
6PAitemnumber SearchPA Item NumberStringSTR3030
7PTE_Quantity SearchPTE QuantityCurrencyPA_DLR15_RBS0_STR15
8PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
9PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
10UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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
11PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
12ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
13PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
14PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
15PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
16OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
17PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
18PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
19PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
20PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
21PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
22PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
23PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
24PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
25PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
26PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
27PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
28PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
29PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
30PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
31PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
32PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
33PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
34PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
35PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
36PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
37PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
38PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
39PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
40LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
41PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
42PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
43PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
44PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
45PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
46BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
47OBKPURAMT SearchOriginating Backout Purchases AmountCurrencyDLR19_RBS0_UTR$19
48PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
49TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
50ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
51BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
52OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
53ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
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
54PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
55PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
56PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
57PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
58PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
59PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
60PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
61PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
62CURRNIDX SearchCurrency IndexIntegerINT33
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
63RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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
64EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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
65XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
66EXCHDATE SearchExchange DateDateDT_Date6
67TIME1 SearchTimeTimeTM66
68RATECALC SearchRate Calc MethodIntegerINT0
69PAExpenseType SearchPA Expense TypeIntegerPA_DDL_Expense_Type0
70PAPaymentMethod SearchPA Payment MethodIntegerPA_DDL_Payment_Method0
71DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
72MCTRXSTT SearchMC Transaction StateIntegerINT11
73PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
74PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
azurecurveProductsProject Accounting (258)ProjectPTE_Employee_Expense_Line_HIST (PTE30501)

Leave a Reply

Your email address will not be published. Required fields are marked *