|
Your accounting software includes Customers (Accounts
Receivable) and Items (Inventory). We export this data
into the Handheld Management System (HMS). Information
not available in your accounting software is maintained
in HMS. This information includes route information,
messages, invoice formats, location codes, item brand,
item category, item package size, special pricing and
forced items.
| Table |
Description |
| Customer |
Customer Master |
| Contacts |
Customer Point of Contact |
| DEX/UCS |
EDI with retail account |
| National
Account |
Parent Company Direct Billing |
| On Account |
A/R Balance Forward |
| Outstanding
Invoice |
Invoice that must be paid before
sale |
| Inventory
Location |
Locations within retail account |
| Liquor
License |
ABC licensed account requirement |
| Route Book |
Active items sold, facings,
Order/Delivery quantity |
| Item |
Item (Product) Master |
| Brand |
Brand Name of Product (ex:
Coors, Dreyers, Pepsi |
| Category |
Type of Product, Premium/Super
Premium |
| Package |
Package Size (ex: 4/6/12 cans) |
| Barcode
Type |
UPC, EAN |
| Unit of
Measure |
Case, Each, Pallet, |
| Item
Pricing Group |
Group Discounting |
| Alternate
Print Item |
Customer Item Code replacing
default item code |
| Assembly |
Sell group of items with one
item code |
| Asset/Asset
Rental |
Equipment rented or loaned to
customers |
| Authorized
Item |
Items authorized or not
authorized to be sold to customer |
| CRV/ADF |
California Redemption
Value/Florida Advance Deposit |
| Item Group |
Items grouped for authorization |
| National
Item Group |
Items grouped to be sold on
national invoice |
| Linked
Empty Item |
Carrier or shell sold or
deposited with sold item |
| Linked
Usage Overage |
Consumption contracts linked to
overage quantity |
|