PA Billing Sub-Detail OPEN Fee (PA23201)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Billing Sub-Detail OPEN Fee
Physical Name: PA23201
Technical Name: PA_Billing_Sub_DTL_OPEN_Fee

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	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
4	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
5	CUTOFDAT	Cutoff Date	DT	Date	4	8
6	PAFeeID	PA Fee ID	STR15_LBAU	String	16	15
7	PAFeebillamount	PA Billing Amount - Fee	DLR17_RBSO_STR$	Currency	10	17
8	PAFeeAmount	PA Fee Amount	DLR17_RBSO_STR$	Currency	10	17
9	PAPreviously_Billed	PA Previously Billed	DLR17_RBS0_STR$	Currency	10	17
10	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
11	PAbilltaxscheduleid	PA Billing Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
12	PAFeetaxamount	PA Tax Amt - Fee	DLR17_RBS0_UTR$	Currency	10	17
13	PABACKBILL	PA Backout Bill Amount	DLR19_RBS0_UTR$	Currency	10	19
14	PAFeeType	PA Fee Type	PA_DDL_Fee_Type	Integer	2	0
15	PARetainer_Fee_Amount	PA Retainer Fee Amount	PA_DLR17_RBS0_STR$	Currency	10	17
16	CURTRXAM	Current Trx Amount	DLR17_RBS0_UTR$	Currency	10	17
17	ORTRXAMT	Original Trx Amount	DLR17_RBS0_STR$	Currency	10	17
18	PA_Project_Sales_IDX	PA Project Sales IDX	LI_14	Long Integer	4	14
19	PAAR_IDX	PA AR IDX	LI_14	Long Integer	4	14
20	PA_Deferred_RevIDX	PA Deferred Rev IDX	LI_14	Long Integer	4	14
21	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	4	14
22	PABProjectBlgsIDX	PA Project Blgs IDX	LI_14	Long Integer	4	14
23	PA_FF_AR_IDX	PA FF AR IDX	LI_14	Long Integer	4	14
24	PABProjectRevenueIDX	PA Project Revenue IDX	LI_14	Long Integer	4	14
25	PA_Retention_AR	PA Retention AR IDX	LI_14	Long Integer	4	14
26	PA_FF_Deferred_Rev_IDX	PA FF Deferred Rev IDX	LI_14	Long Integer	4	14
27	PA_Trade_Discount_Amount	PA Trade Discount Amount	PA_DLR17_RBS0_STR$	Currency	10	17
28	PARetentionFeeAmount	PA Retention Fee Amount	PA_DLR17_RBS0_STR$	Currency	10	17
29	PA_Retention_IDX	PA Retention IDX	LI_14	Long Integer	4	14
30	PAUD1	PA User Defined 1	STR20	String	22	20
31	PAUD2	PA User Defined 2	STR20	String	22	20
32	PAOrigBillingAmtFee	PA Originating Billing Amount - Fee	DLR17_RBS0_STR$	Currency	10	17
33	PAOrigFeeAmount	PA Originating Fee Amount	DLR17_RBS0_STR$	Currency	10	17
34	PAOrigPrevBill	PA Originating Prev Billed	DLR17_RBS0_STR$	Currency	10	17
35	PAOrigTaxAmtFee	PA Originating Tax Amt - Fee	DLR17_RBS0_STR$	Currency	10	17
36	PAOrigBackoutBillAmt	PA Originating Backout Bill Amt	DLR17_RBS0_STR$	Currency	10	17
37	ORCTRXAM	Originating Current Trx Amount	DLR17_RBS0_UTR$	Currency	10	17
38	ORORGTRX	Originating Original Trx Amount	DLR17_RBS0_STR$	Currency	10	17
39	PAOrigTradeDiscAmt	PA Originating Trade Discount Amt	DLR17_RBS0_STR$	Currency	10	17
40	PAOrigRetentionFeeAmt	PA Originating Retention Fee Amt	DLR17_RBS0_STR$	Currency	10	17
41	PA_Previous_Retention	PA Previous Retention	DLR17_RBS0_STR$	Currency	10	17
42	PAOPREVRETENTION	PA Originating Previous Retention	DLR17_RBS0_STR$	Currency	10	17
43	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	18	17
44	BackoutTradeDisc	Backout Trade Discount Amount	DLR19_RBS0_UTR$	Currency	10	19
45	OrigBackoutTradeDisc	Originating Backout Trade Discount Amount	DLR19_RBS0_UTR$	Currency	10	19
46	PA_Backout_Retention_Amt	PA Backout Retention Amount	PA_DLR17_RBS0_STR$	Currency	10	17
47	PA_OrigBackRetentionAmt	PA Originating Backout Retention Amount	PA_DLR17_RBS0_STR$	Currency	10	17
48	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 Fee (PA23201)

Leave a Reply Cancel reply