HITS P.O.S. Tables

Database Table	Name	Description
CINVOICE	Invoices & ROA Headers	Sales invoices and ROA headers
CCUSTOME	Customers	Customer master table
CVENDOR	Vendor	Vendor master table
CINV_DET	Invoice Detail	Invoice details (line itmes)
XINVOICE	Receiving Ticket Headers	Receiving Ticket (Receipts, Returns, POs, Adjustments, Transfers)
XINV_DET	Receiving Detail	Receiving ticker details (line items)
CINVNTOR	Inventory Master	Inventory master file
CINVNCHD	Inventory Child	Stores quantities and tax status, by location
CINVLDG2	Inventory Ledger	Ins & Outs of all inventory items
CONTACTS	Contacts	Contacts (phone, email, and other) linked to customers
CTAG	Vehicles	Vehicles linked to customers
CPRICING	EPP Rules	EPP (Enhanced Profile Pricing) rules
SPRICINX	Manufacturer and Style	Manufacturer and style information including name, type, rebates, and URL
CLASS_CO	Class Code	Inventory class codes

 

---

 

HITS Digital Tables

Database Table	Name	Description
Header	Header	Invoice header data
Detail	Detail	Invoice detail (line items)
Receipt_Header	Receipt Header	Receiving header data (Receipts, Returns, POs, Adjustments, Transfers)
Receipt_Detail	Receiving Detail	Receiving detail (line item) data (Receipts, Returns, POs, Adjustments, Transfers)
ROA	ROA Header	ROA header data
Payments	Payments	Payment data for both invoices and ROAs
EOD	End Of Day	Daily closing data, by store