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