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