TP_POST_INVOICE_DISCOUNTS
Post Invoice Discounts to be updated to AR/AP
tableFINTP
TP_POST_INVOICE_DISCOUNTS — Post Invoice Discounts to be updated to AR/AP. FIN table in the standard Ross ERP 8.0 schema: 39 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.
Open TP_POST_INVOICE_DISCOUNTS 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 | DIVISION | varchar(2) | PK | Division |
| 4 | TRANSACTION_TYPE | varchar(2) | PK | Transaction Type |
| 5 | TRANSACTION_NUMBER | int | PK | Transaction Number |
| 6 | TRANSACTION_LINE_NUMBER | int | PK | Transaction line number used for tax reporting purposes |
| 7 | TP_PROMOTION_CODE | varchar(10) | PK | Promotion Code |
| 8 | CREATION_DATE | datetime | Creation Date | |
| 9 | SALESPERSON_CODE | varchar(8) | Salesperson Code | |
| 10 | BROKER_CODE | varchar(10) | Broker Code | |
| 11 | TP_PROGRAM_ID | varchar(10) | Program Id | |
| 12 | TP_AR_OR_AP | smallint | Post invoice discount destination (AR/AP) | |
| 13 | CUSTOMER_NUMBER | varchar(8) | Customer Number | |
| 14 | AR_PAYMENT_CUSTOMER | varchar(8) | ||
| 15 | INVOICE_ADDRESS_CODE | varchar(10) | Invoice Address Code | |
| 16 | TP_PAYMENT_TOLERANCE | numeric(10,2) | Payment Tolerance Percent | |
| 17 | AP_DIVISION | varchar(2) | Division | |
| 18 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 19 | PAYEE_NUMBER | varchar(12) | Payee Number (or ID) | |
| 20 | TP_AUTO_APPROVE | smallint | Allow Auto Approval | |
| 21 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 22 | COST_CENTER | varchar(3) | Cost Center Code | |
| 23 | TP_TRANS_DISCOUNT_VALUE | numeric(20,2) | ||
| 24 | TP_VALUE_TO_BE_PAID | numeric(20,2) | Value to be Paid to AR/AP | |
| 25 | TP_BASE_VALUE_TO_BE_PAID | numeric(20,2) | ||
| 26 | TP_VALUE_TO_APPROVE | numeric(20,2) | Value to Approve | |
| 27 | TP_APPROVED_FLAG | smallint | Approved Flag | |
| 28 | TP_APPROVED_VALUE | numeric(20,2) | Value of the Discount that has been Approved | |
| 29 | TP_VALUE_TO_UPDATE | numeric(20,2) | Value to Update | |
| 30 | TP_UPDATED_FLAG | smallint | Updated Flag | |
| 31 | TP_UPDATED_VALUE | numeric(20,2) | Value of the Discount that has been Updated | |
| 32 | TP_BOOK_ONLY_IND | smallint | Book Only Discount Indicator | |
| 33 | TP_OUTSTANDING_TO_APPROVE | computed | ||
| 34 | TP_OUTSTANDING_TO_UPDATE | computed | ||
| 35 | AR_DIVISION | varchar(2) | ||
| 36 | AR_CUSTOMER | varchar(8) | ||
| 37 | AR_INVOICE_ADDRESS | varchar(10) | ||
| 38 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. | |
| 39 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |