MP_CREDIT_LINE_DISCOUNTS

Credit Line Discounts

tableFINMP

MP_CREDIT_LINE_DISCOUNTS — Credit Line Discounts. FIN table in the standard Ross ERP 8.0 schema: 29 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.

Open MP_CREDIT_LINE_DISCOUNTS in the interactive Data Dictionary →

Part of MP tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2COMPANY_CODEvarchar(10)PKCompany Code
3DIVISIONvarchar(2)PKDivision
4CREDIT_NOTE_NUMBERintPKCredit Note Number
5CREDIT_NOTE_LINE_NUMBERintPKCredit Note Line Number
6MP_APPLICATION_SEQUENCEsmallintPKDiscount calculated and applied in this order
7MP_CALCULATE_ON_SEQUENCEsmallintDiscount calculated on result the specified sequence
8MP_CALCULATION_LINE_TYPEsmallintMP calculation Line Type
9MP_CALCULATION_TYPEsmallintMP Calculation Type
10MP_AWARD_TYPEsmallintMP Award Type
11MP_AWARD_WAREHOUSEvarchar(2)Award Warehouse
12MP_AWARD_PART_CODEvarchar(15)Award Product
13MP_AWARD_UNITvarchar(4)Award Unit
14MP_AWARD_PRICE_QUANTITYnumeric(20,6)
15MP_AWARD_PRODUCT_PRICEnumeric(20,4)
16MP_AWARD_AMOUNTnumeric(20,2)Award Amount
17MP_AWARD_UNIT_DISCOUNTnumeric(20,4)Award Unit Discount
18MP_AWARD_PERCENTnumeric(10,2)Award Percent
19MP_ON_INVOICE_DISCOUNTnumeric(20,2)
20MP_OTHER_DISCOUNTnumeric(20,2)
21MP_TOTAL_ON_INVOICE_DISCOUNTnumeric(20,2)
22MP_TOTAL_ALL_DISCOUNTnumeric(20,2)
23MP_PRICE_LESS_ON_INVOICEnumeric(20,4)
24MP_PRICE_LESS_TOTALnumeric(20,4)
25MP_DISCOUNT_REDEEM_METHODsmallintMP Discount Redemption Method
26DOCUMENT_NUMBERvarchar(13)Originating Document Number
27MP_AGREEMENT_SEQUENCEsmallint
28MP_AWARD_QUANTITYnumeric(20,6)Award Quantity
29GEM_ARCHIVE_FLAGvarchar(20)System flag indicating whether the row has been archived by the GEMBASE archive process.