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 TypeSQL DB LengthKeyable Length
1KEYSOURC SearchKey SourceSTR40_SourceString4240
2DOCDATE SearchDocument DateDTDate48
3TIME1 SearchTimeTM6Time46
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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/FalseBoolean20
6BCHSOURC SearchBatch SourceSTR15String1615
7USERID SearchUser IDSTR15_User_IDString1615
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_LBAUString2220
9APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
10APTODCDT SearchApply To Document DateDTDate48
11APTODCNM SearchApply To Document NumberSTR20_Document_NumberString2220
12APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
13DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
14DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
15WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
16CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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$Currency1017
19ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
20ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
21ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
22Apply_To_Document_Amount SearchApply To Document AmountDLR19_RBS0_UTR$Currency1019
23Apply_To_Orig_Doc_Amount SearchApply To Orig Doc AmountDLR19_RBS0_UTR$Currency1019
24Apply_To_Discount_Date SearchApply To Discount DateDTDate48
25Apply_To_Due_Date SearchApply To Due DateDTDate48
26Apply_To_Description SearchApply To DescriptionSTR30String3230
27Apply_To_IS_MC_Trx SearchApply To IS MC TrxINTInteger20
28ApplyToGLPostDate SearchApply To GL Posting DateDTDate48
29APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
30APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
31APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger20
32APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger20
33ISMCTRX SearchIS MC TrxINTInteger20
34VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
35DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
36APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
37FROMCURR SearchApply From Currency IDSTR15_Currency_IDString1615
38Apply_From_Document_Amou SearchApply From Document AmountDLR19_RBS0_UTR$Currency1019
39Apply_From_Orig_Doc_Amou SearchApply From Orig Doc AmountDLR19_RBS0_UTR$Currency1019
40APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency1017
41APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency1017
42APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency1017
43APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency1017
44ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency1017
45ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
46ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency1017
47ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
48APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
49APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
50APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger20
51APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger20
52Apply_From_Description SearchApply From DescriptionSTR30String3230
53Apply_From_IS_MC_Trx SearchApply From IS MC TrxINTInteger20
54PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
55GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
56TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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$Currency1017
58UPGSTDAM SearchUnposted GST Discount AmountDLR17_RBS0_STR$Currency1017
59UNPPPSAD SearchUnposted PPS Amount DeductedDLR17_RBS0_UTR$Currency1017
60UPWROFAM SearchUnposted Write Off AmountDLR17_RBS0_STR$Currency1017
61PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
62MODIFDT SearchModified DateDTDate48
63MDFUSRID SearchModified User IDSTR15String1615
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 DateDATEDate46
65PTDUSRID SearchPosted User IDSTR15String1615
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$Currency1017
67RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
68APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency1017
69APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency1017
70APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency1017
71XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
72DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
73RATECALC SearchRate Calc MethodINTInteger20
74Payment_To_Print_On_Stub SearchPayment To Print On StubSTR20_LBAUString2220
75OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency1017
76OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency1017
77OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency1017
78Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency1019
79Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency1019
80Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency1019
81Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency1019
82Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency1019
83Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency1019
azurecurveProductsCashbook (1058)FinancialPM Apply To OPEN OPEN Temporary File (CB990025)

Leave a Reply

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