CUSTOMER_ADDRESSES
Customer Alternate Addresses
tableFINCUSTOMER
CUSTOMER_ADDRESSES — Customer Alternate Addresses. FIN table in the standard Ross ERP 8.0 schema: 118 columns, used by 139 programs. Columns, data types, keys, foreign keys and relationships.
Open CUSTOMER_ADDRESSES in the interactive Data Dictionary →Part of CUSTOMER 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 | CUSTOMER_NUMBER | varchar(8) | PK FK→CUSTOMERS | Customer Number |
| 5 | ADDRESS_CODE | varchar(10) | PK | Address Code |
| 6 | CUSTOMER_NAME | varchar(60) | Customer Name | |
| 7 | PHONE | varchar(21) | Phone Number | |
| 8 | TELEX | varchar(20) | Telex No | |
| 9 | FAX_NUMBER | varchar(21) | Fax Number | |
| 10 | REMARKS | varchar(20) | Remarks | |
| 11 | LOCATION | varchar(8) | FK→LOCATIONS | Location |
| 12 | CUSTOMER_GROUP | varchar(8) | FK→CUSTOMER_GROUPS | Customer Sales Analysis Group |
| 13 | DELIVERY_INSTRUCTIONS | varchar(30) | Delivery Instructions | |
| 14 | MESSAGE_CODE | varchar(6) | FK→MESSAGE_CODES | Message |
| 15 | SALES_TAXABLE | varchar(1) | Sales Tax Applies | |
| 16 | TAX_CODE | varchar(5) | FK→TAX_CODES | Tax Code |
| 17 | SHIP_METHOD | varchar(10) | Method of Shipment | |
| 18 | TAX_EXEMPTION | varchar(20) | Tax Reference | |
| 19 | CUSTOMER_NOTES | text | Customer Notes | |
| 20 | PRICE_CODE | varchar(6) | FK→PRICE_CODES | Price Code |
| 21 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 22 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 23 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 24 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 25 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 26 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 27 | SYS_CITY | varchar(25) | City | |
| 28 | SYS_COUNTY | varchar(25) | County | |
| 29 | SYS_STATE | varchar(6) | State Code | |
| 30 | SYS_PROVINCE | varchar(6) | Province Code | |
| 31 | SYS_COUNTRY | varchar(6) | Country Code | |
| 32 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 33 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 34 | SYS_EC_MODE_OF_TRANSPORT | varchar(1) | EC Mode of Transport | |
| 35 | SYS_EC_DELIVERY_TERMS | varchar(3) | EC Delivery Terms | |
| 36 | SYS_EC_TRANSACTION_TYPE | varchar(2) | EC Nature of Transaction | |
| 37 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 38 | AR_MSDS_FREQUENCY | smallint | MSDS Frequency (months) | |
| 39 | SYS_LANGUAGE_CODE_2 | varchar(8) | FK→SYS_LANGUAGE_CODES | Language Code |
| 40 | SYS_LANGUAGE_CODE_3 | varchar(8) | FK→SYS_LANGUAGE_CODES | Language Code |
| 41 | IC_MSDS_FORMAT_CODE | varchar(10) | MSDS Format Code | |
| 42 | SALESPERSON_CODE | varchar(8) | FK→SALESPERSONS | Salesperson Code |
| 43 | SYS_EC_FACTOR | numeric(10,4) | EC Factor | |
| 44 | SYS_EDI_ENTITY_ID_QUAL | varchar(2) | EDI Entity ID Qualifier | |
| 45 | SYS_EDI_ENTITY_ID | varchar(20) | EDI Entity ID | |
| 46 | SYS_TRADING_PARTNER_CODE | varchar(6) | Trading Partner Code | |
| 47 | SYS_EDI_DEFAULT_WAREHOUSE | varchar(2) | EDI Default Warehouse | |
| 48 | SYS_EDI_DEFAULT_INVOICE_ADDR | varchar(10) | EDI Invoice/Shipping Address | |
| 49 | SYS_BOD_CODE | varchar(8) | Bill of Distribution | |
| 50 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 51 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 52 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 53 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 54 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 55 | SYS_TAX_ON_CASH | varchar(1) | Tax on Cash | |
| 56 | SYS_FREIGHT_MODE | varchar(8) | Freight Mode | |
| 57 | SYS_FREIGHT_CONTRACT_NUMBER | varchar(12) | Contract Number | |
| 58 | SYS_DISTRIBUTION_ZONE | varchar(12) | FK→SYS_DISTRIBUTION_ZONES | Distribution Zone |
| 59 | TELEPHONE_EXT | varchar(6) | Telephone Extension | |
| 60 | varchar(50) | Email Address | ||
| 61 | WEBSITE | varchar(50) | Website Address | |
| 62 | ADDRESS_TYPE_FLAG | varchar(1) | Address Type Flag | |
| 63 | BROKER_CODE | varchar(10) | Broker Code | |
| 64 | CUSTOMER_CONTACT | varchar(20) | Customer Contact | |
| 65 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 66 | SCM_SEND_FLAG | varchar(1) | The flag indicate whether send data to SCM | |
| 67 | SYS_ISO_LANGUAGE_CODE | varchar(2) | ISO 2-character Language Code | |
| 68 | SEND_TO_EXTERNAL | varchar(1) | Send to an external system in next update transaction | |
| 69 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 70 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 71 | SYS_CREATE_USER | varchar(20) | User who new this record | |
| 72 | SYS_MODIFIED_DATE | datetime | Last Modification Date | |
| 73 | SYS_MODIFY_USER | varchar(20) | The last user who modified this record | |
| 74 | PRICING_METHOD | smallint | Pricing method, tax exclusive or inclusive | |
| 75 | FORMAT_CODE | varchar(6) | Format Code | |
| 76 | SYS_FINAL_DESTINATION | smallint | Final destination address flag | |
| 77 | SYS_MOT_CODE | varchar(5) | Mode of Transport | |
| 78 | SYS_INCOTERM_CODE | varchar(3) | INCOTERM Codes | |
| 79 | SYS_INCOTERM_CITY | varchar(30) | INCOTERM City | |
| 80 | SYS_EXPORT_EXIT_PORT | varchar(5) | ||
| 81 | SYS_EXPORT_DEST_PORT | varchar(5) | ||
| 82 | SYS_TRANS_TERM_CODE | varchar(12) | Transport Terms Code | |
| 83 | LEGAL_NAME | varchar(70) | Legal Name of Customer | |
| 84 | LS_STATE_LICENSE_NUMBER | varchar(12) | State License Number | |
| 85 | LS_STATE_LICENSE_EXPIRY_DATE | datetime | License Expiry Date | |
| 86 | LS_DEA_EFFECTIVE_DATE | datetime | DEA Effective Date | |
| 87 | LS_DEA_EXPIRY_DATE | datetime | DEA Expiry Date | |
| 88 | LS_DEA_LICENSE_NUMBER | varchar(10) | DEA License Number | |
| 89 | SOP_REQUIRED_DATE_METHOD | varchar(1) | Required Date Method | |
| 90 | SALES_ORDER_LEAD_TIME | smallint | ||
| 91 | PRICING_DATE_FLAG | varchar(1) | Pricing Date By | |
| 92 | BRACKET_PRICE_LEVEL | smallint | Bracket Price Level | |
| 93 | BRACKET_PRICE_CODE | varchar(6) | FK→PRICE_CODES | |
| 94 | SOP_SHIPPING_TERMS_CODE | varchar(8) | FK→SOP_SHIPPING_TERMS | |
| 95 | INVOICE_AT_SHIP_CONFIRM | varchar(1) | Whether the sales invoice is created at Ship Confirm | |
| 96 | SHIPPING_LEAD_TIME | smallint | Shipping Lead Time | |
| 97 | SALES_ORDER_TYPE | varchar(6) | Sales Order Type | |
| 98 | SO_EMAIL_DOCUMENT | varchar(1) | ||
| 99 | SO_UPLOAD_DOCUMENT | varchar(1) | ||
| 100 | SO_EXPORT_DOCUMENT | varchar(1) | ||
| 101 | DNPL_EMAIL_DOCUMENT | varchar(1) | ||
| 102 | DNPL_UPLOAD_DOCUMENT | varchar(1) | ||
| 103 | DNPL_EXPORT_DOCUMENT | varchar(1) | ||
| 104 | INCN_EMAIL_DOCUMENT | varchar(1) | ||
| 105 | INCN_UPLOAD_DOCUMENT | varchar(1) | ||
| 106 | INCN_EXPORT_DOCUMENT | varchar(1) | ||
| 107 | SO_EMAIL_ACCOUNTS | varchar(200) | ||
| 108 | DNPL_EMAIL_ACCOUNTS | varchar(200) | ||
| 109 | INCN_EMAIL_ACCOUNTS | varchar(200) | ||
| 110 | REPORT_FORM_TYPE | varchar(40) | Report Form Type | |
| 111 | EMAIL_BOL | varchar(1) | ||
| 112 | EMAIL_BOL2 | varchar(1) | ||
| 113 | PRIORITY_CODE | smallint | Workflow routing Priority | |
| 114 | ROUTE_ID | varchar(8) | Route ID | |
| 115 | STOP_NUM | smallint | Stop Number | |
| 116 | CARRIER_ID | varchar(10) | Carrier ID | |
| 117 | CUSTOMER_ACTUAL_NAME | varchar(60) | ||
| 118 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |