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