History Recon Cheque Trn (CB111005)

azurecurveProductsCashbook (1058)FinancialHistory Recon Cheque Trn (CB111005)

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_TRN

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
       ['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
3CMPANYID SearchCompany IDINT5Integer24
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
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
       ['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
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
       ['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
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)FinancialHistory Recon Cheque Trn (CB111005)

Leave a Reply

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