Payments Posting Temp (CB900028)

azurecurveProductsCashbook (1058)FinancialPayments Posting Temp (CB900028)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Payments Posting Temp
Physical Name: CB900028
Technical Name: CB_Payments_Posting_Temp

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
2CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Payments Posting Temp'].CHEKBKID AS 'Payments Posting Temp-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB900028 AS ['Payments Posting Temp']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Payments Posting Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
3CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
4BCHSOURC SearchBatch SourceSTR15String1615
5CB_Dyn_Batch_Number SearchCB_Dyn_Batch_NumberSTR20String2220
6PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
7CB_Trans_Option SearchCB_Trans_OptionCB_DDL_OptionInteger20
8payment_method Searchpayment methodpayment mothodInteger20
9CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
10RMDTYPAL 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
11RMDNUMWK SearchRM Document Number-WORKSTR17_LBAUString1817
12JRNENTRY SearchJournal EntryLI8_U0Long Integer48
13CB_Type SearchCB_TypeCB_DDL_Type2Integer20
14CB_AR_Batch_Updated SearchCB_AR_Batch_UpdatedbooleanBoolean20
15CB_Batch_Number SearchCB_Batch_NumberSTR20String2220
16CB_RM_Customer_MSTR_SUM_ SearchCB_RM_Customer_MSTR_SUM_UpdatedbooleanBoolean20
azurecurveProductsCashbook (1058)FinancialPayments Posting Temp (CB900028)

Leave a Reply

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