TP_PROMOTIONS
Discount Promotions Header Data
tableFINTP
TP_PROMOTIONS — Discount Promotions Header Data. FIN table in the standard Ross ERP 8.0 schema: 48 columns, used by 18 programs. Columns, data types, keys, foreign keys and relationships.
Open TP_PROMOTIONS in the interactive Data Dictionary →Part of TP tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | TP_PROGRAM_ID | varchar(10) | FK→TP_PROGRAMS | Program Id |
| 4 | TP_PROMOTION_CODE | varchar(10) | PK | Promotion Code |
| 5 | DESCRIPTION | varchar(30) | Description | |
| 6 | NOTES | text | Notes | |
| 7 | TP_EFFECTIVE_START_DATE | datetime | Effective start date | |
| 8 | TP_EFFECTIVE_END_DATE | datetime | Effective end date | |
| 9 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 10 | TP_DISCOUNT_TYPE | smallint | Discount return type | |
| 11 | TP_MANDATORY_DISCOUNT | smallint | Mandatory Discount | |
| 12 | TP_PLATEAU_BASIS | smallint | Plateau basis | |
| 13 | TP_CALCULATION_TYPE | smallint | Discount calculation type | |
| 14 | TP_CALCULATION_BASIS | smallint | Calculation basis | |
| 15 | TP_VALUE_TYPE | smallint | Discount value type | |
| 16 | TP_DATE_TYPE | smallint | Promotion date type | |
| 17 | VALID_FROM_DATE | datetime | Promotion Valid From | |
| 18 | VALID_TO_DATE | datetime | Promotion Valid To date | |
| 19 | TP_GRACE_DAYS_BACK | smallint | Promotion grace days back | |
| 20 | TP_GRACE_DAYS_FORWARD | smallint | Promotion grace days forward | |
| 21 | TP_AUTO_UPDATE | smallint | Allow auto update | |
| 22 | TP_AP_BILLING_SOURCE | smallint | AP Billing Source | |
| 23 | TP_PROMOTION_STATUS | smallint | Promotion status | |
| 24 | TP_SALES_ANALYSIS_UNIT | varchar(4) | ||
| 25 | TP_ACTUAL_SALES_QTY | numeric(20,6) | Actual Sales Quantity | |
| 26 | TP_PLANNED_SALES_QTY | numeric(20,6) | Planned Sales Quantity | |
| 27 | TP_AUTO_APPROVE | smallint | Allow Auto Approval | |
| 28 | TP_PLANNED_SALES_VALUE | numeric(20,2) | Planned Sales Value | |
| 29 | TP_ACTUAL_SALES_VALUE | numeric(20,2) | Actual Sales Value | |
| 30 | TP_ACTUAL_DISCOUNT_VALUE | numeric(20,2) | Actual Discount Value | |
| 31 | TP_AR_OR_AP | smallint | Post invoice discount destination (AR/AP) | |
| 32 | AP_DIVISION | varchar(2) | Division | |
| 33 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 34 | PAYEE_NUMBER | varchar(12) | Payee Number (or ID) | |
| 35 | TP_PLATEAU_UOM_TYPE | smallint | Plateau Unit Type | |
| 36 | TP_ADVANCE_AMOUNT | numeric(20,2) | Advance Amount | |
| 37 | TP_SUBSTITUTE_FOR | varchar(10) | ||
| 38 | TP_BOOK_ONLY_IND | smallint | Book Only Discount Indicator | |
| 39 | TP_TAX_FLAG | smallint | Tax on Post Invoice Discount | |
| 40 | TP_TAX_CODE | varchar(5) | ||
| 41 | AR_DIVISION | varchar(2) | ||
| 42 | AR_CUSTOMER | varchar(8) | ||
| 43 | AR_INVOICE_ADDRESS | varchar(10) | ||
| 44 | SYS_EDI_ALLOWANCE_CHG_CODE | varchar(4) | ||
| 45 | SYS_EDI_HANDLING_CODE | varchar(2) | ||
| 46 | IS_SAC_QUALIFIER_CODE | varchar(4) | ||
| 47 | WITH_OPEN_TRANS | varchar(1) | ||
| 48 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |