Data File Listing
Data File Listing
The Files below are used by the Report Generator and for mail merging information to PDF and MS Word documents. An attribute listing for each file can be run from the System Administration, Utilities, Execute D3 Commands, then select the ATTR command.
Accounts Payable
| APH | Closed Invoices (Index) |
| API | All Entered Invoices |
| APR | Recurring Invoice Templates |
| APS | Invoice Payment Schedule |
| APT | Accounts Payable Transactions |
| APU | Unposted Invoices (Index) |
| APX | Posted Invoices (Index) |
| BR | Bank Reconciliation File |
| CK | Checks |
| CKL | Check Layouts |
| CKX | Checks Cross Reference (Index) |
| FI | Financial Institutions |
| VC | Vendor Category Codes |
| VM | Vendor Master File |
| VMH | Vendor History |
| VMX | Vendor Cross Reference |
Accounts Receivable
| AD | Accounts Receivable Adjustments (Q-pointed to CR, AD) |
| AH | Accounts Receivable History (Q-pointed to AX, AH) |
| AT | Accounts Receivable Transactions |
| AX | Accounts Receivable Cross Reference |
| BC | Boat Charges (Open items in Charges Edit) |
| BH | Boat Charges History (Q-pointed to BC, BH) |
| CR | Cash Receipts |
| DS | Deposit Slips (Cash Receipts Header) |
| IS | Invoice Summary (Sales Tax Reporting) |
| STS | Sales Tax Summary |
File Maintenance
| BM | Customer Boat File |
| BX | Boat Cross Reference |
| CF | Class* Sub File |
| CF | BAB* Boat Description Codes |
| CF | BIL* Billing Codes |
| CF | PMT* Payment Terms |
| CF | PTP* Pay Types |
| CF | TAX* Special Tax Codes |
| CF | CCD* Cost Codes |
| CF | CGC* Customer Categories |
| CF | PRF* Price Factors |
| CF | ADJ* Adjustment Codes |
| CF | LOC* Location Codes |
| CL | Clerk / Salesperson |
| CM | Customer Master |
| CX | Customer Cross Reference |
| DP | Departments |
| FQ | Form Queues |
| PD | Printer Drivers |
| PW | Passwords |
| ST | States |
| TXS | Tax Schemas |
| TXC | Tax Codes |
| TXG | Tax Groups |
| TXCC | Tax Code Categories |
| TXCL | Tax Code Levels |
| ZC | Postal Codes |
General Ledger
| Budget.Spread | Budget Spread Codes |
| CO.Table | Companies |
| CC.Table | Cost Centers |
| EXP.Table | Detail Accounts |
| GLA | GL Activity |
| GLS | Chart Of Accounts |
| JA | Journal Audit |
| JT | Journal Transactions |
| JBF | Journal Transaction Batches |
Inventory Management
| FH | Fuel Inventory History |
| FL | Fuel Inventory Master |
| IA | Inventory Adjustments |
| IH | Inventory History |
| IL | Inventory Load Codes (Vendors) |
| IM | Inventory Master |
| IT | Inventory Transfers |
| IU | Inventory Usage |
| IX | Inventory Cross Reference |
| PO | Purchase Orders |
| RM | Receivers |
| RP | Recommended Purchase Orders |
| SA | Sales Analysis |
| SI | Order Entry Sales Tickets (6.2.x and below) |
| SM | Shipping Methods |
| SO | Special Orders |
| SOR | Sales Orders (6.2.x and below) |
| SORX | Sales Orders Cross Reference |
| SOX | Special Order Cross Reference |
| TK | Tune-Up Kits |
| VR | Vendor Returns |
Point Of Sale
| FU | Fuel Usage |
| POS | Tickets (7.x and above) |
| POSBF | Batches (7.x and above) |
| POSH | History (7.x and above) |
| POSLS | Lost Sales (7.x and above) |
| POSQ | Closeout Lists (7.x and above) |
| POSR | Register Numbers (7.x and above) |
| POSX | Cross Reference (7.x and above) |
| SA | Sales Analysis (6.2.x and below) |
| SQ | Closeout Lists (6.2.x and below) |
| SI | Sales Invoices (6.2.x and below) |
| SIX | Invoice Cross Reference (6.2.x and below) |
| SS | Sales Tickets (5.x and below) |
| SSX | Saved Tickets Cross Reference (5.x and below) |
Marina Management
| BC | Boat Charges |
| BCS | Billing Charge Schedule (Deferred Schedule Items) |
| BH | Boat Charges History (Q-pointed to BC, BH) |
| HLC | Launch Calendar |
| HLS | Launch Schedule |
| HLM | Launch Monitor |
| HLX | Launch Cross Reference |
| LC | Slip Location Codes |
| LCA | Location Availability (Reservations) |
| LCX | Location Cross Reference |
| LH | Location History |
| LMO | Launch Operations |
| RS | Reservations |
| RX | Reservations Cross Reference |
| SC | Storage Contracts |
| WL | Wait Lists |
| WLX | Wait Lists Cross Reference |
Sales Management
| BF | Bundles |
| BMI | Boat Models |
| BMX | Boat Models Cross Reference |
| BPO | Boat Purchase Orders |
| BPOX | Boat Purchase Orders Cross Reference |
| BRM | Boat Receivers |
| BSC | Boat Sales Contracts |
| BSCX | Boat Sales Contracts Cross Reference |
| BSI | Boat Serialized Inventory |
| BSX | Boat Serialized Inventory Cross Reference |
| CD | Accident & Health Insurance Codes |
| CI | Credit/Level Life Insurance Codes |
| CLC | Class Codes |
| COC | Color Codes |
| FP | Floorplan |
| LOF | Layout File |
| MMI | Motor Models |
| MMX | Motor Models Cross Reference |
| MSI | Motor Serialized Inventory |
| MSX | Motor Serialized Inventory Cross Reference |
| MT | Model Type Codes |
| PRF | Price Formula Codes |
| PS | Prospects |
| TMI | Trailer Models |
| TMX | Trailer Models Cross Reference |
| TSI | Trailer Serialized Inventory |
| TSX | Trailer Serialized Cross Reference |
| VW | Extended Warranty Codes |
Service Management
| AWX | All Work Orders Cross Reference |
| DM.REPORTS | Reports File |
| HWD | Historical Work Order Detail |
| HWH | Historical Work Order Headers |
| HWO | Historical Work Order Operations |
| HWX | Historical Work Order Cross Reference |
| OC | Operation Codes |
| OCC | Operation Code Categories |
| OWX | Open Work Order Cross Reference |
| OX | Operation Codes Cross Reference |
| SFC | Shop Floor Calendar (5.x and below) |
| SFH | Shop Floor History (5.x and below) |
| SP | Sublet Purchase Orders |
| SSF | Shop Floor Schedule (5.x and below) |
| STC | Skill Type Codes |
| TC | Time Cards |
| TCS | Suspended Time Cards |
| TM | Technician Master |
| TMF | Tool Master File |
| TSF | Shop Floor Technician Schedule |
| TTTL | Tool Transaction Log |
| TX | Technician Cross Reference |
| VAT | Warranty Invoice Cross Reference |
| VW | Vendor Warranty Sales |
| WED | Estimate Detail |
| WEH | Estimate Headers |
| WEO | Estimate Operations |
| WEX | Estimate Cross Reference |
| WFD | Warranty Form Detail |
| WFH | Warranty Form Header |
| WFX | Warranty Cross Reference |
| WOC | Work Order Categories |
| WOL | Layout File (Invoices, Requests, Cards) |
| WOD | Work Order Detail |
| WOH | Work Order Header |
| WOO | Work Order Operations |
| WOS | Work Order Schedule |
| WOT | Work Order Transfers |
| WSD | Work Orders Scheduled By Date |
| WST | Work Orders Scheduled By Technician |
| WTD | Template Detail |
| WTH | Template Header |
| WTO | Template Operations |
| WO.WP | Work Order Word Processing |
Obsolete Areas
The areas and files list below are no longer active in the current version of DockMaster. Your account may have historical data in these files that have not been purged. if you need assistance in accessing the information for reporting purposes please contact support for assistance,
Payroll
| BANK.CODES | Bank Codes (Financial Institutions) |
| CHECKS.FILE | Payroll Checks |
| CHECK.RECON.FILE | Reconciled Checks |
| DEDUCTION.CODES | Deduction Codes |
| EARNING.CODES | Earning Codes |
| EMPLOYEE.FILE | Employee Information |
| PCKL | Payroll Check Layouts |
| TIME.CARDS | Non-Posted Time Cards |
| TIME.CARD.HISTORY | Posted Time Cards |
| W2 | Employee W2's |