PM Apply To OPEN OPEN Temporary File (CB990025)

azurecurveProductsCashbook (1058)FinancialPM Apply To OPEN OPEN Temporary File (CB990025)

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

Product: Cashbook (1058)
Series: Financial

Display Name: PM Apply To OPEN OPEN Temporary File
Physical Name: CB990025
Technical Name: CB_PM_Apply_To_OPEN_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1KEYSOURC SearchKey SourceSTR40_SourceString40
2DOCDATE SearchDocument DateDTDate8
3TIME1 SearchTimeTM6Time6
4VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].VENDORID AS 'PM Apply To OPEN OPEN Temporary File-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].VENDORID = ['PM Vendor Master File'].VENDORID
5POSTED SearchPostedTrue/FalseBoolean0
6BCHSOURC SearchBatch SourceSTR15String15
7USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].USERID AS 'PM Apply To OPEN OPEN Temporary File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].USERID = ['Users Master'].USERID
8APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString20
9APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
10APTODCDT SearchApply To Document DateDTDate8
11APTODCNM SearchApply To Document NumberSTR20_Document_NumberString20
12APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
13DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
14DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
15WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
16CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].CURRNIDX AS 'PM Apply To OPEN OPEN Temporary File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].CURRNIDX = ['Currency Setup'].CURRNIDX
18ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency17
19ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
20ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
21ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
22Apply_To_Document_Amount SearchApply To Document AmountDLR19_RBS0_UTR$Currency19
23Apply_To_Orig_Doc_Amount SearchApply To Orig Doc AmountDLR19_RBS0_UTR$Currency19
24Apply_To_Discount_Date SearchApply To Discount DateDTDate8
25Apply_To_Due_Date SearchApply To Due DateDTDate8
26Apply_To_Description SearchApply To DescriptionSTR30String30
27Apply_To_IS_MC_Trx SearchApply To IS MC TrxINTInteger0
28ApplyToGLPostDate SearchApply To GL Posting DateDTDate8
29APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)14
30APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
31APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger0
32APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger0
33ISMCTRX SearchIS MC TrxINTInteger0
34VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
35DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
36APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString20
37FROMCURR SearchApply From Currency IDSTR15_Currency_IDString15
38Apply_From_Document_Amou SearchApply From Document AmountDLR19_RBS0_UTR$Currency19
39Apply_From_Orig_Doc_Amou SearchApply From Orig Doc AmountDLR19_RBS0_UTR$Currency19
40APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency17
41APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency17
42APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency17
43APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency17
44ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency17
45ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
46ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency17
47ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
48APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)14
49APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
50APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger0
51APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger0
52Apply_From_Description SearchApply From DescriptionSTR30String30
53Apply_From_IS_MC_Trx SearchApply From IS MC TrxINTInteger0
54PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
55GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
56TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].TAXDTLID AS 'PM Apply To OPEN OPEN Temporary File-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
57UPDTKNAM SearchUnposted Discount Taken AmountDLR17_RBS0_STR$Currency17
58UPGSTDAM SearchUnposted GST Discount AmountDLR17_RBS0_STR$Currency17
59UNPPPSAD SearchUnposted PPS Amount DeductedDLR17_RBS0_UTR$Currency17
60UPWROFAM SearchUnposted Write Off AmountDLR17_RBS0_STR$Currency17
61PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer0
62MODIFDT SearchModified DateDTDate8
63MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].MDFUSRID AS 'PM Apply To OPEN OPEN Temporary File-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].MDFUSRID = ['Users Master'].USERID
64POSTEDDT SearchPosted DateDATEDate6
65PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].PTDUSRID AS 'PM Apply To OPEN OPEN Temporary File-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB990025 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].PTDUSRID = ['Users Master'].USERID
66TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
67RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
68APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency17
69APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency17
70APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency17
71XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
72DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
73RATECALC SearchRate Calc MethodINTInteger0
74Payment_To_Print_On_Stub SearchPayment To Print On StubSTR20_LBAUString20
75OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency17
76OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency17
77OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency17
78Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency19
79Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency19
80Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency19
81Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency19
82Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency19
83Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency19
azurecurveProductsCashbook (1058)FinancialPM Apply To OPEN OPEN Temporary File (CB990025)

Leave a Reply

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