Click or drag to resize

Error File Format

Ultriva Supports the Error File for all the "SET" Integration Ponts. These are the points that Ultriva Sends information and waits for a File from ERP to set the Status of the Integration. A typical Example of this type of integration is the PO Release.

The Error File

  1. Name needs to be set in the Integration configuration

  2. needs to be in the Same folder as the SET integration File

SetError Flat File Field Definition

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

SetError Data File (inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

GID

STRING

32

Y

N

Unique GID that identifies the Transaction. The Same as the GID in the associated SET File.

INTERFACE_NAME

STRING

32

Y

N

The integration Point Name(PORlease, POReceive etc)

REQUEST_ID

STRING

32

Y

Y

ERP Request ID if any, Send blank if none

ERROR_TYPE

STRING

64

Y

N

The ERP Module the Error occured if any. Send blank if none

TABLE_NAME

STRING

32

Y

N

The integration Point Name(PORlease, POReceive etc)

ERROR_COLUMN_NAME

STRING

32

Y

Y

The ERP Error Column if Any, Send Blank if None

ERROR_DESC

STRING

4096

Y

N

The ERP Error Description.

CREATED_DATE

DATETIME

N/A

Y

N

Error Create Date

CREATED_BY

STRING

32

Y

Y

Erp User Name If any. Send Blank if None