| Name |
Datatype |
Length |
Prcn |
| USER_DOCUMENT_STATUS |
VARCHAR2
|
(30)
|
|
| VENDOR_SITE_ID |
NUMBER
|
|
|
| VENDOR_CONTACT_ID |
NUMBER
|
|
|
| SUPPLIER_NOTIF_METHOD |
VARCHAR2
|
(30)
|
|
| FAX |
VARCHAR2
|
(30)
|
|
| EMAIL_ADDRESS |
VARCHAR2
|
(2000)
|
|
| CLM_EXTERNAL_IDV |
VARCHAR2
|
(2000)
|
|
| CLM_VENDOR_OFFER_NUMBER |
VARCHAR2
|
(400)
|
|
| CLM_EFFECTIVE_DATE |
DATE
|
|
|
| AGENT_ID |
NUMBER
|
|
|
| CLM_AWARD_ADMINISTRATOR |
VARCHAR2
|
(400)
|
|
| COMMENTS |
VARCHAR2
|
(400)
|
|
| CONFIRMING_ORDER_FLAG |
VARCHAR2
|
(1)
|
|
| TERMS_ID |
NUMBER
|
|
|
| SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
| BILL_TO_LOCATION_ID |
NUMBER
|
|
|
| SHIP_VIA_LOOKUP_CODE |
VARCHAR2
|
(30)
|
|
| FREIGHT_TERMS_LOOKUP_CODE |
VARCHAR2
|
(30)
|
|
| FOB_LOOKUP_CODE |
VARCHAR2
|
(30)
|
|
| SHIPPING_CONTROL |
VARCHAR2
|
(30)
|
|
| NOTE_TO_VENDOR |
VARCHAR2
|
(500)
|
|
| NOTE_TO_RECEIVER |
VARCHAR2
|
(500)
|
|
| BLANKET_TOTAL_AMOUNT |
NUMBER
|
|
|
| PRICE_UPDATE_TOLERANCE |
NUMBER
|
|
|
| START_DATE |
DATE
|
|
|
| END_DATE |
DATE
|
|
|
| CLM_MAX_ORDER_AMOUNT |
NUMBER
|
|
|
| CLM_MIN_ORDER_AMOUNT |
NUMBER
|
|
|
| CLM_MIN_GUARANTEE_AWARD_AMT |
NUMBER
|
|
|
| CLM_MIN_GUAR_AWARD_AMT_PERCENT |
NUMBER
|
|
|
| AUTO_SOURCING_FLAG |
VARCHAR2
|
(1)
|
|
| UPDATE_SOURCING_RULES_FLAG |
VARCHAR2
|
(1)
|
|
| RETRO_PRICE_APPLY_UPDATES_FLAG |
VARCHAR2
|
(1)
|
|
| RETRO_PRICE_COMM_UPDATES_FLAG |
VARCHAR2
|
(1)
|
|
| 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)
|
|
| UMBRELLA_PROGRAM_ID |
NUMBER
|
|
|
| CLM_CONTRACT_FINANCE_CODE |
VARCHAR2
|
(30)
|
|
| CLM_PAYMENT_INSTR_CODE |
VARCHAR2
|
(30)
|
|