Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11801
Product: Project Accounting (258)
Series: Project
Display Name: PA Combined History Detail File Group Display Name: PA Combined History
Physical Name: PA11801
Technical Name: PA_Combined_History_WORK_LINE
Group Technical Name: PA Combined History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PATU ![]() | PA Transaction Usage | PA_DDL_Transaction_Usage | Integer | 0 | |
2 | PADocnumber20 ![]() | PA Document No. | STR17_LBAU | String | 17 | |
3 | PAREFNO ![]() | PA Reference Document No. | STR17_LBAU | String | 17 | |
4 | PADT ![]() | PA Date | PA_Date | Date | 8 | |
5 | PApurordnum ![]() | PA Purchase Order No. | STR17_LBAU | String | 17 | |
6 | PACONTNUMBER ![]() | PA Contract Number | STR10_LBAU | String | 10 | |
7 | PAPROJNUMBER ![]() | PA Project Number | STR15_LBAU | String | 15 | |
8 | PACOSTCATID ![]() | PA Cost Category ID | STR15_Cost_Category_ID | String | 15 | |
9 | PAContMgrID ![]() | PA Contract Manager ID | STR15_Employee_ID | String | 15 | |
10 | PAitemnumber ![]() | PA Item Number | STR30 | String | 30 | |
11 | EMPLOYID ![]() | Employee ID | STR15_Employee_ID | String | 15 | |
12 | PACOSTOWNER ![]() | PA Cost Owner | STR30_Item_Number | String | 30 | |
13 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['PA Combined History Detail File'].CUSTNMBR AS 'PA Combined History Detail File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Combined History Detail File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
14 | PAprojmngrid ![]() | PA Project Manager ID | STR15_Employee_ID | String | 15 | |
15 | PAProjectType ![]() | PA Project Type | PA_DDL_Project_Type | Integer | 0 | |
16 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['PA Combined History Detail File'].SLPRSNID AS 'PA Combined History Detail File-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['PA Combined History Detail File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
17 | PATB ![]() | PA Time Begin | TM6 | Time | 6 | |
18 | PATE ![]() | PA Time End | TM6 | Time | 6 | |
19 | PAconvtmints ![]() | PA Converted Minutes | INT5_RU0 | Integer | 5 | |
20 | PAbillnoteidx ![]() | PA Billing Note Index | DLR14 | Currency | 14 | |
21 | PAQtyQ ![]() | PA Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
22 | PABase_Qty ![]() | PA Base Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
23 | PAUnit_of_Measure ![]() | PA Unit of Measure | U_Of_M | String | 8 | |
24 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['PA Combined History Detail File'].UOMSCHDL AS 'PA Combined History Detail File-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Combined History Detail File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
25 | PAUNITCOST ![]() | PA Unit Cost | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
26 | ORUNTCST ![]() | Originating Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
27 | PABase_Unit_Cost ![]() | PA Base Unit Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
28 | PAORGBSUNITCST ![]() | PA Originating Base Unit Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
29 | PAOverhead_Amount ![]() | PA Overhead Amount | DLR15_RBU$2 | Currency | 15 | |
30 | PAORIGOVHDAMT ![]() | PA Originating Overhead Amount | DLR15_RBU$2 | Currency | 15 | |
31 | PAOverheaPercentage ![]() | PA Overhead Percentage | DLR5_%2 | Currency | 8 | |
32 | PATOTALOVERH ![]() | PA Total Overhead | DLR17_RBS0_UTR$ | Currency | 17 | |
33 | PAORIGTOTOVRHD ![]() | PA Originating Total Overhead | DLR17_RBS0_UTR$ | Currency | 17 | |
34 | PATOTCST ![]() | PA Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
35 | PAORIGTOTCOST ![]() | PA Originating Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
36 | PAbllngtype ![]() | PA Billing Type | PA_DDL_Billing_Type | Integer | 0 | |
37 | BKTPURAM ![]() | Backout Purchases Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
38 | PABILRATE ![]() | PA Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
39 | PAORIGBILLRATE ![]() | PA Originating Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
40 | PA_Base_Billing_Rate ![]() | PA Base Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
41 | PAORIGBSBILLRTE ![]() | PA Originating Base Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
42 | PAMARKPERCENT ![]() | PA Markup Percentage | DLR5_%2 | Currency | 8 | |
43 | PAACREV ![]() | PA Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
44 | PAORIACCRREV ![]() | PA Originating Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
45 | PASTD_Qty ![]() | PA STD Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
46 | PANC_Qty ![]() | PA NC Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
47 | PASplit_NC ![]() | PA Split NC Qty | DLR15_RBU2 | Currency | 15 | |
48 | PANB_Qty ![]() | PA NB Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
49 | PAPurchase_Tax_Options ![]() | PA Purchase Tax Options | PA_DDL_Tax_Options_Purchase | Integer | 0 | |
50 | ITMTSHID ![]() | Item Tax Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Combined History Detail File'].ITMTSHID AS 'PA Combined History Detail File-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Combined History Detail File'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
51 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
52 | FRTAMNT ![]() | Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
53 | MSCCHAMT ![]() | Misc Charges Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
54 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
55 | LNITMSEQ ![]() | Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
56 | PAReference_Line_Seq_N ![]() | PA Reference Line Seq No | LI_Sequence_Number | Long Integer | 10 | |
57 | PAexptdate ![]() | PA Export Date | PA_Date | Date | 8 | |
58 | PABilling_StatusN ![]() | PA Billing Status | DDL_Billing_Status | Integer | 0 | |
59 | PAUD1 ![]() | PA User Defined 1 | STR20 | String | 20 | |
60 | PAUD2 ![]() | PA User Defined 2 | STR20 | String | 20 | |
61 | PAprjclsid ![]() | PA Project Class ID | STR15_Project_Class_ID | String | 15 | |
62 | CUSTCLAS ![]() | Customer Class | STR15_Customer_Class | String | 15 | |
63 | PAcontclassid ![]() | PA Contract Class ID | STR15_Contract_Class_ID | String | 15 | |
64 | PACOSTCATCLASID ![]() | PA Cost Category Class ID | STR15_Cost_Category_Class_ID | String | 15 | |
65 | PAPayCode ![]() | PA Pay Code | STR6_Payroll_Code | String | 6 | |
66 | STATECD ![]() | State Code | STR2_State_Code | String | 2 | |
67 | LOCLCODE ![]() | Local Code | STR6_Payroll_Code | String | 6 | |
68 | SUTASTAT ![]() | Suta State | STR2_State_Code | String | 2 | |
69 | WRKRCOMP ![]() | Workers Comp | STR6_Payroll_Code | String | 6 | |
70 | PASalary_Posting_Type ![]() | PA Salary Posting Type | GB | Integer | 0 | |
71 | PAJob_Title ![]() | PA Job Title | STR6_Payroll_Code | String | 6 | |
72 | PADepartment ![]() | PA Department | STR6_Payroll_Code | String | 6 | |
73 | PABilled_QtyN ![]() | PA Billed Qty | PA_DLR15_RBS0_STR | Currency | 15 | |
74 | PABilledTax ![]() | PA Billed Tax | DLR17_RBS0_STR$ | Currency | 17 | |
75 | PABilled_Misc ![]() | PA Billed Misc | DLR17_RBS0_UTR$ | Currency | 17 | |
76 | PAProfitType ![]() | PA Profit Type | PA_DDL_Profit_Type | Integer | 0 | |
77 | PAProfitAmount ![]() | PA Profit Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
78 | PAORIGPROFAMT ![]() | PA Originating Profit Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
79 | PAProfitPercent ![]() | PA Profit Percent | DLR5_%2 | Currency | 8 | |
80 | PATotalProfit ![]() | PA Total Profit | DLR17_RBS0_UTR$ | Currency | 17 | |
81 | PAORIGTOTPROF ![]() | PA Originating Total Profit | DLR17_RBS0_UTR$ | Currency | 17 | |
82 | PAApproved_Quantity ![]() | PA Approved Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
83 | PAAPPROVBILLRATE ![]() | PA Approved Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
84 | PAAPPROVMKUPPCT ![]() | PA Approved Markup Percentage | DLR5_%2 | Currency | 8 | |
85 | PAApproved_Billing_Amou ![]() | PA Approved Billing Amount | DLR17_RBSO_STR$ | Currency | 17 | |
86 | PA_Billed_Profit_Amount_ ![]() | PA Billed Profit Amount Average | DLR17_RBS0_UTR$ | Currency | 17 | |
87 | PABilledProfitPercentage ![]() | PA Billed Profit Percentage Average | DLR5_%2 | Currency | 8 | |
88 | PABilled_Amount ![]() | PA Billed Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
89 | PABilled_Freight ![]() | PA Billed Freight | DLR17_RBS0_UTR$ | Currency | 17 | |
90 | PABilled_Discount ![]() | PA Billed Discount | DLR17_RBS0_UTR$ | Currency | 17 | |
91 | PAWrite_UpDown_Amount ![]() | PA Write Up/Down Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
92 | PAWrite_UpDown_Percenta ![]() | PA Write Up/Down Percentage | PA_LI5_%2S | Long Integer | 5 | |
93 | PAApprover_ID ![]() | PA Approver ID | STR15 | String | 15 | |
94 | PAApprover_Type ![]() | PA Approver Type | DDL_Approver_Type | Integer | 0 | |
95 | PAPartial_Bill ![]() | PA Partial Bill | CB | Boolean | 0 | |
96 | PACGBWIPIDX ![]() | PA WIP IDX | LI_14 | Long Integer | 14 | |
97 | PAUnbilled_AR_Idx ![]() | PA Unbilled AR IDX | LI_14 | Long Integer | 14 | |
98 | PAUnbilled_Proj_Rev_Idx ![]() | PA Unbilled Proj Rev IDX | LI_14 | Long Integer | 14 | |
99 | PAOverhead_IDX ![]() | PA Overhead IDX | LI_14 | Long Integer | 14 | |
100 | PAContra_Account_IDX ![]() | PA Contra Account IDX | LI_14 | Long Integer | 14 | |
101 | PACogs_Idx ![]() | PA COGS IDX | LI_14 | Long Integer | 14 | |
102 | PAPaymentMethod ![]() | PA Payment Method | PA_DDL_Payment_Method | Integer | 0 | |
103 | PAExpenseType ![]() | PA Expense Type | PA_DDL_Expense_Type | Integer | 0 | |
104 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['PA Combined History Detail File'].LOCNCODE AS 'PA Combined History Detail File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['PA Combined History Detail File'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
105 | PRICELVL ![]() | Price Level | STR15_LBAU | String | 15 | |
106 | IVIVINDX ![]() | IV IV Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PA Combined History Detail File'].IVIVINDX AS 'PA Combined History Detail File-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PA11801 AS ['PA Combined History Detail File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PA Combined History Detail File'].IVIVINDX = ['Account Index Master'].ACTINDX | ||||||
107 | IVIVOFAC ![]() | IV IV Offset Account | Account_Number | Composite | 80 | |
108 | IVIVOFAC_1 ![]() | IV IV Offset Account:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
109 | IVIVOFAC_2 ![]() | IV IV Offset Account:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
110 | IVIVOFAC_3 ![]() | IV IV Offset Account:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
111 | IVIVOFAC_4 ![]() | IV IV Offset Account:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
112 | IVIVOFAC_5 ![]() | IV IV Offset Account:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
113 | IVIVOFAC_6 ![]() | IV IV Offset Account:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
114 | IVIVOFAC_7 ![]() | IV IV Offset Account:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
115 | IVIVOFAC_8 ![]() | IV IV Offset Account:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
116 | IVIVOFAC_9 ![]() | IV IV Offset Account:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
117 | IVIVOFAC_10 ![]() | IV IV Offset Account:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
118 | 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. |