Examples by Table

• 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

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
</per>
*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