Field Types
Data Type | Data Code | Description | Example Data |
|---|---|---|---|
Alpha | A | Alpha Only, no numeric allowed at all, must only be characters. | BLUE |
Alpha Numeric Also known as | AN | Stores alphanumeric combinations and text. No symbols or other characters allowed with some basic exceptions which are dot,comma, colon, ampersand. | Bytesize 1234 |
String | ST | String is really a group of characters stored together as one it can contain numbers, letters and symbols. | Hello World ! [2023] |
Bit | B | Boolean data types are very straightforward. A Boolean data type is simply something that only has two possible values, true or false. The computer will store true as a 1 and false as a 0. | Y or N 0 or 1 |
Character | CH | Stores a single character which can be a letter, number or symbol | £ |
Currency | CU | Same as decimal but to 2dp is required | 17.01 |
Date | DT | dd/mm/yy or dd/mm/yyyy | 18/05/18 |
Decimal | DC | Stores numbers that contain decimal places/values and can also store integers known as REAL, SINGLE, DOUBLE or FLOAT instead. | 17.65665 |
EMl | Should be standard email format containing the @ | ||
Integer | IN | Stores positive or negative whole numbers | 17 |
Numeric | N | Numbers only, including phone numbers | 01324 722663 |
Time | TM | hh:mm | 11:00 |
Goods Outwards
These are charges which are made after goods have left, there are multiple methods to charge for goods outwards
Charge Type | Explanantion |
Orders Processed | A charge for each order |
Order Lines Processed | A Charge for the number of lines on an order |
Cases Ordered | Based on the number of cases ordered by the customer at the order time |
Cases Picked | Based on the number of cases picked during the picking process |
Singles Ordered | Based on what was physically ordered by the customer Do not use this if the customer is ONLY ordering their stock in single items unless you want to charge for everything. |
Singles Picked | Based on what was physically picked during the picking pricess. |
Order Charge | A charge for a particular type of order. This is generally used to charge a paperwork charge for each order, and generally used when customs paperwork is required for the order |
All charges above can have different rates for EDI or Manual orders
At customer import time you can specify whether a customers VCIS orders are considered as EDI or Manual for charging purposes. Please note that if you receive an EDI order and it is wrong and you have to edit it then you will be asked to confirm whether charging should revert back to manual charging.
Field Name | Field Type | Mandatory Or Default to | Explanation |
Customer | char(8) | YES | Customer Code |
OrdersEDI | decimal (18,5) | 0.00 | |
OrdersMan | decimal (18,5) | 0.00 | |
OrderLinesEDI | decimal (18,5) | 0.00 | |
OrderLinesEDI_MIN | decimal (18,5) | 0.00 | Minimum charge |
OrderLinesMan | decimal (18,5) | 0.00 | |
OrderLinesMan_MIN | decimal (18,5) | 0.00 | Minimum charge |
CasesOrderedEDI | decimal (18,5) | 0.00 | |
CasesOrderedMan | decimal (18,5) | 0.00 | |
CasesPickedEDI | decimal (18,5) | 0.00 | |
CasesPickedMan | decimal (18,5) | 0.00 | |
SinglesOrderedEDI | decimal (18,5) | 0.00 | |
SingleOrderedMan | decimal (18,5) | 0.00 | |
SinglePickEDI | decimal (18,5) | 0.00 | |
SinglePickMan | decimal (18,5) | 0.00 | |
OrderChargeEDI | decimal (18,5) | 0.00 | |
OrderChageMan | decimal (18,5) | 0.00 | |
OrderChargeTypes | Informational | Enter the Order Types P,U,E,X,T,D etc. | |
You can have banded charging although this import does not reflect it as we rarely see this being used. If you need banded charges please let us know.
It is also possible to set a MINIMUM charge, however we have only ever seen this done for order lines so the additional fields are only shown beside those entries, if you need to add it for others then simply add those fields in with the _MIN at the end.