Name |
Datatype |
Length |
Prcn |
VENDOR_ID |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
VENDOR_NAME |
VARCHAR2
|
(240)
|
|
VENDOR_NAME_ALT |
VARCHAR2
|
(320)
|
|
SEGMENT1 |
VARCHAR2
|
(30)
|
|
SUMMARY_FLAG |
VARCHAR2
|
(1)
|
|
ENABLED_FLAG |
VARCHAR2
|
(1)
|
|
SEGMENT2 |
VARCHAR2
|
(30)
|
|
SEGMENT3 |
VARCHAR2
|
(30)
|
|
SEGMENT4 |
VARCHAR2
|
(30)
|
|
SEGMENT5 |
VARCHAR2
|
(30)
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
CREATED_BY |
NUMBER
|
|
|
EMPLOYEE_ID |
NUMBER
|
|
|
VENDOR_TYPE_LOOKUP_CODE |
VARCHAR2
|
(30)
|
|
CUSTOMER_NUM |
VARCHAR2
|
(25)
|
|
ONE_TIME_FLAG |
VARCHAR2
|
(1)
|
|
PARENT_VENDOR_ID |
NUMBER
|
|
|
MIN_ORDER_AMOUNT |
NUMBER
|
|
|
SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
BILL_TO_LOCATION_ID |
NUMBER
|
|
|
SHIP_VIA_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
FREIGHT_TERMS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
FOB_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
TERMS_ID |
NUMBER
|
|
|
SET_OF_BOOKS_ID |
NUMBER
|
|
|
CREDIT_STATUS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
CREDIT_LIMIT |
NUMBER
|
|
|
ALWAYS_TAKE_DISC_FLAG |
VARCHAR2
|
(1)
|
|
PAY_DATE_BASIS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
PAY_GROUP_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
PAYMENT_PRIORITY |
NUMBER
|
|
|
INVOICE_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
PAYMENT_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
INVOICE_AMOUNT_LIMIT |
NUMBER
|
|
|
EXCHANGE_DATE_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
HOLD_ALL_PAYMENTS_FLAG |
VARCHAR2
|
(1)
|
|
HOLD_FUTURE_PAYMENTS_FLAG |
VARCHAR2
|
(1)
|
|
HOLD_REASON |
VARCHAR2
|
(240)
|
|
DISTRIBUTION_SET_ID |
NUMBER
|
|
|
ACCTS_PAY_CODE_COMBINATION_ID |
NUMBER
|
|
|
DISC_LOST_CODE_COMBINATION_ID |
NUMBER
|
|
|
DISC_TAKEN_CODE_COMBINATION_ID |
NUMBER
|
|
|
EXPENSE_CODE_COMBINATION_ID |
NUMBER
|
|
|
PREPAY_CODE_COMBINATION_ID |
NUMBER
|
|
|
NUM_1099 |
VARCHAR2
|
(30)
|
|
TYPE_1099 |
VARCHAR2
|
(10)
|
|
WITHHOLDING_STATUS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
WITHHOLDING_START_DATE |
DATE
|
|
|
ORGANIZATION_TYPE_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
VAT_CODE |
VARCHAR2
|
(30)
|
|
START_DATE_ACTIVE |
DATE
|
|
|
END_DATE_ACTIVE |
DATE
|
|
|
MINORITY_GROUP_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
PAYMENT_METHOD_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
BANK_ACCOUNT_NAME |
VARCHAR2
|
(80)
|
|
BANK_ACCOUNT_NUM |
VARCHAR2
|
(30)
|
|
BANK_NUM |
VARCHAR2
|
(25)
|
|
BANK_ACCOUNT_TYPE |
VARCHAR2
|
(25)
|
|
WOMEN_OWNED_FLAG |
VARCHAR2
|
(1)
|
|
SMALL_BUSINESS_FLAG |
VARCHAR2
|
(1)
|
|
STANDARD_INDUSTRY_CLASS |
VARCHAR2
|
(25)
|
|
HOLD_FLAG |
VARCHAR2
|
(1)
|
|
PURCHASING_HOLD_REASON |
VARCHAR2
|
(240)
|
|
HOLD_BY |
NUMBER
|
|
9 |
HOLD_DATE |
DATE
|
|
|
TERMS_DATE_BASIS |
VARCHAR2
|
(25)
|
|
PRICE_TOLERANCE |
NUMBER
|
|
|
INSPECTION_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
RECEIPT_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
QTY_RCV_TOLERANCE |
NUMBER
|
|
|
QTY_RCV_EXCEPTION_CODE |
VARCHAR2
|
(25)
|
|
ENFORCE_SHIP_TO_LOCATION_CODE |
VARCHAR2
|
(25)
|
|
DAYS_EARLY_RECEIPT_ALLOWED |
NUMBER
|
|
|
DAYS_LATE_RECEIPT_ALLOWED |
NUMBER
|
|
|
RECEIPT_DAYS_EXCEPTION_CODE |
VARCHAR2
|
(25)
|
|
RECEIVING_ROUTING_ID |
NUMBER
|
|
|
ALLOW_SUBSTITUTE_RECEIPTS_FLAG |
VARCHAR2
|
(1)
|
|
ALLOW_UNORDERED_RECEIPTS_FLAG |
VARCHAR2
|
(1)
|
|
HOLD_UNMATCHED_INVOICES_FLAG |
VARCHAR2
|
(1)
|
|
EXCLUSIVE_PAYMENT_FLAG |
VARCHAR2
|
(1)
|
|
AP_TAX_ROUNDING_RULE |
VARCHAR2
|
(1)
|
|
AUTO_TAX_CALC_FLAG |
VARCHAR2
|
(1)
|
|
AUTO_TAX_CALC_OVERRIDE |
VARCHAR2
|
(1)
|
|
AMOUNT_INCLUDES_TAX_FLAG |
VARCHAR2
|
(1)
|
|
TAX_VERIFICATION_DATE |
DATE
|
|
|
NAME_CONTROL |
VARCHAR2
|
(4)
|
|
STATE_REPORTABLE_FLAG |
VARCHAR2
|
(1)
|
|
FEDERAL_REPORTABLE_FLAG |
VARCHAR2
|
(1)
|
|
ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
REQUEST_ID |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
OFFSET_VAT_CODE |
VARCHAR2
|
(20)
|
|
VAT_REGISTRATION_NUM |
VARCHAR2
|
(20)
|
|
AUTO_CALCULATE_INTEREST_FLAG |
VARCHAR2
|
(1)
|
|
VALIDATION_NUMBER |
NUMBER
|
|
|
EXCLUDE_FREIGHT_FROM_DISCOUNT |
VARCHAR2
|
(1)
|
|
TAX_REPORTING_NAME |
VARCHAR2
|
(80)
|
|
CHECK_DIGITS |
VARCHAR2
|
(30)
|
|
BANK_NUMBER |
VARCHAR2
|
(30)
|
|
ALLOW_AWT_FLAG |
VARCHAR2
|
(1)
|
|
AWT_GROUP_ID |
NUMBER
|
|
15 |
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE16 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE17 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE18 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE19 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE20 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
EDI_TRANSACTION_HANDLING |
VARCHAR2
|
(25)
|
|
EDI_PAYMENT_METHOD |
VARCHAR2
|
(25)
|
|
EDI_PAYMENT_FORMAT |
VARCHAR2
|
(25)
|
|
EDI_REMITTANCE_METHOD |
VARCHAR2
|
(25)
|
|
EDI_REMITTANCE_INSTRUCTION |
VARCHAR2
|
(256)
|
|
BANK_CHARGE_BEARER |
VARCHAR2
|
(1)
|
|
BANK_BRANCH_TYPE |
VARCHAR2
|
(25)
|
|
MATCH_OPTION |
VARCHAR2
|
(25)
|
|
FUTURE_DATED_PAYMENT_CCID |
NUMBER
|
|
15 |
CREATE_DEBIT_MEMO_FLAG |
VARCHAR2
|
(25)
|
|
OFFSET_TAX_FLAG |
VARCHAR2
|
(1)
|
|
PARTY_ID |
NUMBER
|
|
|
PARENT_PARTY_ID |
NUMBER
|
|
|
TCA_SYNC_NUM_1099 |
VARCHAR2
|
(30)
|
|
TCA_SYNC_VENDOR_NAME |
VARCHAR2
|
(360)
|
|
TCA_SYNC_VAT_REG_NUM |
VARCHAR2
|
(50)
|
|
INDIVIDUAL_1099 |
VARCHAR2
|
(30)
|
|
UNIQUE_TAX_REFERENCE_NUM |
NUMBER
|
|
15 |
PARTNERSHIP_UTR |
NUMBER
|
|
15 |
PARTNERSHIP_NAME |
VARCHAR2
|
(240)
|
|
CIS_ENABLED_FLAG |
VARCHAR2
|
(1)
|
|
FIRST_NAME |
VARCHAR2
|
(240)
|
|
SECOND_NAME |
VARCHAR2
|
(240)
|
|
LAST_NAME |
VARCHAR2
|
(240)
|
|
SALUTATION |
VARCHAR2
|
(30)
|
|
TRADING_NAME |
VARCHAR2
|
(240)
|
|
WORK_REFERENCE |
VARCHAR2
|
(30)
|
|
COMPANY_REGISTRATION_NUMBER |
VARCHAR2
|
(30)
|
|
NATIONAL_INSURANCE_NUMBER |
VARCHAR2
|
(30)
|
|
VERIFICATION_NUMBER |
VARCHAR2
|
(30)
|
|
VERIFICATION_REQUEST_ID |
NUMBER
|
|
15 |
MATCH_STATUS_FLAG |
VARCHAR2
|
(1)
|
|
CIS_VERIFICATION_DATE |
DATE
|
|
|
PAY_AWT_GROUP_ID |
NUMBER
|
|
15 |
CIS_PARENT_VENDOR_ID |
NUMBER
|
|
|
P_POS_EXTERNAL_PAYEE_BO |
POS_EXTERNAL_PAYEE_BO
|
|
|
P_POS_SUPP_UDA_OBJ_TBL |
POS_SUPP_UDA_OBJ_TBL
|
|
|