Deposits Posting Temp (CB990027)

azurecurveProductsCashbook (1058)FinancialDeposits Posting Temp (CB990027)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Deposits Posting Temp
Physical Name: CB990027
Technical Name: CB_Deposits_Posting_Temp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_RM_Customer_MSTR_SUM_ SearchCB_RM_Customer_MSTR_SUM_UpdatedbooleanBoolean20
2CB_AR_Batch_Updated SearchCB_AR_Batch_UpdatedbooleanBoolean20
3CB_Dyn_Batch_Number SearchCB_Dyn_Batch_NumberSTR20String2220
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5CB_Trans_Option SearchCB_Trans_OptionCB_DDL_OptionInteger20
6CB_Trans_Type SearchCB_Trans_TypeSTR1String21
7depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
8CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString1615
9CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Deposits Posting Temp'].CHEKBKID AS 'Deposits Posting Temp-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB990027 AS ['Deposits Posting Temp']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Deposits Posting Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
10CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
11RMDTYPAL SearchRM Document Type-AllINT2Integer22
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
12DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
13BCHSOURC SearchBatch SourceSTR15String1615
14JRNENTRY SearchJournal EntryLI8_U0Long Integer48
15CB_Type SearchCB_TypeCB_DDL_Type2Integer20
azurecurveProductsCashbook (1058)FinancialDeposits Posting Temp (CB990027)

Leave a Reply

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