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_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 KEYSOURC Key Source STR40_Source String 40 2 DOCDATE Document Date DT Date 8 3 TIME1 Time TM6 Time 6 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 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
5 POSTED Posted True/False Boolean 0 6 BCHSOURC Batch Source STR15 String 15 7 USERID User ID STR15_User_ID String 15 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
8 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 9 APTODCTY Apply To Document Type DDL_Document_Type Integer 0 10 APTODCDT Apply To Document Date DT Date 8 11 APTODCNM Apply To Document Number STR20_Document_Number String 20 12 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 13 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 14 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 17 15 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 16 CURNCYID Currency ID STR15_Currency_ID String 15 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
17 CURRNIDX Currency Index INT3 Integer 3 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
18 ORAPPAMT Originating Applied Amount DLR17_RBS0_STR$ Currency 17 19 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 20 ORDATKN Originating Discount Available Taken DLR17_RBS0_UTR$ Currency 17 21 ORWROFAM Originating Write Off Amount DLR17_RBS0_STR$ Currency 17 22 Apply_To_Document_Amount Apply To Document Amount DLR19_RBS0_UTR$ Currency 19 23 Apply_To_Orig_Doc_Amount Apply To Orig Doc Amount DLR19_RBS0_UTR$ Currency 19 24 Apply_To_Discount_Date Apply To Discount Date DT Date 8 25 Apply_To_Due_Date Apply To Due Date DT Date 8 26 Apply_To_Description Apply To Description STR30 String 30 27 Apply_To_IS_MC_Trx Apply To IS MC Trx INT Integer 0 28 ApplyToGLPostDate Apply To GL Posting Date DT Date 8 29 APTOEXRATE Apply To Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 30 APTODENRATE Apply To Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 31 APTORTCLCMETH Apply To Rate Calc Method INT Integer 0 32 APTOMCTRXSTT Apply To MC Transaction State INT Integer 0 33 ISMCTRX IS MC Trx INT Integer 0 34 VCHRNMBR Voucher Number STR20_LBAU String 20 35 DOCTYPE Document Type DDL_Document_Type Integer 0 36 APFRDCNM Apply From Document Number STR20_Document_Number String 20 37 FROMCURR Apply From Currency ID STR15_Currency_ID String 15 38 Apply_From_Document_Amou Apply From Document Amount DLR19_RBS0_UTR$ Currency 19 39 Apply_From_Orig_Doc_Amou Apply From Orig Doc Amount DLR19_RBS0_UTR$ Currency 19 40 APFRMAPLYAMT Apply From Apply Amount DLR17_RBS0_UTR$ Currency 17 41 APFRMDISCTAKEN Apply From Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 42 APFRMDISCAVAIL Apply From Discount Available Taken DLR17_RBS0_UTR$ Currency 17 43 APFRMWROFAMT Apply From Write Off Amount DLR17_RBS0_UTR$ Currency 17 44 ActualApplyToAmount Actual Apply To Amount DLR17_RBS0_UTR$ Currency 17 45 ActualDiscTakenAmount Actual Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 46 ActualDiscAvailTaken Actual Discount Available Taken DLR17_RBS0_UTR$ Currency 17 47 ActualWriteOffAmount Actual Write Off Amount DLR17_RBS0_UTR$ Currency 17 48 APFRMEXRATE Apply From Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 49 APFRMDENRATE Apply From Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 50 APFRMRTCLCMETH Apply From Rate Calc Method INT Integer 0 51 APFRMMCTRXSTT Apply From MC Transaction State INT Integer 0 52 Apply_From_Description Apply From Description STR30 String 30 53 Apply_From_IS_MC_Trx Apply From IS MC Trx INT Integer 0 54 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 55 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 56 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 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
57 UPDTKNAM Unposted Discount Taken Amount DLR17_RBS0_STR$ Currency 17 58 UPGSTDAM Unposted GST Discount Amount DLR17_RBS0_STR$ Currency 17 59 UNPPPSAD Unposted PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 60 UPWROFAM Unposted Write Off Amount DLR17_RBS0_STR$ Currency 17 61 PMDSTMSG PM Distribution Messages ML_PM_Distribution_Messages Long Integer 0 62 MODIFDT Modified Date DT Date 8 63 MDFUSRID Modified User ID STR15 String 15 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
64 POSTEDDT Posted Date DATE Date 6 65 PTDUSRID Posted User ID STR15 String 15 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
66 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 17 67 RLGANLOS Realized Gain-Loss Amount DLR19_$S2 Currency 19 68 APYFRMRNDAMT Apply From Round Amount DLR17_RBS0_STR$ Currency 17 69 APYTORNDAMT Apply To Round Amount DLR17_RBS0_STR$ Currency 17 70 APYTORNDDISC Apply To Round Discount DLR17_RBS0_STR$ Currency 17 71 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 72 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 73 RATECALC Rate Calc Method INT Integer 0 74 Payment_To_Print_On_Stub Payment To Print On Stub STR20_LBAU String 20 75 OAPYFRMRNDAMT Originating Apply From Round Amount DLR17_RBS0_STR$ Currency 17 76 OAPYTORNDAMT Originating Apply To Round Amount DLR17_RBS0_STR$ Currency 17 77 OAPYTORNDDISC Originating Apply To Round Discount DLR17_RBS0_STR$ Currency 17 78 Settled_Gain_CreditCurrT Settled Gain CreditCurrTrx DLR19_$S2 Currency 19 79 Settled_Loss_CreditCurrT Settled Loss CreditCurrTrx DLR19_$S2 Currency 19 80 Settled_Gain_DebitCurrTr Settled Gain DebitCurrTrx DLR19_$S2 Currency 19 81 Settled_Loss_DebitCurrTr Settled Loss DebitCurrTrx DLR19_$S2 Currency 19 82 Settled_Gain_DebitDiscAv Settled Gain DebitDiscAvail DLR19_$S2 Currency 19 83 Settled_Loss_DebitDiscAv Settled Loss DebitDiscAvail DLR19_$S2 Currency 19