The following is a complete list of the primary files available in the Advanced Report Writer dictionary. Consider reviewing the Common ARW dictionary files first.
Primary File |
Definition |
Data & Examples |
See also |
---|---|---|---|
AP |
Accounts Payable Invoices |
Open and paid invoices. Can be used for vendor balances, credit reports, freight amounts, etc. |
Enter vendor invoices |
AP.RECURRING |
Recurring Accounts Payable Invoices |
Similar to AP file, but limited to recurring invoice templates. |
|
BANK.DETAIL |
Bank Ledger & Bank Reconciliation |
Bank account balances and transactions. |
Reconcile your bank statement |
BILLING |
Open Billing Batch - On Account |
Orders that are part of the Invoicing batch (In Billing) before they are posted. This is for On Account orders only (Sales>Invoicing>Invoicing). Consider using POS for the Point of Sale batch. |
Review and bill invoices |
BIN.AUDITS |
Bin Location Audits (RF WMS) |
The Audit trail on Bin Locations. This is for Wireless Warehouse only. |
|
BINS |
Product Bin Location List |
List of Bin Locations (File>Product> Bin Locations). |
Specify bin locations for a product |
BRANCH |
Company Branch Listing |
List of information set in Branch setup (File>Company>Branch). |
Configure company branch sites |
BUY.LINE |
Product Buy Line Listing |
Listing of Buy Lines (File>Product>Buy Lines). |
Set up product buy lines |
CADF |
General Ledger Chart of Accounts |
Listing of G/L Accounts (Accounting>General Ledger>G/L Accounts). |
Maintain your general ledger accounts |
CASH-RECT |
Cash Receipts Current Transactions |
Customer payment data from Cash Receipts Posting. This is the open batch only, not payments that have already been posted. |
Reconcile daily cash receipts |
CASH-RECT-HIST |
Cash Receipts Historical Transactions |
Customer payment data from Cash Receipts Posting. This is posted payments only, not the open batch. Data is stored by the payment, and can list the invoices paid. Alternatively, consider using PAID.OI which is stored by the paid invoice (and can list the payment applied). |
Reconcile daily cash receipts |
CHECKS |
Accounts Payable Checks |
Vendor payment data from Check Print. This is posted checks only, not the open batch. Most commonly used for Disbursement Reports and Positive Pay style reports. |
Print checks |
CONTACTS |
Customer & Vendor Contact Information |
Contains both Customer and Vendor Contact data, specifically from the Contacts tab. Can also be used for eCommerce web permissions (except web passwords which are encrypted). |
Manage customer contacts |
CONTACTS.UDF |
Custom UDF (User Defined Fields) for Contacts |
Is visible if custom fields have been added to Contacts. Start the report from CONTACTS and then link to this file. |
Work with custom fields |
CONTAINER |
Container Management |
Header information for open and received Containers (Purchasing>Container Management). |
|
CPSH |
Customer Price Sales History (Order Pad) |
Includes recent sales history and is where the Customer Order Pad and Due To Buy data is derived from. This can be used for Reorder Forms or reviewing Last Sale information, but should not be used for detailed sales history. |
View customer price history on the customer order pad |
CREDIT.REF |
Customer Credit References |
List of Credit References from the Customer Master. |
Add customer credit references |
CUST.AR |
Open Accounts Receivable - Summary |
Summary Accounts Receivable information (such as open balances), and can be used for an AR Aging style report. For a detailed AR Aging (which includes invoices) consider using OPEN-ITEMS file. |
Accounts receivable reconciliation |
CUST.CATEGORY |
Customer Category Listing |
Listing of Customer Categories (File>Customer>Category). |
Categorize customers by business or pricing |
CUST.PAYRCPTS |
Fast Receipt |
Fast Receipt transactions (Sales>Order>Fast Receipt). |
Generate a fast receipt for counter payment |
CUST.PN.XREF |
Customer Part Number |
Customer Part Numbers as set on the Part Numbers tab of both the Customer and Product Master. |
Assign customer part numbers by product |
CUST.PO |
Customer PO Numbers - (Sales Orders) |
Contains Customer PO Numbers used on Sales Orders. Alternatively, consider using the OH file. |
Create a sales order Create a point of sale (POS) order |
CUST.PO.CONTROL |
Customer PO Dollar Limits |
PO Dollar Limit amounts as set in P/O Specs tab of the Customer Master. |
Configure spending limits for purchase orders by customer |
CUST.PROD.CONSIGN |
Customer Consignment Inventory |
Product inventory stored in Customer Consignment Warehouses (File>Company>Warehouse). |
Set up a customer consignment warehouse |
CUST.PROD.MINS |
Ship To Stock Levels |
The Stock Levels set on a Ship To from the Customer Master. Most commonly used for QuickOrder reports that list min and max stock quantities (for the customer/ship to). |
Configure minimum and maximum stock levels per ship to |
CUST.TAX.MATRIX |
Customer Tax Matrix |
List of Tax Matrices as set on the Tax Matrix tab of the Customer Master | Work with customer tax matrices |
CUSTOMER |
Customer Master |
List of information set in Customer Master (File>Customer>Master). Additionally includes monthly and YTD sales figures along with open AR balances. |
Add a customer |
CUSTOMER.SOURCE |
Customer Source Code Listing |
Listing of Customer Source Codes (File>Customer>Source). |
Add a customer to a source |
CUSTOMER.UDF |
Custom UDF (User Defined Fields) for Customers |
Is visible if custom fields have been added to Customers. Start the report from CUSTOMER and then link to this file. |
View and apply customer custom fields |
CYCLE.GROUP |
Product Cycle Count Group Listing |
Listing of Cycle Count Groups (File>Product>Cycle Count Group). |
Set up manual cycle count groups |
DAILY.REC.REP |
Purchase Order Stock Receipts |
Received Purchase Orders including detail such as products and pricing. Recommended for purchase history style reports that identify what was purchased from vendors. |
|
DIVISION |
Company Division Listing |
Listing of Division information (File>Company>Division). |
Manage company divisions |
DOT.CODE |
Product Hazardous Material - DOT Listing |
Listing of HazMat information (File>Product>Hazardous Material - DOT). |
Set up hazardous material classifications |
GL.BUDGET |
General Ledger Budget |
Budgeted amounts for each fiscal month/year as set in G/L Budget (Accounting>General Ledger>G/L Budget). |
Use financial budgets |
GL.GROUP |
General Ledger Group List |
List of G/L Group information (from Accounting>General Ledger>G/L Group). |
General ledger control table |
GLB |
General Ledger Opening Balances |
Opening balances for G/L accounts by fiscal period. |
Create a monthly G/L balance report |
GLD |
General Ledger Transaction Detail |
Contains transaction information and is where the General Ledger derives data from. This can be used to list the transactions (system postings) for specified accounts but does not contain balance information (and therefore should not be used for financial reports such as a balance sheet). |
Get started with the general ledger |
INV.ADJ |
Inventory Adjustments |
Inventory adjustment transactions, including updates made from Inventory Adjustment and Physical Inventory | Inventory Adjustment report |
INVENTORY |
Inventory (Product Analysis) |
Inventory related data typically found on the Product Analysis such as Rank, Committed, On Hand, On PO, etc. Additionally can be used for Sales and Demand information (by product). Optionally filter by warehouse. Recommended to start with PRODUCT file and link to INVENTORY. |
Analyze product information |
INVOICE |
Customer Invoices |
Invoice information including product detail and order amounts. Most commonly used for Sales reports such as Detailed Sales Journal and Who Bought What Reports. This should not be used for AR Aging reports (consider CUST.AR or OPEN-ITEMS instead). Additionally, it should not be used for payment against invoices (consider CASH-RECT-HIST or PAID.OI). |
View customer invoice and payment history |
INVOICE.FAX.RESULTS |
Sent Invoice Results |
The status of faxed and emailed customer invoices sent out as a batch. Consider linking to INVOICE for additional data fields. |
Sent Invoice Results report |
JOB |
Customer Job Listing |
Listing of Job information (File>Customer>Job). |
Create jobs to group sales and purchase orders |
JS.PRODUCT.EXCLUDE |
Excluded Products (Johnstone) |
Indicates which fields from Products are excluded from the Johnstone Corporate nightly transmission (from Johnstone>Corporate Field Updates>Product Fields Update). | |
MAJOR.BUY.LINE |
Product Major Buy Line Listing |
List of Major Buy Line information (File>Product>Major Buy Line). |
Work with major buy lines |
MAJOR.GROUP |
Product Major Group Listing |
List of Major Group information (File>Product>Major Group). |
Work with major product groups |
MARGIN.CAP |
Price Margin Cap Listing |
Listing of Price Margin Cap information (Sales>Pricing>Price Margin Cap). |
Set price margin caps |
MISC.CHRG |
Company Miscellaneous Charge Code Listing |
Listing of Miscellaneous Charge Code information (File>Company>Miscellaneous Charge). |
Set up miscellaneous charges |
OD |
Sales Order Detail |
The Detail tab of Sales Order. This includes products, quantities, and pricing. Recommended to start with OH file and link to OD. |
Create a sales order |
OH |
Sales Order Header |
The Header and Final tab of Sales Order. This includes customer, ship date, salesperson, and total amounts. Most commonly used for Open Sales Order reports (such as open backorders, drop shipments, etc). Can be used for completed orders as well, however it is recommended to use INVOICE file instead. |
Create a sales order |
OPEN-ITEMS |
Open Accounts Receivable Invoices - Detail |
Can be used for an AR Aging style report. Includes invoice data such as discount amounts, due date, and ship to. For a simpler summary AR Aging (balances only) consider using CUST.AR file. |
Run an A/R Aging report |
ORDER.TYPE |
Company Order Type Listing |
Listing of Order Types (File>Company>Order Type). |
Manage order types |
PAID.OI |
Paid Accounts Receivable Invoices |
Can be used to track payment history. Data is stored by the invoice, and can list the payments applied. Alternatively, consider using CASH-RECT-HIST which is stored by the payment (and can list the paid invoices). |
View customer invoice and payment history |
PHYSICAL |
Physical Inventory |
Information from the "frozen" warehouse while performing a Physical Inventory count (Inventory>Physical Inventory). To track the results of a physical count (after it has bee updated) consider using INV.ADJ. |
Run physical inventory |
PO |
Purchase Order (Header & Detail) |
Open and completed Purchase Orders including both the order header information and product detail. Most commonly used for Open Purchase Order reports. To track purchase history, consider using DAILY.REC.REP (Stock Receipts). |
|
POS |
Open Billing Batch - POS |
Orders that are part of the Point of Sale batch (In Billing) before they are posted. This is for Point of Sale orders only (Sales>Order>Point of Sale). Consider using BILLING for the On Account batch. |
Create a point of sale (POS) order |
PRD-SLS-HIST |
Product Sales History - Summary |
Provides analytical data on product sales such as YTD and variance amounts. Can not be filtered by warehouse. Consider using INVENTORY as an alternative. |
Customer Sales History report |
PRICE.CONTRACT |
Price Contract - Header |
Header information from the Main tab of Price Contract (Sales>Pricing>Price Contract). Consider using PRICE.MATRIX to obtain detailed products, prices, and costs. |
Create a price contract to group customer pricing |
PRICE.GROUP |
Product Price Group Listing |
Listing of Price Groups (File>Product>Price Group). |
Set up price groups |
PRICE.MATRIX |
Price Matrix |
Pricing formulas and net amounts, as set in the Price Matrix (Sales>Pricing>Price Matrix). This also includes Price Contract information. |
Create a price formula in the matrix |
PRICE.ROLLUP |
Price Rollup Schedule |
Pricing rollup formulas for Price Groups and/or Product Lines (Sales>Pricing>Price Rollup Schedule). |
Set a price roll-up schedule |
PROD.LINE |
Product Line Listing |
Listing of Product Lines (File>Product>Product Line). |
Set up product lines |
PROD.POINTER |
Product Pointer |
Open orders or transfers for products. Most commonly used for inquiry style reports that list all pending transactions for a product (by listing all open transfers and orders that contain the product). |
Review open sales orders for a product |
PRODUCT |
Product Master |
Listing of information set in Product Master (File>Product>Master). Additionally includes common inventory fields such as OnHand. Recommended to link to INVENTORY file for additional fields. |
Create and edit products |
PRODUCT.OPTS |
Product Options & Accessories Listing |
List of Options & Accessories (File>Product>Options and Accessories). |
Create option and accessory product groups |
PRODUCT.UDF |
Custom UDF (User Defined Fields) for Products |
Is visible if custom fields have been added to Products. Start the report from PRODUCT and then link to this file. |
View and apply product custom fields |
PURCH.MATRIX |
Purchasing Matrix |
Pricing formulas and net amounts, as set in the Purchasing Matrix (Purchasing>Purchasing Matrix). |
|
RW.Reports | Report List | List of all reports in ARW. | ARW Report Library |
SALESMAN |
Customer Salesman List |
List of Salespeople (File>Customer>Salesman), including current month and YTD sales figures. |
Manage your salespeople |
SHIP.VIA |
Company Ship Via Listing |
Listing of Ship Via's (File>Company>Ship Via). |
Create and configure Ship Via options |
SHIPTO |
Customer Ship To Location Listing |
Listing of Ship To locations as set in the Customer Master. Recommended to link to this file when building sales reports to obtain relevant Ship To information (such as name or address). |
Set up customer Ship To locations |
SHIPTO.UDF |
Custom UDF (User Defined Fields) for Ship To's |
Is visible if custom fields have been added to Ship To. Start the report from SHIPTO and then link to this file. |
Work with custom fields |
SPODHDR |
Proof of Delivery Signature Data |
The date, time, and name of the person who electronically signed for an order (from signature pads and ePod devices). Consider linking this to the OH file to filter on specific orders or truck routes. |
Capturing a proof of delivery scan |
STO |
Stock Transfer |
Open and completed Stock Transfers including both the transfer header information and product detail. Most commonly used for Open Stock Transfer reports. |
Inventory Adjustment report |
TAX |
Customer Tax Code Listing |
Listing of Tax Code's (File>Customer>Tax). |
Create tax codes |
TERMS |
Customer Terms Code Listing |
Listing of Accounts Receivable Terms (File>Customer>Terms). |
Set up customer payment terms |
TERMS-AP |
Vendor Terms Code Listing |
Listing of Accounts Payable Terms (File>Vendor>Terms). |
Set up vendor accounts payable terms |
TERRITORY |
Customer Territory Code Listing |
Listing of Territories (File>Customer>Territory). |
Manage sales territories |
TRUCK |
Company Truck Code Listing |
Listing of Trucks (File>Company>Truck). |
Manage trucks |
TRUCK.SCHED |
Truck Manifest |
Sales orders that are routed to delivery trucks, visible in the Truck Manifest. This can be used to build an open delivery report. Consider linking to OH and OD files for additional order details. Alternatively, use the OH file instead (and filter on truck scheduled orders). |
Route trucks and print a manifest |
UOM |
Product Unit of Measure Listing |
List of Units of Measure (File>Product>Unit of Measure). |
Add units of measure |
USER.EVENT |
Calendar Events & Tasks |
Tasks and events that appear on the Calendar. Typically used for CRM Activity reports or A/R Note listings. |
View and create activities |
VM |
Vendor Master |
List of information set in Vendor Master (File>Vendor>Master). Additionally includes YTD payment and purchasing figures. |
Add a vendor |
VM.CATEGORY |
Vendor Category Code Listing |
List of Vendor Categories (File>Vendor>Category). |
Categorize vendors by business or product line |
VM.SOURCE |
Vendor Source Code Listing |
List of Vendor Source Codes (File>Vendor>Source). |
Add a vendor to a source |
VM.UDF |
Custom UDF (User Defined Fields) for Vendors |
Is visible if custom fields have been added to Vendors. Start the report from VM and then link to this file. |
View and apply vendor custom fields |
WARRANTY.CLAIM |
Warranty Claim List |
Open and completed claims including product details (Inventory>Warranty>Create/Receive Warranty Claim). |
Create a warranty claim |
WARRANTY.TAGS |
Warranty Tag List |
Contains Warranty Tag information including the product and sales order number the tag is linked to. (Inventory>Warranty>Entered Warranty Tag) |
Review, edit, and print warranty tags |
WEB.CAT |
Product Web Category Code List |
List of Web Categories (File>Product>Web Category). |
Categorize the catalog |
WHSE.BUY.ZONE |
Company Warehouse Buy Zone Listing |
Listing of Warehouse Buy Zones (File>Company>Warehouse Buy Zone). |
Group warehouses by buy zone |