Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBINT001
Product: Cashbook (1058)
Series: System
Display Name: CB Inter comp Chequebook Master
Physical Name: CBINT001
Technical Name: CB_INTER_Checkbook_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTNUMBR_1 
Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 2 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 3 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 4 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 5 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 6 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 7 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 8 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 9 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 10 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 11 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CB Inter comp Chequebook Master'].CHEKBKID AS 'CB Inter comp Chequebook Master-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBINT001 AS ['CB Inter comp Chequebook Master']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CB Inter comp Chequebook Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 DSCRIPTN Description STR30 String 30 13 BANKID Bank ID STR15_Bank_ID String 15 14 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CB Inter comp Chequebook Master'].CURNCYID AS 'CB Inter comp Chequebook Master-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CBINT001 AS ['CB Inter comp Chequebook Master']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CB Inter comp Chequebook Master'].CURNCYID = ['Currency Setup'].CURNCYID15 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CB Inter comp Chequebook Master'].ACTINDX AS 'CB Inter comp Chequebook Master-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CBINT001 AS ['CB Inter comp Chequebook Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CB Inter comp Chequebook Master'].ACTINDX = ['Account Index Master'].ACTINDX16 BNKACTNM Bank Account Number STR15 String 15 17 NXTCHNUM Next Check Number STR20_Document_Number String 20 18 Next_Deposit_Number Next Deposit Number STR20_Document_Number String 20 19 INACTIVE Inactive CB_Inactive Boolean 0 20 DYDEPCLR Days Deposits To Clear INT3_U0 Integer 3 21 XCDMCHPW Exceed Max Check Password Password String 10 22 MXCHDLR Maximum Check Dollar DLR19_RBSO_UTR$ Currency 19 23 DUPCHNUM Duplicate Check Numbers CB_Duplicate_Check_Numbers Boolean 0 24 OVCHNUM1 Override Check Number 1 CB_Override_Check_Number Boolean 0 25 LOCATNID Location ID STR15_Location_ID String 15 26 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CB Inter comp Chequebook Master'].NOTEINDX AS 'CB Inter comp Chequebook Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CBINT001 AS ['CB Inter comp Chequebook Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CB Inter comp Chequebook Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX27 CMUSRDF1 CM User Defined 1 STR20 String 20 28 CMUSRDF2 CM User Defined 2 STR20 String 20 29 Last_Reconciled_Date Last Reconciled Date DT Date 8 30 Last_Reconciled_Balance Last Reconciled Balance DLR19_$S2 Currency 19 31 CURRBLNC Current Balance DLR19_RBS0_STR$ Currency 19 32 CREATDDT Created Date DT Date 8 33 MODIFDT Modified Date DT Date 8 34 Recond Reconciled Boolean Boolean 0 35 Reconcile_In_Progress Reconcile In Progress DLR_Document_Number Currency 19 36 Deposit_In_Progress Deposit In Progress STR20_Document_Number String 20 37 CHBKPSWD Checkbook Password STR15 String 15 38 CURNCYPD Currency Paid STR15_Currency_ID String 15 39 CRNCYRCD Currency Received STR15_Currency_ID String 15 40 ADPVADLR Allow Deposit Variance Dollar DLR17_RBS0_STR$ Currency 17 41 ADPVAPWD Allow Deposit Variance Password Password String 10 42 DYCHTCLR Days Checks To Clear INT3_U0 Integer 3 43 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['CB Inter comp Chequebook Master'].CMPANYID AS 'CB Inter comp Chequebook Master-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CBINT001 AS ['CB Inter comp Chequebook Master']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CB Inter comp Chequebook Master'].CMPANYID = ['Company Master'].CMPANYID44 CHKBKTYP Checkbook Type DDL_Checkbook_Type Integer 0