</span

--- title: "'Slimstock file definitions'" slug: "slimstock-file-definitions" description: "'Slimstock file definitions'" tags: ["check-ai", "QA599"] updated: 2024-06-07T12:18:48Z published: 2024-06-07T12:18:48Z canonical: "docs.retailvista.net/slimstock-file-definitions" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.retailvista.net/llms.txt > Use this file to discover all available pages before exploring further. # 'Slimstock file definitions' ## </spanSales - All sales (both cash and on account) are exported in batches (csv files) of up to 50,000 records and the transaction date exported is always the last 7 days for each export. | 1 | Transaction Number | Starts with CS or IS for cash or on account respectively, followed by transaction number | | --- | --- | --- | | 2 | Sale type code | Sales type code | | 3 | Sale type description | Sales type description | | 4 | Transaction status | Completed or Active, 'Completed' when the delivery is invoiced for on account sales, 'Completed' for cash sales | | 5 | Warehouse | From location, followed by a hyphen | | 6 | Product number | Product number or external code (*2) | | 7 | Transaction issue date | Transaction date | | 8 | | | | 9 | | | | 10 | Transaction issue quantity | Quantity | | 11 | Transaction line number | Primary key of line (note: can overlap with same primary key for cash sales and invoice sales) | | 12 | | | | 13 | | | | 14 | Transaction customer number | Customer number (*3) | | 15 | Transaction customer type | Customer type description | | 16 | Transaction customer name | Customer name | | 17 | Transaction sale price | Transaction net weighted unit price | | 18 | | | | 19 | Transaction supplier number | Supplier number | | 20 | | | | 21 | Transaction supplier name | Supplier name | | 22 | Transaction issue quantity | Purchase price per unit excluding VAT | | 1 | File ID | 9 | | 2 | Year | yyyy | | 3 | Month | mm | | 4 | Week | Current week number (*1) | | 5 | Warehouse | From location, followed by a hyphen | | 6 | Product number | Article number or external code (*2) | | 7 | Confirmed order number | Sales order number | | 8 | Confirmed order required date | Sales order expected delivery date, if not specified, system date will be used | | 9 | Still to received quantity | Remaining quantity to be delivered | | 10 | | | | 11 | Confirmed order type | Sales order classification description | | 12 | Customer details | Customer name | | 13 | | | | 14 | Confirmed order comments | Sales order reference | | 15 | Original order quantity | Sales order line quantity ordered | | 16 | Supplied quantity | Sales order line quantity ordered - outstanding (=delivered quantity) | | 17 | | | | 18 | | | | 19 | | | | 20 | | | | 21 | | | | 22 | | | | 1 | File ID | 8 | | 2 | Year | yyyy | | 3 | Month | mm | | 4 | Week | Current week number (*1) | | 5 | Warehouse | From location, followed by a hyphen | | 6 | Product Code | Article number or external article code (*2) | | 7 | Purchase order number | Purchase order number | | 8 | Purchase order expected arrival date | Expected delivery date from purchase order line. If empty, the print date (shipping date) of the purchase order will be used | | 9 | Purchase order open quantity | Remaining number of pieces to be received from purchase order line | | 10 | Purchase order supplier details | Supplier name | | 11 | Confirmed order type | | | 12 | Purchase order original quantity | Number of pieces ordered | | 13 | Purchase order supplier quantity | Field 12 - field 9 | | 14 | Free text 1 | Purchase order reference code | | 15 | Free text 2 | Article order code | | 16 | Free number 1 | Purchase order number (=field 7) | | 17 | Free number 2 | Total net price of product | | 18 | | | | 19 | | | | 20 | | | | 1 | File ID | 3 | | 2 | Year | yyyy | | 3 | Month | mm | | 4 | Week | Current week number (*1) | | 5 | Warehouse | From location, followed by a hyphen | | 6 | Product Code | Product number or external product code (*2) | | 7 | Stock on hand | Available stock. If <0 then export 0 | | 8 | | | | 9 | | | | 10 | | | | 11 | | | | 12 | | | | 13 | | | | 14 | | | | 15 | | | | 16 | | | | 17 | | | | 18 | | | | 19 | | | | 20 | | | | 21 | | | | 22 | Criterium 1 | Average FIFO purchase price per product | | 23 | | | | 24 | | | | 25 | | | | 26 | | | | 27 | | | | 28 | | | | 29 | | | | 30 | | | | 31 | | | | 32 | Product Description | Product description | | 33 | Lead time | Standard delivery days from purchase or if empty then standard delivery days from supplier | | 34 | | | | 35 | | | | 36 | Run code | Round((day of the month/7)+0.5) | | 37 | Supplier number | Supplier number | | 38 | Supplier name | Supplier name | | 39 | MOQ Minimum order quantity | Minimum order quantity | | 40 | IOQ Incremental Order Quantity | Minimum order quantity (otherwise it would be a field that RetailVista does not have, namely subsequent order quantity) | | 41 | | | | 42 | Unit price | Purchase price per unit of product, formatted to 4 decimals | | 43 | Sales price | Selling price of product (if store price is empty, default selling price is used) | | 44 | Analysis code 1 | Product category code | | 45 | Analysis code 2 | Product category description | | 46 | Analysis code 3 (Available for web) | "Y" | | 47 | Analysis code 4 | Order code | | 48 | Analysis code 5 | Purchase status description | | 49 | Analysis code 6 | Purchase assortment (from Assortment indication) | | 50 | Price per | Quantity per purchase price | | 51 | Stocked item | =Analysis code 6 | | 52 | | | | 53 | User defined 2 | Expected stock date supplier | | 54 | | | | 55 | | | | 56 | Supplier stock | Supplier stock | | 57 | | | | 58 | | | | 59 | | | | 60 | | | | 61 | | | | 62 | | | | 63 | | | | 64 | | | | 65 | | | | 66 | | | | 67 | | | | 68 | | | | 69 | | | | 70 | | | | 71 | | | | 72 | | | | 73 | | | | 74 | | | | 75 | | | | 76 | | | | 77 | | | | | | | | | | | | 1 | Product code | Article number or external article code (*2) | | 2 | Amount | The number of SKUs to order (Must not be less than or equal to 0) | | 1 | Warehouse code | Warehouse code, must match warehouse code from location, tab Slimstock | | 2 | Product code | Article number or external article code (*2) | | 3 | Product Description | Article description, completely ignored | | 4 | Minimum stock | Minimum stock | | 5 | Maximum stock | Maximum inventory | | 6 | Min/max Yes/No | | | 7 | Fixed Minimum stock | Minimum inventory limitation | | | | | | | | | | | | |