product field names ------------------- CN carrier number customerID customer ID productID product ID or article number productName product name productDesc product description (see table productDesc for descriptions in other languages) categoryID a product group or category imgUrl the URL of a product image productUrl the URL of a product description page userID user ID who created the product status the status of the product remarks internal remarks on the product color field names ----------------- colorID color ID or color number colorDesc description of the color colorQtyPerPackUnit quantity of this color per packing unit colorImgUrl the URL of a product image size field names ---------------- sizeID size ID or size number sizeDesc description of the size sizeQtyPerPackUnit quantity of this size per packing unit sizeImgUrl the URL of a product image pricing field names ------------------- currency currency code price the price of the product qLimit quantity limit for price price2 price up to tLimit2 qLimit2 quantity limit for price2 price3 price up to tLimit3 qLimit3 quantity limit for price3 price4 price up to tLimit4 qLimit4 quantity limit for price4 price5 price up to tLimit5 VATtype VAT type (determines percentage from param) billingType oneoff,recurring,voluntary,transaction term term (period) in months prePaid Y = prePaid, N = postPaid renewalEmailDays days before renewalDate to automatically warn the customer renewalEmailPerc percentage before tMax transactions to automatically warn the customer renewalEmail e-mail text to send to warn the customer terminationEmail e-mail text to send to tell the customer the contract was terminated clemencyDays number of days to automatically extend a renewalDate, suggested value: 7 clemencyPerc percentage to automatically extend tMax, suggested value: 10. packing field names ------------------- packUnitID packing unit (piece, bundle, box, pallet..) qtyPerPackUnit quantity per packing unit sale field names ---------------- sColorID color ID or color number sSizeID size ID or size number sBatchID batch ID or batch number sQtyOrdered total quantity ordered by customers sQtyShipped total quantity shipped to customers sQtyBackOrder total quantity on backorder by customers inventory field names --------------------- iWarehouseID warehouse ID or code iLocationID location ID or code of location in warehouse iColorID color ID or color number iSizeID size ID or size number iBatchID batch ID or batch number iPackUnit packing unit iQtyInStock total packing units in stock purchase field names -------------------- pColorID color ID or color number pSizeID size ID or size number pBatchID batch ID or batch number pSuplProductRef supplier product reference or product ID pSuplColorRef supplier color reference or color ID pSuplSizeRef supplier size reference or size ID pSuplPackUnit supplier packing unit pSuplQtyPerPackUnit number of packing units per supplier packing unit pQtyPurchased total quantity purchased pQtyReceived total quantiry received pQtyOnBackOrder total quantiry on backorder