CN04000 - Collections - Days Sales Log

Dynamics GP table CN04000 (Collections - Days Sales Log) contains 7 columns including STRTDATE, SEQNUMBR, ENDDATE....

SQL Query Builder

SELECT * FROM CN04000

Select all

Column	Description	Type	Length	Shared With
STRTDATE	Start Date	Date	4	15 tables
SEQNUMBR	Sequence Number	Long Integer	4	30 tables
ENDDATE	End Date	Date	4	9 tables
DATEDONE	Date Done	Date	4	1 tables
SLSAMNT	Sales Amount	Currency	10	8 tables
Outstanding_Amount	Outstanding Amount	Currency	10	4 tables
NMBROFDYS	Number of Days	Integer	2	2 tables

Tables that share columns with CN04000. Click "Join" to add to your query.

STRTDATE

ENDDATE

SLSAMNT

Outstanding_Amount

NMBROFDYS

DATEDONE