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