Load All Purchase Orders
- Mai Labagnoy
This service is used to Load All Purchase Orders by bulk (All open POs Large File by Batch) using File Upload, FTP Upload or REST API.
iHub generates a unique Batch ID for every file. Then it process the file by grouping lines together by the PONumber and passing each Purchase Order to Seko 360 DCM with this BatchID and EOF (End of File) flag.
iHub set the End of File (EOF) to “False” for every purchase order in the file that is sent to Seko 360 DCM EXCEPT for the very last purchase order. For the last Purchase Order in the file, the Hub needs set the EOF flag to “True”.
iHub removes PO lines that are excluded in the next upload.
To use Load All Purchase Order service:
Client must subscribe to this iHub Service Load All PO
A PO configuration is created on iHub Service Setting for each Client
The “Load All Purchase Orders” service supports the ability to use “EAN” as the line identifier”
Contact support to enable this feature (EAN” as the line identifier)
PO Supplier can be updated if:
No PO Lines on the PO exist on a Booking
Shipment status is NOT Confirmed on Board (COB)
Purchase orders uploaded in iHub can be view in DCM PO List Menu.
Column Name | Data Type | NOTES |
|---|---|---|
IntegrationID | nvarchar(100) | Seko 360 iHub |
PONumber | nvarchar(50) | Required |
ConsigneeCode | nvarchar(100) | Required |
SupplierCode | nvarchar(100) | Required |
SupplierName | nvarchar(200) |
|
CountryOfOrigin | nvarchar(50) |
|
PODate | datetime |
|
PaymentTerms | nvarchar(50) |
|
CurrencyCode | nvarchar(50) |
|
Department | nvarchar(50) |
|
Class | nvarchar(50) |
|
Buyer | nvarchar(50) |
|
OriginPort | nvarchar(50) |
|
DestinationPort | nvarchar(50) |
|
ShippingTerms | nvarchar(50) |
|
ShippingTermsLoction | nvarchar(50) |
|
Category | nvarchar(100) |
|
Notes | nvarchar(4000) |
|
BatchID | nvarchar(100) | Seko 360 iHub |
EOF | bit (True, False) | Seko 360 iHub |
Load All Purchase Order Line | ||
|---|---|---|
Column Name | Data Type | NOTES |
LineNo | int | Required |
ProductCode | nvarchar(100) | Required |
ProductDescription | nvarchar(100) | Required |
Quantity | int | Required |
ProductAttributes | nvarchar(500) |
|
ProductCategory | nvarchar(200) |
|
EAN | nvarchar(50) | Required if EAN identifier is in use |
ExDate |
|
|
DeliveryDate | datetime | Required |
TransportMode | nvarchar(50) |
|
DCCode | nvarchar(100) | Required |
Season | nvarchar(100) |
|
SeasonYear | smallint |
|
UnitCostPrice | decimal(18,2) |
|
Colour | nvarchar(100) |
|
Size | nvarchar(100) |
|
CustomerRef | nvarchar(100) |
|
CommodityCode | nvarchar(100) |
|
LatestExDate | datetime |
|
EstimatedCBM | decimal(18, 3) |
|
RestrictSplit | bit |
|
