GP Tables

CN00600 - Collections - Query Master

Dynamics GP table CN00600 (Collections - Query Master) contains 67 columns including Query_ID, Query_Description, STCUSTID....

SQL Query Builder

SELECT * FROM CN00600

67 Columns

Select all

Column	Description	Type	Length	Shared With
Query_ID	Query ID	String	16	1 tables
Query_Description	Query Description	String	32	-
STCUSTID	Start Customer ID	String	16	1 tables
STCUSTNM	Start Customer Name	String	66	-
STTCLSID	Start Class ID	String	16	1 tables
STTUDEF1	Start User Defined 1	String	22	-
STSPRSID	Start Salesperson ID	String	16	-
STSLSTER	Start Sales Territory	String	16	-
StartPrefContactMethod	Start Preferred Contact Method	Integer	2	-
CNStartTimeZone	CN Start Time Zone	Integer	2	-
STRTUDEF	Start User Defined	String	22	-
STUDDAT1	Start User Defined Date 1	Date	4	-
STUDTAB1	Start User Defined Table 1	String	22	-
ENCUSTID	End Customer ID	String	16	1 tables
ENCSTNAM	End Customer Name	String	66	-
ENDCLSID	End Class ID	String	16	1 tables
ENUSRDF1	End User Defined 1	String	22	-
ENSPSNID	End Salesperson ID	String	16	-
ENSLSTER	End Sales Territory	String	16	-
CNEndTimeZone	CN End Time Zone	Integer	2	-
EndPrefContactMethod	End Preferred Contact Method	Integer	2	-
ENUSRDEF	End User Defined	String	22	-
ENDUDDT1	End User Defined Date 1	Date	4	-
ENDUDTBL	End User Defined Table 1	String	22	-
StartCreditControlCycle	CN Start Credit Control Cycle	Integer	2	-
EndCreditControlCyle	CN End Credit Control Cycle	Integer	2	-
CONNAACT	Consolidate National Account Activity	Boolean	2	-
DateSelection	Date Selection	Integer	2	-
QRYSTCDTPER	Query Start Credit Limit Period	Integer	2	-
QryEndCrLimitPeriod	Query End Credit Limit Period	Integer	2	-
QRYSTCDTAMT	Query Start Credit Limit Amount	Currency	10	-
QryEndCreditLimitAmt	Query End Credit Limit Amount	Currency	10	-
QryStartDateToken	Query Start Date Token	Integer	2	-
QryEndDateToken	Query End Date Token	Integer	2	-
STRTNGDT	Starting Date	Date	4	6 tables
ENDINGDT	Ending Date	Date	4	7 tables
Starting_Trx_Days	Starting Trx Days	Integer	2	-
Ending_Trx_Days	Ending Trx Days	Integer	2	-
Start_Caller_ID	Start Caller ID	String	16	-
Start_Contact_Date	Start Contact Date	Date	4	-
Start_Action_Assigned_To	Start Action Assigned To	String	16	-
Start_Action_Promised	Start Action Promised	String	18	-
Start_Action_Date	Start Action Date	Date	4	-
SNOTPRTY	Start Note Priority	Integer	2	-
QRYACTCOM	Query Action Completed	Integer	2	-
End_Caller_ID	End Caller ID	String	16	-
End_Contact_Date	End Contact Date	Date	4	-
End_Action_Assigned_To	End Action Assigned To	String	16	-
End_Action_Promised	End Action Promised	String	18	-
End_Action_Date	End Action Date	Date	4	-
ENOTPRTY	End Note Priority	Integer	2	-
QCMFLAG	Query Credit Manager Flag	Boolean	2	-
Start_Credit_Manager	Start Credit Manager	String	16	-
End_Credit_Manager	End Credit Manager	String	16	-
CUSTCSTS	Customer Commitment Status	Integer	2	-
QueryBalanceReturned	Query Balance Returned	Integer	2	-
QueryExcludeOlderBalance	Query Exclude Older Balances	Boolean	2	-
QryExcludeifPaymentMade	Query Exclude if Payment Made	Boolean	2	-
QueryNumberofDays	Query Number of Days	Integer	2	-
QueryNoteExists	Query Note Exists	Integer	2	-
STUDTAB2	Start User Defined Table 2	String	22	-
ENDUDTBL2	End User Defined Table 2	String	22	-
USERLANG	User Language ID	Integer	2	3 tables
CN_Credit_LevelStart	Start CN Credit Level	Integer	2	-
CN_Credit_LevelEnd	End CN Credit Level	Integer	2	-
Query_Exclude_Partial_Pa	Query Exclude Partial Payments	Boolean	2	-
CN_BalanceOverCreditLim	CN_BalanceOverCreditLimit	Boolean	2	-