CN00600 - Collections - Query Master | Prospr

CN00600 - Collections - Query Master

Query Builder

Select * from CN00600

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

CN00600 - Collections - Query Master

Query Builder

Customer Service

Information

My Account

Contact Us