Notes | ||
|---|---|---|
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. | |
not available | ||
CSV | Available | |
XML | Not available | |
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. | |
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 |