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 pricing field names (standard pricing, actual orders may differ from this) ------------------- currency currency code price the price of the product priceTable name of a pricing table VATtype VAT type (determines percentage from param) billingType oneoff,recurring,voluntary,transaction period term (period) in months prePaid Y = prePaid, N = postPaid renewalEmail e-mail text or template to warn the customer for a renewal terminationEmail e-mail text or template to tell the customer the contract was terminated renewalDays days before renewalDate to send renewalEmail renewalPerc percentage before tMax transactions to send renewalEmail clemencyDays 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 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 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