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_TempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 APTVCHNM 
Apply To Voucher Number STR20_LBAU String 20 2 VCHRNMBR Voucher Number STR20_LBAU String 20 3 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 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'].VENDORID4 APTODCTY Apply To Document Type DDL_Document_Type Integer 0 5 DOCTYPE Document Type DDL_Document_Type Integer 0 6 APFRDCNM Apply From Document Number STR20_Document_Number String 20 7 APTODCNM Apply To Document Number STR20_Document_Number String 20 8 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 9 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 10 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 11 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 12 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 13 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 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'].TAXDTLID14 POSTED Posted True/False Boolean 0 15 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 17 16 DOCDATE Document Date DT Date 8 17 APTODCDT Apply To Document Date DT Date 8 18 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 17 19 FROMCURR Apply From Currency ID STR15_Currency_ID String 15 20 CURNCYID Currency ID STR15_Currency_ID String 15 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'].CURNCYID21 CURRNIDX Currency Index INT3 Integer 3 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'].CURRNIDX22 ORAPPAMT Originating Applied Amount DLR17_RBS0_STR$ Currency 17 23 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 24 ORWROFAM Originating Write Off Amount DLR17_RBS0_STR$ Currency 17 25 ORDATKN Originating Discount Available Taken DLR17_RBS0_UTR$ Currency 17 26 RLGANLOS Realized Gain-Loss Amount DLR19_$S2 Currency 19 27 MCAPYFRMRNDAMT IS MC Apply From Round Amount INT Integer 0 28 APYFRMRNDAMT Apply From Round Amount DLR17_RBS0_STR$ Currency 17 29 MCAPYTORNDAMT IS MC Apply To Round Amount INT Integer 0 30 APYTORNDAMT Apply To Round Amount DLR17_RBS0_STR$ Currency 17 31 MCAPYTORNDDISC IS MC Apply To Round Discount INT Integer 0 32 APYTORNDDISC Apply To Round Discount DLR17_RBS0_STR$ Currency 17 33 DATE1 Date DT6 Date 6 34 GLPOSTDT GL Posting Date DT Date 8 35 ActualApplyToAmount Actual Apply To Amount DLR17_RBS0_UTR$ Currency 17 36 ActualDiscAvailTaken Actual Discount Available Taken DLR17_RBS0_UTR$ Currency 17 37 ActualDiscTakenAmount Actual Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 38 ActualWriteOffAmount Actual Write Off Amount DLR17_RBS0_UTR$ Currency 17 39 APFRMAPLYAMT Apply From Apply Amount DLR17_RBS0_UTR$ Currency 17 40 APFRMDENRATE Apply From Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 41 APFRMDISCAVAIL Apply From Discount Available Taken DLR17_RBS0_UTR$ Currency 17 42 APFRMDISCTAKEN Apply From Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 43 APFRMEXRATE Apply From Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 44 ApplyFromGLPostDate Apply From GL Posting Date DT Date 8 45 APFRMMCTRXSTT Apply From MC Transaction State INT Integer 0 46 APFRMRTCLCMETH Apply From Rate Calc Method INT Integer 0 47 APFRMWROFAMT Apply From Write Off Amount DLR17_RBS0_UTR$ Currency 17 48 APTODENRATE Apply To Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 49 APTOEXRATE Apply To Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 50 ApplyToGLPostDate Apply To GL Posting Date DT Date 8 51 APTOMCTRXSTT Apply To MC Transaction State INT Integer 0 52 APTORTCLCMETH Apply To Rate Calc Method INT Integer 0 53 OAPYFRMRNDAMT Originating Apply From Round Amount DLR17_RBS0_STR$ Currency 17 54 OAPYTORNDAMT Originating Apply To Round Amount DLR17_RBS0_STR$ Currency 17 55 OAPYTORNDDISC Originating Apply To Round Discount DLR17_RBS0_STR$ Currency 17 56 Revaluation_Status Revaluation Status INT Integer 0 57 Settled_Gain_CreditCurrT Settled Gain CreditCurrTrx DLR19_$S2 Currency 19 58 Settled_Gain_DebitCurrTr Settled Gain DebitCurrTrx DLR19_$S2 Currency 19 59 Settled_Gain_DebitDiscAv Settled Gain DebitDiscAvail DLR19_$S2 Currency 19 60 Settled_Loss_CreditCurrT Settled Loss CreditCurrTrx DLR19_$S2 Currency 19 61 Settled_Loss_DebitCurrTr Settled Loss DebitCurrTrx DLR19_$S2 Currency 19 62 Settled_Loss_DebitDiscAv Settled Loss DebitDiscAvail DLR19_$S2 Currency 19 63 TIME1 Time TM6 Time 6