[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_VENDOR_SITES_OBS |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| Subobject Name: | |
| Status: | VALID |
PO_VENDOR_SITES_ALL stores information about your supplier sites. You
need a row for each supplier site you define. Each row includes the
site address, supplier reference, purchasing, payment, bank, and
general information. Oracle Purchasing uses this information to
store supplier address information.
.
This table is one of three tables that store supplier information.
PO_VENDOR_SITES_ALL corresponds to the Sites region of the
Suppliers window.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_VENDOR_SITES_OBS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 VENDOR_SITE_ID
|
| PO_VENDOR_SITES_OBS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
VENDOR_SITE_CODE
ORG_ID
|
| PO_VENDOR_SITES_OBS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_SITE_CODE
|
| PO_VENDOR_SITES_OBS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TP_HEADER_ID
ECE_TP_LOCATION_CODE
|
| PO_VENDOR_SITES_OBS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ECE_TP_LOCATION_CODE
|
| PO_VENDOR_SITES_OBS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SELLING_COMPANY_IDENTIFIER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VENDOR_SITE_ID | NUMBER | Yes | Supplier site 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_ID | NUMBER | Yes | Supplier unique identifier | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Yes | Site code name |
| VENDOR_SITE_CODE_ALT | VARCHAR2 | (320) | Alternate supplier site code for Kana Value | |
| 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). | ||
| PURCHASING_SITE_FLAG | VARCHAR2 | (1) | Indicates whether you can purchase from this site | |
| RFQ_ONLY_SITE_FLAG | VARCHAR2 | (1) | Indicates whether you can only send RFQs to this site | |
| PAY_SITE_FLAG | VARCHAR2 | (1) | Indicates whether you can send payments to this site | |
| ATTENTION_AR_FLAG | VARCHAR2 | (1) | Indicates whether the payments should be sent to the Accounts Receivable department | |
| ADDRESS_LINE1 | VARCHAR2 | (240) | First line of supplier address | |
| ADDRESS_LINES_ALT | VARCHAR2 | (560) | Alternate address line for Kana Value | |
| ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of supplier address | |
| ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of supplier address | |
| CITY | VARCHAR2 | (25) | City name | |
| STATE | VARCHAR2 | (150) | State name or abbreviation | |
| ZIP | VARCHAR2 | (20) | Postal code | |
| PROVINCE | VARCHAR2 | (150) | Province | |
| COUNTRY | VARCHAR2 | (25) | Country name | |
| AREA_CODE | VARCHAR2 | (10) | Area code | |
| PHONE | VARCHAR2 | (15) | Phone number | |
| CUSTOMER_NUM | VARCHAR2 | (25) | Customer number with the supplier site | |
| SHIP_TO_LOCATION_ID | NUMBER | Default ship-to location unique identifier | ||
| BILL_TO_LOCATION_ID | NUMBER | Ship-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 | |
| INACTIVE_DATE | DATE | Inactive date for record | ||
| FAX | VARCHAR2 | (15) | Customer site facsimile number | |
| FAX_AREA_CODE | VARCHAR2 | (10) | Customer site | |
| TELEX | VARCHAR2 | (15) | Telex number | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Default payment method type | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Bank account name | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank account number | |
| BANK_NUM | VARCHAR2 | (25) | Bank number | |
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Bank account type | |
| TERMS_DATE_BASIS | VARCHAR2 | (25) | Type of invoice payment schedule basis | |
| CURRENT_CATALOG_NUM | VARCHAR2 | (20) | Not currently used | |
| VAT_CODE | VARCHAR2 | (20) | Value-added tax code | |
| DISTRIBUTION_SET_ID | NUMBER | Distribution set unique identifier | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | Unique identifier for the supplier liability account | ||
| PREPAY_CODE_COMBINATION_ID | NUMBER | Unique identifier for the general ledger account for prepayment | ||
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Payment group type | |
| PAYMENT_PRIORITY | NUMBER | Payment priority | ||
| TERMS_ID | NUMBER | Payment terms unique identifier | ||
| INVOICE_AMOUNT_LIMIT | NUMBER | Maximum amount per invoice | ||
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | (25) | Type of payment date basis | |
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | (1) | Indicator of whether Oracle Payables should always take a discount for the supplier | |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Default currency unique identifier | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Default payment currency unique identifier | |
| HOLD_ALL_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place all payments for this supplier on hold | |
| HOLD_FUTURE_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold | |
| HOLD_REASON | VARCHAR2 | (240) | Reason that the Supplier Site has been placed on hold | |
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | Indicates whether unmatched invoices should be put on hold | |
| AP_TAX_ROUNDING_RULE | VARCHAR2 | (1) | Indicates the rounding rule for tax values | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | Level for automatic tax calculation for supplier | |
| 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? | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Exclusive payment flag | |
| TAX_REPORTING_SITE_FLAG | VARCHAR2 | (1) | Tax reporting site 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). | ||
| VALIDATION_NUMBER | NUMBER | Validation number | ||
| EXCLUDE_FREIGHT_FROM_DISCOUNT | VARCHAR2 | (1) | Indicates whether the freight amount is to be excluded from the discount | |
| VAT_REGISTRATION_NUM | VARCHAR2 | (20) | VAT registration number | |
| OFFSET_VAT_CODE | VARCHAR2 | (20) | Offset VAT code | |
| ORG_ID | NUMBER | Organization identifier | ||
| CHECK_DIGITS | VARCHAR2 | (30) | Check digits for Accounts Payable | |
| BANK_NUMBER | VARCHAR2 | (30) | Bank number for Accounts Payable | |
| ADDRESS_LINE4 | VARCHAR2 | (240) | Fourth line of address | |
| COUNTY | VARCHAR2 | (150) | Supplier site county | |
| ADDRESS_STYLE | VARCHAR2 | (30) | Style of address | |
| LANGUAGE | VARCHAR2 | (30) | Site language | |
| 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) | ANSI standard code for EDI transaction type | |
| EDI_ID_NUMBER | VARCHAR2 | (30) | EDI trading partner number for the supplier site | |
| EDI_PAYMENT_METHOD | VARCHAR2 | (25) | How payment is to be made through EDI. Valid method are ACH and BOP. | |
| EDI_PAYMENT_FORMAT | VARCHAR2 | (25) | Type of information being transmitted with the funds if using EDI_PATMENT_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 | |
| BANK_CHARGE_BEARER | VARCHAR2 | (1) | Indicator of whether this supplier site is a bank charge bearer site | |
| EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (256) | Who will send the remittance advice. Valid values are banks or payables systems. | |
| BANK_BRANCH_TYPE | VARCHAR2 | (25) | Which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, and OTHER. | |
| PAY_ON_CODE | VARCHAR2 | (25) | When to create an invoice. Currently, the code 'RECEIPT' is used. Future enhancements could include 'DELIVERY'. | |
| DEFAULT_PAY_SITE_ID | NUMBER | (15) | Payment site for the site in which the receipt was entered. | |
| PAY_ON_RECEIPT_SUMMARY_CODE | VARCHAR2 | (25) | If the PAY_ON_CODE is 'RECEIPT', then this column identifies how to consolidate the receipts to create invoices. Valid values are PAY_SITE, PACKING_SLIP, and RECEIPT. | |
| TP_HEADER_ID | NUMBER | EDI transaction header unique identifier | ||
| ECE_TP_LOCATION_CODE | VARCHAR2 | (60) | Trading partner location code for e-Commerce Gateway | |
| PCARD_SITE_FLAG | VARCHAR2 | (1) | Indicator of whether the site allows use of procurement cards | |
| MATCH_OPTION | VARCHAR2 | (25) | Indicator of whether to match the invoices to the purchase order or receipt | |
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Code for the country of manufacture | |
| 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 offset tax is used | |
| SUPPLIER_NOTIF_METHOD | VARCHAR2 | (25) | The preferred Notification Method for the supplier | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | Email Address of the supplier Contact | |
| REMITTANCE_EMAIL | VARCHAR2 | (2000) | The destination e-mail address for remittance information. Populating this field activates the E-mail Remittance Advice feature in Payables | |
| PRIMARY_PAY_SITE_FLAG | VARCHAR2 | (1) | A value of Y indicates that this is the default pay site for the supplier | |
| SHIPPING_CONTROL | VARCHAR2 | (30) | Indicator of who is responsible for arranging transportation | |
| SELLING_COMPANY_IDENTIFIER | VARCHAR2 | (10) | Selling Company Identifier used in generating invoice numbers when gapless invoice numbering is enabled | |
| GAPLESS_INV_NUM_FLAG | VARCHAR2 | (1) | Indicates whether gapless invoice numbering is used | |
| DUNS_NUMBER | VARCHAR2 | (30) | DUNS Number | |
| TOLERANCE_ID | NUMBER | (15) | Tolerance Unique Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_SITE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, VENDOR_ID
, VENDOR_SITE_CODE
, VENDOR_SITE_CODE_ALT
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PURCHASING_SITE_FLAG
, RFQ_ONLY_SITE_FLAG
, PAY_SITE_FLAG
, ATTENTION_AR_FLAG
, ADDRESS_LINE1
, ADDRESS_LINES_ALT
, ADDRESS_LINE2
, ADDRESS_LINE3
, CITY
, STATE
, ZIP
, PROVINCE
, COUNTRY
, AREA_CODE
, PHONE
, CUSTOMER_NUM
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, FOB_LOOKUP_CODE
, INACTIVE_DATE
, FAX
, FAX_AREA_CODE
, TELEX
, PAYMENT_METHOD_LOOKUP_CODE
, BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM
, BANK_NUM
, BANK_ACCOUNT_TYPE
, TERMS_DATE_BASIS
, CURRENT_CATALOG_NUM
, VAT_CODE
, DISTRIBUTION_SET_ID
, ACCTS_PAY_CODE_COMBINATION_ID
, PREPAY_CODE_COMBINATION_ID
, PAY_GROUP_LOOKUP_CODE
, PAYMENT_PRIORITY
, TERMS_ID
, INVOICE_AMOUNT_LIMIT
, PAY_DATE_BASIS_LOOKUP_CODE
, ALWAYS_TAKE_DISC_FLAG
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, HOLD_ALL_PAYMENTS_FLAG
, HOLD_FUTURE_PAYMENTS_FLAG
, HOLD_REASON
, HOLD_UNMATCHED_INVOICES_FLAG
, AP_TAX_ROUNDING_RULE
, AUTO_TAX_CALC_FLAG
, AUTO_TAX_CALC_OVERRIDE
, AMOUNT_INCLUDES_TAX_FLAG
, EXCLUSIVE_PAYMENT_FLAG
, TAX_REPORTING_SITE_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
, VALIDATION_NUMBER
, EXCLUDE_FREIGHT_FROM_DISCOUNT
, VAT_REGISTRATION_NUM
, OFFSET_VAT_CODE
, ORG_ID
, CHECK_DIGITS
, BANK_NUMBER
, ADDRESS_LINE4
, COUNTY
, ADDRESS_STYLE
, LANGUAGE
, 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_ID_NUMBER
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_FORMAT
, EDI_REMITTANCE_METHOD
, BANK_CHARGE_BEARER
, EDI_REMITTANCE_INSTRUCTION
, BANK_BRANCH_TYPE
, PAY_ON_CODE
, DEFAULT_PAY_SITE_ID
, PAY_ON_RECEIPT_SUMMARY_CODE
, TP_HEADER_ID
, ECE_TP_LOCATION_CODE
, PCARD_SITE_FLAG
, MATCH_OPTION
, COUNTRY_OF_ORIGIN_CODE
, FUTURE_DATED_PAYMENT_CCID
, CREATE_DEBIT_MEMO_FLAG
, OFFSET_TAX_FLAG
, SUPPLIER_NOTIF_METHOD
, EMAIL_ADDRESS
, REMITTANCE_EMAIL
, PRIMARY_PAY_SITE_FLAG
, SHIPPING_CONTROL
, SELLING_COMPANY_IDENTIFIER
, GAPLESS_INV_NUM_FLAG
, DUNS_NUMBER
, TOLERANCE_ID
FROM PO.PO_VENDOR_SITES_OBS;
PO.PO_VENDOR_SITES_OBS does not reference any database object
PO.PO_VENDOR_SITES_OBS is referenced by following:
APPS
PO_VENDOR_SITES_OBS
|
|
|
|