PA Combined History Detail File (PA11801)

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
Physical Name: PA11801
Technical Name: PA_Combined_History_WORK_LINE

Group Display Name: PA Combined History
Group Technical Name: PA Combined History

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

azurecurve Products Project Accounting (258)ProjectPA Combined History Detail File (PA11801)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply