RM40501 - RM Statements Options File | Prospr

RM40501 - RM Statements Options File

Query Builder

Select * from RM40501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
STMNTID	Statement ID	String	16	View
DSCRIPTN	Description	String	32	View
NOTEINDX	Note Index	Currency	10	View
STMTFORM	Statement Form	Integer	2	View
PRTCRLMT	Print Credit Limit	Boolean	2	View
PRTPYTRM	Print Payment Terms	Boolean	2	View
PRNTFNCH	Print Finance Charge	Boolean	2	View
PRNTMSGS	Print Messages	Boolean	2	View
STMNTFOR	Statement For	Long Integer	4	View
RSTRACTY	Restrict Account Type	Integer	2	View
CUSTSORT	Customer Sorts	Integer	2	View
DOCSORTS	Document Sorts	Integer	2	View
AGPERAMT_1	Aging Period Amounts[1]	Currency	10	View
AGPERAMT_2	Aging Period Amounts[2]	Currency	10	View
AGPERAMT_3	Aging Period Amounts[3]	Currency	10	View
AGPERAMT_4	Aging Period Amounts[4]	Currency	10	View
AGPERAMT_5	Aging Period Amounts[5]	Currency	10	View
AGPERAMT_6	Aging Period Amounts[6]	Currency	10	View
AGPERAMT_7	Aging Period Amounts[7]	Currency	10	View
STMTRSTR	Statement Restricts	Integer	2	View
RSTRFRID	Restrict From ID	String	16	View
RSTRTOID	Restrict To ID	String	16	View
RSTRFNAM	Restrict From Name	String	66	View
RSTRTNAM	Restrict To Name	String	66	View
RSTRFCLS	Restrict From Class	String	16	View
RSTRTCLS	Restrict To Class	String	16	View
RSTRFRUD	Restrict From User Defined	String	22	View
RSTRTOUD	Restrict To User Defined	String	22	View
RSTFSPSN	Restrict From Salesperson	String	16	View
RSTTSPSN	Restrict To Salesperson	String	16	View
RSTRFTER	Restrict From Territory	String	16	View
RSTTOTER	Restrict To Territory	String	16	View
RSTRFZIP	Restrict From Zip	String	12	View
RSTRTZIP	Restrict To Zip	String	12	View
RSTFSTCY	Restrict From Statement Cycle	Integer	2	View
RSTTSTCY	Restrict To Statement Cycle	Integer	2	View
STMTLPTD	Statement Last Printed	Date	4	View
PRTDTTKN	Print Date Token	Integer	2	View
SUMDTTKN	Summary Date Token	Integer	2	View
COFDTOKN	Cut-Off Date Token	Integer	2	View
STMTPRDT	Statement Print Date	Date	4	View
SMRYDATE	Summary Date	Date	4	View
CUTOFDAT	Cutoff Date	Date	4	View
ASKECHTM	Ask Each Time	Boolean	2	View
EXPTTYPE	Export Type	Integer	2	View
FILEXPNM	File Export Name	String	256	View
IFFILXST	If File Existing	Integer	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
LOCATNID	Location ID	String	16	View
INDCHLDSTMT	Individual Child Statements	Boolean	2	View
Email_Statements_Options	Email Statements Options	Integer	2	View
Email_Statements_Form	Email Statements Form	Integer	2	View
EmailStmtsSubjectLine	Email Statements Subject Line	String	132	View
RDCOLDPDBYUNAPPLDCR	Reduce Oldest Period by Unapplied Credit	Boolean	2	View

RM40501 - RM Statements Options File

Query Builder

Customer Service

Information

My Account

Contact Us