Command Import: Difference between revisions

From KeystoneIntranet
Jump to navigation Jump to search
No edit summary
No edit summary
Line 4: Line 4:
:[[Command Import: Hedger Work Notes]]
:[[Command Import: Hedger Work Notes]]
:[[Command Import: Rain MO Work Notes]]
:[[Command Import: Rain MO Work Notes]]
Command Tables:
*'''ACCT:''' GL  Accounts
*'''ARTB:''' Aging - Ifr from CMD
*'''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 no change
*'''PRCC:''' Price Group – no change
*'''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

Revision as of 16:37, 9 January 2024

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

Here are some samples used in the past...

Command Import: Hedger Work Notes
Command Import: Rain MO Work Notes


Command Tables:

  • ACCT: GL Accounts
  • ARTB: Aging - Ifr from CMD
  • 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 no change
  • PRCC: Price Group – no change
  • 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