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 TypeLength
1SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
2INTERID SearchIntercompany IDSTR5_IC_IDString5
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 IDINT5Integer4
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_IncDDLInteger0
5CB_Vat_Account_Index SearchCB_Vat_Account_IndexLI_14Long Integer14
6CB_Vat_Account_Number_1 SearchCB_Vat_Account_Number:Account_Segment_Pool1Account_Segment_Pool1String6
7CB_Vat_Account_Number_2 SearchCB_Vat_Account_Number:Account_Segment_Pool2Account_Segment_Pool2String6
8CB_Vat_Account_Number_3 SearchCB_Vat_Account_Number:Account_Segment_Pool3Account_Segment_Pool3String6
9CB_Vat_Account_Number_4 SearchCB_Vat_Account_Number:Account_Segment_Pool4Account_Segment_Pool4String6
10CB_Vat_Account_Number_5 SearchCB_Vat_Account_Number:Account_Segment_Pool5Account_Segment_Pool5String6
11CB_Vat_Account_Number_6 SearchCB_Vat_Account_Number:Account_Segment_Pool6Account_Segment_Pool6String6
12CB_Vat_Account_Number_7 SearchCB_Vat_Account_Number:Account_Segment_Pool7Account_Segment_Pool7String6
13CB_Vat_Account_Number_8 SearchCB_Vat_Account_Number:Account_Segment_Pool8Account_Segment_Pool8String6
14CB_Vat_Account_Number_9 SearchCB_Vat_Account_Number:Account_Segment_Pool9Account_Segment_Pool9String6
15CB_Vat_Account_Number_10 SearchCB_Vat_Account_Number:Account_Segment_Pool10Account_Segment_Pool10String6
16BACHNUMB SearchBatch NumberSTR15_LBAUString15
17CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
18CB_Line_No SearchCB_Line_NoSTR10String10
19TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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_IDString15
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_Pool1String6
22ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
23ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
24ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
25ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
26ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
27ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
28ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
29ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
30ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
31ACTINDX SearchAccount IndexLI_14Long Integer14
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_DescriptionSTR30String30
33CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
34Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency19
35CB_Balanced SearchCB_BalancedBooleanBoolean0
azurecurveProductsCashbook (1058)FinancialCheck Transaction (CB888002)

Leave a Reply

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