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 |
Add label
Goods Inwards
Goods Inwards charges or known as RHD are charges applied per line as goods are received into stock.
Field Name | Type | Mandatory Or Default to |
|
Customer | Char(8) |
| Enter the customer code. |
ReducedRate | int |
| We find most customers will offer a standard pack charge and then a discount for a pack half the size or even the other way around. Indicate how this will be used for this customer
1 LOL Greater Than 2 LOL Less Than 3 Bottles/Case Greater Than 4 Bottles/Case Less Than
|
IsPremiumCharge | bit | YES | Will you charge a premium charge for expedited receipts This is defined |
PremiumChargePercentage | decimal(18, 2) | 0.00 | How much is the surcharge for an expedited receipt. |
IsRRDiscount | bit | YES | Are you applying a reduced rate. |
RRDiscountQty | decimal(18, 2) |
| What is the quantity to achieve the discount e.g. 6.00 litres or less…… |
RRDiscountPercentage | decimal(18, 2) |
| Is you are applying a reduced rate then what is the discount % age e.g. 50.00% discount |
Product Types | Information |
| Does this charge apply to particular product types |
Product Groups | Information |
| Does this charge apply to particular product groups |
Charge | decimal(19, 5) | YES 0.00 |
|
Minimumcharge | decimal(19, 5) | YES 0.00 |
|
ReceiptType | int | YES | How is this charge being applied
1 Case True 2 Pallet True 3 Gross Weight True 4 Container False 5 Container 60ft False 9 Single True
|
Multiplier | bit | YES 0 | Does this rate get used as a multiplier for some products |
Multiplier1Qty | Decimal (18,5) | 0.00 | Enter the value 1.00 means same as existing rate 2.00 would be double |
Multiplier1ProductTypes | Informational |
| Tell us which product types this applies to |
Multipleier1ProductGroups | Informational |
| Tell us which product group this multiplier would apply to |
Multiplier2Qty | Decimal (18,5) | 0.00 | Enter the value 1.00 means same as existing rate 2.00 would be double |
Multiplier2ProductTypes | Informational |
| Tell us which product types this applies to |
Multipleier2ProductGroups | Informational |
| Tell us which product group this multiplier would apply to |
We will use this table to build a standard charging matrix and then that matrix of charges will be applied to the customer accounts which can use a specific charge and then we use this to apply it to the products.