CE Apply Match Print (CBEU1021)

azurecurveProductsCashbook (1058)FinancialCE Apply Match Print (CBEU1021)

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

Product: Cashbook (1058)
Series: Financial

Display Name: CE Apply Match Print
Physical Name: CBEU1021
Technical Name: CB_Euro_Apply_Match_Print

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DATE1 SearchDateDT6Date46
2PSTGDATE SearchPosting DateDTDate48
3DOCDATE SearchDocument DateDTDate48
4DISCDATE SearchDiscount DateDTDate48
5DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
6APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
7WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
8REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
9DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency1017
10DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
11DUEDATE SearchDue DateDTDate48
12APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
13APFRDCTY SearchApply From Document TypeINT2Integer22
14APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
15APTODCNM SearchApply To Document NumberSTR20_Document_NumberString2220
16CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CE Apply Match Print'].CHEKBKID AS 'CE Apply Match Print-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBEU1021 AS ['CE Apply Match Print']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CE Apply Match Print'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
17CB_Ledger_Type SearchCB_Ledger_TypeINT3Integer23
18CB_Doc_No SearchCB_Doc_NoDocument_NumberString2220
azurecurveProductsCashbook (1058)FinancialCE Apply Match Print (CBEU1021)

Leave a Reply

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