PM Apply To WORK OPEN File TEMP (CB400111)

azurecurveProductsCashbook (1058)FinancialPM Apply To WORK OPEN File TEMP (CB400111)

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

Product: Cashbook (1058)
Series: Financial

Display Name: PM Apply To WORK OPEN File TEMP
Physical Name: CB400111
Technical Name: CB_Payments_Apply_Temp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString20
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
3VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Apply To WORK OPEN File TEMP'].VENDORID AS 'PM Apply To WORK OPEN File TEMP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CB400111 AS ['PM Apply To WORK OPEN File TEMP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Apply To WORK OPEN File TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID
4APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
5DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
6APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString20
7APTODCNM SearchApply To Document NumberSTR20_Document_NumberString20
8APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
9DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
10WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
11PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
12GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
13TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['PM Apply To WORK OPEN File TEMP'].TAXDTLID AS 'PM Apply To WORK OPEN File TEMP-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CB400111 AS ['PM Apply To WORK OPEN File TEMP']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['PM Apply To WORK OPEN File TEMP'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
14POSTED SearchPostedTrue/FalseBoolean0
15TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
16DOCDATE SearchDocument DateDTDate8
17APTODCDT SearchApply To Document DateDTDate8
18DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
19FROMCURR SearchApply From Currency IDSTR15_Currency_IDString15
20CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Apply To WORK OPEN File TEMP'].CURNCYID AS 'PM Apply To WORK OPEN File TEMP-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB400111 AS ['PM Apply To WORK OPEN File TEMP']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Apply To WORK OPEN File TEMP'].CURNCYID = ['Currency Setup'].CURNCYID
21CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Apply To WORK OPEN File TEMP'].CURRNIDX AS 'PM Apply To WORK OPEN File TEMP-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB400111 AS ['PM Apply To WORK OPEN File TEMP']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Apply To WORK OPEN File TEMP'].CURRNIDX = ['Currency Setup'].CURRNIDX
22ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency17
23ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
24ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
25ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
26RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
27MCAPYFRMRNDAMT SearchIS MC Apply From Round AmountINTInteger0
28APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency17
29MCAPYTORNDAMT SearchIS MC Apply To Round AmountINTInteger0
30APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency17
31MCAPYTORNDDISC SearchIS MC Apply To Round DiscountINTInteger0
32APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency17
33DATE1 SearchDateDT6Date6
34GLPOSTDT SearchGL Posting DateDTDate8
35ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency17
36ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency17
37ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
38ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
39APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency17
40APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
41APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency17
42APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency17
43APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)14
44ApplyFromGLPostDate SearchApply From GL Posting DateDTDate8
45APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger0
46APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger0
47APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency17
48APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
49APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)14
50ApplyToGLPostDate SearchApply To GL Posting DateDTDate8
51APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger0
52APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger0
53OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency17
54OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency17
55OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency17
56Revaluation_Status SearchRevaluation StatusINTInteger0
57Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency19
58Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency19
59Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency19
60Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency19
61Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency19
62Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency19
63TIME1 SearchTimeTM6Time6
azurecurveProductsCashbook (1058)FinancialPM Apply To WORK OPEN File TEMP (CB400111)

Leave a Reply

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