Click or drag to resize

PO Cancel Data

This option is used to Send the ERP PO Cancel to Ultriva so that the cards can be recalled. The fields marked as bold are required. Required fields must always have non-empty data.

ERP PO Cancel Flat File Field Definition

The following table defines the fields in ERP PO Cancel Data file. The fields marked as bold are required. Required fields must always have non-empty data.

PO Cancel Data File (inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

ReleaseID

STRING

32

Y

N

Kanban Card Bar code ID from Ultriva - unique for a cycle. Release ID is optional only if file contains order details

EBJ_BUSCODE

STRING

32

Y

N

The Plant Code the Card Belongs to

EBJ_ITEMNO

STRING

32

Y

N

Part number

OrderNum

STRING

32

Y

N

Purchase Order Number from ERP

OrderLineNum

INTEGER

N/A

Y

N

Purchase Order Line No from ERP Send 0 if Empty

OrderReleaseNum

STRING

32

Y

N

The P.O. Release No if any

OrderReleaseLineNum

STRING

32

Y

N

The Release Line No if any

Pre-Processing

This interface uses following fields as uniqueness constraint if cancel is by Release ID

Field Name

Mandatory Field

EBJ_BUSCODE

Yes

EBJ_ITEMNO

Yes

ReleaseId

Yes

This interface uses following fields as uniqueness constraint if cancel is by Order details

Field Name

Mandatory Field

EBJ_BUSCODE

Yes

EBJ_ITEMNO

Yes

OrderNum

Yes

OrderLineNum

Yes

OrderReleaseNum

Yes

OrderReleaseLineNum

Yes

  1. If ReleaseId is empty then it looks up by item, plant, supplier, order number, order line number, order release number, order release line number.

Validation

Batch Job Processor validates each record with following validation before it starts processing the record.

  1. CardID/Order should be in the right state

  2. CardID/Order must belong to the plant

  3. CardID/Order should belong to the item from the record

Processing Logic

If ReleaseID is given then it returns a CardID. Using the CardID, a card is found. If the card is in a valid state then the card is recalled.

If ReleaseID is empty, then it looks up by item, plant, supplier, order number, order line number, order release number, order release line number. All cards for this will be recalled.

Error Handling

Accept Data Processor may mark incoming records with specific error messages during interface processing.

The following table shows the error messages and their meaning:

Note Note

In the following table the placeholders are encoded with curly braces.

Error Message

Meaning

CardID does not belong to plant

CardID does not match plant code given in the file

CardID does not belong to item

CardID does not belong to the item referenced by Item Number

Plant code is missing

Empty plant code in the record

Item number is missing

Empty item number in the record

Invalid Order Number

when release id is empty, then the order lookup failed