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

Ultriva PO Receive:

  1. Ultriva:

    • Ultriva updates all the related fields required once the PO in Received into Ultriva.

    • These fields are identified in the column below

  2. ERP:

    • ERP system must consume this data and send the Purchase Order Status back to Ultriva

    • ERP system should update the PO receipt related info and the Status fields

Purchase Order Receive SQL Table Field Definition

The following table defines the fields in Purchase Order SQL Table.

Processing Logic

ERP Connector must query this table periodically by running a SELECT Query with WHERE Clause ((ERP_STATUS IS NULL OR ERP_STATUS = '') AND UEK_STATUS = 'created')

If one or more records returned by above query then Connector does following: Update the record with the ERP_STATUS = 'Processing' and ERP_LAST_UPDATE_DATE = current time Then sends the data to ERP System

Once ERP completes the Receipt Transaction then connector must populate the required ERP Fields back to this table and Update the ERP_STATUS = 'processed' and ERP_LAST_UPDATE_DATE = CurrrentTime where clause should be GID column of this record

If the transaction failed in the ERP system, then the connector must update the record with the ERP_STATUS = 'FAILED' AND ERP_LAST_UPDATE_DATE = Current time.

If any additional error details to be passed back to ultriva then Connector should Insert those details into the UEK_INTERFACE_ERRORS table with ROW_ID is set to the GID of this staging record.

PO Receive Data SQL Table (outbound from Ultriva) UEK2ERPReceiptsData

Field Name

Data Type

Length

Required

Populated By

Description

GID

VARCHAR

32

Y

Ultriva

Unique Identifier.

KANBAN_CARD_NO

VARCHAR

32

N

Ultriva

Kanban Card ID from Ultriva

BPFL_VERSION

INTEGER

N/A

Y

Ultriva

Card Version No. Ultriva Internal Value

CYCLE_ID

VARCHAR

32

Y

Ultriva

Unique Cycle ID

CYCLE_NO

INTEGER

N/A

Y

Ultriva

Card Cycle No.

ERP_LAST_UPDATE_DATE

DATETIME

N/A

Y

ERP

Record Updated Time

ERP_PO_REFERENCE

VARCHAR

32

N

Ultriva

Purchase Order Number details from Ultriva Card Cycle

ERP_PO_LINE_REFERENCE

INTEGER

N/A

N

Ultriva

Purchase Order Number details from Ultriva Card Cycle

ERP_PO_RELEASE_NUM

VARCHAR

N/A

N

Ultriva

Purchase Order Number details from Ultriva Card Cycle

ERP_PO_RELEASE_LINE_NUM

VARCHAR

32

N

Ultriva

Purchase Order Number details from Ultriva Card Cycle

ERP_RECEIPT_NUMBER

VARCHAR

32

N

ERP

The P.O Receipt Number if any.

ERP_RECEIPT_LINE_NUMBER

VARCHAR

32

N

ERP

The Receipt Line No if any.

ERP_STATUS

VARCHAR

32

Y

ERP

Status of Transcation ERP. Should Set to Processed/Failed.

ITEM_NUM

VARCHAR

32

Y

Ultriva

Item Code/Number for this transaction

QUANTITY

INTEGER

N/A

Y

Ultriva

Qty released

ORG_ID

INTEGER

N/A

N

Ultriva

Organization ID set as custom configuration field in Business Unit

LOCATOR

VARCHAR

64

N

Ultriva

Location Code defined at Item level

SHIPPED_DATE

DATETIME

N/A

Y

Ultriva

Card Shipped Date

SHIP_TO_LOCATION_CODE

VARCHAR

32

N

Ultriva

Ship Location Code

SHIP_TO _ORGANIZATION_CODE

VARCHAR

32

Y

Ultriva

Plant Or Workcenter Code where this Card Released

SUBINVENTORY

VARCHAR

32

N

Ultriva

SubInventory Code (as custom field)defined in Ultriva Item

TRANSACTION_DATE

DATETIME

N/A

Y

Ultriva

Card Transaction Time

UEK_LAST_UPDATE_DATE

DATETIME

N/A

Y

Ultriva

Record Added/Updated Time

UEK_STATUS

VARCHAR

32

Y

Ultriva

Status of Transcation. Ultriva will set it to Created.

UNIT_OF_MEASURE

VARCHAR

16

N

Ultriva

Unit of Measure defined in Ultriva for this Item Number

VENDOR_CODE

VARCHAR

32

Y

Ultriva

Vendor Code - the supplier who is receiving this order

TRACKING_NO

VARCHAR

32

N

Ultriva

Card Tracking no

PACKINGSLIP_NO

VARCHAR

32

N

Ultriva

Packing Slip No

FLAGS

INTEGER

N/A

N

Ultriva

Internal Ultriva Item Flags value

ReleaseID

Varchar

32

N

Ultriva

Barcode ID for the Card with Cycle and Checksum

ParentBusinessCode

Varchar

128

N

Ultriva

Parent Business Unit code. In case if the card is released for workcenter then this field will contain the Parent Business Unit Code

ParentBusinessName

Varchar

128

N

Ultriva

Parent Business Unit Name. In case if the card is released for workcenter then this field will contain the Parent Business Unit Name

ParentConcentratorName

Varchar

128

N

Ultriva

Parent Business Unit Concentrator Name. In case if the card is released for workcenter then this field will contain the Parent Business Unit Concentrator Name

CARD_LOCATION

Varchar

64

N

Ultriva

Current Storage Location Code of the Card