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 TypeLength
1DATE1 SearchDateDT6Date6
2PSTGDATE SearchPosting DateDTDate8
3DOCDATE SearchDocument DateDTDate8
4DISCDATE SearchDiscount DateDTDate8
5DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
6APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
7WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
8REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
9DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency17
10DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
11DUEDATE SearchDue DateDTDate8
12APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString20
13APFRDCTY SearchApply From Document TypeINT2Integer2
14APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
15APTODCNM SearchApply To Document NumberSTR20_Document_NumberString20
16CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_TypeINT3Integer3
18CB_Doc_No SearchCB_Doc_NoDocument_NumberString20
azurecurveProductsCashbook (1058)FinancialCE Apply Match Print (CBEU1021)

Leave a Reply

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