Cashbook Historical Print table (CB330009)

azurecurveProductsCashbook (1058)FinancialCashbook Historical Print table (CB330009)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Cashbook Historical Print table
Physical Name: CB330009
Technical Name: CB_Print_History_Cashbook

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1INTERID SearchIntercompany IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Cashbook Historical Print table'].INTERID AS 'Cashbook Historical Print table-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Cashbook Historical Print table'].INTERID = ['Company Master'].INTERID
2ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Cashbook Historical Print table'].ACTINDX AS 'Cashbook Historical Print table-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Cashbook Historical Print table'].ACTINDX = ['Account Index Master'].ACTINDX
3ACTNUMST SearchAccount Number StringSTR128_LBUString128
4CB_Print_Cashbook_Key SearchCB_Print_Cashbook_KeySTR50String50
5DATE1 SearchDateDT6Date6
6CB_Recon_Source SearchCB_Recon_SourceDDLInteger0
7CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger0
8CB_Document_Number_25 SearchCB_Document_Number_25CB_Document_Number_25String25
9CB_Payee SearchCB_PayeeSTR40String40
10ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
11ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
12ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
13ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
14ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
15ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
16ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
17ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
18ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
19ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
20CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
21CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Cashbook Historical Print table'].CHEKBKID AS 'Cashbook Historical Print table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Cashbook Historical Print table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
azurecurveProductsCashbook (1058)FinancialCashbook Historical Print table (CB330009)

Leave a Reply

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