Click or drag to resize

Supplier Sync

This option allows the Ultriva Supplier master data to be in synch with the ERP Supplier master data. The fields marked as bold are required. Required fields must always have non-empty data.

Supplier Sync SQL Table Field Definition

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

Supplier Master Data SQL Table (inbound to Ultriva) ERP2UEKSupplierData

Field Name

Data Type

Length

Required

Nullable

Description

GID

STRING

32

Y

N

Unique Identifier.

PlantCode

STRING

32

Y

N

Plant Code where this new supplier or association should be made

SupplierCode

STRING

32

Y

N

Unique SupplierCode Code to identify this supplier.

SupplierName

STRING

128

Y

N

Supplier Name for this supplier.

Address1

STRING

64

Y

N

Address Line 1 for the supplier address

Address2

STRING

64

N

N

Address Line 2 for the supplier address

Address3

STRING

64

N

N

Address Line 2 for the supplier address

City

STRING

64

Y

N

City of this Supplier

State

STRING

64

Y

N

State

Zip

STRING

32

Y

N

Zip Code

Country

STRING

32

Y

N

Country

CRDATE

DATETIME

N/A

Y

N

Record Created Time

ERPSTATUS

STRING

32

Y

N

Should be Set to Created.

ERPSTATUSMSG

STRING

1024

Y

N

Any Status Message. Can be Empty

ERPLASTUPDATE

DATETIME

N/A

Y

N

Record Updated Time

UEKSTATUS

STRING

32

Y

N

Populated by Ultriva. Indicates the Staus of the Transaction. Valid Values(created,fail,processed))

UEKSTATUSMSG

STRING

1024

Y

N

Populated By Ultriva. If Error Error message will be sent.

UEKLASTUPDATE

DATETIME

N/A

N

Y

Populated By ultriva. Record Update Time

ActionDate

DATETIME

N/A

N

Y

Populated By ultriva.

ResponseGID

STRING

32

N

Y

Ultriva Internal Field