Command Import: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
*'''ACCT:''' GL Accounts | *'''ACCT:''' GL Accounts | ||
*'''ARTB:''' Aging | *'''ARTB:''' Aging | ||
*'''CCON:''' Contact Connection | *'''CCON:''' Contact Connection | ||
*'''COMP:''' Company | *'''COMP:''' Company | ||
| Line 22: | Line 22: | ||
*'''IPRC:''' Prices - by Level (Group) | *'''IPRC:''' Prices - by Level (Group) | ||
*'''LOCN:''' Locations (Similar to Plant) | *'''LOCN:''' Locations (Similar to Plant) | ||
*'''PLNT:''' Plant | *'''PLNT:''' Plant | ||
*'''PRCC:''' Price Group | *'''PRCC:''' Price Group | ||
*'''PRJP:''' Project Prices | *'''PRJP:''' Project Prices | ||
*'''PROJ:''' Project | *'''PROJ:''' Project | ||
Revision as of 16:38, 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
- 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