MC10101 - MC RM Distribution Temp File | Prospr

MC10101 - MC RM Distribution Temp File

Query Builder

Select * from MC10101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	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
DOCNUMBR	Document Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
APTODCNM	Apply To Document Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	View
DSTINDX	Distribution Account Index	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View
CHANGED	Changed	Boolean	2	View
CUSTNMBR	Customer Number	String	16	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
MCSTRUCT_1	MC Def Structure:Currency ID	String	16	View
MCSTRUCT_2	MC Def Structure:Currency Index	Integer	2	View
MCSTRUCT_3	MC Def Structure:Rate Type ID	String	16	View
MCSTRUCT_4	MC Def Structure:Exchange Table ID	String	16	View
MCSTRUCT_5	MC Def Structure:Exchange Rate	Currency (Variable)	10	View
MCSTRUCT_6	MC Def Structure:Exchange Date	Date	4	View
MCSTRUCT_7	MC Def Structure:Decimal Places	Integer	2	View
MCSTRUCT_8	MC Def Structure:Time	Time	4	View
MCSTRUCT_9	MC Def Structure:Rate Calc Method	Integer	2	View
MCSTRUCT_10	MC Def Structure:View Mode	Integer	2	View
MCSTRUCT_11	MC Def Structure:IS MC Trx	Integer	2	View
MCSTRUCT_12	MC Def Structure:Expiration Date	Date	4	View
MCSTRUCT_13	MC Def Structure:Denomination Exchange Rate	Currency (Variable)	10	View
MCSTRUCT_14	MC Def Structure:MC Transaction State	Integer	2	View
SPCLDIST	Specialized Distribution	Integer	2	View

MC10101 - MC RM Distribution Temp File

Query Builder

Customer Service

Information

My Account

Contact Us