SELECT AR_Customer.CustomerNo,
	AR_Customer.ARDivisionNo,
	AR_Customer.CustomerName,
	AR_Customer.AddressLine1,
	AR_Customer.AddressLine2,
	AR_Customer.AddressLine3,
	AR_Customer.City,
	AR_Customer.State,
	AR_Customer.ZipCode,
	AR_Customer.CountryCode,
	AR_Customer.TelephoneNo,
	AR_Customer.TelephoneExt,
	AR_Customer.FaxNo,
	AR_Customer.EmailAddress,
	AR_Customer.SalespersonNo,
	AR_Customer.AgingCategory1,
	AR_Customer.AgingCategory2,
	AR_Customer.AgingCategory3,
	AR_Customer.AgingCategory4,
	AR_Customer.CreditLimit,
	AR_Customer.CustomerDiscountRate,
	AR_Customer.CurrentBalance,
	SO_ShipToAddress.ShipToAddress1,
	SO_ShipToAddress.ShipToAddress2,
	SO_ShipToAddress.ShipToAddress3,
	SO_ShipToAddress.ShipToCode
FROM { OJ AR_Customer AR_Customer
JOIN SO_ShipToAddress ON SO_ShipToAddress.CustomerNo=AR_Customer.CustomerNo};
Customers.csv;

SELECT CI_Item.ItemCode,
	CI_Item.ItemType,
	CI_Item.ItemCodeDesc,
	CI_Item.InactiveItem,
	CI_Item.SalesUnitOfMeasure,
	CI_Item.TaxClass,
	CI_Item.ProductType,
	CI_Item.DefaultWarehouseCode,
	CI_Item.StandardUnitPrice,
	CI_Item.SalesPromotionPrice,
	CI_Item.SalesPromotionCode,
	CI_Item.SaleStartingDate,
	CI_Item.StandardUnitCost,
	CI_Item.SaleEndingDate,
	CI_Item.SalesPromotionDiscountPercent,
	CI_Item.SuggestedRetailPrice,
	CI_Item.TaxClass,
	CI_Item.UseInSO,
CI_Item.ImageFile,
CI_Item.StandardUnitCost,
CI_Item.AverageUnitCost,
CI_Item.ProductLine,
CI_Item.ProductType,
IM_ProductLine.ProductLineDesc
FROM { IT CI_Item CI_Item
JOIN IM_ProductLine ON CI_Item.ProductLine = IM_ProductLine.ProductLine };
Products.csv;


SELECT  AR_InvoiceHistoryDetail.InvoiceNo,
	AR_InvoiceHistoryDetail.ItemCode,
	AR_InvoiceHistoryDetail.ItemCodeDesc,
	AR_InvoiceHistoryDetail.UnitPrice,
	AR_InvoiceHistoryDetail.LineDiscountPercent,
	AR_InvoiceHistoryDetail.AppliedCustomerPONo,
	AR_InvoiceHistoryDetail.OrderWarehouse,
	AR_InvoiceHistoryDetail.QuantityShipped,
	AR_InvoiceHistoryHeader.CustomerNo,
	AR_InvoiceHistoryHeader.CostOfSalesAmt,
	AR_InvoiceHistoryHeader.InvoiceDate
FROM { OJ AR_InvoiceHistoryDetail AR_InvoiceHistoryDetail
JOIN AR_InvoiceHistoryHeader ON AR_InvoiceHistoryDetail.InvoiceNo = AR_InvoiceHistoryHeader.InvoiceNo }
WHERE AR_InvoiceHistoryHeader.InvoiceDate > { d '2023-01-01' };
Invoices.csv;

SELECT IM_ItemWarehouse.ItemCode,
	IM_ItemWarehouse.WarehouseCode,
	IM_ItemWarehouse.BinLocation,
	IM_ItemWarehouse.QuantityOnHand,
	IM_ItemWarehouse.QuantityOnSalesOrder,
	
	IM_Warehouse.WarehouseDesc
FROM { OJ IM_ItemWarehouse IM_ItemWarehouse
JOIN IM_Warehouse ON IM_ItemWarehouse.WarehouseCode = IM_Warehouse.WarehouseCode };
Stocklevels.csv;

SELECT * FROM AR_Salesperson;
Users.csv;

SELECT * FROM AR_CustomerPricingWrk;
CustomerPricing.csv;

SELECT * FROM IM_PriceCode;
PriceBracketPricing.csv;

SELECT * FROM IM_PriceListWrk;
PriceList.csv