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

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 *