SALES_TEMPLATE_HEADERS
Sales Order Template Headers
tableFINSALES
SALES_TEMPLATE_HEADERS — Sales Order Template Headers. FIN table in the standard Ross ERP 8.0 schema: 34 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.
Open SALES_TEMPLATE_HEADERS in the interactive Data Dictionary →Part of SALES 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 FK→AR_CONTROLS | Division |
| 4 | TEMPLATE_CODE | varchar(10) | PK | Sales Order Template Code |
| 5 | DESCRIPTION | varchar(30) | Description | |
| 6 | CUSTOMER_NUMBER | varchar(8) | FK→CUSTOMERS | Customer Number |
| 7 | INVOICE_ADDRESS_CODE | varchar(10) | FK→CUSTOMER_ADDRESSES | Invoice Address Code |
| 8 | DELIVERY_ADDRESS_CODE | varchar(10) | FK→CUSTOMER_ADDRESSES | Delivery Address Code |
| 9 | CUSTOMER_REFERENCE | varchar(25) | Customer Reference | |
| 10 | LOCATION | varchar(8) | FK→LOCATIONS | Location |
| 11 | SALESPERSON_CODE | varchar(8) | FK→SALESPERSONS | Salesperson Code |
| 12 | SALES_COMMISSION_CODE | varchar(6) | FK→SALES_COMMISSION_CODES | Sales Commission Group |
| 13 | SALES_ANALYSIS_GROUP | varchar(8) | FK→CUSTOMER_GROUPS | Sales Analysis Group Code |
| 14 | FREIGHT | numeric(20,2) | Freight Value | |
| 15 | MISCELLANEOUS | numeric(20,2) | Miscellaneous Charge | |
| 16 | STATUS_FLAG | varchar(1) | Status Flag | |
| 17 | CREATION_DATE | datetime | Creation Date | |
| 18 | CUSTOMER_CONTACT | varchar(20) | Customer Contact | |
| 19 | COST_CENTER | varchar(3) | Cost Center Code | |
| 20 | CREDIT_TERMS_CODE | varchar(6) | FK→CREDIT_TERMS | Credit Terms Code |
| 21 | SALES_ORDER_TYPE | varchar(6) | Sales Order Type | |
| 22 | NOTES | text | Notes | |
| 23 | SYS_PRINT_PART_DETAIL | varchar(1) | Print product detail flag | |
| 24 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 25 | SYS_BASE_CURRENCY | varchar(6) | ||
| 26 | SYS_RATE_TYPE | varchar(6) | Currency Rate Type | |
| 27 | SYS_RATE_AUTHORITY | varchar(6) | Currency Rate Authority | |
| 28 | SOP_SHIPPING_TERMS_CODE | varchar(8) | FK→SOP_SHIPPING_TERMS | |
| 29 | DELIVERY_INSTRUCTIONS | varchar(30) | Delivery Instructions | |
| 30 | SHIP_METHOD | varchar(10) | Method of Shipment | |
| 31 | SOP_DESTINATION_WAREHOUSE | varchar(2) | ||
| 32 | SOP_PRINT_CONF_FLAG | varchar(1) | Print Order Acknowledgement | |
| 33 | PRICING_METHOD | smallint | Pricing method, tax exclusive or inclusive | |
| 34 | FINAL_ADDRESS_CODE | varchar(10) | Invoice Address Code |