CUSTOMERS
Customers
tableFINCUSTOMERS
CUSTOMERS — Customers. FIN table in the standard Ross ERP 8.0 schema: 184 columns, used by 347 programs. Columns, data types, keys, foreign keys and relationships.
Open CUSTOMERS in the interactive Data Dictionary →Part of Other 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 | Customer Number |
| 5 | CUSTOMER_NAME | varchar(60) | Customer Name | |
| 6 | TELEX | varchar(20) | Telex No | |
| 7 | PHONE | varchar(21) | Phone Number | |
| 8 | FAX_NUMBER | varchar(21) | Fax Number | |
| 9 | REMARKS | varchar(20) | Remarks | |
| 10 | STATEMENT_ACCOUNT | varchar(8) | Payment Customer Number | |
| 11 | DEBT_LETTER | varchar(6) | FK→DEBT_LETTERS | Debt Letter |
| 12 | BALANCE_FORWARD | varchar(1) | Balance Brought Forward Flag | |
| 13 | YTD_SALES | numeric(20,2) | Year to Date Sales | |
| 14 | YTD_COSTS | numeric(20,2) | Year to Date Costs | |
| 15 | LAST_SALE | datetime | Last Sale Date | |
| 16 | LAST_CASH_RECEIPT | datetime | Last Cash Receipt Date | |
| 17 | LAST_PERIOD_END | smallint | Last Period End | |
| 18 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 19 | DEFAULT_ADDR | varchar(10) | FK→CUSTOMER_ADDRESSES | Default Address Code |
| 20 | DEFAULT_DELIVERY_ADDR_CODE | varchar(10) | FK→CUSTOMER_ADDRESSES | Default Address Code |
| 21 | STOP_CODE | varchar(8) | FK→STOP_CODES | Stop Code |
| 22 | STATEMENT_PRINT | varchar(8) | Statement Print Flag | |
| 23 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 24 | HOLD_BY_PERIOD | varchar(1) | Hold Sales, Costs and Budgets by Period | |
| 25 | HOLD_SALES | varchar(1) | ||
| 26 | HOLD_COST | varchar(1) | ||
| 27 | HOLD_BUDGET | varchar(1) | ||
| 28 | DEFAULT_POSTING_FORMAT | varchar(6) | FK→POSTING_FORMATS | Default Posting Format Code |
| 29 | PERIODS_RETAINED_HISTORY | smallint | Number of Periods of Retained Transaction History | |
| 30 | ORDER_DISCOUNT_GROUP | varchar(6) | FK→ORDER_DISCOUNT_GROUPS | Order Discount Group |
| 31 | LINE_DISCOUNT_GROUP | varchar(6) | FK→CUSTOMER_DISCOUNT_GROUPS | Line Discount Group |
| 32 | DUNS_NUMBER | varchar(20) | Credit Reference Number | |
| 33 | DUNS_DATE | datetime | Credit Review Date | |
| 34 | CREDIT_REVIEW_DATE | datetime | Date Credit Status Last Reviewed | |
| 35 | CREDIT_LIMIT_CODE | varchar(6) | FK→CREDIT_LIMIT_CONTROLS | Credit Limit Code |
| 36 | CREDIT_TERMS_CODE | varchar(6) | FK→CREDIT_TERMS | Credit Terms Code |
| 37 | WARNING_LIMIT | numeric(20,2) | Credit Warning Limit | |
| 38 | ABORT_LIMIT | numeric(20,2) | Credit Abort Limit | |
| 39 | CREDIT_TOLERANCE | numeric(10,2) | Credit Tolerance Percentage | |
| 40 | PICKING_VALUE | numeric(20,2) | Picking Value | |
| 41 | DESPATCH_VALUE | numeric(20,2) | Shipping Value | |
| 42 | BALANCE | numeric(20,2) | Balance | |
| 43 | OS_ORDER_VALUE | numeric(20,2) | Outstanding Order Value | |
| 44 | CREDIT_STATUS_CODE | varchar(6) | FK→CREDIT_HOLD_STATUS_CODES | Credit Status Code |
| 45 | PRICE_CODE | varchar(6) | FK→PRICE_CODES | Price Code |
| 46 | STATEMENT | varchar(1) | Print Statement Flag | |
| 47 | PERIOD_TD_SALES | numeric(20,2) | Period To Date Sales | |
| 48 | PERIOD_TD_COSTS | numeric(20,2) | Period To Date Costs | |
| 49 | SHIPPING_REQUIREMENTS | varchar(1) | Shipping Requirements | |
| 50 | SHIPPING_PERCENTAGE | numeric(10,2) | Minimum Shipping Percentage | |
| 51 | PERMIT_RESERVATION | varchar(1) | Permit Reservation Of Inventory | |
| 52 | AUTO_RESERVE | varchar(1) | Reserve Inventory Automatically | |
| 53 | NON_STOCK_REVENUE_CODE | varchar(6) | FK→GL_SHORT_CODES | Non-Stock Revenue Account Short Code |
| 54 | NON_STOCK_REVENUE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Non-Stock Revenue Account |
| 55 | SALES_ORDER_TYPE | varchar(6) | FK→SALES_ORDER_TYPES | Sales Order Type |
| 56 | ALPHA_SEARCH_KEY | varchar(8) | Alpha Search Key | |
| 57 | CREDIT_NAME_FORMAL | varchar(30) | Formal Credit Name | |
| 58 | CREDIT_NAME_GREETING | varchar(30) | Credit Name Greeting | |
| 59 | CREDIT_NAME_TITLE | varchar(30) | Credit Name Title | |
| 60 | CREDIT_PHONE | varchar(21) | Credit Phone Number | |
| 61 | CREDIT_PHONE_EXT | varchar(8) | Credit Phone Extension | |
| 62 | CREDIT_FAX_NUMBER | varchar(21) | Credit Fax Number | |
| 63 | LEVEL_FLAG | varchar(1) | Dept Letter Level Status Flag | |
| 64 | CREDIT_DL_CLOSE | varchar(30) | Debt Letter Close | |
| 65 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 66 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 67 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 68 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 69 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 70 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 71 | SYS_CITY | varchar(25) | City | |
| 72 | SYS_COUNTY | varchar(25) | County | |
| 73 | SYS_STATE | varchar(6) | State Code | |
| 74 | SYS_PROVINCE | varchar(6) | Province Code | |
| 75 | SYS_COUNTRY | varchar(6) | Country Code | |
| 76 | SYS_SIC_CODE | varchar(8) | FK→SYS_SIC_CODES | SIC Code |
| 77 | SYS_CUSTOMER_CLASS | varchar(6) | Customer Class | |
| 78 | AR_FINANCE_CHARGES_IN_USE | varchar(1) | Finance charges in use | |
| 79 | AR_ANNUAL_PERCENTAGE_RATE | numeric(10,4) | Annual Percentage Rate | |
| 80 | AR_MIN_FINANCE_CHARGE | numeric(20,2) | Minimum finance charge | |
| 81 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 82 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 83 | SYS_AGENT_TAX_REFERENCE_BRANCH | varchar(4) | Agents Tax Branch Reference | |
| 84 | SYS_EC_MODE_OF_TRANSPORT | varchar(1) | EC Mode of Transport | |
| 85 | SYS_EC_DELIVERY_TERMS | varchar(3) | EC Delivery Terms | |
| 86 | SYS_AGENT_IN_USE | varchar(1) | Agent In Use | |
| 87 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 88 | AR_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Auto AR Postings |
| 89 | AR_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Postings |
| 90 | AR_CREDIT_GROUP | varchar(6) | Credit Control Group | |
| 91 | AR_CREDIT_RATING | varchar(6) | Credit Rating | |
| 92 | AR_NEXT_CREDIT_REVIEW_DATE | datetime | ||
| 93 | AR_DRAFTS_IN_USE | varchar(1) | ||
| 94 | AR_DRAFT_APPROVAL_REQUIRED | varchar(1) | Draft Approval Required Flag | |
| 95 | SYS_EDI_DEFAULT_WAREHOUSE | varchar(2) | EDI Default Warehouse | |
| 96 | AR_DRAFT_DS_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Draft Sent for approval |
| 97 | AR_DRAFT_DS_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Draft Sent for approval |
| 98 | AR_DRAFT_DP_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Draft Post |
| 99 | AR_DRAFT_DP_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Draft Post |
| 100 | AR_DRAFT_DI_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Draft Issued |
| 101 | AR_DRAFT_DI_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Draft Issued |
| 102 | AR_DRAFT_PAYMENT_TYPE | varchar(3) | ||
| 103 | SYS_347_EXCLUDE_FLAG | varchar(1) | ||
| 104 | SYS_347_CODE | varchar(1) | 347 Operation Code | |
| 105 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 106 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 107 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 108 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 109 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 110 | SOP_INVOICE_GROUPING | varchar(1) | Invoice Grouping Method | |
| 111 | SYS_FREIGHT_CONTRACT_NUMBER | varchar(12) | Contract Number | |
| 112 | SYS_FREIGHT_MODE | varchar(8) | Freight Mode | |
| 113 | SOP_SHIPPING_TERMS_CODE | varchar(8) | FK→SOP_SHIPPING_TERMS | |
| 114 | SOP_ALLOW_ORDER_CLOSE | varchar(1) | Allow Order Close | |
| 115 | SOP_PRINT_CONF_FLAG | varchar(1) | Print Order Acknowledgement | |
| 116 | MP_DISTRIBUTOR | varchar(1) | Distributor | |
| 117 | MP_STRUCTURE_CODE | varchar(10) | Structure Code | |
| 118 | MP_STRUCTURE_LEVEL | smallint | Structure Level | |
| 119 | MP_PARENT_CUSTOMER | varchar(8) | ||
| 120 | MP_SHIPPING_CUSTOMER | varchar(8) | Shipping Customer | |
| 121 | MP_INVOICE_CUSTOMER | varchar(8) | Invoice Customer | |
| 122 | MP_CUSTOMER_VENDOR | varchar(12) | ||
| 123 | MP_SALES_AREA | varchar(6) | MP Sales Area | |
| 124 | MP_SALES_OFFICE | varchar(6) | MP Sales Office | |
| 125 | MP_TERRITORY | varchar(6) | MP Territory | |
| 126 | MP_MARKET_SEGMENT | varchar(6) | MP Market Segment | |
| 127 | MP_SHIPPING_VALUATION | smallint | MP Shipping Valuation | |
| 128 | MP_STRUCTURE_MEMBER_ID | varchar(20) | Structure Member Id | |
| 129 | IC_CHEP_CODE | varchar(11) | Chep Code | |
| 130 | SOP_SEPARATE_INVOICE_PER_SHIP | varchar(1) | Separate Invoice per Ship Note | |
| 131 | PAY_STATEMENT_ADDR_CODE | varchar(10) | Statement Address Code | |
| 132 | PAY_STAT_SELECTION_CODE | varchar(6) | Statement Selection Code | |
| 133 | STREAMLINE_UPDATE_FLAG | varchar(1) | Include in Streamlined Update | |
| 134 | TELEPHONE_EXT | varchar(6) | Telephone Extension | |
| 135 | varchar(50) | Email Address | ||
| 136 | WEBSITE | varchar(50) | Website Address | |
| 137 | CREDIT_EMAIL | varchar(50) | ||
| 138 | DISTRIBUTION_DAYS | smallint | Number of days allowed before product life is expired | |
| 139 | SALESPERSON_CODE | varchar(8) | Salesperson Code | |
| 140 | BROKER_CODE | varchar(10) | Broker Code | |
| 141 | TP_DISABLE_PROMOTIONS | varchar(1) | Disable Pricing and Promotions | |
| 142 | TP_AUTO_APPROVE | smallint | Allow Auto Approval | |
| 143 | TP_PAYMENT_TOLERANCE | numeric(10,2) | Payment Tolerance Percent | |
| 144 | AP_DIVISION | varchar(2) | Division | |
| 145 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 146 | PAYEE_NUMBER | varchar(12) | Payee Number (or ID) | |
| 147 | ES_INQUIRY_GEM_TRANSACTION_ID | varchar(64) | ||
| 148 | SYS_FIXED_DAY_1 | smallint | Fixed day 1 | |
| 149 | SYS_FIXED_DAY_2 | smallint | Fixed day 1 | |
| 150 | SYS_FIXED_DAY_3 | smallint | Fixed day 1 | |
| 151 | SYS_FIXED_DAY_4 | smallint | Fixed day 1 | |
| 152 | HOLIDAY_START_DAY | smallint | ||
| 153 | HOLIDAY_START_MONTH | numeric(3,0) | ||
| 154 | HOLIDAY_END_DAY | smallint | ||
| 155 | HOLIDAY_END_MONTH | numeric(3,0) | ||
| 156 | POST_HOLIDAY_PAY_DAY | smallint | ||
| 157 | SCM_SEND_FLAG | varchar(1) | The flag indicate whether send data to SCM | |
| 158 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 159 | SYS_BILLBACK_IN_USE | varchar(1) | ||
| 160 | AR_WRITE_OFF_LIMIT | numeric(20,2) | Auto write off limit in base currency | |
| 161 | AR_WRITE_OFF_PERCENT | numeric(10,2) | Auto write off percent | |
| 162 | AR_AUTO_WO_TRAN_TYPE | varchar(2) | ||
| 163 | AR_USE_DIV_WO_TOLER | varchar(1) | Use division write off tolerances flag | |
| 164 | AR_CD_TOLERANCE | smallint | Cash discount tolerance in days | |
| 165 | AR_USE_DIV_CD_TOLER | varchar(1) | Use division cash discount tolerances flag | |
| 166 | SYS_CREATE_USER | varchar(20) | User who new this record | |
| 167 | SYS_MODIFIED_DATE | datetime | Last Modification Date | |
| 168 | SYS_MODIFY_USER | varchar(20) | The last user who modified this record | |
| 169 | PRICING_METHOD | smallint | Pricing method, tax exclusive or inclusive | |
| 170 | ORDER_BY_CPC | smallint | Sale Order by Customer Product Code flag | |
| 171 | LEGAL_NAME | varchar(70) | Legal Name of Customer | |
| 172 | PRICING_DATE_FLAG | varchar(1) | Pricing Date By | |
| 173 | BRACKET_PRICE_UOM | varchar(4) | FK→UNITS_OF_MEASURE | |
| 174 | BRACKET_PRICE_LEVEL | smallint | Bracket Price Level | |
| 175 | BRACKET_PRICE_CODE | varchar(6) | FK→PRICE_CODES | |
| 176 | ACCEPT_ZERO_PRICE | varchar(1) | Accept Zero Price | |
| 177 | INVOICE_AT_SHIP_CONFIRM | varchar(1) | Whether the sales invoice is created at Ship Confirm | |
| 178 | SYS_EDI_VENDOR_NUMBER | varchar(25) | ||
| 179 | DISCONTINUE_FLAG | varchar(1) | Discontinue Master Record | |
| 180 | MINIMUM_ORDER_VALUE | numeric(20,2) | Minimum Order Value | |
| 181 | RMA_RETURN_REQUIRED | varchar(1) | RMA Return Required | |
| 182 | RECALC_PRICE_ON_INVOICE | varchar(1) | Recalculate Sales Prices on Invoice | |
| 183 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. | |
| 184 | PAYMENT_COMMUNICATION_TYPE | varchar(1) |
Referenced by · 15 foreign keys
AR_CUSTOMER_DIARYAR_FINANCE_CHARGESA_AR_FINANCE_CHARGESA_CASH_RECEIPT_BATCHESA_TAX_TRANSACTIONSCASH_RECEIPT_BATCHESAR_BATCH_TRAN_LINESAR_TRANSACTIONSCUSTOMER_ADDRESSESPART_MASTER_BY_CUSTOMERSALES_ORDER_HEADERSSALES_ORDER_INVOICESSALES_TEMPLATE_HEADERSSA_DETAIL_LINESTAX_TRANSACTIONS