Click or drag to resize

Purchase Order Receipt

Purchase Order Receive integration is triggered when a Card is Received from External Supplier in ULtriva

Note Note

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

API Call

API Call Sample Using Get Method :

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

Note Note

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

Purchase Order Receive API Field Definition

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

PO Receive 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

SHIP_TO _ORGANIZATION_CODE

STRING

32

Y

Plant Or Workcenter Code where this Card Released

SUBINVENTORY

STRING

32

N

SubInventory Code (as custom field)defined in Ultriva Item

SHIP_TO_LOCATION_CODE

STRING

32

N

Ship Location Code

LOCATOR

STRING

64

N

Location Code

SHIPPED_DATE

DATETIME

N/A

Y

Card Shipped 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_PO_NUMBER

STRING

32

N

Purchase Order number for the Card

ERP_PO_LINE_NUMBER

INTEGER

N/A

N

Purchase Order Line number for the card

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

TRACKING_NO

STRING

32

N

Card Tracking no

PACKINGSLIP_NO

STRING

32

N

Packing Slip No

Lot Data

If the Receipt has additional lot information, it will be sent in the file.

This can be configured in the Ultriva Integration Configurator.

If a Card has miltiple Lots, a New record for the Same card will be sent with the new Lot information.

Fields Description

Field Name

Data Type

Length

Required

Description

LotNumber

VARCHAR

64

Y

The Lot Number for the Card

LotQty

INTEGER

N/A

Y

The Lot Quantity

Processing Logic

The data is published after card is Received into Ultriva. Ultriva can wait for a SETPOReceipt 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.