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 TypeSQL DB LengthKeyable Length
1APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString2220
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
3VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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_TypeInteger20
5DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
6APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
7APTODCNM SearchApply To Document NumberSTR20_Document_NumberString2220
8APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
9DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
10WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
11PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
12GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
13TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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/FalseBoolean20
15TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
16DOCDATE SearchDocument DateDTDate48
17APTODCDT SearchApply To Document DateDTDate48
18DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
19FROMCURR SearchApply From Currency IDSTR15_Currency_IDString1615
20CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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$Currency1017
23ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
24ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
25ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
26RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
27MCAPYFRMRNDAMT SearchIS MC Apply From Round AmountINTInteger20
28APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency1017
29MCAPYTORNDAMT SearchIS MC Apply To Round AmountINTInteger20
30APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency1017
31MCAPYTORNDDISC SearchIS MC Apply To Round DiscountINTInteger20
32APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency1017
33DATE1 SearchDateDT6Date46
34GLPOSTDT SearchGL Posting DateDTDate48
35ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency1017
36ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency1017
37ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
38ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
39APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency1017
40APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
41APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency1017
42APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency1017
43APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
44ApplyFromGLPostDate SearchApply From GL Posting DateDTDate48
45APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger20
46APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger20
47APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency1017
48APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
49APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
50ApplyToGLPostDate SearchApply To GL Posting DateDTDate48
51APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger20
52APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger20
53OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency1017
54OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency1017
55OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency1017
56Revaluation_Status SearchRevaluation StatusINTInteger20
57Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency1019
58Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency1019
59Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency1019
60Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency1019
61Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency1019
62Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency1019
63TIME1 SearchTimeTM6Time46
azurecurveProductsCashbook (1058)FinancialPM Apply To WORK OPEN File TEMP (CB400111)

Leave a Reply

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