Click or drag to resize

Consumption Data

This option allows the ERP to send the Cards Consumed to Ultriva so that those can be released. The fields marked as bold are required. Required fields must always have non-empty data.

ERP Consumption Flat File Field Definition

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

ERPConsumption Data File (inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

ReleaseID

STRING

32

Y

N

Kanban Card Barcode ID from Ultriva - unique for a cycle

PlantCode

STRING

32

Y

N

Plant Code

ItemNo

STRING

32

Y

N

Part number.

QtyConsumed

INTEGER

N/A

Y

N

Current Qty Consumed.

ConsumptionTime

DATETIME

N/A

Y

N

Card Consumption Time

Pre-Processing

This interface uses following fields as uniqueness constraint.

Field Name

Mandatory Field

EBJ_BUSCODE

Yes

EBJ_ItemNo

Yes

ReleaseId

Yes