Command Import

From KeystoneIntranet
Revision as of 22:27, 18 February 2024 by Chanson (talk | contribs)
Jump to navigation Jump to search

There is not ONE way to import Command Data - each situation is unique.

Here are some samples used in the past...

Examples by Table
Command Import: Hedger Work Notes
Command Import: Rain MO Work Notes


Command Tables:

  • ACCT: GL Accounts
  • ARTB: Aging
  • CCON: Contact Connection
  • COMP: Company
  • CPRD: Customer Prices
  • CTCT: Contact
  • CUST: Customer Prices
  • EMPL: Employee - Sales and Drivers
  • ICAT: Item (Product)
  • ICST: Component Structure
  • ILOC: Product by Location (Similar to Plant)
  • IMST: Products
  • IPRC: Prices - by Level (Group)
  • LOCN: Locations (Similar to Plant)
  • PLNT: Plant
  • PRCC: Price Group
  • PRJP: Project Prices
  • PROJ: Project
  • SANL: Customer Class
  • TAXC: Tax (Similar to Keystone Tax Auth)
  • TAXJ: Tax Structure
  • TAXL: Tax Locality (not 1 to 1 with Keystone)
  • TRMS: Terms
  • TRUC: Trucks
  • UOMS: Unit of Meausure
  • USGE: Useage