SVRMA305 - Commission History Archive

SQL Query Builder

SELECT * FROM SVRMA305

Select all

Column	Type	Shared With
NCOMAMNT	numeric(19,5)	14 tables
RMDTYPAL	smallint	57 tables
COMPRCNT	smallint	19 tables
DOCNUMBR	char(21)	66 tables
SEQNUMBR	int	86 tables
TRXSORCE	char(13)	93 tables
COMTRSRC	char(13)	-
CUSTNMBR	char(15)	230 tables
SLPRSNID	char(15)	83 tables
SALSTERR	char(15)	44 tables
COMMCODE	char(15)	7 tables
PRCTOSAL	smallint	2 tables
SLSAMNT	numeric(19,5)	9 tables
COMDLRAM	numeric(19,5)	16 tables
POSTED	tinyint	39 tables
COMMPAID	tinyint	-
COMMDEST	smallint	-
ORCOMAMT	numeric(19,5)	5 tables
ORSLSAMT	numeric(19,5)	3 tables
ORNCMAMT	numeric(19,5)	5 tables
CURRNIDX	smallint	112 tables
DEX_ROW_ID	int auto number (1,1)	608 tables