PA Billing Detail HIST (PA33200)

Easily find this page again using the shortlink:

Product: Project Accounting (258)
Series: Project

Display Name: PA Billing Detail HIST
Physical Name: PA33200
Technical Name: PA_Billing_DTL_HIST

Group Display Name: PA Billing Transactions History
Group Technical Name: PA Billing Transactions History

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

       ['PA Billing Detail HIST'].CUSTNMBR AS 'PA Billing Detail HIST-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
       PA33200 AS ['PA Billing Detail HIST']
       RM00101 AS ['RM Customer MSTR']
                     ['PA Billing Detail HIST'].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
33PA_Trade_IDX SearchPA Trade IDXLI_14Long Integer14
34TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

       ['PA Billing Detail HIST'].TAXSCHID AS 'PA Billing Detail HIST-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
       PA33200 AS ['PA Billing Detail HIST']
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
                     ['PA Billing Detail HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
35PAOrigBillAmount SearchPA Originating Billing AmountDLR17_RBSO_STR$Currency17
36PAOrigBillingAmtTM SearchPA Originating Billing Amount - TMDLR17_RBS0_STR$Currency17
37PAOrigBillingAmtFF SearchPA Originating Billing Amount - FFDLR17_RBS0_STR$Currency17
38PAOrigBillingAmtFee SearchPA Originating Billing Amount - FeeDLR17_RBS0_STR$Currency17
39PAOrigTotalBilings SearchPA Originating Total BillingsDLR17_RBS0_STR$Currency17
40PAOrigTotalTaxAmt SearchPA Originating Total TaxDLR17_RBSO_STR$Currency17
41PAOrigTaxAmtTM_ SearchPA Originating Tax Amt - TMDLR17_RBS0_STR$Currency17
42PAOrigTaxAmtFF SearchPA Originating Tax Amt - FFDLR17_RBS0_STR$Currency17
43PAOrigTaxAmtFee SearchPA Originating Tax Amt - FeeDLR17_RBS0_STR$Currency17
44PAOrigBackoutBillAmt SearchPA Originating Backout Bill AmtDLR17_RBS0_STR$Currency17
45PAOrigBackoutBillTM SearchPA Originating Backout Bill Amt - TMDLR17_RBS0_STR$Currency17
46PAOrigBackoutBillFF SearchPA Originating Backout Bill Amt - FFDLR17_RBS0_STR$Currency17
47PAOrigBackoutBillFee SearchPA Originating Backout Bill Amt - FeeDLR17_RBS0_STR$Currency17
48PAOrigRetentionFeeAmt SearchPA Originating Retention Fee AmtDLR17_RBS0_STR$Currency17
49PAOrigRetainerFeeAmt SearchPA Originating Retainer Fee AmtDLR17_RBS0_STR$Currency17
50PAOrigAppliedDocAmt SearchPA Originating Applied Document AmtDLR17_RBS0_STR$Currency17
51PAOrigAppliedFreightMisc SearchPA Originating Applied Freight MiscDLR17_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
55BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
56OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
57PA_Third_Party_CB SearchPA Third Party CBCBBoolean0
58BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
59OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
60PA_Backout_Retention_Tax SearchPA Backout Retention Tax AmountPA_DLR17_RBS0_STR$Currency17
61PA_OrigBackRetentionTax SearchPA Originating Backout Retention Tax AmountPA_DLR17_RBS0_STR$Currency17
62DEX_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 *