RM50103 - RM Email Statements Header Temporary File | Prospr

RM50103 - RM Email Statements Header Temporary File

Query Builder

Select * from RM50103

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DSCRIPTN	Description	String	32	View
STMNTID	Statement ID	String	16	View
CUSTNMBR	Customer Number	String	16	View
STMTNAME	Statement Name	String	66	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
DATE1	Date	Date	4	View
MINPYDUE	Minimum Payment Due	Currency	10	View
CUSTMSGS_1	Customer Messages[1]	String	42	View
CUSTMSGS_2	Customer Messages[2]	String	42	View
CUSTMSGS_3	Customer Messages[3]	String	42	View
AMNTDUE	Amount Due	Currency	10	View
STMTMSGS_1	Statement Messages[1]	String	52	View
STMTMSGS_2	Statement Messages[2]	String	52	View
STMTMSGS_3	Statement Messages[3]	String	52	View
STMTMSGS_4	Statement Messages[4]	String	52	View
STMTMSGS_5	Statement Messages[5]	String	52	View
STMTMSGS_6	Statement Messages[6]	String	52	View
STMTMSGS_7	Statement Messages[7]	String	52	View
STMTMSGS_8	Statement Messages[8]	String	52	View
STMTMSGS_9	Statement Messages[9]	String	52	View
STMTMSGS_10	Statement Messages[10]	String	52	View
STMTMSGS_11	Statement Messages[11]	String	52	View
STMTMSGS_12	Statement Messages[12]	String	52	View
STMTMSGS_13	Statement Messages[13]	String	52	View
STMTMSGS_14	Statement Messages[14]	String	52	View
STMTMSGS_15	Statement Messages[15]	String	52	View
DOCARABR_1	Document Array Abbreviation[1]	String	4	View
DOCARABR_2	Document Array Abbreviation[2]	String	4	View
DOCARABR_3	Document Array Abbreviation[3]	String	4	View
DOCARABR_4	Document Array Abbreviation[4]	String	4	View
DOCARABR_5	Document Array Abbreviation[5]	String	4	View
DOCARABR_6	Document Array Abbreviation[6]	String	4	View
DOCARABR_7	Document Array Abbreviation[7]	String	4	View
DOCARABR_8	Document Array Abbreviation[8]	String	4	View
DOCARABR_9	Document Array Abbreviation[9]	String	4	View
DOCARDSC_1	Document Array Description[1]	String	22	View
DOCARDSC_2	Document Array Description[2]	String	22	View
DOCARDSC_3	Document Array Description[3]	String	22	View
DOCARDSC_4	Document Array Description[4]	String	22	View
DOCARDSC_5	Document Array Description[5]	String	22	View
DOCARDSC_6	Document Array Description[6]	String	22	View
DOCARDSC_7	Document Array Description[7]	String	22	View
DOCARDSC_8	Document Array Description[8]	String	22	View
DOCARDSC_9	Document Array Description[9]	String	22	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
AGPERDSC_1	Aging Periods Descriptions[1]	String	16	View
AGPERDSC_2	Aging Periods Descriptions[2]	String	16	View
AGPERDSC_3	Aging Periods Descriptions[3]	String	16	View
AGPERDSC_4	Aging Periods Descriptions[4]	String	16	View
AGPERDSC_5	Aging Periods Descriptions[5]	String	16	View
AGPERDSC_6	Aging Periods Descriptions[6]	String	16	View
AGPERDSC_7	Aging Periods Descriptions[7]	String	16	View
CMPANYID	Company ID	Integer	2	View
LOCATNID	Location ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
CUSTBLNC	Customer Balance	Currency	10	View
DEPRECV	Deposits Received	Currency	10	View
RNNMBR	Run Number	Long Integer	4	View
PRNTSTUS	Printing Status	Integer	2	View
USERID	User ID	String	16	View
Process_Index	Process Index	Long Integer	4	View

RM50103 - RM Email Statements Header Temporary File

Query Builder

Customer Service

Information

My Account

Contact Us