PA Billing Detail OPEN (PA23200)

azurecurve Products Project Accounting (258)ProjectPA Billing Detail OPEN (PA23200)

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

Product: Project Accounting (258)
Series:

Display Name: PA Billing Detail OPEN
Physical Name: PA23200
Technical Name: PA_Billing_DTL_OPEN

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	PADOCDT	PA Document Date	Date	PA_Date	8
4	PAREFNO	PA Reference Document No.	String	STR17_LBAU	17
5	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
6	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['PA Billing Detail OPEN'].CUSTNMBR AS 'PA Billing Detail OPEN-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PA23200 AS ['PA Billing Detail OPEN'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['PA Billing Detail OPEN'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
7	PACONTNUMBER	PA Contract Number	String	STR10_LBAU	10
8	PAPROJNUMBER	PA Project Number	String	STR15_LBAU	15
9	PAProjectType	PA Project Type	Integer	PA_DDL_Project_Type	0
10	PApurordnum	PA Purchase Order No.	String	STR17_LBAU	17
11	PABillingAmount	PA Billing Amount	Currency	DLR17_RBS0_UTR$	17
12	PATMbillamount	PA Billing Amount - TM	Currency	DLR17_RBS0_UTR$	17
13	PAFFbillamount	PA Billing Amount - FF	Currency	PA_DLR17_RBS0_STR$	17
14	PAFeebillamount	PA Billing Amount - Fee	Currency	DLR17_RBSO_STR$	17
15	PAtotbillings	PA Total Billings	Currency	DLR17_RBS0_UTR$	17
16	PA_Discount_Type	PA Discount Type	Integer	GB	0
17	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
18	PA_Trade_Discount_Pcnt	PA Trade Discount Percent	Integer	INT5_%2	5
19	PATOTTAX	PA Total Tax	Currency	DLR15_RBU$2	15
20	PATMtaxamt	PA Tax Amt - TM	Currency	DLR17_RBS0_UTR$	17
21	PAFFtaxamt	PA Tax Amt - FF	Currency	DLR17_RBS0_UTR$	17
22	PAFeetaxamount	PA Tax Amt - Fee	Currency	DLR17_RBS0_UTR$	17
23	PABACKBILL	PA Backout Bill Amount	Currency	DLR19_RBS0_UTR$	19
24	PATMbckoutbillamt	PA Backout Bill Amt - TM	Currency	DLR17_RBS0_UTR$	17
25	PAPBbckoutbillamt	PA Backout Bill Amt - FF	Currency	DLR17_RBS0_UTR$	17
26	PAFeebckoutbillamt	PA Backout Bill Amt - Fee	Currency	DLR17_RBS0_UTR$	17
27	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
28	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
29	PARetentionFeeAmount	PA Retention Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
30	PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
31	PA_Applied_Retainer	PA Applied Document Amt	Currency	PA_DLR17_RBS0_STR$	17
32	PA_Applied_Freight_Misc	PA Applied Freight Misc	Currency	PA_DLR17_RBS0_STR$	17
33	AGNGBUKT	Aging Bucket	Integer	INT1_U0	1
34	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
35	PA_Trade_IDX	PA Trade IDX	Long Integer	LI_14	14
36	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Billing Detail OPEN'].TAXSCHID AS 'PA Billing Detail OPEN-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA23200 AS ['PA Billing Detail OPEN'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Billing Detail OPEN'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
37	PAOrigBillAmount	PA Originating Billing Amount	Currency	DLR17_RBSO_STR$	17
38	PAOrigBillingAmtTM	PA Originating Billing Amount - TM	Currency	DLR17_RBS0_STR$	17
39	PAOrigBillingAmtFF	PA Originating Billing Amount - FF	Currency	DLR17_RBS0_STR$	17
40	PAOrigBillingAmtFee	PA Originating Billing Amount - Fee	Currency	DLR17_RBS0_STR$	17
41	PAOrigTotalBilings	PA Originating Total Billings	Currency	DLR17_RBS0_STR$	17
42	PAOrigTotalTaxAmt	PA Originating Total Tax	Currency	DLR17_RBSO_STR$	17
43	PAOrigTaxAmtTM_	PA Originating Tax Amt - TM	Currency	DLR17_RBS0_STR$	17
44	PAOrigTaxAmtFF	PA Originating Tax Amt - FF	Currency	DLR17_RBS0_STR$	17
45	PAOrigTaxAmtFee	PA Originating Tax Amt - Fee	Currency	DLR17_RBS0_STR$	17
46	PAOrigBackoutBillAmt	PA Originating Backout Bill Amt	Currency	DLR17_RBS0_STR$	17
47	PAOrigBackoutBillTM	PA Originating Backout Bill Amt - TM	Currency	DLR17_RBS0_STR$	17
48	PAOrigBackoutBillFF	PA Originating Backout Bill Amt - FF	Currency	DLR17_RBS0_STR$	17
49	PAOrigBackoutBillFee	PA Originating Backout Bill Amt - Fee	Currency	DLR17_RBS0_STR$	17
50	PAOrigRetentionFeeAmt	PA Originating Retention Fee Amt	Currency	DLR17_RBS0_STR$	17
51	PAOrigRetainerFeeAmt	PA Originating Retainer Fee Amt	Currency	DLR17_RBS0_STR$	17
52	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
53	ORAPPAMT	Originating Applied Amount	Currency	DLR17_RBS0_STR$	17
54	ORACTAMT	Originating Account Amount	Currency	DLR19_RBS0_UTR$	19
55	ORCTRXAM	Originating Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
56	PAOrigAppliedDocAmt	PA Originating Applied Document Amt	Currency	DLR17_RBS0_STR$	17
57	PAOrigAppliedFreightMisc	PA Originating Applied Freight Misc	Currency	DLR17_RBS0_STR$	17
58	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
59	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
60	PA_Third_Party_CB	PA Third Party CB	Boolean	CB	0
61	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
62	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
63	PA_Backout_Retention_Tax	PA Backout Retention Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
64	PA_OrigBackRetentionTax	PA Originating Backout Retention Tax Amount	Currency	PA_DLR17_RBS0_STR$	17

azurecurve Products Project Accounting (258)ProjectPA Billing Detail OPEN (PA23200)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply