Contents - Index - Previous - Next

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, 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
BKAPCHKF  UNPOSTED AP CHECKS (Temporary)
BKAPCHKH  AP CHECK HISTORY
BKAPINVL  AP VOUCHERS
BKAPINVT  AP TRANSACTIONS
BKAPVEND  VENDOR MASTER
BKAPVND2  VENDOR TAX ID
BKAPRIVL  AP RECURRING VOUCHERS
ISAPACHK  ARCHIVED CHECK HISTORY
ISAPAINL  ARCHIVED AP VOUCHERS
ISAPAINT  ARCHIVED AP INVOICES
ISAPAVND  ARCHIVED VENDOR MASTER
ISAPPROJ  AP LINK TO JOB
MKICLASS  AP INVOICE CROSS REFERENCE
ACCOUNTS RECEIVABLE
BKARCHKF  CUSTOMER PAYMENT HISTORY
BKARCUST  CUSTOMER MASTER
BKARDEP  CUSTOMER DEPOSITS
BKARINVT  AR TRANSACTIONS
BKARINVV  AR VOUCHERS
BKART  AR TRANSACTION DETAIL
BKARTNOT  AR TRANSACTION NOTES
ISARACHK  ARCHIVED CUSTOMER PAYMENT HISTORY
ISARACST  ARCHIVED CUSTOMER MASTER
ISARAINT  ARCHIVED CUSTOMER INVOICES
ISARAT  ARCHIVED TRANSACTION DETAIL
ISARATNT  ARCHIVED TRANSACTION NOTES 
MKECLASS  AR CUSTOMER CHECK CROSS REFERENCE
BILLS OF MATERIAL
BKBMDIM  BOM COMPONENT DIMENSIONS
BKBMMSTR  BILL OF MATERIAL MASTER
BKBMNOTE  BILL OF MATERIAL NOTES
BKBMREMK  BILL OF MATERIAL REMARKS
BKSBMFG  APPROVED MANUFACTURERS
BKSBPART  APPROVED SUBSTITUTE PARTS
BKSBVEND  APPROVED VENDORS
CONTACT MANAGER
BKCMACCC  ACCOUNT CLASS CODES
BKCMACCL  ACCOUNT CLASSES
BKCMACCN  ACCOUNT CONTACTS
BKCMACCT  ACCOUNT MASTER
BKCMACFC  ACCOUNT FOLLOW-UP CODES
BKCMACTD  ACCOUNT DATES
BKCMACTF  ACCOUNT FOLLOW-UPS
BKCMACTH  ACCOUNT HISTORY
BKCMCNTD  CONTACT MANAGER DEFAULTS
BKCMDTCD  DATE CODES
BKCMEACC  ACCOUNT CLASSES EXPORT FILE
BKCMEACD  ACCOUNT DATES EXPORT FILE
BKCMEACF  ACCOUNT FOLLOW-UPS EXPORT FILE
BKCMEACH  ACCOUNT HISTORY EXPORT FILE
BKCMEACT  ACCOUNT MASTER EXPORT FILE
BKCMFTME  NO CHARGE TIME 
BKCMHCOD  HISTORY CODES
BKCMHCD2  HISTORY CODES, 2ND DATABASE
BKCMLEAD  LEAD SOURCE CODES
BKCMMHST  MAILING HISTORY
BKCMPCNT  PERSONAL CONTACT MASTER
BKCMPCTF  PERSONAL CONTACT FOLLOW-UPS
BKCMPCTH  PERSONAL CONTACT HISTORY
BKCMREP  REP MASTER
BKCMTERR  TERRITORY MASTER
BKCMVNDF  VENDOR FOLLOW-UPS
BKCMVNDH  VENDOR HISTORY
BKCMVNFC  VENDOR FOLLOW-UP CODES
DATA COLLECTION
BKDCLAB  POSTED DC LABOR TRANSACTIONS
BKDCSHFT  DC SHIFTS
BKDCPLAB  UNPOSTED DC LABOR TRANSACTIONS
BKDCTLAB  TEMPORARY DC LABOR TRANSACTIONS  
DATA IMPORT
BKAPEVND  DI VENDOR MASTER
BKARECST  DI CUSTOMER MASTER
BKBMEMTR  DI BILL OF MATERIAL MASTER
BKGLECOA  DI CHART OF ACCOUNTS
BKICELOC  DI INVENTORY LOCATIONS
BKICEMTR  DI INVENTORY MASTER ?ACCOUNTING
BKRTEMTR  DI ROUTINGS 
MTICEMTR  DI INVENTORY MASTER ?MANUFACTURING
WOEMAT  DI MATERIAL ISSUES
WOERECV  DI WO RECEIPTS
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
FEATURES & OPTIONS
BKFOCFG  FEATURES & OPTIONS CONFIGURATION
ISFOHEAD  CONGIGURATON HEADER
ISFOLINE  CONFIGURATION LINES
ISFOBMRM  CONFIGURATION LINE REMARKS
ISFOHIST  CONFIGURATION HISTORY
GENERAL LEDGER
BKGLCCOA  CONSOLIDATED CHART OF ACCOUNTS (Temporary)
BKGLCHK  CHECKING ACCOUNT REGISTER
BKGLCOA  CHART OF ACCOUNTS
BKGLFCOA  CONSOLIDATED FINANCIALS 
BKGLFSTL  CUSTOM FINANCIAL STATEMENTS 
BKGLGJLN  GENERAL JOURNAL LINE ITEMS
BKGLGJRN  GENERAL JOURNAL HEADER
BKGLRGJL  RECURRING GENERAL JOURNAL LINES
BKGLRGJR  RECURRING GENERAL JOURNAL HEADER
BKGLSTMT  FINANCIAL STATEMENT SETUP
BKGLTEMP  UNPOSTED GL TRANSACTIONS
BKGLTRAN  POSTED 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
BKICDIM  INVENTORY DIMENSIONS
BKICLOC  INVENTORY LOCATIONS
BKICLOCM  INVENTORY LOCATION MASTER
BKICMSTR  INVENTORY MASTER ACCOUNTING
BKICPMAT  PRICE MATRIX
BKICREF  INVENTORY CROSS-REFERENCE
DBAFIFO  FIFO, LIFO BUCKETS
DISCOUNT  DISCOUNT TABLE MASTER
INVTXN  INVENTORY TRANSACTIONS
MTICMSTR  INVENTORY MASTER MANUFACTURING
ISICMSTR  INVENTORY MASTER 3
ISICADT  INVENTORY MASTER AUDIT FILE
ISMICADT  INVENTORY MASTER AUDIT FILE 2
LOT CONTROL
LOT   LOT NUMBER MASTER
MATERIAL REQUIREMENTS
BKMRPFC  FORECASTS
BKMRPPO  MRP TO PO CONVERSION FILE (Temporary)
MTMRP  MATERIAL REQUIREMENTS (MRP) MASTER
DBA PAYROLL 
BKPRCURP  CURRENT PAYROLL INFORMATION (Temporary)
BKPRFTAX  PAYROLL TAX TABLES
BKPRGLFL  PAYROLL DEFAULTS
BKPRHIST  PAYROLL HISTORY
BKPRINFO  SUPPLEMENTAL EMPLOYEE MASTER
BKPRMSTR  JOB COST EMPLOYEE MASTER
BKPRTC  TIME CARDS
BKPRW2  PAYROLL W-2 FILE
ISPRMSTR  PAYROLL EMPLOYEE MASTER
PHYSICAL INVENTORY
BKPIFROZ   FROZEN INVENTORY
BKPILCNT  COUNTED LOTS
BKPILOT   FROZEN LOTS
BKPIMSTR   MASTER PI LISTING
BKPIPHYS  TAG FILE
BKPISCNT  COUNTED SERIAL NUMBERS
BKPISER  FROZEN SERIAL NUMBERS
PURCHASE ORDERS
BKAPAPO  ARCHIVED PURCHASE ORDER HEADER
BKAPADSC  ARCHIVED PO NOTES
BKAPAPOL  ARCHIVED PO LINES

