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 |
Sundry Charges
The system is setup with generic sundry charges which are applied to all accounts within the warehouse these charges can be customised for individual customers accounts during the UAT phase before you go live.
Sundry Nominal Codes
We need a list of the nominal codes you will use and when providing the summary charges you will use this ID number on the left column to associate the charge to the nominal
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 |
Sundry Charges
Field Name | Type | Notes | |
Code | Text (10) | Provide a short code for this charge, make it memorable as this can be used instead of a lookup | |
Nominal Code | Int | Take from the previous table. | |
Description | Text (50) | ||
Charge | Money (5,2) | ||
Goods Inwards ? | 0 or 1 | 0 for No and 1 for Yes | |
Goods Outwards ? | 0 or 1 | 0 for No and 1 for Yes | |
Fixed Charge | 0 (default) or 1 | A fixed charge can not be modified once entered onto the charging screen. You can only edit the quantity field if charge is fixed. 0 for not fixed and 1 where it is fixed. | |
FKSundryUse | Int | Options are | 1 - All |
FKSundryChargeType | int | Options are | 1 - Each |
ProductCode | Text (50) | This is used for reporting to enable you to produce a report about usage of a particular product to allow you to maintain stock management for the product e.g. cartons and packaging materials Used when scanning for efullfillment costs during packaging operation | |