View: ICX_PO_VENDORS_V

View Text

SELECT "VENDOR_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "VENDOR_NAME"
, "SEGMENT1"
, "SUMMARY_FLAG"
, "ENABLED_FLAG"
, "SEGMENT2"
, "SEGMENT3"
, "SEGMENT4"
, "SEGMENT5"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
, "CREATED_BY"
, "EMPLOYEE_ID"
, "VENDOR_TYPE_LOOKUP_CODE"
, "CUSTOMER_NUM"
, "ONE_TIME_FLAG"
, "PARENT_VENDOR_ID"
, "MIN_ORDER_AMOUNT"
, "SHIP_TO_LOCATION_ID"
, "BILL_TO_LOCATION_ID"
, "SHIP_VIA_LOOKUP_CODE"
, "FREIGHT_TERMS_LOOKUP_CODE"
, "FOB_LOOKUP_CODE"
, "TERMS_ID"
, "SET_OF_BOOKS_ID"
, "CREDIT_STATUS_LOOKUP_CODE"
, "CREDIT_LIMIT"
, "ALWAYS_TAKE_DISC_FLAG"
, "PAY_DATE_BASIS_LOOKUP_CODE"
, "PAY_GROUP_LOOKUP_CODE"
, "PAYMENT_PRIORITY"
, "INVOICE_CURRENCY_CODE"
, "PAYMENT_CURRENCY_CODE"
, "INVOICE_AMOUNT_LIMIT"
, "EXCHANGE_DATE_LOOKUP_CODE"
, "HOLD_ALL_PAYMENTS_FLAG"
, "HOLD_FUTURE_PAYMENTS_FLAG"
, "HOLD_REASON"
, "DISTRIBUTION_SET_ID"
, "ACCTS_PAY_CODE_COMBINATION_ID"
, "DISC_LOST_CODE_COMBINATION_ID"
, "DISC_TAKEN_CODE_COMBINATION_ID"
, "EXPENSE_CODE_COMBINATION_ID"
, "PREPAY_CODE_COMBINATION_ID"
, "NUM_1099"
, "TYPE_1099"
, "WITHHOLDING_STATUS_LOOKUP_CODE"
, "WITHHOLDING_START_DATE"
, "ORGANIZATION_TYPE_LOOKUP_CODE"
, "VAT_CODE"
, "START_DATE_ACTIVE"
, "END_DATE_ACTIVE"
, "MINORITY_GROUP_LOOKUP_CODE"
, "PAYMENT_METHOD_LOOKUP_CODE"
, "BANK_ACCOUNT_NAME"
, "BANK_ACCOUNT_NUM"
, "BANK_NUM"
, "BANK_ACCOUNT_TYPE"
, "WOMEN_OWNED_FLAG"
, "SMALL_BUSINESS_FLAG"
, "STANDARD_INDUSTRY_CLASS"
, "HOLD_FLAG"
, "PURCHASING_HOLD_REASON"
, "HOLD_BY"
, "HOLD_DATE"
, "TERMS_DATE_BASIS"
, "PRICE_TOLERANCE"
, "INSPECTION_REQUIRED_FLAG"
, "RECEIPT_REQUIRED_FLAG"
, "QTY_RCV_TOLERANCE"
, "QTY_RCV_EXCEPTION_CODE"
, "ENFORCE_SHIP_TO_LOCATION_CODE"
, "DAYS_EARLY_RECEIPT_ALLOWED"
, "DAYS_LATE_RECEIPT_ALLOWED"
, "RECEIPT_DAYS_EXCEPTION_CODE"
, "RECEIVING_ROUTING_ID"
, "ALLOW_SUBSTITUTE_RECEIPTS_FLAG"
, "ALLOW_UNORDERED_RECEIPTS_FLAG"
, "HOLD_UNMATCHED_INVOICES_FLAG"
, "EXCLUSIVE_PAYMENT_FLAG"
, "TAX_VERIFICATION_DATE"
, "NAME_CONTROL"
, "STATE_REPORTABLE_FLAG"
, "FEDERAL_REPORTABLE_FLAG"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "OFFSET_VAT_CODE"
, "VAT_REGISTRATION_NUM"
, "AUTO_CALCULATE_INTEREST_FLAG"
, "VALIDATION_NUMBER"
, "EXCLUDE_FREIGHT_FROM_DISCOUNT"
, "TAX_REPORTING_NAME"
, "CHECK_DIGITS"
, "BANK_NUMBER"
, "ALLOW_AWT_FLAG"
, "AWT_GROUP_ID"
FROM PO_VENDORS

Columns