NC_Import_Audit_MSTR (NCBL0002)

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

Display Name: NC_Import_Audit_MSTR
Physical Name: NCBL0002
Technical Name: NC_Import_Audit_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Import_Definition_ID	Import Definition ID	STR20_LBAU	String	20
2	DATE1	Date	DT6	Date	6
3	TIME1	Time	TM6	Time	6
4	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['NC_Import_Audit_MSTR'].USERID AS 'NC_Import_Audit_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM NCBL0002 AS ['NC_Import_Audit_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['NC_Import_Audit_MSTR'].USERID = ['Users Master'].USERID
5	Import_File_Name	Import File Name	STR255	String	255
6	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
7	Save_File_Name	Save File Name	STR255	String	255
8	Number_of_Records	Number of Records	LI_Sequence_Number	Long Integer	10
9	Value	Value	DLR11_$S2	Currency	14
10	Number_of_Errors	Number of Errors	LI6_U0	Long Integer	6