Command Import: Difference between revisions

From KeystoneIntranet
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:


Here are some samples used in the past...
Here are some samples used in the past...
:[[Examples by Table]]
:[[Command Import: Hedger Work Notes]]
:[[Command Import: Hedger Work Notes]]
:[[Command Import: Rain MO Work Notes]]
:[[Command Import: Rain MO Work Notes]]





Revision as of 22:27, 18 February 2024

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