PA Billing Detail OPEN (PA23200)

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

Product: Project Accounting (258)
Series:

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 TypeIntegerPA_DDL_Biller_Trx_Type0
2PADocnumber20 SearchPA Document No.StringSTR17_LBAU17
3PADOCDT SearchPA Document DateDatePA_Date8
4PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
5LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
6CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 NumberStringSTR10_LBAU10
8PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
9PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
10PApurordnum SearchPA Purchase Order No.StringSTR17_LBAU17
11PABillingAmount SearchPA Billing AmountCurrencyDLR17_RBS0_UTR$17
12PATMbillamount SearchPA Billing Amount - TMCurrencyDLR17_RBS0_UTR$17
13PAFFbillamount SearchPA Billing Amount - FFCurrencyPA_DLR17_RBS0_STR$17
14PAFeebillamount SearchPA Billing Amount - FeeCurrencyDLR17_RBSO_STR$17
15PAtotbillings SearchPA Total BillingsCurrencyDLR17_RBS0_UTR$17
16PA_Discount_Type SearchPA Discount TypeIntegerGB0
17TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
18PA_Trade_Discount_Pcnt SearchPA Trade Discount PercentIntegerINT5_%25
19PATOTTAX SearchPA Total TaxCurrencyDLR15_RBU$215
20PATMtaxamt SearchPA Tax Amt - TMCurrencyDLR17_RBS0_UTR$17
21PAFFtaxamt SearchPA Tax Amt - FFCurrencyDLR17_RBS0_UTR$17
22PAFeetaxamount SearchPA Tax Amt - FeeCurrencyDLR17_RBS0_UTR$17
23PABACKBILL SearchPA Backout Bill AmountCurrencyDLR19_RBS0_UTR$19
24PATMbckoutbillamt SearchPA Backout Bill Amt - TMCurrencyDLR17_RBS0_UTR$17
25PAPBbckoutbillamt SearchPA Backout Bill Amt - FFCurrencyDLR17_RBS0_UTR$17
26PAFeebckoutbillamt SearchPA Backout Bill Amt - FeeCurrencyDLR17_RBS0_UTR$17
27APPLDAMT SearchApplied AmountCurrencyDLR17_RBS0_STR$17
28ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
29PARetentionFeeAmount SearchPA Retention Fee AmountCurrencyPA_DLR17_RBS0_STR$17
30PARetainer_Fee_Amount SearchPA Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
31PA_Applied_Retainer SearchPA Applied Document AmtCurrencyPA_DLR17_RBS0_STR$17
32PA_Applied_Freight_Misc SearchPA Applied Freight MiscCurrencyPA_DLR17_RBS0_STR$17
33AGNGBUKT SearchAging BucketIntegerINT1_U01
34CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
35PA_Trade_IDX SearchPA Trade IDXLong IntegerLI_1414
36TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 AmountCurrencyDLR17_RBSO_STR$17
38PAOrigBillingAmtTM SearchPA Originating Billing Amount - TMCurrencyDLR17_RBS0_STR$17
39PAOrigBillingAmtFF SearchPA Originating Billing Amount - FFCurrencyDLR17_RBS0_STR$17
40PAOrigBillingAmtFee SearchPA Originating Billing Amount - FeeCurrencyDLR17_RBS0_STR$17
41PAOrigTotalBilings SearchPA Originating Total BillingsCurrencyDLR17_RBS0_STR$17
42PAOrigTotalTaxAmt SearchPA Originating Total TaxCurrencyDLR17_RBSO_STR$17
43PAOrigTaxAmtTM_ SearchPA Originating Tax Amt - TMCurrencyDLR17_RBS0_STR$17
44PAOrigTaxAmtFF SearchPA Originating Tax Amt - FFCurrencyDLR17_RBS0_STR$17
45PAOrigTaxAmtFee SearchPA Originating Tax Amt - FeeCurrencyDLR17_RBS0_STR$17
46PAOrigBackoutBillAmt SearchPA Originating Backout Bill AmtCurrencyDLR17_RBS0_STR$17
47PAOrigBackoutBillTM SearchPA Originating Backout Bill Amt - TMCurrencyDLR17_RBS0_STR$17
48PAOrigBackoutBillFF SearchPA Originating Backout Bill Amt - FFCurrencyDLR17_RBS0_STR$17
49PAOrigBackoutBillFee SearchPA Originating Backout Bill Amt - FeeCurrencyDLR17_RBS0_STR$17
50PAOrigRetentionFeeAmt SearchPA Originating Retention Fee AmtCurrencyDLR17_RBS0_STR$17
51PAOrigRetainerFeeAmt SearchPA Originating Retainer Fee AmtCurrencyDLR17_RBS0_STR$17
52ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
53ORAPPAMT SearchOriginating Applied AmountCurrencyDLR17_RBS0_STR$17
54ORACTAMT SearchOriginating Account AmountCurrencyDLR19_RBS0_UTR$19
55ORCTRXAM SearchOriginating Current Trx AmountCurrencyDLR17_RBS0_UTR$17
56PAOrigAppliedDocAmt SearchPA Originating Applied Document AmtCurrencyDLR17_RBS0_STR$17
57PAOrigAppliedFreightMisc SearchPA Originating Applied Freight MiscCurrencyDLR17_RBS0_STR$17
58BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
59OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
60PA_Third_Party_CB SearchPA Third Party CBBooleanCB0
61BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountCurrencyDLR17_RBS0_UTR$17
62OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountCurrencyDLR17_RBS0_UTR$17
63PA_Backout_Retention_Tax SearchPA Backout Retention Tax AmountCurrencyPA_DLR17_RBS0_STR$17
64PA_OrigBackRetentionTax SearchPA Originating Backout Retention Tax AmountCurrencyPA_DLR17_RBS0_STR$17

Leave a Reply

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