<< Click to Display Table of Contents >>
FILE NAMES
All files end in an extension *.B, or *.Bxx if you are using multiple companies. Knowing the file names is necessary if you will be customizing or writing new programs, adding fields to RTMs, or if you will be using outside report writers. You can get a printout of each file through UT-H Print File Layouts, which will list all the field names and their associated properties.
ACCOUNTS PAYABLE
BKAPCHKH AP PAYMENT HISTORY
BKSYAP AP DEFAULT MASTER
BKAPINVT AP INVOICE
MKICLASS AP INVOICE CROSS REFERENCE
ISAPPROJ AP LINK TO JOB
BKAPINVL AP VOUCHER
ISVNDADT APPROVED VENDOR CONTROL
ISAPAINT ARCHIVED AP INVOICES
ISAPAINL ARCHIVED AP VOUCHERS
ISAPACHK ARCHIVED CHECK HISTORY
BKAPADSC ARCHIVED DBA VENDOR & PO NOTES
ISAPAVND ARCHIVED VENDOR MASTER
BKAPCHKF PRO-FORMA CHECK REGITER
BKAPVEND VENDOR MASTER
BKAPVND2 VENDOR TAX ID
BKAPDESC VENDOR WEBSITE
BKAPRIVL VOUCHER TEMPLATE/RECURRING VOUCHER
ACCOUNTS RECEIVABLE
IS2DBAR 2 D BAR CODE PARAMETERS
BKART AGING TRANSACTION DETAIL
BKARTNOT AGING TRANSACTION NOTES
BKARINVT AR AGING INVOICE
MKECLASS AR CUSTOMER CHECK CROSS REFERENCE
BKSYAR AR DEFAULT MASTER
BKARINVV AR VOUCHER
ISISATAX ARCHIVE SALES TAX
ISARAIVV ARCHIVED AR VOUCHERS
ISARAINT ARCHIVED CUSTOMER INVOICES
ISARACST ARCHIVED CUSTOMER MASTER
ISARACHK ARCHIVED CUSTOMER PAYMENT HISTORY
ISARAHTX ARCHIVED SALES TAX
ISARAT ARCHIVED TRANSACTION DETAIL
ISARATNT ARCHIVED TRANSACTION NOTES
ISCC CREDIT CARD LISTING
CUSTCLAS CUSTOMER CLASS MASTER
BKARDEP CUSTOMER DEPOSITS
BKARCUST CUSTOMER MASTER
BKARCHKF CUSTOMER PAYMENT HISTORY
BKARDESC CUSTOMER WEBSITE
BKCMDUN DUN LETTER HEADER
BKCMDUNH DUN LETTER HISTORY
BKCMFORM FORM & DUN LETTER TEMPLATE
BKISHTAX PAID SALES TAX DETAIL
BKARHTAX SALES TAX
BKISTAX SALES TAX DETAIL
BKARSHIP SHIP TO CUSTOMER MASTER (NOT USED)
ISTAXFIL TAX CODES
ISTAXGRP TAX GROUPS
BILLS OF MATERIAL
BKSBMFG APPROVED MANUFACTURERS
BKSBPART APPROVED SUBSTITUTE PARTS
BKSBVEND APPROVED VENDORS
BKBMAMTR ARCHIVED BOM
BKBMMSTR BOM MASTER
BKBMNOTE BOM NOTES
BKBMREMK BOM REMARKS
BKBMSUMM TEMP FILE FOR SUMMARIZED BOM
BKBMAVAL TEMP FILE USED BY BOM AVAILABILITY REPORT
CONTACT MANAGER
BKCMACCC ACCOUNT CLASS CODES
BKCMACCL ACCOUNT CLASSES
BKCMACCN ACCOUNT CONTACTS
BKCMACTD ACCOUNT DATES
BKCMDTCD DATE CODES
BKCMCUST CONTACT ACCOUNT MASTER
BKCMLEAD LEAD SOURCE CODES
BKCMTERR TERRITORY MASTER
CONTRACT REVIEW
ISCTREVU CONTRACT REVIEW APPROVER LIST
ISSOREVU CONTRACT REVIEW STATUS
DATA COLLECTION
BKDCLAB POSTED DC LABOR TRANSACTIONS
BKDCSHFT DC SHIFTS
BKDCPLAB UNPOSTED DC LABOR TRANSACTIONS
DATA IMPORT
BKGLECOA DI CHART OF ACCOUNTS
WOEMAT DI MATERIAL ISSUES
WOERECV DI WO RECEIPTS
BKBMEMTR DI BOM MASTER
BKBMERMK DI BOM REMARKS
BKARECST DI CUSTOMER
BKGLETRN DI GL TRANSACTIONS
BKICEMTR DI INVENTORY
BKICELOC DI INVENTORY LOCATION
BKAPEIVT DI OPEN AP
BKAREIVT DI OPEN AR
BKRTEMTR DI ROUTINGS
BKAPEVND DI VENDOR
WOELABOR DI LABOR
MTICEMTR DI INVENTORY
EDI
BKEDIDUN CUSTOMER ID/EDI ENABLEMENT FILE
BKEDMSTR EDI MASTER SETUP FILE
BKEDNOTE EDI NOTES
BKEDPOST INVOICES SUBJECT TO EDI
BKEDIL TEMPORARY SO LINE ITEMS
BKEDIH TEMPORARY SO HEADERS
ESTIMATING
BKESTCFG ESTIMATING CONFIGURATION
BKMATCST MATERIAL COST FILE
ESTSUM ESTIMATE MASTER
MTEXCHG EXTRA CHARGES
FIXED ASSETS
ISFXASST FIXED ASSET MASTER
ISFXATRN FIXED ASSET TRANSACTIONS
FEATURES & OPTIONS
ISFOHIST CONFIGURATION HISTORY
ISFOBMRM CONFIGURATION LINE REMARKS
ISFOLINE CONFIGURATION LINES
ISFOORDL CONFIGURATION ORDER LINE CONVERSION
ISFOHEAD CONFIGURATON HEADER
BKFOCFG FEATURES & OPTIONS CONFIGURATION
GENERAL LEDGER
ISBANKS BANK MASTER
BKGLCOA CHART OF ACCOUNTS
ISGLCOA CHART OF ACCOUNTS 3-6 YR PAST
BKGLCHK CHECKING ACCOUNT REGISTER
BKGLCCOA CONSOLIDATED CHART OF ACCOUNTS
BKGLFCOA CONSOLIDATED FINANCIALS
BKGLFSTL CUSTOM FINANCIAL STATEMENTS
ISJBSF BUSINESS STATUS
BKGLSTMT FINANCIAL STATEMENT SETUP
ISGLDATE FISCAL PERIOD DATES
BKGLGJRN GENERAL JOURNAL HEADER
BKGLGJLN GENERAL JOURNAL LINE ITEMS
ISGLHDAT HISTORICAL FISCAL PERIOD DATES
BKGLTGJR JOURNAL TEMPLATE HEADER
BKGLTGJL JOURNAL TEMPLATE LINE
ISGLBDGT MULTI-YEAR BUDGET
ISGLNBGT NEXT YEAR BUDGET
BKGLTRAN POSTED GL TRANSACTIONS
BKGLRGJR RECURRING GENERAL JOURNAL HEADER
BKGLRGJL RECURRING GENERAL JOURNAL LINES
BKGLX TRANSACTION DETAIL
BKGLXH TRANSACTION DETAIL HISTORY
BKGLTEMP UNPOSTED GL TRANSACTIONS
INTERNATIONAL MODULE
ISBROKER CUSTOMS BROKER FEES
ISDUTY DUTY CODES
ISIS INTERNATIONAL MASTER SETTINGS
ISLANDF LANDED COST DEFAULTS
ISMCF MULTI-CURRENCY MASTER FILE
ISMCR CURRENCY CONVERSION FACTORS
INVENTORY
BKICAMTR ARCHIVE INVENTORY MASTER
ISICAMTR ARCHIVE INVENTORY MASTER FILE 3
INVATXN ARCHIVE INVENTORY TRANSACTIONS
MTICAMTR ARCHIVED INVENTORY MASTER 2
ISITMCFG AUTO PART GENERATOR
DBAFIFO FIFO, LIFO BUCKETS
BKACTRPT IN-L-O REPORT LAYOUT
BKICREF CUSTOMER CROSS-REFERENCE
BKQTTEMP INVENTORY LINKS
BKICLOCM INVENTORY LOCATION MASTER
BKICLOC INVENTORY LOCATIONS
BKICMSTR INVENTORY MASTER
MTICMSTR INVENTORY MASTER 2
ISICMSTR INVENTORY MASTER 3
ISICADT INVENTORY MASTER AUDIT FILE
ISMICADT INVENTORY MASTER AUDIT FILE 2
INVTXN INVENTORY TRANSACTIONS
ISUDFINV INVENTORY USER DEFINED DEFINITIONS
ISUDMSTR INVENTORY USER DEFINED MASTER LIST
ISCATMST ITEM CATEGORY MASTER LIST
CLASMSTR ITEM CLASS MASTER
CLASS ITEM CLASSES
ISECO ITEM ECO LISTING
ISITP ITP MASTER LISTING
ISORDECO ORDER SPECIFIC ECO
LOT CONTROL
LOT LOT NUMBER MASTER
MATERIAL REQUIREMENTS
MTMRP MATERIAL REQUIREMENTS (MRP) MASTER
SUMPNCUS MRP TEMP FILE
BKMRPPO MRP TO PO CONVERSION FILE (Temporary)
BKMRPSW TEMP FILE USED BY MRP
PAYROLL
BKPRCURP CURRENT PAYROLL INFORMATION (Temporary)
BKPRGLFL PAYROLL DIVISION MASTER
ISPRMSTR PAYROLL EMPLOYEE MASTER
BKPRHIST PAYROLL HISTORY
BKPRFTAX PAYROLL TAX TABLES
BKPRW2 PAYROLL W-2 FILE
BKPRINFO SUPPLEMENTAL EMPLOYEE MASTER
ISPRTEMP TEMP FILE FOR CONSOLIDATING PAYROLL DETAIL
BKPRTC TIME CARDS
BKCPMSTR CHECK MARK PAYROLL MASTER
BKCPEC CHECK MARK PAYROLL TRANSFER
PHYSICAL INVENTORY
BKPILCNT COUNTED LOTS
BKPISCNT COUNTED SERIAL NUMBERS
BKPIFROZ FROZEN PHYSICAL INVENTORY
BKPILOT FROZEN PI LOTS
BKPISER FROZEN SERIAL NUMBERS
BKPIMSTR PHYSICAL INVENTORY MASTER
PIBINLOC PI BIN LOCATION
PIBINLOT PI LOT BIN LOCATION
BKPIPHYS TAG FILE
PURCHASE ORDERS
ISARFQ ARCHIVE RFQ
ISAPHQT ARCHIVE VENDOR PRICING
BKAPAPO ARCHIVED PO HEADER
BKAPAPOL ARCHIVED PO LINES
ISAPARFQ ARCHIVED RFQ HEADER
ISAPARFL ARCHIVED RFQ LINE
ISAPCHG CHANGES TO PURCHASE ORDERS
BKAPPO OPEN PO HEADER
BKAPPOL OPEN PO LINES
ISDIGSIG PO DIGITAL SIGNATURE
BKAPHPO PO RECEIVER HEADER
BKAPHPOL PO RECEIVER LINES
ISPODESC PURCHASE ORDER DESCRIPTION LIST
BKQCMSTR QUALITY CONTROL MASTER
BKQCTRAN QUALITY CONTROL TRANSACTION
BKAPRFQ RFQ HEADER
BKAPRFQL RFQ LINES
BKSOPO TEMP FILE FOR CONVERT SO TO PO
BKWOPO TEMP FILE FOR CONVERT WO TO PO
BKAPQUOT VENDOR PRICING
BKRFQ VERBAL FOR QUOTES
ROUTINGS
ROUTAING ARCHIVED ROUTING MASTER
DPTMENT DEPARTMENTS
MACHINE MACHINES
BKRTCST ROUTING COSTS
ROUTING ROUTING MASTER
BKRTSPEC ROUTING SPECIFICATIONS
ROUTTEMP ROUTING TEMPLATES
BKRTTEMP SPECIFICATION TEMPLATES
TOOL TOOL MASTER
WORKCTR WORK CENTER
SALES ANALYSIS
BKSAREPT REPORT NAMES FOR SA-M & SA-N
SALES COMMISSIONS
BKPRAGNT AGENTS
BKPRACOM ARCHIVED COMMISSION DETAIL
ISARAIVI ARCHIVED COMMISSION DETAIL
BKARINVI COMMISSIONS
BKPRCOMM COMMISSIONS
ISREPORD EXTENDED COMMISSION LINE ITEM COMMISSIONS
ISREPLNK EXTENDED COMMISSION REP ASSIGNMENT
BKPRHCOM POSTED COMMISSION DETAIL
BKPRSALE SALESPERSON MASTER
SALES ORDERS
BKICAPMA ARCHIVE PRICE CODE
ISESTAQT ARCHIVE QUOTE HEADER
ISESTAQL ARCHIVE QUOTE LINES
ISARAINV ARCHIVED CLOSED SALES ORDER HEADERS
ISARAIVL ARCHIVED CLOSED SALES ORDER LINES
ISARADSC ARCHIVED CLOSED SALES ORDER NOTES
ISSOAHBX ARCHIVED INVOICE BOX ALLOCATION
ISARAHIN ARCHIVED INVOICE HEADERS
ISARAHIL ARCHIVED INVOICE LINES
ISSOALOT ARCHIVED INVOICE LOT CONTROL
ISARAHDS ARCHIVED INVOICE NOTES
ISSOASER ARCHIVED INVOICE SERIAL CONTROL
ISARATXN ARCHIVED LOT LINK TO INVOICE LINE
ISSRAINV ARCHIVED SALES ORDER HEADER
ISSRAIVL ARCHIVED SALES ORDER LINE
ISARATXS ARCHIVED SERIAL LINK TO INVOICE LINE
ISSOABOX ARCHIVED SHIPPING DETAIL
ISARTXNB BIN ALLOCATION TO SO LINE
ISARCHG CHANGES TO SALES ORDERS
DISCOUNT DISCOUNT TABLE MASTER
BKARHINV INVOICE HEADER
BKARHIVL INVOICE LINE
BKSOHLOT INVOICE LOT CONTROL
BKSOHSER INVOICE SERIAL CONTROL
BKSOLOCK LOCK FILE FOR SO INVOICE POSTING
ISARHCHG ON TIME DELIVERY
BKICPMAT PRICE MATRIX
BKARRINV RECURRING ORDER HEADER
BKARRIVL RECURRING ORDER LINE
BKSAREPT REPORT NAMES FOR SA-M & SA-N
BKSONOTE SALES ORDER ASSIGNED TEMPLATES
ISORDDSC SALES ORDER DESCRIPTION LIST
BKARINV SALES ORDER HEADER
BKARINVL SALES ORDER LINES
ISSOINFO SALES ORDER SUPPLEMENTAL INFO
BKESTQT SALES QUOTATION HEADER
BKESTQTL SALES QUOTATION LINE ITEMS
ISSOHBOX SHIPPED BOX ID
ISSOBOX SHIPPING DETAIL
ISQTINFO SUPPLEMENTAL QUOTE INFO
ISQSOA TEMP FILE FOR QUICK SO ENTRY
INVETXN TEMP FILE FOR UNPOSTED INVENTORY TRANSACTIONS
BKARTXN UNPOSTED LOT ALLOCATION TO ORDER LINES
BKARTXNS UNPOSTED SERIAL ALLOCATION TO ORDER LINES
SCHEDULING
BUCKETS FINITE SCHEDULE BUCKETS
SCHWO FINITE SCHEDULING TEMP FILE
WCCTL FINITE SCHEDULING TEMP FILE
SCHEDCAL SCHEDULING SHOP CALENDAR
CALENDAR SHOP CALENDAR
WCTRSLOD TEMP WORK CENTER LOAD % FOR VISUAL SCHEDULER
WORKSORD TEMP WORK ORDER HEADER FOR VISUAL SCHEDULER
WOSROUT TEMP WORK ORDER ROUTING FOR VISUAL SCHEDULER
SERIAL CONTROL
SERIALH ARCHIVED SERIAL NUMBERS
ISSERCNT SERIAL NUMBER GENERATION MASTER
SERIAL SERIAL NUMBER MASTER
SYSTEM MANAGER
ISLOG ACTIVE USER LIST
ISCHAINM AUTO CHAIN PROGRAM MASTER
ISCHAIN AUTO CHAIN PROGRAMS
ISNUMBER DOCUMENT COUNTERS
ISLINKS LINKS
ISNTYPE NOTE TYPES
ISNOTES NOTES
ISREMIND REMINDERS
ISJOB JOB MASTER LISTING
ISSCHED LIST OF PROGRAMS TO RUN BY EVO SCHEDULER
ISDLCK2 LOCK FILE FOR MASTER DEFAULT PROGRAM
ISDLCK1 LOCK FILE FOR NEXT NUMBER PROGRAM
ISDRILLM MASTER DRILL DOWN FILE
ISEREM NOTIFICATIONS
ISTERMS PAYMENT TERMS
DBAHLPID PROGRAM SPECIFIC HELP REFERENCE
ISSHIPCO SHIP VIA COMPANY
ISSHPVIA SHIP VIA LISTING
BKSYMSTR SYSTEM DEFAULT MASTER FILE
BKYSMSTR SYSTEM DEFAULT MASTER FILE 2
MKAHIST SYSTEM DEFAULT MASTER FILE 3
CALTEMP TEMP FILE FOR GENERATING SHOP CALENDAR
LANGDICT TRANSLATION MASTER
ISTRIGRS TRIGGERS
WORK ORDERS
WOROUTMP AGGREGATE WO ROUTINGS (Temporary)
BKDCHLAB ARCHIVED DC LABOR TRANSACTIONS
MTEXCHG EXTRA CHARGES
WOLABOR LABOR TRANSACTIONS
WOHLABOR LABOR TRANSACTIONS - ARCHIVE
ISMACS MACHINE SCHEDULE
WOMAT MATERIAL TRANSACTIONS
WOHMAT MATERIAL TRANSACTIONS - ARCHIVE
OUTPROC OUTSIDE PROCESSING TRANSACTIONS
OUTHPROC OUTSIDE PROCESSING TRANSACTIONS - ARCHIVE
ISWOTRAY PAPERLESS BATCH TRACKING
ISLSMAP PAPERLESS SHOP FLOOR BATCH TRACKER
ISQCMTHD PAPERLESS SHOP FLOOR TEST METHODS
ISQCSPEC PAPERLESS SHOP FLOOR TEST REQUIREMENTS
ISQCRSLT PAPERLESS SHOP FLOOR TEST RESULTS
BKDCLAB POSTED DC LABOR TRANSACTIONS
QCCODES QC CODES
SCRAP SCRAP CODES
BKSHORT TEMP FILE FOR SHORTAGE REPROT
BKDCPLAB UNPOSTED DC LABOR TRANSACTIONS
WOBOMREM WO BILL OF MATERIAL REMARKS
WOBOMHRM WO BILL OF MATERIAL REMARKS - ARCHIVE
WCTRLOAD WORK CENTER LOAD %
WORKCTR WORK CENTERS
WOBOM WORK ORDER BILL OF MATERIAL
WOHBOM WORK ORDER BILL OF MATERIAL - ARCHIVE
WODATE WORK ORDER DATES
WOHDATE WORK ORDER DATES - ARCHIVE
WOEXCHG WORK ORDER EXTRA CHARGES
WOHEXCHG WORK ORDER EXTRA CHARGES - ARCHIVE
WORKORD WORK ORDER HEADER
WORKHORD WORK ORDER HEADER - ARCHIVE
ISWOEX WORK ORDER HEADER 2
ISWOPRIO WORK ORDER PRIORITY MASTER
WORECV WORK ORDER RECEIPTS
WOHRECV WORK ORDER RECEIPTS - ARCHIVE
WOROUT WORK ORDER ROUTING
WOHROUT WORK ORDER ROUTING - ARCHIVE
ISWOROEX WORK ORDER ROUTING ADJUNCT FILE