Cashbook Print table (CB550005)

azurecurveProductsCashbook (1058)FinancialCashbook Print table (CB550005)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Cashbook Print table
Physical Name: CB550005
Technical Name: CB_Print_Cashbook

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

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

Click to show/hide

SELECT
       ['Cashbook Print table'].ACTINDX AS 'Cashbook Print table-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB550005 AS ['Cashbook Print table']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Cashbook Print table'].ACTINDX = ['Account Index Master'].ACTINDX
3ACTNUMST SearchAccount Number StringSTR128_LBUString130128
4CB_Print_Cashbook_Key SearchCB_Print_Cashbook_KeySTR50String5250
5DATE1 SearchDateDT6Date46
6CB_Recon_Source SearchCB_Recon_SourceDDLInteger20
7CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
8CB_Document_Number_25 SearchCB_Document_Number_25CB_Document_Number_25String2625
9CB_Payee SearchCB_PayeeSTR40String4240
10ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
11ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
12ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
13ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
14ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
15ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
16ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
17ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
18ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
19ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
20CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
21CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

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

Leave a Reply

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