Click or drag to resize

Gross Requirements

The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.

Field Name

Data Type

Length

Required

Nullable

Description

PlantCode

STRING

32

Y

N

Plant Code

ItemNo

STRING

32

Y

N

Item No.

VendorCode

STRING

32

Y

N

Supplier Code. Send Blank

DaysOffset

INTEGER

NA

Y

N

Days Offset for Expediting/Defering

ExceptionCode

STRING

32

Y

N

Defined Exception Code. Ordrs will be placed/Expedited/Deferred/Recalled based on that

QtySuggested

INTEGER

NA

Y

N

Order Qty

OrderNum

STRING

64

Y

N

Order No.

OrderLineNum.

INTEGER

NA

Y

N

Order Line No

OrderDate

DATETIME

NA

Y

N

Current Order Date

StartDate

DATETIME

NA

Y

N

Order Start Date

DueDate

DATETIME

NA

Y

N

Order Due Date

CARDGID

STRING

32

Y

N

CardGID for already Open Order.