| AC_CONTROL | |
| AC_DEFECT | |
| AC_FLIGHT_LOG | |
| AC_INSTALLED | |
| AC_METER | |
| AC_METER_TYPE | |
| AC_POLICIES | |
| AC_PROGRAMS | |
| AC_STOCK_CFG | |
| AC_STOCK_POLICIES | |
| AC_STOCK_PROGRAMS | |
| AGENTS | |
| AIRCRAFT | |
| AIRCRAFT_WARRANTIES | |
| ALTERNATES_PARTS_MASTER | |
| ALTERNATES_VIEW | |
| ALTERNATE_TYPE_CODES | |
| APPLICATION_CODES | |
| AP_ACCOUNT | |
| AP_DETAIL | |
| AR_ACCOUNT | Accounts Receivable Accounts |
| AR_DETAIL | Accounts Receivable Transactions Details |
| ASSEMBLY_MATRIX | |
| AUDIT_TRAIL | |
| AVREF_DSC_MATCH | |
| AVREF_MFG_MATCH | |
| AVREF_PCC_MATCH | |
| AVREF_UOM_MATCH | |
| BANK | |
| BUY_DETAIL | |
| BUY_SOURCE | |
| CALENDAR | |
| CALL_LIST | |
| CALL_USERS | |
| CAPABILITY_CODES | |
| CERT_SOURCE | |
| CK_DETAIL | |
| CK_HEADER | |
| CK_MANUAL | |
| CK_PRINT | |
| CLASS_CODES | |
| CLASS_FLAGS | |
| CLAUSES | |
| COMMISSION_CODES | |
| COMPANIES | |
| COMPANY_AGENTS | |
| COMPANY_CLAUSES | |
| COMPANY_CREDIT_CARDS | |
| COMPANY_IQ_USER | |
| COMPANY_LIST | |
| COMPANY_PART_CAPABILITY | |
| COMPANY_ROLODEX | |
| COMPANY_SITES | |
| CONSIGNMENT_CODES | Primary Key:CNC_AUTO_KEY |
| CQ_DETAIL | |
| CQ_HEADER | |
| CQ_STATUS | |
| CQ_TAX_MATRIX | |
| CQ_WO_OPTIONS | |
| CQ_WO_TEMPLATES | |
| CREDIT_CARD_TYPE | |
| CR_DETAIL | |
| CR_HEADER | |
| CURRENCY | |
| CUSTOMER_DISCOUNT_CODES | |
| CUSTOMER_WARRANTIES | |
| CVT_REDIRECT | |
| DEFAULT_CLAUSES | |
| DELETE_ME | |
| DELIVERY_CODES | |
| DEPARTMENT | |
| DISCOUNT_CODES | |
| DISCOUNT_LEVELS | |
| DISCOUNT_MATRIX | |
| DIVISION | |
| ERROR_LIST | |
| ERROR_LOOKUP | |
| ERROR_MESSAGES | |
| EVENT_DETAIL | |
| EVENT_HISTORY | |
| EVENT_MASTER | |
| EXCHANGE | |
| FAX_PREFIX_CODES | |
| FIELD_CORRESPONDENCE | |
| FIELD_LIST | |
| FORM_HIST | |
| FORM_LISTS | |
| FORM_MASTER | |
| GEO_CODES | |
| GL_ACCOUNT | |
| GL_ACCT_CAT | |
| GL_BATCH | |
| GL_CONTROL | |
| GL_DISTRIBUTION | |
| GL_FISCAL | |
| GL_JOURNAL | |
| GL_PERIOD | |
| GL_SEGMENT | |
| GL_SEG_ATTR | |
| GL_SEG_ATTR_DEF | |
| GL_SEG_SUB_CAT | |
| GL_SUMMARY | |
| GL_TEMPLATE | |
| GL_TEMPLATE_TRANS | |
| GL_TRANS | |
| HSCRATCH | |
| ILS_CONS_PARAMS | |
| ILS_DATA | |
| ILS_FLAG_CODES | ILS Flag for determining if part should be exported. IFC_AUTO_KEY ILS_FLAG_CODE CHAR(1) NOT NULL DESCRIPTION T_DESCRIPTION NOT NULL SEQUENCE T_ITEM_SEQUENCE default 1 NOT NULL |
| ILS_FLAG_PARAMS | |
| ILS_MB | |
| ILS_PARAMS | |
| IMAGE_CODES | |
| IMAGE_LIST | |
| INTER_FUND | |
| INVC_DETAIL | |
| INVC_HEADER | |
| INVC_TAX_MATRIX | |
| IQ_USER_OVERRIDE | |
| KITS_VIEW | |
| KIT_COMPONENTS | |
| KIT_STOCK | |
| LEASE_HEADER | |
| LIST_MASTER | |
| LOCATION | |
| LOT_CHARGE | |
| MANUALS | |
| MANUAL_PARTS | |
| MANUAL_STATUS | |
| MANUAL_TOOLS | |
| MANUAL_TYPE | |
| MANUFACTURER | |
| MH_PARTS | |
| MH_POLICIES | |
| MODEL | |
| MODEL_HIERARCHY | |
| MODEL_POLICIES | |
| MX_ACTION | |
| MX_DISCR | |
| MX_ERRORS | |
| MX_FAULT | |
| MX_HEADER | |
| MX_HEADER_ERRORS | |
| MX_LABOR | |
| MX_PARTS | |
| MX_STATUS | |
| MX_SYMPTOM | |
| OBJECT_ACCESS | |
| OPERATION_BOM | |
| OPERATION_MASTER | |
| OPERATION_REPAIR_TASKS | |
| OPERATION_TASKS | |
| ORDER_CLAUSES | |
| PARTS_CATALOG | |
| PARTS_MASTER | If ACTIVE_PART='F' then the part is inactive. IFC_AUTO_KEY in ILS_FLAG_CODES (IFC_AUTO_KEY=[4] links to Y in the ILS_FLAG_CODES table.) |
| PARTS_MASTER_VIEW | |
| PART_APPLICATION_CODES | |
| PART_CLAUSES | |
| PART_CONDITION_CODES | |
| PART_TAX_CAT | |
| PAYMENT_TYPE | |
| PBH_HISTORY | |
| PI_DETAIL | |
| PI_HEADER | |
| PI_STATUS | |
| PNM_BYDESCR_VIEW | |
| PNM_BYGROUP_VIEW | |
| PN_GROUPS | |
| PN_GROUP_VENDORS | |
| PN_TYPE_CODES | |
| POLICIES | |
| POSITION_GROUPS | |
| POSITION_REF | |
| PO_CATEGORY_CODES | |
| PO_DETAIL | |
| PO_HEADER | |
| PRE_EXPORT | |
| PRICES | |
| PROGRAM_EFF | |
| PROGRAM_MASTER | |
| PROJECT_ACTION | |
| PROJECT_AVL_PRIORITY | |
| PROJECT_AVL_STATUS | |
| PROJECT_AVL_TYPES | |
| PROJECT_CATEGORY | |
| PROJECT_DETAIL | |
| PROJECT_HEADER | |
| PROJECT_HISTORY | |
| PROJECT_LINKS | |
| PROJECT_MASTER | |
| PROJECT_PRIORITY | |
| PROJECT_STATUS | |
| PROJECT_TYPES | |
| PROJECT_USERS | |
| PR_DETAIL | |
| PR_HEADER | |
| PR_LEVELS | |
| PR_STATUS_HISTORY | |
| PURCHASE_SALES | |
| PURCHASE_WO | |
| QT_CATEGORY_CODES | |
| QUANTUM | |
| RB_FIELD | |
| RB_FOLDER | Contains List of folders in the Report Explorer (Forms Designer) |
| RB_ITEM | Contains the actual report files for Forms Designer |
| RB_JOIN | |
| RB_TABLE | |
| RC_CONTROL | |
| RC_DETAIL | |
| RC_DISP_CODES | |
| RC_HEADER | |
| RC_SERIAL | |
| RC_STATUS | |
| REPORT_IMAGES | |
| RMA_LOG | |
| RMA_STATUS | |
| ROLODEX | |
| RO_DETAIL | |
| RO_HEADER | |
| RO_PIECE_PARTS | |
| RR_DETAIL | |
| RR_HEADER | |
| SALESPERSON | |
| SECURITY_TEMPLATE | |
| SERIAL_EFF | |
| SERIAL_GROUP | |
| SERIAL_GROUP_NUMBERS | |
| SHIP_VIA_ACCOUNTS | |
| SHIP_VIA_CODES | |
| SM_BATCH | |
| SM_CONTROL | |
| SM_DETAIL | |
| SM_EMPL_STATUS | |
| SM_HEADER | |
| SM_STATUS | |
| SO_CATEGORY_CODES | |
| SO_DETAIL | |
| SO_HEADER | |
| SO_TAX_MATRIX | |
| STOCK | |
| STOCK_ADJUST | |
| STOCK_AUDIT | |
| STOCK_CATEGORY_CODES | |
| STOCK_RESERVATIONS | |
| STOCK_TI | |
| STOCK_TRANS | |
| SYS_COMPANIES | |
| SYS_CONFIG_GROUP | |
| SYS_FACTORY_SETTINGS | |
| SYS_FIND_OPTIONS | |
| SYS_NUMBER_LOG | |
| SYS_NUMBER_LOG_CODES | |
| SYS_QUERIES | |
| SYS_STYLES | |
| SYS_STYLE_SETTINGS | |
| SYS_SUBSYSTEM | |
| SYS_SYSTEM | |
| SYS_USERS | |
| SYS_USER_LAST_MESSAGE | |
| SYS_USER_MESSAGES | |
| SYS_USER_QUERIES | |
| SYS_USER_SETTINGS | |
| TASK_INSTRUCTIONS | |
| TASK_INST_IMAGES | |
| TASK_SKILLS | |
| TASK_TOOLS | |
| TAX_CATEGORIES | |
| TAX_MATRIX | |
| TAX_RATES | |
| TAX_TABLE | |
| TEMPLATE_CALLS | |
| TERM_CODES | Payment terms for companies. TMC_AUTO_KEY is a foreign key in several other tables, including INVC_HEADER. |
| TIMELIFE | |
| TI_REASON | |
| TPS_COST | |
| UDM_GROUPS | |
| UDM_ITEMS | |
| UDM_USERS | |
| UOM_CODES | |
| UOM_CONV | |
| USER_CACHE_REFRESH | |
| USER_FIELDS | |
| U_CLASS_FORMULA | |
| U_PERIODS | |
| U_SUMMARY_CONSUMABLE | |
| U_SUMMARY_EI_CONS | |
| U_SUMMARY_END_ITEM | |
| U_TOTAL_CONSUMABLE | |
| U_TOTAL_EI_CONS | |
| U_TOTAL_END_ITEM | |
| U_USAGE | |
| VQ_BATCH | |
| VQ_DETAIL | |
| VQ_HEADER | |
| VQ_LINE | |
| VQ_STATUS | |
| WAREHOUSE | |
| WAREHOUSE_LEVEL | |
| WC_DETAIL | |
| WC_HEADER | |
| WC_STATUS | |
| WC_STOCK_HIST | |
| WC_TYPE | |
| WC_TYPE_PARTS | |
| WC_VNDRECV_LINK | |
| WEB_CALLS | |
| WEB_SESSIONS | |
| WEB_TEMPLATE | |
| WEB_TEMPLATE_CALLS | |
| WEB_USERS | |
| WEB_USER_CALLS | |
| WO_ACTION | |
| WO_ACTION_LIST | |
| WO_AC_JOBS | |
| WO_BARCODE_LABOR | |
| WO_BOM | |
| WO_CHARGE | |
| WO_CONTROL | |
| WO_EMPL_SKILLS | |
| WO_EXCHANGE | |
| WO_FAULT | |
| WO_FAULT_LIST | |
| WO_MANUAL | |
| WO_NOTES_DEF | |
| WO_OPERATION | |
| WO_PART_TYPE | |
| WO_REPAIRS | |
| WO_REPAIR_VERSION | |
| WO_SKILLS | |
| WO_STATION | |
| WO_STATUS | |
| WO_STM_COMPLETE | |
| WO_SYMPTOM | |
| WO_SYMPTOM_LIST | |
| WO_TASK | |
| WO_TASK_INSTRUCTIONS | |
| WO_TASK_LABOR | |
| WO_TASK_MASTER | |
| WO_TASK_SKILLS | |
| WO_TASK_STATUS | |
| WO_TASK_TOOLS | |
| WO_TASK_TYPE | |
| WO_TAX_TABLE | |
| WO_VALID_PART_TYPES | |
| WO_VALID_REPAIRS | |
| WO_WORK_CENTER | |
| WO_WORK_TYPE | |
| WPS_OPERATION_BOM | |
| WPS_OPERATION_MASTER | |
| WPS_OPERATION_TASKS | |
| WPS_TASK_INSTRUCTIONS | |
| WPS_TASK_SKILLS | |
| WPS_TASK_TOOLS |