Check Transaction (CB888002)

azurecurveProductsCashbook (1058)FinancialCheck Transaction (CB888002)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Check Transaction
Physical Name: CB888002
Technical Name: CB_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
       ['Check Transaction'].INTERID AS 'Check Transaction-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB888002 AS ['Check Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Check Transaction'].INTERID = ['Company Master'].INTERID
3CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Check Transaction'].CMPANYID AS 'Check Transaction-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CB888002 AS ['Check Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Check 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
       ['Check Transaction'].TAXSCHID AS 'Check Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB888002 AS ['Check Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Check Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
20TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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