Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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
(8,2) the total number of digits before and after the decimal point.

e.g 42.00 17.00 18.43 26.40

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.

  • No labels