Name |
Datatype |
Length |
Prcn |
NEED_BY_DATE |
DATE
|
|
|
PROMISED_DATE |
DATE
|
|
|
CLM_PERIOD_PERF_START_DATE |
DATE
|
|
|
CLM_PERIOD_PERF_END_DATE |
DATE
|
|
|
DAYS_EARLY_RECEIPT_ALLOWED |
NUMBER
|
|
|
DAYS_LATE_RECEIPT_ALLOWED |
NUMBER
|
|
|
RECEIPT_DAYS_EXCEPTION_CODE |
VARCHAR2
|
(30)
|
|
ALLOW_SUBSTITUTE_RECEIPTS_FLAG |
VARCHAR2
|
(1)
|
|
RECEIVE_CLOSE_TOLERANCE |
NUMBER
|
|
|
QTY_RCV_TOLERANCE |
NUMBER
|
|
|
QTY_RCV_EXCEPTION_CODE |
VARCHAR2
|
(30)
|
|
RECEIVING_ROUTING_ID |
NUMBER
|
|
|
ENFORCE_SHIP_TO_LOCATION_CODE |
VARCHAR2
|
(30)
|
|
NOTE_TO_RECEIVER |
VARCHAR2
|
(800)
|
|
VMI_FLAG |
VARCHAR2
|
(1)
|
|
CONSIGNED_FLAG |
VARCHAR2
|
(1)
|
|
PREFERRED_GRADE |
VARCHAR2
|
(400)
|
|
COUNTRY_OF_ORIGIN_CODE |
VARCHAR2
|
(30)
|
|
ENCUMBERED_FLAG |
VARCHAR2
|
(1)
|
|
FIRM_STATUS_LOOKUP_CODE |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(400)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(400)
|
|
ACCRUE_ON_RECEIPT_FLAG |
VARCHAR2
|
(1)
|
|
MATCH_OPTION |
VARCHAR2
|
(25)
|
|
INVOICE_CLOSE_TOLERANCE |
NUMBER
|
|
|
PAYMENT_TYPE |
VARCHAR2
|
(30)
|
|
PRICE_OVERRIDE |
NUMBER
|
|
|
DESCRIPTION |
VARCHAR2
|
(240)
|
|
INSPECTION_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
RECEIPT_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|