Recon Cheque Transaction (CB777001)

azurecurveProductsCashbook (1058)FinancialRecon Cheque Transaction (CB777001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB777001

Product: Cashbook (1058)
Series: Financial

Display Name: Recon Cheque Transaction
Physical Name: CB777001
Technical Name: CB_Recon_Check_TRN

Group Display Name: Bank Management
Group Technical Name: Bank Management

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
2INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Recon Cheque Transaction'].INTERID AS 'Recon Cheque Transaction-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB777001 AS ['Recon Cheque Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Recon Cheque Transaction'].INTERID = ['Company Master'].INTERID
3CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Recon Cheque Transaction'].CMPANYID AS 'Recon Cheque Transaction-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CB777001 AS ['Recon Cheque Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Recon Cheque Transaction'].CMPANYID = ['Company Master'].CMPANYID
4CB_Exc_Inc SearchCB_Exc_IncDDLInteger20
5CB_Vat_Account_Index SearchCB_Vat_Account_IndexLI_14Long Integer414
6CB_Vat_Account_Number_1 SearchCB_Vat_Account_Number:Account_Segment_Pool1Account_Segment_Pool1String86
7CB_Vat_Account_Number_2 SearchCB_Vat_Account_Number:Account_Segment_Pool2Account_Segment_Pool2String86
8CB_Vat_Account_Number_3 SearchCB_Vat_Account_Number:Account_Segment_Pool3Account_Segment_Pool3String86
9CB_Vat_Account_Number_4 SearchCB_Vat_Account_Number:Account_Segment_Pool4Account_Segment_Pool4String86
10CB_Vat_Account_Number_5 SearchCB_Vat_Account_Number:Account_Segment_Pool5Account_Segment_Pool5String86
11CB_Vat_Account_Number_6 SearchCB_Vat_Account_Number:Account_Segment_Pool6Account_Segment_Pool6String86
12CB_Vat_Account_Number_7 SearchCB_Vat_Account_Number:Account_Segment_Pool7Account_Segment_Pool7String86
13CB_Vat_Account_Number_8 SearchCB_Vat_Account_Number:Account_Segment_Pool8Account_Segment_Pool8String86
14CB_Vat_Account_Number_9 SearchCB_Vat_Account_Number:Account_Segment_Pool9Account_Segment_Pool9String86
15CB_Vat_Account_Number_10 SearchCB_Vat_Account_Number:Account_Segment_Pool10Account_Segment_Pool10String86
16BACHNUMB SearchBatch NumberSTR15_LBAUString1615
17CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
18CB_Line_No SearchCB_Line_NoSTR10String1210
19TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Recon Cheque Transaction'].TAXSCHID AS 'Recon Cheque Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB777001 AS ['Recon Cheque Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Recon Cheque Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
20ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
21ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
22ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
23ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
24ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
25ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
26ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
27ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
28ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
29ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
30ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Recon Cheque Transaction'].ACTINDX AS 'Recon Cheque Transaction-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB777001 AS ['Recon Cheque Transaction']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Recon Cheque Transaction'].ACTINDX = ['Account Index Master'].ACTINDX
31CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
32CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
33Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency1019
34CB_Balanced SearchCB_BalancedBooleanBoolean20
azurecurveProductsCashbook (1058)FinancialRecon Cheque Transaction (CB777001)

Leave a Reply

Your email address will not be published. Required fields are marked *