[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_VENDORS_OBS |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| Subobject Name: | |
| Status: | VALID |
PO_VENDORS stores information about your suppliers. You need one row for each supplier you define. Each row includes the supplier name as well as purchasing, receiving, payment, accounting, tax, classification,
and general information. Oracle Purchasing uses this information to determine active suppliers. VENDOR_ID is the unique system-generated
receipt header number invisible to the user. SEGMENT1 is the system-generated or manually assigned number you use to identify the supplier in forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate supplier numbers for you. This table is
one of three tables that store supplier information. PO_VENDORS corresponds to the Suppliers window.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_VENDORS_OBS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 VENDOR_ID
|
| PO_VENDORS_OBS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
VENDOR_NAME
|
| PO_VENDORS_OBS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SEGMENT1
|
| PO_VENDORS_OBS_F1 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("END_DATE_ACTIVE",TO_DATE('9999-12-31 00:00:00', 'yyyy-mm-dd hh24:mi:ss'))
|
| PO_VENDORS_OBS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EMPLOYEE_ID
|
| PO_VENDORS_OBS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NUM_1099
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VENDOR_ID | NUMBER | Yes | Supplier unique identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| VENDOR_NAME | VARCHAR2 | (240) | Yes | Supplier name |
| VENDOR_NAME_ALT | VARCHAR2 | (320) | Alternate supplier name for kana value | |
| SEGMENT1 | VARCHAR2 | (30) | Yes | Key flexfield segment |
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Key flexfield summary flag |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key flexfield summary flag |
| SEGMENT2 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (30) | Key flexfield segment | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| EMPLOYEE_ID | NUMBER | Employee unique identifier if the supplier is an employee | ||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Supplier type | |
| CUSTOMER_NUM | VARCHAR2 | (25) | Customer number with the supplier | |
| ONE_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the supplier is a one-time supplier | |
| PARENT_VENDOR_ID | NUMBER | Unique identifier of the parent supplier | ||
| MIN_ORDER_AMOUNT | NUMBER | Minimum purchase order amount | ||
| SHIP_TO_LOCATION_ID | NUMBER | Default ship-to location unique identifier | ||
| BILL_TO_LOCATION_ID | NUMBER | Default bill-to location unique identifier | ||
| SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Default carrier type | |
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | Default freight terms type | |
| FOB_LOOKUP_CODE | VARCHAR2 | (25) | Default free-on-board type | |
| TERMS_ID | NUMBER | Payment terms unique identifier | ||
| SET_OF_BOOKS_ID | NUMBER | Set of Books unique identifier | ||
| CREDIT_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| CREDIT_LIMIT | NUMBER | Not used | ||
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | (1) | Indicator of whether Oracle Payables should always take a discount for the supplier | |
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | (25) | Type of payment date basis | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Payment group type | |
| PAYMENT_PRIORITY | NUMBER | Payment priority | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Default currency unique identifier | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Default payment currency unique identifier | |
| INVOICE_AMOUNT_LIMIT | NUMBER | Maximum amount per invoice | ||
| EXCHANGE_DATE_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| HOLD_ALL_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place all payments for this supplier on hold or not | |
| HOLD_FUTURE_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place upapproved payments for this supplier on hold or not | |
| HOLD_REASON | VARCHAR2 | (240) | Reason for placing the supplier on payment hold | |
| DISTRIBUTION_SET_ID | NUMBER | Distribution set unique identifier | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | Unique identifier for the supplier liability account | ||
| DISC_LOST_CODE_COMBINATION_ID | NUMBER | No longer used | ||
| DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | No longer used | ||
| EXPENSE_CODE_COMBINATION_ID | NUMBER | Not used | ||
| PREPAY_CODE_COMBINATION_ID | NUMBER | Unique identifier for the general ledger account for prepayment | ||
| NUM_1099 | VARCHAR2 | (30) | Tax identification number | |
| TYPE_1099 | VARCHAR2 | (10) | Type of 1099 | |
| WITHHOLDING_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Withholding status type | |
| WITHHOLDING_START_DATE | DATE | Withholding start date | ||
| ORGANIZATION_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | IRS organization type | |
| VAT_CODE | VARCHAR2 | (15) | VAT code | |
| START_DATE_ACTIVE | DATE | Key flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key flexfield end date | ||
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Type of minority-owned business | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Default payment method type | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Name of the supplier bank account | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Number of the supplier bank account | |
| BANK_NUM | VARCHAR2 | (25) | Bank number for the supplier | |
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Type of bank account | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (1) | Indicates whether the supplier is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | Indicates that the supplier is a small business | |
| STANDARD_INDUSTRY_CLASS | VARCHAR2 | (25) | Standard industry classification number | |
| HOLD_FLAG | VARCHAR2 | (1) | Indicator of whether the supplier is on purchasing hold | |
| PURCHASING_HOLD_REASON | VARCHAR2 | (240) | Reason for placing the supplier on purchasing hold | |
| HOLD_BY | NUMBER | (9) | Unique identifier for the employee who placed the supplier on hold | |
| HOLD_DATE | DATE | Date the supplier was placed on purchasing hold | ||
| TERMS_DATE_BASIS | VARCHAR2 | (25) | Type of invoice payment schedule basis | |
| PRICE_TOLERANCE | NUMBER | Not used | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether inspection is required or not | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether shipment must be received before the invoice is paid | |
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (25) | Enforces, warns, or ignores quantity receiving tolerance | |
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Action to be taken when the receiving location differs from the ship-to location | |
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received early | ||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received late | ||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | Action to be taken when items are received earlier or later than the allowed number of days specified | |
| RECEIVING_ROUTING_ID | NUMBER | Receipt routing unique identifier | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | Indicates whether substitute items can be received in place of the ordered items | |
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | Indicates whether unordered receipts are allowed | |
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | Indicates whether unmatched invoices should be put on hold | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Indicates exclusive payment | |
| AP_TAX_ROUNDING_RULE | VARCHAR2 | (1) | Determines the rounding rule for tax values | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | Supplier level where the tax calculation is done | |
| AUTO_TAX_CALC_OVERRIDE | VARCHAR2 | (1) | Allows override of tax calculation at supplier site level | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Do amounts include tax from this supplier? | |
| TAX_VERIFICATION_DATE | DATE | Tax verification date | ||
| NAME_CONTROL | VARCHAR2 | (4) | Name control | |
| STATE_REPORTABLE_FLAG | VARCHAR2 | (1) | State reportable flag | |
| FEDERAL_REPORTABLE_FLAG | VARCHAR2 | (1) | Federal reportable flag | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| OFFSET_VAT_CODE | VARCHAR2 | (20) | No longer used | |
| VAT_REGISTRATION_NUM | VARCHAR2 | (20) | VAT registration number | |
| AUTO_CALCULATE_INTEREST_FLAG | VARCHAR2 | (1) | Indicates whether interest is to be automatically calculated | |
| VALIDATION_NUMBER | NUMBER | Validation number | ||
| EXCLUDE_FREIGHT_FROM_DISCOUNT | VARCHAR2 | (1) | Exclude supplier freight from discount amount | |
| TAX_REPORTING_NAME | VARCHAR2 | (80) | Tax reporting method name | |
| CHECK_DIGITS | VARCHAR2 | (30) | Check number used by Payables | |
| BANK_NUMBER | VARCHAR2 | (30) | Bank number for Accounts Payable | |
| ALLOW_AWT_FLAG | VARCHAR2 | (1) | Indicator of whether Allow Withholding Tax is enabled | |
| AWT_GROUP_ID | NUMBER | (15) | Unique identifier for the withholding tax group | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| EDI_TRANSACTION_HANDLING | VARCHAR2 | (25) | Defines whether this supplier is an EDI partner | |
| EDI_PAYMENT_METHOD | VARCHAR2 | (25) | How payment is to be made through EDI. Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT. | |
| EDI_PAYMENT_FORMAT | VARCHAR2 | (25) | Type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP. | |
| EDI_REMITTANCE_METHOD | VARCHAR2 | (25) | How remittance advice will be sent to the supplier | |
| EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (256) | Who will send the remittance advice. Valid values are Bank or payables system. | |
| BANK_CHARGE_BEARER | VARCHAR2 | (1) | Indicator of whether this supplier bears bank charges | |
| BANK_BRANCH_TYPE | VARCHAR2 | (25) | Which list the bank routing number is on. Valid type are ABA, CHIPS, SWIFT and OTHER. | |
| MATCH_OPTION | VARCHAR2 | (25) | Indicator of whether to match invoices to the purchase order or the receipt for this supplier | |
| FUTURE_DATED_PAYMENT_CCID | NUMBER | (15) | Accounting Flexfield identifier for the future dated payment account | |
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | (25) | Indicator of whether a debit memo should be created | |
| OFFSET_TAX_FLAG | VARCHAR2 | (1) | Indicator of whether the supplier uses offset taxes | |
| INDIVIDUAL_1099 | VARCHAR2 | (30) | ||
| UNIQUE_TAX_REFERENCE_NUM | NUMBER | (15) | Unique Tax Reference Number of the subcontractor | |
| PARTNERSHIP_UTR | NUMBER | (15) | Unique Tax Reference Number of the partnership | |
| PARTNERSHIP_NAME | VARCHAR2 | (240) | Partnership name | |
| CIS_ENABLED_FLAG | VARCHAR2 | (1) | CIS enabled flag | |
| FIRST_NAME | VARCHAR2 | (240) | First name of the Subcontractor | |
| SECOND_NAME | VARCHAR2 | (240) | Second name of the Subcontractor | |
| LAST_NAME | VARCHAR2 | (240) | Last name of the Subcontractor | |
| SALUTATION | VARCHAR2 | (30) | Salutation | |
| TRADING_NAME | VARCHAR2 | (240) | Trading name of the Subcontractor | |
| WORK_REFERENCE | VARCHAR2 | (30) | Work reference of the Subcontractor | |
| COMPANY_REGISTRATION_NUMBER | VARCHAR2 | (30) | Company Registration Number | |
| NATIONAL_INSURANCE_NUMBER | VARCHAR2 | (30) | National Insurance Number of the subcontractor | |
| VERIFICATION_NUMBER | VARCHAR2 | (30) | Verification Number returned by HMRC for the subcontractor | |
| VERIFICATION_REQUEST_ID | NUMBER | (15) | Verification concurrent request identifier | |
| MATCH_STATUS_FLAG | VARCHAR2 | (1) | Match status code returned by HMRC | |
| CIS_VERIFICATION_DATE | DATE | Date the subcontractor was verified | ||
| CIS_PARENT_VENDOR_ID | NUMBER | Parent Vendor id | ||
| BUS_CLASS_LAST_CERTIFIED_BY | NUMBER | bus class last certified by | ||
| BUS_CLASS_LAST_CERTIFIED_DATE | DATE | bus class last certified date |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, VENDOR_NAME
, VENDOR_NAME_ALT
, 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
, AP_TAX_ROUNDING_RULE
, AUTO_TAX_CALC_FLAG
, AUTO_TAX_CALC_OVERRIDE
, AMOUNT_INCLUDES_TAX_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
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EDI_TRANSACTION_HANDLING
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_FORMAT
, EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION
, BANK_CHARGE_BEARER
, BANK_BRANCH_TYPE
, MATCH_OPTION
, FUTURE_DATED_PAYMENT_CCID
, CREATE_DEBIT_MEMO_FLAG
, OFFSET_TAX_FLAG
, INDIVIDUAL_1099
, UNIQUE_TAX_REFERENCE_NUM
, PARTNERSHIP_UTR
, PARTNERSHIP_NAME
, CIS_ENABLED_FLAG
, FIRST_NAME
, SECOND_NAME
, LAST_NAME
, SALUTATION
, TRADING_NAME
, WORK_REFERENCE
, COMPANY_REGISTRATION_NUMBER
, NATIONAL_INSURANCE_NUMBER
, VERIFICATION_NUMBER
, VERIFICATION_REQUEST_ID
, MATCH_STATUS_FLAG
, CIS_VERIFICATION_DATE
, CIS_PARENT_VENDOR_ID
, BUS_CLASS_LAST_CERTIFIED_BY
, BUS_CLASS_LAST_CERTIFIED_DATE
FROM PO.PO_VENDORS_OBS;
PO.PO_VENDORS_OBS does not reference any database object
PO.PO_VENDORS_OBS is referenced by following:
APPS
PO_VENDORS_OBS
|
|
|
|