PA Billing Sub-Detail OPEN TM (PA23203)

azurecurve Products Project Accounting (258)ProjectPA 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:

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

azurecurve Products Project Accounting (258)ProjectPA Billing Sub-Detail OPEN TM (PA23203)

Leave a Reply Cancel reply