Build Deposits Temp (CB300088)

azurecurve Products Cashbook (1058)FinancialBuild Deposits Temp (CB300088)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Build Deposits Temp
Physical Name: CB300088
Technical Name: CB_Cash_Dep_Temp

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CB_Type_Enquiry	CB_Type_Enquiry	INT2	Integer	2
2	CB_Sales_Type	CB_Sales_Type	INT1	Integer	1
3	CB_Sales_Number	CB_Sales_Number	STR30	String	30
4	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Build Deposits Temp'].USERID AS 'Build Deposits Temp-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM CB300088 AS ['Build Deposits Temp'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Build Deposits Temp'].USERID = ['Users Master'].USERID
5	depositnumber	Deposit Number	STR20_Document_Number	String	20
6	DSCRIPTN	Description	STR30	String	30
7	CUSTNAME	Customer Name	STR64_Customer_Name	String	64
8	CHEKBKID	Checkbook ID	STR15_Checkbook_ID	String	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Build Deposits Temp'].CHEKBKID AS 'Build Deposits Temp-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM CB300088 AS ['Build Deposits Temp'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Build Deposits Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
9	CHEKNMBR	Check Number	STR20_Document_Number	String	20
10	RcpType	Receipt Type	DDL_Document_Type	Integer	0
11	DATE1	Date	DT6	Date	6
12	DOCNUMBR	Document Number	STR20_Document_Number	String	20
13	CB_Trans_Amount	CB_Trans_Amount	CB_DLR19	Currency	19
14	RcvdFrom	Received From	STR30	String	30
15	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Build Deposits Temp'].CUSTNMBR AS 'Build Deposits Temp-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM CB300088 AS ['Build Deposits Temp'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Build Deposits Temp'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
16	BANKNAME	Bank Name	STR30	String	30
17	BNKBRNCH	Bank Branch	STR20	String	20
18	CURNCYID	Currency ID	STR15_Currency_ID	String	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Build Deposits Temp'].CURNCYID AS 'Build Deposits Temp-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM CB300088 AS ['Build Deposits Temp'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Build Deposits Temp'].CURNCYID = ['Currency Setup'].CURNCYID
19	CB_Check_Deposit	CB_Check_Deposit	CB_Check_Deposit	Boolean	0

azurecurve Products Cashbook (1058)FinancialBuild Deposits Temp (CB300088)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply