| 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
|
|
|
[Home] [Help]
[Dependency Information]
APPS
STANDARD
- show dependent code
POS_AP_SUPPLIER_BO_PKG
- show dependent code