Conversion Exclusion Table (CB100010)

azurecurveProductsCashbook (1058)FinancialConversion Exclusion Table (CB100010)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Conversion Exclusion Table
Physical Name: CB100010
Technical Name: CB_Con_Exclusion_Table

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DATE1 SearchDateDT6Date46
2CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
3s SearchCB_DescriptionSTR2000String202200
4CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Conversion Exclusion Table'].CHEKBKID AS 'Conversion Exclusion Table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB100010 AS ['Conversion Exclusion Table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Conversion Exclusion Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
5CMTrxNum SearchCM Trx NumberSTR20_Document_NumberString2220
azurecurveProductsCashbook (1058)FinancialConversion Exclusion Table (CB100010)

Leave a Reply

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