Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB111005
Product: Cashbook (1058)
Series: Financial
Display Name: History Recon Cheque Trn
Physical Name: CB111005
Technical Name: CB_History_Check_TRNSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 2 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['History Recon Cheque Trn'].INTERID AS 'History Recon Cheque Trn-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB111005 AS ['History Recon Cheque Trn']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['History Recon Cheque Trn'].INTERID = ['Company Master'].INTERID
3 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['History Recon Cheque Trn'].CMPANYID AS 'History Recon Cheque Trn-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CB111005 AS ['History Recon Cheque Trn']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['History Recon Cheque Trn'].CMPANYID = ['Company Master'].CMPANYID
4 CB_Exc_Inc CB_Exc_Inc DDL Integer 0 5 CB_Vat_Account_Index CB_Vat_Account_Index LI_14 Long Integer 14 6 CB_Vat_Account_Number_1 CB_Vat_Account_Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 7 CB_Vat_Account_Number_2 CB_Vat_Account_Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 8 CB_Vat_Account_Number_3 CB_Vat_Account_Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 9 CB_Vat_Account_Number_4 CB_Vat_Account_Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 10 CB_Vat_Account_Number_5 CB_Vat_Account_Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 11 CB_Vat_Account_Number_6 CB_Vat_Account_Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 12 CB_Vat_Account_Number_7 CB_Vat_Account_Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 13 CB_Vat_Account_Number_8 CB_Vat_Account_Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 14 CB_Vat_Account_Number_9 CB_Vat_Account_Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 15 CB_Vat_Account_Number_10 CB_Vat_Account_Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 16 BACHNUMB Batch Number STR15_LBAU String 15 17 CHEKNMBR Check Number STR20_Document_Number String 20 18 CB_Line_No CB_Line_No STR10 String 10 19 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
['History Recon Cheque Trn'].TAXSCHID AS 'History Recon Cheque Trn-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB111005 AS ['History Recon Cheque Trn']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['History Recon Cheque Trn'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
20 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 21 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 22 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 23 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 24 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 25 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 26 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 27 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 28 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 29 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 30 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['History Recon Cheque Trn'].ACTINDX AS 'History Recon Cheque Trn-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB111005 AS ['History Recon Cheque Trn']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['History Recon Cheque Trn'].ACTINDX = ['Account Index Master'].ACTINDX
31 CB_Type_Description CB_Type_Description STR30 String 30 32 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 33 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 34 CB_Balanced CB_Balanced Boolean Boolean 0