Click or drag to resize

Work Order Release/Create

Work Order Release/Create integration is triggered when a Card is Released to a Work Center in Ultriva

Note Note

Please make sure the Purchase Order Release Event Rule for Integration is Enabled

Note Note

By Default all thease Transaction will be sent in the Purchae Order Release File if the Instance Wishes these to be sent seperately then this has to be setup in tha Plant configuration.

Note Note

If the Release should wait then please Enable Release Waiting For Purchase Order Flag is set for this Item

API Call

API Call Sample Using Get Method :

http://[Website URL]/JobExpApi/ExecuteBatch?plantCode=[Plant Code]&jobName=JOBEXPWORELEASE

Note Note

Please make sure you replace [Website URL] with client website URL and [Plant Code] with client Plant Code.

Work Order Release/Create API Field Definition

The following table defines the fields in Work Order file.

Note Note

If some of the fields given below are not required for ERP System then it is easy to configure the required fields through Ultriva Integration Configuration Module

WO Release/Create Data File (outbound from Ultriva)

Field Name

Data Type

Length

Required

Description

PREPARER_NAME

STRING

64

N

Item Buyer Name

ITEM_NUM

STRING

32

Y

Item Code/Number for this transaction

QUANTITY

INTEGER

N/A

Y

Qty released

UNIT_PRICE

NUMBER

N/A

N

Unit Price defined in Ultriva for this Item Number

UNIT_OF_MEASURE

STRING

16

N

Unit of Measure defined in Ultriva for this Item Number

DESTINATION_ORGANIZATIOM_CODE

STRING

32

Y

Plant Or Workcenter Code where this Card Released

DESTINATION_SUBINVENTORY

STRING

32

N

SubInventory Code (as custom field)defined in Ultriva Item

DELIVER_TO_LOCATION_CODE

STRING

32

N

Location Code defined in the Item Master

DELIVER_TO_REQUESTOR_NAME

STRING

64

N

Item's Co-ordinator (buyer) Name

NEED_BY_DATE

DATETIME

N/A

Y

Required Receive Date

ORG_ID

INTEGER

N/A

N

Organization ID set as custom configuration field in Business Unit

VENDOR_CODE

STRING

32

Y

Vendor Code - the supplier who is receiving this order

VENDOR_SITE_CODE

STRING

32

N

Vendor Site Code - A Custom field set in the Supplier

BUYER_CODE

STRING

32

N

Buyer user code set in the buyer user record

ERP_WO_NUMBER

STRING

32

N

Blanket Purchase Order number set in the Item 2 Supplier relationship

ERP_WO_LINE_NUMBER

INTEGER

N/A

N

Blanket Purchase Order Line number set in the Item 2 Supplier relationship

KANBAN_CARD_NO

STRING

32

N

Kanban Card ID from Ultriva

RELEASEID

STRING

32

N

Kanban Card Barcode ID from Ultriva - unique for a cycle

FLAGS

INTEGER

N/A

N

Internal Ultriva Item Flags value

CATEGORY

STRING

32

N

Ultriva Item Category

PARENTBUSINESSCODE

STRING

32

N

Parent Business Unit Code - applicable if the item belongs to workcenter

PARENTBUSINESSNAME

STRING

32

N

Parent Business Unit Name - applicable if the item belongs to workcenter

CARD_LOCATION

STRING

32

N

Card's Location code

REQ_SHIP_DATE

DATETIME

N/A

N

Required Ship Date Time by the supplier

Processing Logic

The data is published after card is released from Ultriva. ERP system must consume this data and send the Purchase Order Results back to Ultriva through Set WO File.