RM50100 - RM History Removal Tempoary File | Prospr

RM50100 - RM History Removal Tempoary File

Query Builder

Select * from RM50100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	View
CHEKNMBR	Check Number	String	22	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
DUEDATE	Due Date	Date	4	View
DOCDATE	Document Date	Date	4	View
POSTDATE	Post Date	Date	4	View
PSTUSRID	Post User ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
ORTRXAMT	Original Trx Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
SLSAMNT	Sales Amount	Currency	10	View
COSTAMNT	Cost Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
WROFAMNT	Write Off Amount	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View
CSPORNBR	Customer Purchase Order Number	String	22	View
SLPRSNID	Salesperson ID	String	16	View
SLSTERCD	Sales Territory Code	String	16	View
DINVPDOF	Date Invoice Paid Off	Date	4	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
DELETE1	Delete	Boolean	2	View
TAXSCHID	Tax Schedule ID	String	16	View
SLSCHDID	Sales Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
CURNCYID	Currency ID	String	16	View
SHIPMTHD	Shipping Method	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
TRDISAMT	Trade Discount Amount	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
VOIDDATE	Void Date	Date	4	View
BALFWDNM	Balance Forward Number	String	22	View
CSHRCTYP	Cash Receipt Type	Integer	2	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
SALEDATE	Sale Date	Date	4	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
USERID	User ID	String	16	View
PRCSSQNC	Process Sequence	Integer	2	View
Status	Status	Integer	2	View
STR1	STR1	String	2	View

RM50100 - RM History Removal Tempoary File

Query Builder

Customer Service

Information

My Account

Contact Us