Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB330222
Product: Cashbook (1058)
Series: Financial
Display Name: Recon Receipts Transaction
Physical Name: CB330222
Technical Name: CB_Recon_Cash_Rec_TRNSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Audit_Trail CB_Audit_Trail STR15 String 15 2 CB_Voided CB_Voided Boolean Boolean 0 3 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Recon Receipts Transaction'].CURRNIDX AS 'Recon Receipts Transaction-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Recon Receipts Transaction'].CURRNIDX = ['Currency Setup'].CURRNIDX
4 CB_Checkbook_Currency_In CB_Checkbook_Currency_Index INT5 Integer 4 5 CB_Cash_Rec_Batch_Number CB_Cash_Rec_Batch_Number STR30 String 30 6 CB_Checkbook_Currency CB_Checkbook_Currency STR15_Currency_ID String 15 7 CB_Printed CB_Printed boolean Boolean 0 8 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Recon Receipts Transaction'].USERID AS 'Recon Receipts Transaction-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Recon Receipts Transaction'].USERID = ['Users Master'].USERID
9 CB_Receipt_Total CB_Receipt_Total DLR19_RBS0_STR$ Currency 19 10 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Recon Receipts Transaction'].CURNCYID AS 'Recon Receipts Transaction-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Recon Receipts Transaction'].CURNCYID = ['Currency Setup'].CURNCYID
11 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 12 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 13 CB_Exc_Inc CB_Exc_Inc DDL Integer 0 14 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Recon Receipts Transaction'].CHEKBKID AS 'Recon Receipts Transaction-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Recon Receipts Transaction'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
15 BANKNAME Bank Name STR30 String 30 16 CB_Trans_Type CB_Trans_Type STR1 String 1 17 CRCARDID Credit Card ID STR15 String 15 18 CRCRDNUM Credit Card Number STR20 String 20 19 CHEKNMBR Check Number STR20_Document_Number String 20 20 CB_Branch_Number CB_Branch_Number STR12 String 12 21 CB_Vat_Account_Number_1 CB_Vat_Account_Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 22 CB_Vat_Account_Number_2 CB_Vat_Account_Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 23 CB_Vat_Account_Number_3 CB_Vat_Account_Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 24 CB_Vat_Account_Number_4 CB_Vat_Account_Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 25 CB_Vat_Account_Number_5 CB_Vat_Account_Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 26 CB_Vat_Account_Number_6 CB_Vat_Account_Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 27 CB_Vat_Account_Number_7 CB_Vat_Account_Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 28 CB_Vat_Account_Number_8 CB_Vat_Account_Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 29 CB_Vat_Account_Number_9 CB_Vat_Account_Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 30 CB_Vat_Account_Number_10 CB_Vat_Account_Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 31 CB_Vat_Account_Index CB_Vat_Account_Index LI_14 Long Integer 14 32 TIME1 Time TM6 Time 6 33 RATECALC Rate Calc Method INT Integer 0 34 EXPNDATE Expiration Date DT_Date Date 6 35 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Recon Receipts Transaction'].RATETPID AS 'Recon Receipts Transaction-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Recon Receipts Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
36 EXCHDATE Exchange Date DT_Date Date 6 37 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['Recon Receipts Transaction'].EXGTBLID AS 'Recon Receipts Transaction-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Recon Receipts Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
38 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 39 payment_method payment method payment mothod Integer 0 40 DATE1 Date DT6 Date 6 41 PSTGDATE Posting Date DT Date 8 42 CB_Type_Description CB_Type_Description STR30 String 30 43 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 44 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 45 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 46 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 47 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 48 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 49 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 50 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 51 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 52 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 53 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Recon Receipts Transaction'].ACTINDX AS 'Recon Receipts Transaction-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Recon Receipts Transaction'].ACTINDX = ['Account Index Master'].ACTINDX
54 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['Recon Receipts Transaction'].TAXSCHID AS 'Recon Receipts Transaction-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Recon Receipts Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
55 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['Recon Receipts Transaction'].TAXDTLID AS 'Recon Receipts Transaction-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Recon Receipts Transaction'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
56 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 57 CB_Type CB_Type CB_DDL_Type2 Integer 0 58 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Recon Receipts Transaction'].CUSTNMBR AS 'Recon Receipts Transaction-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Recon Receipts Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
59 CUSTNAME Customer Name STR64_Customer_Name String 64 60 CB_Payer CB_Payer STR40 String 40 61 CB_Tel_No CB_Tel_No STR15 String 15 62 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 63 CB_Ref_No CB_Ref_No CB_STR15NoNegative String 15