DBA Data[Home] [Help] [Dependency Information]


TABLE: AP.AP_SUPPLIER_SITES_ALL

Object Details
Object Name: AP_SUPPLIER_SITES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_SUPPLIER_SITES_ALL
Subobject Name:
Status: VALID


AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. You need a row for unique combination of supplier address, operating unit and the business relationship that you have with the supplier. This table relplaces the old PO_VENDOR_SITES_ALL table. The supplier address information is not maintained in this table and is maintained in TCA. The reference to the internal identifier of address in TCA will be stored in AP_SUPPLIER_SITES_ALL.LOCATION_ID, to link the address record in TCA. Each row includes the supplier reference, purchasing, invoice, and general information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_SUPPLIER_SITES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_ID
AP_SUPPLIER_SITES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_CODE
ColumnORG_ID
AP_SUPPLIER_SITES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_CODE
AP_SUPPLIER_SITES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_HEADER_ID
ColumnECE_TP_LOCATION_CODE
AP_SUPPLIER_SITES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECE_TP_LOCATION_CODE
AP_SUPPLIER_SITES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELLING_COMPANY_IDENTIFIER
AP_SUPPLIER_SITES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
AP_SUPPLIER_SITES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_SITE_ID
Columns
Name Datatype Length Mandatory Comments
VENDOR_SITE_ID NUMBER
Yes Supplier site unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
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
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
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 (60)
City name
STATE VARCHAR2 (150)
State name or abbreviation
ZIP VARCHAR2 (60)
Postal code
PROVINCE VARCHAR2 (150)
Province
COUNTRY VARCHAR2 (60)
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)
No longer used
BANK_ACCOUNT_NUM VARCHAR2 (30)
No longer used
BANK_NUM VARCHAR2 (25)
No longer used
BANK_ACCOUNT_TYPE VARCHAR2 (25)
No longer used
TERMS_DATE_BASIS VARCHAR2 (25)
Type of invoice payment schedule basis
CURRENT_CATALOG_NUM VARCHAR2 (20)
Not currently used
VAT_CODE VARCHAR2 (30)
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 segment
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

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
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

Operating unit unique identifier
CHECK_DIGITS VARCHAR2 (30)
Check digits for Accounts Payable
BANK_NUMBER VARCHAR2 (30)
No longer used
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)
No longer used
EDI_ID_NUMBER VARCHAR2 (30)
EDI Trading Partner Number for the Supplier Site
EDI_PAYMENT_METHOD VARCHAR2 (25)
No longer used
EDI_PAYMENT_FORMAT VARCHAR2 (25)
No longer used
EDI_REMITTANCE_METHOD VARCHAR2 (25)
No longer used
BANK_CHARGE_BEARER VARCHAR2 (1)
Indicator of whether this supplier site is a bank charge bearer site
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
No longer used
BANK_BRANCH_TYPE VARCHAR2 (25)
No longer used
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 Idetifier
LOCATION_ID NUMBER (15)
Location Identifier
PARTY_SITE_ID NUMBER (15)
Party Site Identifier
SERVICES_TOLERANCE_ID NUMBER (15)
Services Tolerance Identifier
RETAINAGE_RATE NUMBER

Maximum percentage that can be withheld from an invoice as Retainage
TCA_SYNC_STATE VARCHAR2 (150)
For internal use only
TCA_SYNC_PROVINCE VARCHAR2 (150)
For internal use only
TCA_SYNC_COUNTY VARCHAR2 (150)
For internal use only
TCA_SYNC_CITY VARCHAR2 (60)
For internal use only
TCA_SYNC_ZIP VARCHAR2 (60)
For internal use only
TCA_SYNC_COUNTRY VARCHAR2 (60)
For internal use only
PAY_AWT_GROUP_ID NUMBER (15)
Payment AWT Group ID
CAGE_CODE VARCHAR2 (5)
CAGE Code of Site
LEGAL_BUSINESS_NAME VARCHAR2 (240)
Legal Business Name of Supplier Site as per CCR records(If site is a CCRSite)
DOING_BUS_AS_NAME VARCHAR2 (240)
Doing Business as Name as per CCR records(If site is a CCR Site)
DIVISION_NAME VARCHAR2 (60)
Division Name as per CCR records(If site is a CCR Site)
SMALL_BUSINESS_CODE VARCHAR2 (10)
Small Business code for Supplier site. Values will be 'Small' or 'Other then Small'
CCR_COMMENTS VARCHAR2 (240)
Comments provided to Site as per CCR Records (If site is a CCR Site)
DEBARMENT_START_DATE DATE

Debarment Start Date for Supplier site
DEBARMENT_END_DATE DATE

Debarment End Date for Supplier Site
Query Text

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
,      LOCATION_ID
,      PARTY_SITE_ID
,      SERVICES_TOLERANCE_ID
,      RETAINAGE_RATE
,      TCA_SYNC_STATE
,      TCA_SYNC_PROVINCE
,      TCA_SYNC_COUNTY
,      TCA_SYNC_CITY
,      TCA_SYNC_ZIP
,      TCA_SYNC_COUNTRY
,      PAY_AWT_GROUP_ID
,      CAGE_CODE
,      LEGAL_BUSINESS_NAME
,      DOING_BUS_AS_NAME
,      DIVISION_NAME
,      SMALL_BUSINESS_CODE
,      CCR_COMMENTS
,      DEBARMENT_START_DATE
,      DEBARMENT_END_DATE
FROM AP.AP_SUPPLIER_SITES_ALL;

Dependencies

[top of page]

AP.AP_SUPPLIER_SITES_ALL does not reference any database object

AP.AP_SUPPLIER_SITES_ALL is referenced by following:

SchemaAP
ViewAP_SUPPLIER_SITES_ALL#