Command Import: Difference between revisions
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 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