PA Billing Detail OPEN (PA23200)

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

Product: Project Accounting (258)
Series: Project

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PABILLTRXT SearchPA Biller Trx TypePA_DDL_Biller_Trx_TypeInteger20
2PADocnumber20 SearchPA Document No.STR17_LBAUString1817
3PADOCDT SearchPA Document DatePA_DateDate48
4PAREFNO SearchPA Reference Document No.STR17_LBAUString1817
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
6CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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
7PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
8PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
9PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
10PApurordnum SearchPA Purchase Order No.STR17_LBAUString1817
11PABillingAmount SearchPA Billing AmountDLR17_RBS0_UTR$Currency1017
12PATMbillamount SearchPA Billing Amount - TMDLR17_RBS0_UTR$Currency1017
13PAFFbillamount SearchPA Billing Amount - FFPA_DLR17_RBS0_STR$Currency1017
14PAFeebillamount SearchPA Billing Amount - FeeDLR17_RBSO_STR$Currency1017
15PAtotbillings SearchPA Total BillingsDLR17_RBS0_UTR$Currency1017
16PA_Discount_Type SearchPA Discount TypeGBInteger20
17TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
18PA_Trade_Discount_Pcnt SearchPA Trade Discount PercentINT5_%2Integer25
19PATOTTAX SearchPA Total TaxDLR15_RBU$2Currency1015
20PATMtaxamt SearchPA Tax Amt - TMDLR17_RBS0_UTR$Currency1017
21PAFFtaxamt SearchPA Tax Amt - FFDLR17_RBS0_UTR$Currency1017
22PAFeetaxamount SearchPA Tax Amt - FeeDLR17_RBS0_UTR$Currency1017
23PABACKBILL SearchPA Backout Bill AmountDLR19_RBS0_UTR$Currency1019
24PATMbckoutbillamt SearchPA Backout Bill Amt - TMDLR17_RBS0_UTR$Currency1017
25PAPBbckoutbillamt SearchPA Backout Bill Amt - FFDLR17_RBS0_UTR$Currency1017
26PAFeebckoutbillamt SearchPA Backout Bill Amt - FeeDLR17_RBS0_UTR$Currency1017
27APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
28ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
29PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency1017
30PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
31PA_Applied_Retainer SearchPA Applied Document AmtPA_DLR17_RBS0_STR$Currency1017
32PA_Applied_Freight_Misc SearchPA Applied Freight MiscPA_DLR17_RBS0_STR$Currency1017
33AGNGBUKT SearchAging BucketINT1_U0Integer21
34CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
35PA_Trade_IDX SearchPA Trade IDXLI_14Long Integer414
36TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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
37PAOrigBillAmount SearchPA Originating Billing AmountDLR17_RBSO_STR$Currency1017
38PAOrigBillingAmtTM SearchPA Originating Billing Amount - TMDLR17_RBS0_STR$Currency1017
39PAOrigBillingAmtFF SearchPA Originating Billing Amount - FFDLR17_RBS0_STR$Currency1017
40PAOrigBillingAmtFee SearchPA Originating Billing Amount - FeeDLR17_RBS0_STR$Currency1017
41PAOrigTotalBilings SearchPA Originating Total BillingsDLR17_RBS0_STR$Currency1017
42PAOrigTotalTaxAmt SearchPA Originating Total TaxDLR17_RBSO_STR$Currency1017
43PAOrigTaxAmtTM_ SearchPA Originating Tax Amt - TMDLR17_RBS0_STR$Currency1017
44PAOrigTaxAmtFF SearchPA Originating Tax Amt - FFDLR17_RBS0_STR$Currency1017
45PAOrigTaxAmtFee SearchPA Originating Tax Amt - FeeDLR17_RBS0_STR$Currency1017
46PAOrigBackoutBillAmt SearchPA Originating Backout Bill AmtDLR17_RBS0_STR$Currency1017
47PAOrigBackoutBillTM SearchPA Originating Backout Bill Amt - TMDLR17_RBS0_STR$Currency1017
48PAOrigBackoutBillFF SearchPA Originating Backout Bill Amt - FFDLR17_RBS0_STR$Currency1017
49PAOrigBackoutBillFee SearchPA Originating Backout Bill Amt - FeeDLR17_RBS0_STR$Currency1017
50PAOrigRetentionFeeAmt SearchPA Originating Retention Fee AmtDLR17_RBS0_STR$Currency1017
51PAOrigRetainerFeeAmt SearchPA Originating Retainer Fee AmtDLR17_RBS0_STR$Currency1017
52ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
53ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency1017
54ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency1019
55ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency1017
56PAOrigAppliedDocAmt SearchPA Originating Applied Document AmtDLR17_RBS0_STR$Currency1017
57PAOrigAppliedFreightMisc SearchPA Originating Applied Freight MiscDLR17_RBS0_STR$Currency1017
58BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
59OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
60PA_Third_Party_CB SearchPA Third Party CBCBBoolean20
61BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
62OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
63PA_Backout_Retention_Tax SearchPA Backout Retention Tax AmountPA_DLR17_RBS0_STR$Currency1017
64PA_OrigBackRetentionTax SearchPA Originating Backout Retention Tax AmountPA_DLR17_RBS0_STR$Currency1017
65DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *