Examples by Table

• GL Accounts (ACCT)

• ARTB: Aging

AR may or may not come from Command system. This needs to be researched.

• CCON: Contact Connection
• COMP: Company
• CPRD: Customer Prices
• CTCT: Contact

Customer

• CUST: Customer

State needs to be mapped... <pre) CASE REPLACE(UPPER(TRIM(ADDR_STATE)),' ',)

  WHEN 'NEBRASK' THEN 'NE'
  WHEN 'NEWYORK' THEN 'NY'
  WHEN 'NEWJERSEY' THEN 'NJ'
  ...
  WHEN 'PENNSYLVAN' THEN 'PA'
  WHEN 'SOUTHCARO' THEN 'SC'
  WHEN 'TENNESSEE' THEN 'TN'
ELSE SUBSTR(UPPER(TRIM(ADDR_STATE)),1,2) END STATE,

• 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

with sac (clsno,descr) as
	(
	select 
	case ltrim(rtrim(sales_anl_code)) 
	when 'NSF' THEN 'NS'
	when 'CNA' THEN 'CN'
	when 'C27' THEN '27'
	when 'C29' THEN '29'
	when 'C34' THEN '34'
	when 'C53' THEN '53'
	else ltrim(rtrim(sales_anl_code))  end
	"class_no",
	ltrim(rtrim(descr)) description
	from sanl
	)
select  
concat('
INSERT INTO artcucls
( CLASS_NO, DESCRIPTION, IMPORTED_FLAG, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG )  VALUES 
( ''',clsno,''',''',left(descr,35),''', ''Y'', CAST(''TODAY'' AS TIMESTAMP), ''HIT'', ''Y''    );
'),
ltrim(rtrim(clsno)) "class_no",
ltrim(rtrim(descr)) description,  * 
from sac

• 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