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_TempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 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'].CHEKBKID3 CB_Recon_Trans_Type CB_Recon_Trans_Type INT Integer 0 4 BCHSOURC Batch Source STR15 String 15 5 CB_Dyn_Batch_Number CB_Dyn_Batch_Number STR20 String 20 6 PMNTNMBR Payment Number STR20_LBAU String 20 7 CB_Trans_Option CB_Trans_Option CB_DDL_Option Integer 0 8 payment_method payment method payment mothod Integer 0 9 CHEKNMBR Check Number STR20_Document_Number String 20 10 RMDTYPAL RM Document Type-All INT2 Integer 2 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 Payments11 RMDNUMWK RM Document Number-WORK STR17_LBAU String 17 12 JRNENTRY Journal Entry LI8_U0 Long Integer 8 13 CB_Type CB_Type CB_DDL_Type2 Integer 0 14 CB_AR_Batch_Updated CB_AR_Batch_Updated boolean Boolean 0 15 CB_Batch_Number CB_Batch_Number STR20 String 20 16 CB_RM_Customer_MSTR_SUM_ CB_RM_Customer_MSTR_SUM_Updated boolean Boolean 0