BKAPDESC  PURCHASE ORDER NOTES
BKAPHPO  PO RECEIPTS ?HEADER
BKAPHPOL  PO RECEIPTS - LINE ITEMS
BKAPPO  OPEN PURCHASE ORDER HEADER
BKAPPOL  OPEN PURCHASE ORDER LINE ITEMS
BKAPQUOT  VENDOR PRICES
BKAPRFQ  RFQ HEADER
BKAPRFQL  RFQ LINE ITEMS
BKQCMSTR  QUALITY CONTROL MASTER
BKQCTRAN  QUALITY CONTROL TRANSACTION
BKRFQ  VERBAL FOR QUOTES
BKRFQDES  RFQ NOTES
ISAPCHG  CHANGES TO PURCHASE ORDERS

ROUTINGS
BKRTCST  ROUTING COSTS
BKRTSPEC  ROUTING SPECIFICATIONS
BKRTTEMP  SPECIFICATION TEMPLATES
DPTMENT  DEPARTMENTS
MACHINE  MACHINES
QCCODES  QC CODES
ROUTING  ROUTING MASTER
ROUTTEMP  ROUTING TEMPLATES
SCRAP   SCRAP CODES
TOOL   TOOLS
WORKCTR  WORK CENTERS
SALES ANALYSIS
BKSAREPT  REPORT NAMES FOR SA-M & SA-N
SALES COMMISSIONS
BKPRAGNT  AGENTS
BKPRCOMM  COMMISSIONS
BKPRSALE  SALESPERSON MASTER
SALES ORDERS
BKARDESC  SALES ORDER NOTES
BKARHDSC  POSTED INVOICE NOTES
BKARHINV  INVOICE HISTORY ?HEADER
BKARHIVL  INVOICE HISTORY - LINE ITEMS
BKARINV  SALES ORDER HEADER
BKARINVI  SALES ORDER COMMISSIONS (Temporary)
BKARINVL  SALES ORDER LINE ITEMS
BKARRINV  RECURRING INVOICES ?HEADER
BKARRIVL  RECURRING INVOICES - LINE ITEMS
BKARTXN  SO LOT CONTROL (Temporary)
BKARTXNS  SO SERIAL CONTROL (Temporary)
BKESTQT  SALES QUOTATION HEADER
BKESTQTL  SALES QUOTATION LINE ITEMS
BKSOHLOT  INVOICE LOT CONTROL
BKSOHSER  INVOICE SERIAL CONTROL
BKSONOTE  SALES ORDER ASSIGNED TEMPLATES
ISARAINV  ARCHIVED CLOSED SALES ORDER HEADERS
ISARAIVL  ARCHIVED CLOSED SALES ORDER LINES
ISARADSC  ARCHIVED CLOSED SALES ORDER NOTES
ISARAHIN  ARCHIVED INVOICE HEADERS
ISARAHIL  ARCHIVED INVOICE LINES
ISARAHDS  ARCHIVED INVOICE NOTES
ISSOALOT  ARCHIVED INVOICE LOT CONTROL
ISSOASER  ARCHIVED INVOICE SERIAL CONTROL 
ISARCHG  CHANGES TO SALES ORDERS
ISARHCHG  ON TIME DELIVERY
ISSOABOX  ARCHIVED SHIPPING DETAIL
ISSOBOX  SHIPPING DETAIL
NOTETEMP  SALES ORDER NOTE TEMPLATES
SERIAL CONTROL
SERIAL  SERIAL NUMBER MASTER
SYSTEM MANAGER
BKSYMSTR  SYSTEM MASTER FILE
BKYSMSTR  SYSTEM MASTER FILE 2
CALENDAR  SHOP CALENDAR
CLASMSTR  ITEM CLASS MASTER
CLASS  ITEM CLASSES
ISTAXFIL  TAX CODES
ISTAXGRP  TAX GROUPS
MKAHIST  SYSTEM MASTER FILE 3
ISNUMBER  DOCUMENT COUNTERS
WORK ORDERS
OUTPROC  OUTSIDE PROCESSING TRANSACTIONS
OUTHPROC  OUTSIDE PROCESSING TRANSACTIONS - ARCHIVE
WOBOM  WORK ORDER BILL OF MATERIAL
WOBOMHRM  WO BILL OF MATERIAL REMARKS - ARCHIVE
WOBOMREM  WO BILL OF MATERIAL REMARKS
WODATE  WORK ORDER DATES
WOEXCHG  WORK ORDER EXTRA CHARGES
WOHBOM  WORK ORDER BILL OF MATERIAL - ARCHIVE
WOHDATE  WORK ORDER DATES - ARCHIVE
WOHEXCHG  WORK ORDER EXTRA CHARGES - ARCHIVE
WOHLABOR  LABOR TRANSACTIONS - ARCHIVE
WOHMAT  MATERIAL TRANSACTIONS - ARCHIVE
WOHRECV  WORK ORDER RECEIPTS - ARCHIVE
WOHROUT  WORK ORDER ROUTING - ARCHIVE
WOLABOR  LABOR TRANSACTIONS
WOMAT  MATERIAL TRANSACTIONS
WORECV  WORK ORDER RECEIPTS
WORKORD  WORK ORDER HEADER
WORKHORD  WORK ORDER HEADER - ARCHIVE
WOROUT  WORK ORDER ROUTING
WOROUTMP  AGGREGATE WO ROUTINGS (Temporary)