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 TypeLength
1SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
2INTERID SearchIntercompany IDSTR5_IC_IDString5
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 IDINT5Integer4
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_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
       ['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_Pool1String6
21ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
22ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
23ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
24ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
25ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
26ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
27ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
28ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
29ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
30ACTINDX SearchAccount IndexLI_14Long Integer14
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_DescriptionSTR30String30
32CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
33Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency19
34CB_Balanced SearchCB_BalancedBooleanBoolean0
azurecurveProductsCashbook (1058)FinancialHistory Recon Cheque Trn (CB111005)

Leave a Reply

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