PAYEES
Payees
tableFINPAYEES
PAYEES — Payees. FIN table in the standard Ross ERP 8.0 schema: 53 columns, used by 111 programs. Columns, data types, keys, foreign keys and relationships.
Open PAYEES 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 | AP_DIVISION | varchar(2) | PK FK→AP_CONTROLS | Division |
| 4 | PAYEE_NUMBER | varchar(12) | PK | Payee Number (or ID) |
| 5 | PAYEE_NAME | varchar(60) | Payee Name | |
| 6 | PHONE | varchar(21) | Phone Number | |
| 7 | TELEX | varchar(20) | Telex No | |
| 8 | REMARK | varchar(30) | Remarks | |
| 9 | STATIONARY_TYPE | varchar(6) | Payment Stationery Type | |
| 10 | TEN99_FLAG | varchar(1) | US 1099 Flag | |
| 11 | TEN99_STATE_ID | varchar(8) | State Identification Code for 1099's | |
| 12 | FAX_NUMBER | varchar(21) | Fax Number | |
| 13 | PAYMENT_PRIORITY | smallint | Payment Priority | |
| 14 | PAYMENT_FREQUENCY | varchar(2) | Payment Frequency | |
| 15 | PAYMENT_TYPE | varchar(6) | FK→PAYMENT_TYPES | Payment Type |
| 16 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 17 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 18 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 19 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 20 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 21 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 22 | SYS_CITY | varchar(25) | City | |
| 23 | SYS_COUNTY | varchar(25) | County | |
| 24 | SYS_STATE | varchar(6) | State Code | |
| 25 | SYS_PROVINCE | varchar(6) | Province Code | |
| 26 | SYS_COUNTRY | varchar(6) | Country Code | |
| 27 | DEFAULT_SEQ_NUMBER | smallint | Default Sequence Number | |
| 28 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 29 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 30 | OVERRIDE_PAYMENT_TYPE | varchar(1) | Override Payee Payment Type | |
| 31 | DRAFTS_IN_USE | varchar(1) | ||
| 32 | SYS_TEN99_IN_USE | varchar(1) | 1099 Reporting Required | |
| 33 | SYS_TEN99_ID | varchar(9) | Federal 1099 Identification Code | |
| 34 | SYS_TEN99_RETURN_TYPE | varchar(1) | 1099 Return Type | |
| 35 | SYS_TEN99_AMOUNT_TYPE | varchar(2) | FK→SYS_TEN99_TYPES | 1099 Amount Type |
| 36 | SYS_TEN99_TIN_TYPE | varchar(1) | 1099 TIN Type | |
| 37 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 38 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 39 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 40 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 41 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 42 | SYS_TAX_RETAINERS_FLAG | varchar(1) | Tax Retainers Flag | |
| 43 | SYS_TAX_RETAINERS_CODE_1 | varchar(5) | Tax Retainer Code | |
| 44 | SYS_TAX_RETAINERS_CODE_2 | varchar(5) | Tax Retainer Code | |
| 45 | SYS_TAX_RETAINERS_CODE_3 | varchar(5) | Tax Retainer Code | |
| 46 | SYS_TAX_RETAINERS_CODE_4 | varchar(5) | Tax Retainer Code | |
| 47 | varchar(50) | Email Address | ||
| 48 | LEGAL_NAME | varchar(70) | Legal Name of Customer | |
| 49 | CK_EMAIL_DOCUMENT | varchar(1) | ||
| 50 | CK_UPLOAD_DOCUMENT | varchar(1) | ||
| 51 | CK_EXPORT_DOCUMENT | varchar(1) | ||
| 52 | CK_EMAIL_ACCOUNTS | varchar(200) | ||
| 53 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 15 foreign keys
AP_CHECK_REGISTERCHECK_LINESAP_EFT_PAYMENT_HEADERSPAYEE_BANKSMANUAL_PAYMENT_LINESRECURRING_CHARGE_LINESPURCHASE_INVOICESAP_BACS_REGISTERA_AP_BACS_REGISTERA_AP_CHECK_REGISTERAP_VENDOR_PAYEE_LINKSAP_TRANSACTIONSAP_PAYMENT_HEADERSPURCHASE_CREDIT_NOTESPURCHASE_REGISTER