SOP_CI_HEADERS
Consolidated invoice headers
tableFINSOP
SOP_CI_HEADERS — Consolidated invoice headers. FIN table in the standard Ross ERP 8.0 schema: 39 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.
Open SOP_CI_HEADERS in the interactive Data Dictionary →Part of SOP 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 | CI_TRANSACTION_NUMBER | int | PK | |
| 5 | CI_AR_TRANSACTION_TYPE | varchar(1) | PK | Transaction Type |
| 6 | CUSTOMER_NUMBER | varchar(8) | PK | Customer Number |
| 7 | INVOICE_ADDRESS_CODE | varchar(10) | PK | Invoice Address Code |
| 8 | SYS_CURRENCY_CODE | varchar(6) | PK | Currency Code |
| 9 | CREDIT_TERMS_CODE | varchar(6) | PK | Credit Terms Code |
| 10 | YEAR | smallint | PK | Year Number |
| 11 | PERIOD | smallint | PK | Period Number |
| 12 | CI_AR_DATA_TYPE | varchar(2) | PK | Consolidated Data Type |
| 13 | INVOICE_NUMBER | int | PK | Invoice Number |
| 14 | CI_CUTOFF_DATE | datetime | ||
| 15 | DUE_DATE | datetime | Due Date | |
| 16 | DUE_PERIOD | smallint | Period When Transaction Due | |
| 17 | DUE_YEAR | smallint | Year When Transaction Due | |
| 18 | INVOICE_DATE | datetime | Invoice Date | |
| 19 | LINE_TAX | numeric(20,2) | Line Tax | |
| 20 | LINE_DISCOUNT | numeric(20,2) | Line Discount | |
| 21 | LINE_VALUE_DISCOUNTED | numeric(20,2) | Line Value (after order discount) | |
| 22 | LINE_TAX_DISCOUNTED | numeric(20,2) | Line Tax (after order discount) | |
| 23 | INVOICE_DISCOUNT_PERCENT | numeric(10,2) | Invoice Discount Percent | |
| 24 | INVOICE_DISCOUNT | numeric(20,2) | Invoice Discount | |
| 25 | INVOICE_DISCOUNT_GROUP | varchar(6) | Invoice Discount Group | |
| 26 | SOP_INVOICE_TOTAL_CURRENCY | numeric(20,2) | Total Invoice Line Value in Currency | |
| 27 | SOP_INVOICE_TOTAL_BASE | numeric(20,2) | Total Invoice Value in Base Currency | |
| 28 | INVOICE_VALUE | numeric(20,2) | Invoice Value | |
| 29 | FREIGHT_TAX_CODE | varchar(5) | Tax code associated with this freight code | |
| 30 | FREIGHT | numeric(20,2) | Freight Value | |
| 31 | TAX_ON_FREIGHT | numeric(20,2) | Tax on Freight | |
| 32 | MISC_TAX_CODE | varchar(5) | Miscellaneous Tax Code | |
| 33 | MISCELLANEOUS | numeric(20,2) | Miscellaneous Charge | |
| 34 | TAX_ON_MISCELLANEOUS | numeric(20,2) | Tax on Miscellaneous | |
| 35 | CASH_DISCOUNT_AT_ENTRY | numeric(20,2) | Cash Discount at Entry | |
| 36 | CASH_DISCOUNT_TAX | numeric(20,2) | Cash Discount Tax Value | |
| 37 | TOTAL_TAX | numeric(20,2) | Total Tax This Period | |
| 38 | CI_INVOICE_DATE | datetime | Invoice Date for Consolidated Invoice | |
| 39 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |