PA Billing Sub-Detail OPEN TM (PA23203)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Billing Sub-Detail OPEN TM
Physical Name: PA23203
Technical Name: PA_Billing_Sub_DTL_OPEN_TM

Group Display Name: PA Billing Transactions Open
Group Technical Name: PA Billing Transactions Open

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PABILLTRXT	PA Biller Trx Type	PA_DDL_Biller_Trx_Type	Integer	2	0
2	PADocnumber20	PA Document No.	STR17_LBAU	String	18	17
3	PACOSTDOCNO	PA Cost Document No.	STR17_LBAU	String	18	17
4	PACOSTSEQNO	PA Cost Sequence No.	LI_Sequence_Number	Long Integer	4	10
5	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
6	PASSN	PA Split Sequence Number	LI_14	Long Integer	4	14
7	PAReference_Line_Seq_N	PA Reference Line Seq No	LI_Sequence_Number	Long Integer	4	10
8	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
9	PATU	PA Transaction Usage	PA_DDL_Transaction_Usage	Integer	2	0
10	PACOSTCATID	PA Cost Category ID	STR15_Cost_Category_ID	String	16	15
11	PAbllngtype	PA Billing Type	PA_DDL_Billing_Type	Integer	2	0
12	PACOSTDATE	PA Cost Date	DATE	Date	4	6
13	PACOSTOWNER	PA Cost Owner	STR30_Item_Number	String	32	30
14	PAUnit_of_Measure	PA Unit of Measure	U_Of_M	String	10	8
15	PAUNITCOST	PA Unit Cost	PA_DLR17_RBS0_UTR$	Currency	10	17
16	PAProfitType	PA Profit Type	PA_DDL_Profit_Type	Integer	2	0
17	PABILRATE	PA Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
18	PAMARKPERCENT	PA Markup Percentage	DLR5_%2	Currency	10	8
19	PAQtyQ	PA Quantity	PA_DLR15_RBS0_STR	Currency	10	15
20	PAACREV	PA Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
21	PATOTCST	PA Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
22	PAWrite_UpDown_Amount	PA Write Up/Down Amount	PA_DLR17_RBS0_STR$	Currency	10	17
23	PAWrite_UpDown_Percenta	PA Write Up/Down Percentage	PA_LI5_%2S	Long Integer	4	5
24	PAApproved_Quantity	PA Approved Quantity	PA_DLR15_RBS0_STR	Currency	10	15
25	PAAPPROVBILLRATE	PA Approved Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
26	PAAPPROVMKUPPCT	PA Approved Markup Percentage	DLR5_%2	Currency	10	8
27	PAApproved_Billing_Amou	PA Approved Billing Amount	DLR17_RBSO_STR$	Currency	10	17
28	PARecognizedRevenue	PA Recognized Revenue	DLR17_RBS0_STR$	Currency	10	17
29	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
30	PATMtaxamt	PA Tax Amt - TM	DLR17_RBS0_UTR$	Currency	10	17
31	PARetainer_Fee_Amount	PA Retainer Fee Amount	PA_DLR17_RBS0_STR$	Currency	10	17
32	PAbilltaxscheduleid	PA Billing Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
33	PABACKBILL	PA Backout Bill Amount	DLR19_RBS0_UTR$	Currency	10	19
34	PAAR_IDX	PA AR IDX	LI_14	Long Integer	4	14
35	PACogs_Idx	PA COGS IDX	LI_14	Long Integer	4	14
36	PARev_IDX	PA Revenue IDX	LI_14	Long Integer	4	14
37	PAUnbilled_AR_Idx	PA Unbilled AR IDX	LI_14	Long Integer	4	14
38	PAUnbilled_Proj_Rev_Idx	PA Unbilled Proj Rev IDX	LI_14	Long Integer	4	14
39	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	4	14
40	CURTRXAM	Current Trx Amount	DLR17_RBS0_UTR$	Currency	10	17
41	ORTRXAMT	Original Trx Amount	DLR17_RBS0_STR$	Currency	10	17
42	PA_Trade_Discount_Amount	PA Trade Discount Amount	PA_DLR17_RBS0_STR$	Currency	10	17
43	PA_Variance	PA Variance	CB	Boolean	2	0
44	PA_Variance_Accrued_Reve	PA Variance Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
45	PAOrigUnitCost	PA Originating Unit Cost	DLR17_RBS0_STR$	Currency	10	17
46	PAORIGBILLRATE	PA Originating Billing Rate	DLR17_RBS0_UTR$	Currency	10	17
47	PAORIACCRREV	PA Originating Accrued Revenues	DLR17_RBS0_UTR$	Currency	10	17
48	PAORIGTOTCOST	PA Originating Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
49	PAOrigWUDAmt	PA Originating Write Up/Down Amt	DLR17_RBS0_STR$	Currency	10	17
50	PAOrigApprBillRate	PA Originating Approved Billing Rate	DLR17_RBS0_STR$	Currency	10	17
51	PAOrigApprBillAmt	PA Originating Approved Billing Amount	DLR17_RBS0_STR$	Currency	10	17
52	PAOrigRecogRevenue	PA Originating Recognized Revenue	DLR17_RBS0_STR$	Currency	10	17
53	PAOrigTaxAmtTM_	PA Originating Tax Amt - TM	DLR17_RBS0_STR$	Currency	10	17
54	PAOrigBackoutBillAmt	PA Originating Backout Bill Amt	DLR17_RBS0_STR$	Currency	10	17
55	PAOrigTradeDiscAmt	PA Originating Trade Discount Amt	DLR17_RBS0_STR$	Currency	10	17
56	ORCTRXAM	Originating Current Trx Amount	DLR17_RBS0_UTR$	Currency	10	17
57	ORORGTRX	Originating Original Trx Amount	DLR17_RBS0_STR$	Currency	10	17
58	PAOrigVarAccruedRev	PA Originating Variance Accrued Rev	DLR17_RBS0_STR$	Currency	10	17
59	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	18	17
60	BackoutTradeDisc	Backout Trade Discount Amount	DLR19_RBS0_UTR$	Currency	10	19
61	OrigBackoutTradeDisc	Originating Backout Trade Discount Amount	DLR19_RBS0_UTR$	Currency	10	19
62	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 Billing Sub-Detail OPEN TM (PA23203)

Leave a Reply Cancel reply