PDK Employee Expense LINE (PDK10501)

azurecurveProductsProject Accounting (258)ProjectPDK Employee Expense LINE (PDK10501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK10501

Product: Project Accounting (258)
Series:

Display Name: PDK Employee Expense LINE
Physical Name: PDK10501
Technical Name: PDK_Employee_Expense_LINE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PDK_EE_No SearchPDK EE No.StringPDK_Document_Number30
2PDK_EE_Trx_Type SearchPDK EE Trx TypeIntegerPDK_DDL_Trx_Type0
3EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
4PADT SearchPA DateDatePA_Date8
5PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
6PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
7PAitemnumber SearchPA Item NumberStringSTR3030
8PDK_Quantity SearchPDK QuantityCurrencyPA_DLR19_RBS2_U19
9PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
10PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
11UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PDK Employee Expense LINE'].UOMSCHDL AS 'PDK Employee Expense LINE-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PDK10501 AS ['PDK Employee Expense LINE']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PDK Employee Expense LINE'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
12PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
13ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
14PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
15PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
16PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
17OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
18PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
19PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
20PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
21PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
22PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
23PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
24PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
25PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
26PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
27PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
28PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
29PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
30PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
31PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
32PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
33PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
34PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
35PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
36PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
37PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
38PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
39PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
40PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
41PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
42PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
43LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
44PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
45PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
46PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
47PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
48PDK_Billing_Note_ID SearchPDK Billing Note IDStringSTR4040
49BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
50OBKPURAMT SearchOriginating Backout Purchases AmountCurrencyDLR19_RBS0_UTR$19
51PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
52TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
53ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
54BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
55OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
56ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PDK Employee Expense LINE'].ITMTSHID AS 'PDK Employee Expense LINE-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PDK10501 AS ['PDK Employee Expense LINE']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PDK Employee Expense LINE'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
57PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
58PAExpenseType SearchPA Expense TypeIntegerPA_DDL_Expense_Type0
59PAPaymentMethod SearchPA Payment MethodIntegerPA_DDL_Payment_Method0
60PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
61PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
62PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
63PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
64PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
65PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
66PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
67CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PDK Employee Expense LINE'].CURRNIDX AS 'PDK Employee Expense LINE-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PDK10501 AS ['PDK Employee Expense LINE']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PDK Employee Expense LINE'].CURRNIDX = ['Currency Setup'].CURRNIDX
68RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PDK Employee Expense LINE'].RATETPID AS 'PDK Employee Expense LINE-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PDK10501 AS ['PDK Employee Expense LINE']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PDK Employee Expense LINE'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
69EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PDK Employee Expense LINE'].EXGTBLID AS 'PDK Employee Expense LINE-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PDK10501 AS ['PDK Employee Expense LINE']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PDK Employee Expense LINE'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
70XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
71EXCHDATE SearchExchange DateDateDT_Date6
72TIME1 SearchTimeTimeTM66
73RATECALC SearchRate Calc MethodIntegerINT0
74DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
75MCTRXSTT SearchMC Transaction StateIntegerINT11
azurecurveProductsProject Accounting (258)ProjectPDK Employee Expense LINE (PDK10501)

Leave a Reply

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