Voided Transactions (CB600007)

azurecurveProductsCashbook (1058)FinancialVoided Transactions (CB600007)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Voided Transactions
Physical Name: CB600007
Technical Name: CB_Voided

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
2CB_Payee SearchCB_PayeeSTR40String4240
3DATE1 SearchDateDT6Date46
4CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Voided Transactions'].CHEKBKID AS 'Voided Transactions-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB600007 AS ['Voided Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Voided Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
5BACHNUMB SearchBatch NumberSTR15_LBAUString1615
6CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
7CB_Type SearchCB_TypeCB_DDL_Type2Integer20
azurecurveProductsCashbook (1058)FinancialVoided Transactions (CB600007)

Leave a Reply

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