Overview
This file is generated to show stock movements from the warehouse and their respective inbound movements, essentially for every item leaving where it went to, how much it cost and where it came from.
This is an old format which is still available and is used on the VCIS site, a newer automated XML format is available (see transaction audit)
Format
The report is in csv format, which means it can be read into your system or can be opened in excel.
Delivery & Scheduling
The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis.
It is up to the customers whether this is scheduled.
The file will normally be emailed to your email address as an attachment to an existing message.
File Name Convention
The filename will be
SiteCode_CustomerCode_StkTrsn_datetime. (csv)
Limitations
The file generated can be extremely large, as this will contain a great deal of data about all movements. We suggest that this file is only run when required and is not scheduled to run.
CSV Field Names & Content
Field Name | Size | Notes |
CustomerCode | 8 | |
RotationNumber | 10 | |
LineNumber | 4 | This is the POD line number field. |
MovementType | 2 | See “Duty and VAT” section for a list of the stock movement types |
DocumentReference | 8 | |
MovementDate | 10 | |
Cases | 10 | |
Singles | 10 | |
TotalSingles | 10 | The total movement in singles |
DeliveryNumber | 10 | |
ProductCode | 30 | |
ProductDescription | 50 | |
PackageDescription | 50 | |
DateReceived | 10 | |
SinglesPerCase | 4 | |
DutyPaid | 3 | Yes or No |
ReserveCustomer | 8 | The code used for the customer |
Details1 | 120 | |
Details2 | 120 | |
Details3 | 120 | |
InBondValue | 15 | |
IBVCurrency | 3 | |
FreeCirculation | 3 | Yes or No |
ReceiptDeliveryType | 6 | See “goods received” section for possible codes |
BestBeforeDate | 10 | |
OriginalWoodenCase | 3 | Yes or No |
Pallets | 6 | |
CasesPerPallet | 6 | |
RotationNotes | 120 | |
OrderDate | 10 | |
BookedDate | 10 | |
DeliveryDate | 10 | |
DeliveryLines | 6 | How many lines were on this delivery |
TotalPhysicalCases | 6 | |
TotalInvoiceCases | 6 | |
TotalInvoicePallets | 6 | |
ChargePerCase | 15 | |
ChargePerPallet | 15 | |
TotalHandlingCharge | 15 | |
AdditionalCharge | 15 | |
AdditionalChargeReason | 30 | |
AdditionalChargeDate | 10 | |
AdditionalChargeUser | 10 | |
TotalCharge | 15 | Final charge adding all previous transport charges together |
Notes | 60 | |
DeliveryAddressCode | 8 | |
DeliveryName | 30 | |
DeliveryAddress1 | 30 | |
DeliveryAddress2 | 30 | |
DeliveryAddress3 | 30 | |
DeliveryAddress4 | 30 | |
DeliveryPostcode | 10 | |
AgentCode | 8 | |
AgentName | 30 | |
AgentAddress1 | 30 | |
AgentAddress2 | 30 | |
AgentAddress3 | 30 | |
AgentAddress4 | 30 | |
DeliveryInstructions | 120 |