Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA23203
Product: Project Accounting (258)
Series: Project
Display Name: PA Billing Sub-Detail OPEN TM Group Display Name: PA Billing Transactions Open
Physical Name: PA23203
Technical Name: PA_Billing_Sub_DTL_OPEN_TM
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 | PACOSTDOCNO ![]() | PA Cost Document No. | STR17_LBAU | String | 17 | |
4 | PACOSTSEQNO ![]() | PA Cost Sequence No. | LI_Sequence_Number | Long Integer | 10 | |
5 | LNITMSEQ ![]() | Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
6 | PASSN ![]() | PA Split Sequence Number | LI_14 | Long Integer | 14 | |
7 | PAReference_Line_Seq_N ![]() | PA Reference Line Seq No | LI_Sequence_Number | Long Integer | 10 | |
8 | PAPROJNUMBER ![]() | PA Project Number | STR15_LBAU | String | 15 | |
9 | PATU ![]() | PA Transaction Usage | PA_DDL_Transaction_Usage | Integer | 0 | |
10 | PACOSTCATID ![]() | PA Cost Category ID | STR15_Cost_Category_ID | String | 15 | |
11 | PAbllngtype ![]() | PA Billing Type | PA_DDL_Billing_Type | Integer | 0 | |
12 | PACOSTDATE ![]() | PA Cost Date | DATE | Date | 6 | |
13 | PACOSTOWNER ![]() | PA Cost Owner | STR30_Item_Number | String | 30 | |
14 | PAUnit_of_Measure ![]() | PA Unit of Measure | U_Of_M | String | 8 | |
15 | PAUNITCOST ![]() | PA Unit Cost | PA_DLR17_RBS0_UTR$ | Currency | 17 | |
16 | PAProfitType ![]() | PA Profit Type | PA_DDL_Profit_Type | Integer | 0 | |
17 | PABILRATE ![]() | PA Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
18 | PAMARKPERCENT ![]() | PA Markup Percentage | DLR5_%2 | Currency | 8 | |
19 | PAQtyQ ![]() | PA Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
20 | PAACREV ![]() | PA Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
21 | PATOTCST ![]() | PA Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
22 | PAWrite_UpDown_Amount ![]() | PA Write Up/Down Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
23 | PAWrite_UpDown_Percenta ![]() | PA Write Up/Down Percentage | PA_LI5_%2S | Long Integer | 5 | |
24 | PAApproved_Quantity ![]() | PA Approved Quantity | PA_DLR15_RBS0_STR | Currency | 15 | |
25 | PAAPPROVBILLRATE ![]() | PA Approved Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
26 | PAAPPROVMKUPPCT ![]() | PA Approved Markup Percentage | DLR5_%2 | Currency | 8 | |
27 | PAApproved_Billing_Amou ![]() | PA Approved Billing Amount | DLR17_RBSO_STR$ | Currency | 17 | |
28 | PARecognizedRevenue ![]() | PA Recognized Revenue | DLR17_RBS0_STR$ | Currency | 17 | |
29 | PAbillnoteidx ![]() | PA Billing Note Index | DLR14 | Currency | 14 | |
30 | PATMtaxamt ![]() | PA Tax Amt - TM | DLR17_RBS0_UTR$ | Currency | 17 | |
31 | PARetainer_Fee_Amount ![]() | PA Retainer Fee Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
32 | PAbilltaxscheduleid ![]() | PA Billing Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
33 | PABACKBILL ![]() | PA Backout Bill Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
34 | PAAR_IDX ![]() | PA AR IDX | LI_14 | Long Integer | 14 | |
35 | PACogs_Idx ![]() | PA COGS IDX | LI_14 | Long Integer | 14 | |
36 | PARev_IDX ![]() | PA Revenue IDX | LI_14 | Long Integer | 14 | |
37 | PAUnbilled_AR_Idx ![]() | PA Unbilled AR IDX | LI_14 | Long Integer | 14 | |
38 | PAUnbilled_Proj_Rev_Idx ![]() | PA Unbilled Proj Rev IDX | LI_14 | Long Integer | 14 | |
39 | PACGBWIPIDX ![]() | PA WIP IDX | LI_14 | Long Integer | 14 | |
40 | CURTRXAM ![]() | Current Trx Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
41 | ORTRXAMT ![]() | Original Trx Amount | DLR17_RBS0_STR$ | Currency | 17 | |
42 | PA_Trade_Discount_Amount ![]() | PA Trade Discount Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
43 | PA_Variance ![]() | PA Variance | CB | Boolean | 0 | |
44 | PA_Variance_Accrued_Reve ![]() | PA Variance Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
45 | PAOrigUnitCost ![]() | PA Originating Unit Cost | DLR17_RBS0_STR$ | Currency | 17 | |
46 | PAORIGBILLRATE ![]() | PA Originating Billing Rate | DLR17_RBS0_UTR$ | Currency | 17 | |
47 | PAORIACCRREV ![]() | PA Originating Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
48 | PAORIGTOTCOST ![]() | PA Originating Total Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
49 | PAOrigWUDAmt ![]() | PA Originating Write Up/Down Amt | DLR17_RBS0_STR$ | Currency | 17 | |
50 | PAOrigApprBillRate ![]() | PA Originating Approved Billing Rate | DLR17_RBS0_STR$ | Currency | 17 | |
51 | PAOrigApprBillAmt ![]() | PA Originating Approved Billing Amount | DLR17_RBS0_STR$ | Currency | 17 | |
52 | PAOrigRecogRevenue ![]() | PA Originating Recognized Revenue | DLR17_RBS0_STR$ | Currency | 17 | |
53 | PAOrigTaxAmtTM_ ![]() | PA Originating Tax Amt - TM | DLR17_RBS0_STR$ | Currency | 17 | |
54 | PAOrigBackoutBillAmt ![]() | PA Originating Backout Bill Amt | DLR17_RBS0_STR$ | Currency | 17 | |
55 | PAOrigTradeDiscAmt ![]() | PA Originating Trade Discount Amt | DLR17_RBS0_STR$ | Currency | 17 | |
56 | ORCTRXAM ![]() | Originating Current Trx Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
57 | ORORGTRX ![]() | Originating Original Trx Amount | DLR17_RBS0_STR$ | Currency | 17 | |
58 | PAOrigVarAccruedRev ![]() | PA Originating Variance Accrued Rev | DLR17_RBS0_STR$ | Currency | 17 | |
59 | PACHGORDNO ![]() | PA Change Order Number | STR17_LBAU | String | 17 | |
60 | BackoutTradeDisc ![]() | Backout Trade Discount Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
61 | OrigBackoutTradeDisc ![]() | Originating Backout Trade Discount Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
62 | 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. |