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
Customer Basic Standard Charges
Against the customer record we store the charge defaults information, all fields are mandatory and if you are not using them the default is shown in the default field, your import table should include the field and the default value unless you need it to be something else.
Field Name | Type | Default to |
|
Customer | int | Customer Code | |
VATCode | tinyint | 1 | This is to highlight any customer to us who may not be paying VAT such as the EU land / rental directive.
1 Standard VAT 8 No VAT on Storage 9 Non Standard VAT |
MinRHDCharge | decimal(19, 5) | 0.00 | This applies at the invoice level, and will only apply to the invoice for the main period. E.g. Annual customers will have a pro-rata invoice each month or so and this will not use the minimum charge, only the one raised at the annual date will. |
MinStorageCharge | decimal(19, 5) | 0.00 | |
StandardOrderCharge | decimal(19, 5) | 0.00 | Not in use – was replaced by outwards charging |
PickingOrder | int | 1 | By default all customers are set to 1 which is FIFO |
FKInvoicePeriod | int | 7 | This applies to the storage (rent) invoice “invoice” period, not to be confused with the charge period.
Where you are sending invoices out monthly but on a weekly schedule e.g. 4w/4w/5w then use period invoicing as this then allows you to define the period you are invoicing for.
1 Daily 2 Weekly 4 Monthly 5 Quarterly 6 Annual 7 Period |
LooseItemCharge | decimal(18, 5) | 0.00 | Used for goods inwards, you specify the quantity and it is charged at this rate. Customer use this either for a man hour charge or a per item charge. |
RotationQtyBandedStorage | bit | 0 | If you are using storage bands, then change to 1, otherwise you are using one price irrespective of the number of items received. |
MarketValueReportCharge | decimal(18, 2) | 0.00 | VCIS web request if using Livex and LWIN |
VCISChargedAsEDIOrder | bit | 1 | Generally this would be set to 1 for YES Used to work out order charging for goods out ordering |
Condition Report QR Charge | Money (5,2) | 0.00 | Usually carried out with a Flex device’s mobile camera when a full, professional report is not required and a lower charge could be raised (stock is not moved) |
Is CR (above) per case | bit | 0 | Is this charge a fixed charge or a charge per case, default is fixed which is 0 change to 1 if charge by the case |
Condition Report Standard Report Charge | Money (5,2) | 0.00 | Professional photos usually taken in a photo booth (stock is moved) |
Is CR (above) per case | bit | 0 | Is this charge a fixed charge or a charge per case, default is fixed which is 0 change to 1 if charge by the case |
Condition Report 3D Report | Money (5,2) | 0.00 | Professional photos taken with equipment capable of producing a 3D image (future use, stock is moved) |
Is CR (above) per case | bit | 0 | Is this charge a fixed charge or a charge per case, default is fixed which is 0 change to 1 if charge by the case |