CE Posting Table Temp (CBEU1108)

azurecurveProductsCashbook (1058)FinancialCE Posting Table Temp (CBEU1108)

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

Product: Cashbook (1058)
Series: Financial

Display Name: CE Posting Table Temp
Physical Name: CBEU1108
Technical Name: CB_Euro_Posting_Table_Temp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Pay_Rec SearchCB_Pay_RecSTR5String65
2CB_Matched SearchCB_MatchedbooleanBoolean20
3CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
4CB_Batch_Total SearchCB_Batch_TotalbooleanBoolean20
5CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CE Posting Table Temp'].CHEKBKID AS 'CE Posting Table Temp-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBEU1108 AS ['CE Posting Table Temp']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CE Posting Table Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
6CB_Ledger_Type SearchCB_Ledger_TypeINT3Integer23
7CB_Doc_No SearchCB_Doc_NoDocument_NumberString2220
8BCHSOURC SearchBatch SourceSTR15String1615
9BACHNUMB SearchBatch NumberSTR15_LBAUString1615
10JRNENTRY SearchJournal EntryLI8_U0Long Integer48
11DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
12PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
azurecurveProductsCashbook (1058)FinancialCE Posting Table Temp (CBEU1108)

Leave a Reply

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