Click or drag to resize

Inventory Transfer

Inventory Transfer integration is triggered when the Following actions are Performed in Ultriva. Issue Inventory, Move Location, Adjust Inventory

Note Note

Please make sure the Inventory Transfer Event Rule for Integration is Enabled

Note Note

The Transaction Type in the File will be either "MoveAndResetQty""OR "PastIssued"

API Call

API Call Sample Using Get Method :

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

Note Note

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

Inventory Transfer API Field Definition

The following table defines the fields in Inventory Transfer 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

Inventory Transfer/Create Data File (outbound from Ultriva)

Field Name

Data Type

Length

Required

Description

ITEM_NUM

STRING

32

Y

Item Code/Number for this transaction

QUANTITY

INTEGER

N/A

Y

Qty released

UNIT_OF_MEASURE

STRING

16

N

Unit of Measure defined in Ultriva for this Item Number

ORGANIZATIOM_CODE

STRING

32

Y

Plant Or Workcenter Code where this Card Released

LOCATOR

STRING

32

N

Location Code defined in the Item Master

TRANSACTION_TYPE

STRING

32

N

Contains the Transaction Type(MoveAndResetQty,PartsIssued)

TRANSACTION_BY

STRING

32

N

User(LoginName) who performed the Transaction

TRANSACTION_DATE

DATETIME

N/A

Y

Date OF Transaction

ORG_ID

Integer

N/A

N

Organization ID set as custom configuration field in Business Unit

FROM_LOCATION

STRING

32

N

The Location from where the card was Moved from

ISSUE_LOCATION

STRING

32

Y

The Location from where the card was moved To

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

CYCLE_NO

INTEGER

8

N

Card Cycle no

CYCLE_ID

STRING

32

N

Card Cycle GID

BPFL_VERSION

INTEGRER

8

N

Card Version

Processing Logic

The data is published after card is Transacted in Ultriva. Ultriva can wait for a SETInventory File to be Sent back from ERP or can mark the Record as Completed once the File is exported. This can be set in the Ultriva integration Configurator.