Complete list of ARW dictionary files – DDI System

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 Manage vendor engagement with contact analysis
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 Assign product part numbers by customer
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

Menu

Related articles