Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1166
Product: Cashbook (1058)
Series: Financial
Display Name: CE Cashbook Match Table
Physical Name: CBEU1166
Technical Name: CB_Euro_MatchSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CHEKBKID 
Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CE Cashbook Match Table'].CHEKBKID AS 'CE Cashbook Match Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CE Cashbook Match Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 CB_Invoice_Number_String CB_Invoice_Number_String STR200 String 200 3 CB_Doc_No CB_Doc_No Document_Number String 20 4 CB_Trx_Type_String CB_Trx_Type_String STR30 String 30 5 CB_Ledger_Type CB_Ledger_Type INT3 Integer 3 6 CB_Matched CB_Matched boolean Boolean 0 7 OPENYEAR Open Year INT4_S0 Integer 4 8 JRNENTRY Journal Entry LI8_U0 Long Integer 8 9 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 10 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['CE Cashbook Match Table'].SOURCDOC AS 'CE Cashbook Match Table-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['CE Cashbook Match Table'].SOURCDOC = ['Source Document Master'].SOURCDOC11 REFRENCE Reference STR30 String 30 12 DSCRIPTN Description STR30 String 30 13 TRXDATE TRX Date DT_Date Date 6 14 TRXSORCE TRX Source STR13 String 13 15 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CE Cashbook Match Table'].ACTINDX AS 'CE Cashbook Match Table-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CE Cashbook Match Table'].ACTINDX = ['Account Index Master'].ACTINDX16 POLLDTRX Polled Transaction YN Boolean 0 17 LASTUSER Last User User_ID String 15 18 LSTDTEDT Last Date Edited DT_Date Date 6 19 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['CE Cashbook Match Table'].USWHPSTD AS 'CE Cashbook Match Table-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['CE Cashbook Match Table'].USWHPSTD = ['Users Master'].USERID20 ORGNTSRC Originating Source STR15 String 15 21 ORGNATYP Originating Type INT Integer 0 22 QKOFSET Quick Offset INT Integer 0 23 SERIES Series DDL_Series Integer 0 24 ORTRXTYP Originating TRX Type INT Integer 0 25 ORCTRNUM Originating Control Number STR20 String 20 26 ORMSTRID Originating Master ID STR30 String 30 27 ORMSTRNM Originating Master Name STR64 String 64 28 ORDOCNUM Originating Document Number STR20 String 20 29 ORPSTDDT Originating Posted Date DT_Date Date 6 30 ORTRXSRC Originating TRX Source STR13 String 13 31 OrigDTASeries Originating DTA Series INT Integer 0 32 OrigSeqNum Originating Sequence Number Long Int Long Integer 8 33 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 34 DTA_GL_Status DTA GL Status INT1 Integer 1 35 DTA_Index DTA Index DLR14 Currency 14 36 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CE Cashbook Match Table'].CURNCYID AS 'CE Cashbook Match Table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CE Cashbook Match Table'].CURNCYID = ['Currency Setup'].CURNCYID37 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CE Cashbook Match Table'].CURRNIDX AS 'CE Cashbook Match Table-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CE Cashbook Match Table'].CURRNIDX = ['Currency Setup'].CURRNIDX38 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['CE Cashbook Match Table'].RATETPID AS 'CE Cashbook Match Table-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['CE Cashbook Match Table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID39 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['CE Cashbook Match Table'].EXGTBLID AS 'CE Cashbook Match Table-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['CE Cashbook Match Table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID40 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 41 EXCHDATE Exchange Date DT_Date Date 6 42 TIME1 Time TM6 Time 6 43 RTCLCMTD Rate Calculation Method GB Integer 0 44 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CE Cashbook Match Table'].NOTEINDX AS 'CE Cashbook Match Table-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CE Cashbook Match Table'].NOTEINDX = ['Record Notes Master'].NOTEINDX45 ICTRX IC TRX CB_IC_TRX Boolean 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany46 ORCOMID Originating Company ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['CE Cashbook Match Table'].ORCOMID AS 'CE Cashbook Match Table-Originating Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CBEU1166 AS ['CE Cashbook Match Table']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CE Cashbook Match Table'].ORCOMID = ['Company Master'].CMPANYID47 ORIGINJE Originating Journal Entry LI8_U0 Long Integer 8 48 PERIODID Period ID INT3 Integer 3 49 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 50 DEBITAMT Debit Amount DLR19_$S2 Currency 19 51 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 52 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19 53 DOCDATE Document Date DT Date 8 54 PSTGNMBR Posting Number LI8_U0 Long Integer 8 55 PPSGNMBR Period Posting Number LI8_U0 Long Integer 8 56 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 57 MCTRXSTT MC Transaction State INT1 Integer 1