NC_Propose_Multi_Match_Stmt_TEMP (NCABR322)

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

Display Name: NC_Propose_Multi_Match_Stmt_TEMP
Physical Name: NCABR322
Technical Name: NC_Propose_Multi_Match_Stmt_TEMP

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['NC_Propose_Multi_Match_Stmt_TEMP'].USERID AS 'NC_Propose_Multi_Match_Stmt_TEMP-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM NCABR322 AS ['NC_Propose_Multi_Match_Stmt_TEMP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['NC_Propose_Multi_Match_Stmt_TEMP'].USERID = ['Users Master'].USERID
2	BANKID	Bank ID	STR15_Bank_ID	String	15
3	NC_Statement_Number	NC_Statement_Number	Long Int	Long Integer	8
4	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	10
5	NC_Trx_Date	NC_Trx_Date	DATE	Date	6
6	NC_Trx_Type	NC_Trx_Type	STR9	String	9
7	NC_Reference	NC_Reference	STR30	String	30
8	NCCHQNUM	NC_Cheque_Number	STR20_Document_Number	String	20
9	NC_BL_Amount	NC_BL_Amount	NC_BL_Amount	Currency	15
10	NC_Bank_Amount	NC Bank Amount	DLR19_$S2	Currency	19
11	LINCOUNT	Line Count	INT5_W2_Forms_Count	Integer	5