Load Purchase Order
- Mai Labagnoy
This service is used to create new or update Purchase Order via File Upload, FTP Upload or REST API.
To use Load Purchase Orders service:
Client must subscribe to this iHub Service Load PO
A PO configuration is created on iHub Service Setting for each Client
The “Load Purchase Orders” service supports the ability to use “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.
<Request>
-<PurchaseOrder>
<Category>NE</Category>
<DCMPrefix>ANZ01</DCMPrefix>
<ConsigneeCode>DN01</ConsigneeCode>
<CurrencyCode>AUD</CurrencyCode>
<DCCode>DN01</DCCode>
<PODate>2025-03-31</PODate>
<Department>BP01</Department>
<PONumber>4500215323</PONumber>
<SupplierCode>900180</SupplierCode>
</PurchaseOrder>
-<List>
-<LineItems>
<LineNo>10</LineNo>
<LineSeason>RY-TL</LineSeason>
<CommodityCode />
<CustomerRef>R18HVC</CustomerRef>
<Colour />
<LineDeliveryDate>2025-04-01</LineDeliveryDate>
<LineExDate>2025-03-02</LineExDate>
<LineLatestExDate>2025-03-08</LineLatestExDate>
<LineStatus>B</LineStatus>
<ProductAttributes>0001</ProductAttributes>
<ProductCategory>CPT</ProductCategory>
<ProductCode>019183005</ProductCode>
<ProductDescription>RYOBI 18V HAND VACUUM FC TO</ProductDescription>
<Quantity>128</Quantity>
<EstimatedCBM />
</LineItems>
</List>
</Request>
Column Name | Data Type | NOTES |
|---|---|---|
IntegrationID | nvarchar(100) | Seko 360 iHub |
PONumber | nvarchar(50) | Required |
ExDate | datetime |
|
DeliveryDate | datetime | Required |
TransportMode | nvarchar(50) |
|
DCCode | nvarchar(100) | Required |
Season | nvarchar(100) |
|
SeasonYear | smallint |
|
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) | Required if Client is using Departments |
Class | nvarchar(50) |
|
Buyer | nvarchar(50) |
|
OriginPort | nvarchar(50) |
|
DestinationPort | nvarchar(50) |
|
ShippingTerms | nvarchar(50) |
|
ShippingTermsLoction | nvarchar(50) |
|
Category | nvarchar(100) |
|
LatestExDate | datetime |
|
Notes | nvarchar(4000) |
|
Load PO Line Item Table | ||
|---|---|---|
Column Name | Data Type | NOTES |
LineNo | int | Autogenerated (increment) |
LineStatus | nvarchar(20) | Standard: N (New), A (Amend), C (Cancel) |
LineExDate | datetime |
|
LineDeliveryDate | datetime |
|
LineTransportMode | nvarchar(50) |
|
LineDCCode | nvarchar(100) |
|
LineSeason | nvarchar(100) |
|
LineSeasonYear | smallint |
|
ProductCode | nvarchar(100) |
|
ProductDescription | nvarchar(100) |
|
Quantity | int |
|
ProductAttributes | nvarchar(500) |
|
ProductCategory | nvarchar(200) |
|
EAN | nvarchar(50) | Required if EAN identifier is in use |
UnitCostPrice | decimal(18, 2) |
|
Colour | nvarchar(100) |
|
Size | nvarchar(100) |
|
CustomerRef | nvarchar(100) |
|
CommodityCode | nvarchar(100) |
|
LineLatestExDate | datetime |
|
EstimatedCBM | decimal(18, 3) |
|
RestrictSplit | bit (True, False) |
|