Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30201
Product: Project Accounting (258)
Series: Project
Display Name: PA Equipment Log Detail History File Group Display Name: PA Equipment Log Transactions History
Physical Name: PA30201
Technical Name: PA_Equipment_Log_LINE_HIST
Group Technical Name: PA Equipment Log Transactions History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PAEQLTRX ![]() | PA Equipment Log TRX Type | PA_DDL_EL_Trx_Typ | Integer | 0 | |
2 | PAEQLOGNO ![]() | PA Equipment Log No. | STR17_LBAU | String | 17 | |
3 | PAREFNO ![]() | PA Reference Document No. | STR17_LBAU | String | 17 | |
4 | PAEQUIPTID ![]() | PA Equipment ID | STR15_Equipment_ID | String | 15 | |
5 | PADT ![]() | PA Date | PA_Date | Date | 8 | |
6 | PAPROJNUMBER ![]() | PA Project Number | STR15_LBAU | String | 15 | |
7 | PACOSTCATID ![]() | PA Cost Category ID | STR15_Cost_Category_ID | String | 15 | |
8 | PATB ![]() | PA Time Begin | TM6 | Time | 6 | |
9 | PATE ![]() | PA Time End | TM6 | Time | 6 | |
10 | PAQtyQ ![]() | PA Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
11 | PABase_Qty ![]() | PA Base Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
12 | PAUnit_of_Measure ![]() | PA Unit of Measure | U_Of_M | String | 8 | |
13 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['PA Equipment Log Detail History File'].UOMSCHDL AS 'PA Equipment Log Detail History File-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA30201 AS ['PA Equipment Log Detail History File']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Equipment Log Detail History File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
14 | PAROUNDAMT ![]() | PA Round Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
15 | PAUNITCOST ![]() | PA Unit Cost | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
16 | ORUNTCST ![]() | Originating Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
17 | PABase_Unit_Cost ![]() | PA Base Unit Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
18 | PAORGBSUNITCST ![]() | PA Originating Base Unit Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
19 | PAOverhead_Amount ![]() | PA Overhead Amount | DLR15_RBU$2 | Currency | 15 | |
20 | PABaseOvhdCost ![]() | PA Base Overhead Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
21 | PAORIGOVHDAMT ![]() | PA Originating Overhead Amount | DLR15_RBU$2 | Currency | 15 | |
22 | PAORIGBASEOVRHCST ![]() | PA Originating Base Overhead Cost | DLR15_RBU$2 | Currency | 15 | |
23 | PAOverheaPercentage ![]() | PA Overhead Percentage | DLR5_%2 | Currency | 8 | |
24 | PATOTALOVERH ![]() | PA Total Overhead | DLR17_RBS0_UTR$ | Currency | 17 | |
25 | PAORIGTOTOVRHD ![]() | PA Originating Total Overhead | DLR17_RBS0_UTR$ | Currency | 17 | |
26 | PAEXTCOST ![]() | PA Extended Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
27 | OREXTCST ![]() | Originating Extended Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
28 | PATOTCST ![]() | PA Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
29 | PAORIGTOTCOST ![]() | PA Originating Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
30 | PABILRATE ![]() | PA Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
31 | PAORIGBILLRATE ![]() | PA Originating Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
32 | PA_Base_Billing_Rate ![]() | PA Base Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
33 | PAORIGBSBILLRTE ![]() | PA Originating Base Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
34 | PAMARKPERCENT ![]() | PA Markup Percentage | DLR5_%2 | Currency | 8 | |
35 | PAACREV ![]() | PA Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
36 | PAORIACCRREV ![]() | PA Originating Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
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 | PASplit_NC ![]() | PA Split NC Qty | DLR15_RBU2 | Currency | 15 | |
40 | PANB_Qty ![]() | PA NB Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
41 | LNITMSEQ ![]() | Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
42 | PAReference_Line_Seq_N ![]() | PA Reference Line Seq No | LI_Sequence_Number | Long Integer | 10 | |
43 | PAbillnoteidx ![]() | PA Billing Note Index | DLR14 | Currency | 14 | |
44 | PAbllngtype ![]() | PA Billing Type | PA_DDL_Billing_Type | Integer | 0 | |
45 | PACONTNUMBER ![]() | PA Contract Number | STR10_LBAU | String | 10 | |
46 | PAexptdate ![]() | PA Export Date | PA_Date | Date | 8 | |
47 | PABilled_QtyN ![]() | PA Billed Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
48 | PABilledTax ![]() | PA Billed Tax | DLR17_RBS0_STR$ | Currency | 17 | |
49 | PABilled_Misc ![]() | PA Billed Misc | DLR17_RBS0_UTR$ | Currency | 17 | |
50 | PAProfitType ![]() | PA Profit Type | PA_DDL_Profit_Type | Integer | 0 | |
51 | PAProfitAmount ![]() | PA Profit Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
52 | PAORIGPROFAMT ![]() | PA Originating Profit Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
53 | PAProfitPercent ![]() | PA Profit Percent | DLR5_%2 | Currency | 8 | |
54 | PATotalProfit ![]() | PA Total Profit | DLR17_RBS0_UTR$ | Currency | 17 | |
55 | PAORIGTOTPROF ![]() | PA Originating Total Profit | DLR17_RBS0_UTR$ | Currency | 17 | |
56 | PAApproved_Quantity ![]() | PA Approved Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
57 | PAAPPROVBILLRATE ![]() | PA Approved Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
58 | PAAPPROVMKUPPCT ![]() | PA Approved Markup Percentage | DLR5_%2 | Currency | 8 | |
59 | PAApproved_Billing_Amou ![]() | PA Approved Billing Amount | DLR17_RBSO_STR$ | Currency | 17 | |
60 | PA_Billed_Profit_Amount_ ![]() | PA Billed Profit Amount Average | DLR17_RBS0_UTR$ | Currency | 17 | |
61 | PABilledProfitPercentage ![]() | PA Billed Profit Percentage Average | DLR5_%2 | Currency | 8 | |
62 | PABilled_Amount ![]() | PA Billed Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
63 | PABilled_Freight ![]() | PA Billed Freight | DLR17_RBS0_UTR$ | Currency | 17 | |
64 | PABilled_Discount ![]() | PA Billed Discount | DLR17_RBS0_UTR$ | Currency | 17 | |
65 | PAWrite_UpDown_Amount ![]() | PA Write Up/Down Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
66 | PAWrite_UpDown_Percenta ![]() | PA Write Up/Down Percentage | PA_LI5_%2S | Long Integer | 5 | |
67 | PAApprover_ID ![]() | PA Approver ID | STR15 | String | 15 | |
68 | PAApprover_Type ![]() | PA Approver Type | DDL_Approver_Type | Integer | 0 | |
69 | PAPartial_Bill ![]() | PA Partial Bill | CB | Boolean | 0 | |
70 | PABilling_StatusN ![]() | PA Billing Status | DDL_Billing_Status | Integer | 0 | |
71 | PACGBWIPIDX ![]() | PA WIP IDX | LI_14 | Long Integer | 14 | |
72 | PAUnbilled_AR_Idx ![]() | PA Unbilled AR IDX | LI_14 | Long Integer | 14 | |
73 | PAUnbilled_Proj_Rev_Idx ![]() | PA Unbilled Proj Rev IDX | LI_14 | Long Integer | 14 | |
74 | PAOverhead_IDX ![]() | PA Overhead IDX | LI_14 | Long Integer | 14 | |
75 | PAContra_Account_IDX ![]() | PA Contra Account IDX | LI_14 | Long Integer | 14 | |
76 | PACogs_Idx ![]() | PA COGS IDX | LI_14 | Long Integer | 14 | |
77 | RNDDIFF ![]() | Rounding Difference | LI_14 | Long Integer | 14 | |
78 | PACHGORDNO ![]() | PA Change Order Number | STR17_LBAU | String | 17 | |
79 | PACBADDFRMFLY ![]() | PA CB From Add On The Fly | CB | Boolean | 0 | |
80 | PA_Billed_Status ![]() | PA Billed Status | CB | Boolean | 0 | |
81 | PAMCCURNCYID ![]() | PA MC Currency ID | STR15_Currency_ID | String | 15 | |
82 | PA_MC_Billing_Rate ![]() | PA MC Billing Rate | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
83 | PA_MC_Base_Billing_Rate ![]() | PA MC Base Billing Rate | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
84 | PA_MC_Accrued_Revenue ![]() | PA MC Accrued Revenue | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
85 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Equipment Log Detail History File'].CURRNIDX AS 'PA Equipment Log Detail History File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PA30201 AS ['PA Equipment Log Detail History File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Equipment Log Detail History File'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
86 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PA Equipment Log Detail History File'].RATETPID AS 'PA Equipment Log Detail History File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PA30201 AS ['PA Equipment Log Detail History File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PA Equipment Log Detail History File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
87 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['PA Equipment Log Detail History File'].EXGTBLID AS 'PA Equipment Log Detail History File-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PA30201 AS ['PA Equipment Log Detail History File']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PA Equipment Log Detail History File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
88 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
89 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 6 | |
90 | TIME1 ![]() | Time | TM6 | Time | 6 | |
91 | RATECALC ![]() | Rate Calc Method | INT | Integer | 0 | |
92 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
93 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 1 | |
94 | Correcting_Trx_Type ![]() | Correcting Trx Type | INT | Integer | 0 | |
95 | PAORIGINLDOCNUM ![]() | PA Original Document Number | STR17_LBAU | String | 17 | |
96 | PAORIGLINEIMSEQ ![]() | PA Original Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
97 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |