Field Types
Field Type | Explanantion |
|---|---|
int | integer fields |
bit | Yes or No fields 1 for Yes and 0 for No |
date | format dd/mm/yy or dd/mm/yyyy |
nvarchar (11) | text field with maximum length 11 |
decimal (8,2) | Decimal field must include the decimal and 00 e.g 42.00 17.00 18.43 26.40 |
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
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 2 Goods Inwards 3 Goods Out 4 eFullfillment |
FKSundryChargeType | int | Options are | Description Qty1 QtyUserDefined Charge per Qty 1 Each False Yes 0 2 Fixed True No 0 |
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 | |