Click or drag to resize

Support Tables

This Section explains about the Support tables used in the SQL Table Integration

The Following are the Tables

  1. UEK_INTERFACE_ERRORS

  2. UEKLotData

  3. UEKStagingParams

UEK Interface Errors SQL Table Definition

The following table defines the fields in UEK Interface Errors SQL Table.

Processing Logic

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.

UEK_INTERFACE_ERRORS

Field Name

Data Type

Length

Required

Populated By

Description

ROW_ID

VARCHAR

50

Y

ERP

GID of the transaction Record

INTERFACE_NAME

VARCHAR

20

Y

ERP

The Integration Type UEKPO for Po Release and UEKREC for PO Receive

REQUEST_ID

VARCHAR

50

N

ERP

ERP Request ID for this if Any

ERROR_TYPE

VARCHAR

50

N

ERP

ERP Module ID if any

TABLE_NAME

VARCHAR

50

Y

ERP

The Integration Table. UEK2ERPPOData of Po Release and UEK2ERPReceiptsData for PO Receipt.

ERROR_COLUMN_NAME

VARCHAR

50

N

ERP

Erp Column Name if any

ERROR_DESC

VARCHAR

200

Y

ERP

ERP Error Description. Displayted on the Integration Report

CREATION_DATE

DATATIME

N/A

Y

ERP

Error Creation Time

CREATED_BY

VARCHAR

32

N

ERP

ERP User Id if any

LAST_UPDATE_DATE

DATATIME

N/A

N

ERP

Deprecated.

LAST_UPDATED_BY

VARCHAR

N/A

N

ERP

Deprecated.

LAST_UPDATED_LOGIN

VARCHAR

N/A

N

ERP

Deprecated.

UEK Lot Data SQL Table Definition

The following table defines the fields in UEK Lot Data SQL Table.

Processing Logic

Ultriva PO Receipt Integration Process may populate this table if the Receipt has additional Lot information.

The GID of this record is same as the PO Receipt Staging Record’s GID. So, this table may contain more than 1 record for the PO Staging Record.

UEKLotData

Field Name

Data Type

Length

Required

Populated By

Description

GID

VARCHAR

32

Y

Ultriva

GID of the transaction Record

LotNumber

VARCHAR

64

Y

Ultriva

The Lot Number for the Card

LotQty

INTEGER

N/A

Y

Ultriva

The Lot Quantity

Notes

VARCHAR

1024

N

Ultriva

Notes if any

UEK Staging Params

The following table defines the fields in UEK Staging Params SQL Table.

Processing Logic

If a staging record has additional extra parameter values then Ultirva Integration may populate those values into this table. The GID of this record is same as the PO Receipt Staging Record’s GID. So, this table may contain more than 1 record for the PO Staging Record. The source field value will be UEK.

If ERP connector needs to send some value back to Ultriva then it may populate those extra parameter values into this table. The GID of this record is same as the PO Receipt Staging Record’s GID. So, this table may contain more than 1 record for the PO Staging Record. The source field value must be ERP

UEKStagingParams

Field Name

Data Type

Length

Required

Populated By

Description

GID

VARCHAR

32

Y

Ultriva/ERP

GID of the transaction Record

ParamName

VARCHAR

128

Y

Ultriva/ERP

Parameter Name

ParamValue

VARCHAR

128

Y

Ultriva/ERP

Parameter Value

Source

VARCHAR

32

Y

Ultriva/ERP

Source ERP or UEK.