8001 Order Transaction Audit
- Alan Gilchrist
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. | |
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 |
|---|---|
|
|
|
|
Example Output
Not available
CSV
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 |
|
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.