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 |