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. |