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. | |
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 |
...
SiteCode_CustomerCode_StkTrsn_datetime |
...
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. | |
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Date | Change |
|---|
CSV Field Names & Content
...
|
|
|
|
Example Output
Not available
CSV
| View file | ||
|---|---|---|
|
XML
Not available
CSV Output
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 |
...