1. Tables and Views for Procurement
  2. POZ_SUPPLIER_SITES_INT

POZ_SUPPLIER_SITES_INT

This table holds Supplier Site information which is loaded by the user for import. The columns in the table map to corresponding columns in POZ_SUPPLIER_SITES_ALL_M table. Supplier import application uses this information to create a new Supplier Site record. Each row in the table will be joined to the appropriate Supplier using the VENDOR_ID column.This is the open interface table for POZ Supplier Sites. Use it in conjunction with POZ_SUPPLIERS_INT table.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POZ_SUPPLIER_SITES_INT_PK

VENDOR_SITE_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
VENDOR_SITE_INTERFACE_ID NUMBER 18 Yes Vendor site interface identifier
OVERRIDE_B2B_COMM_CODE VARCHAR2 30 Captures specific criterion to override the supplier site B2B communication for purchasing documents.
BATCH_ID VARCHAR2 200 An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing.
REQUEST_SOURCE VARCHAR2 15 Signifies whether the request is from import or through a web service.
REMITTANCE_FAX VARCHAR2 15 Fax number at which the payee wishes to receive remittance advice.
VENDOR_SITE_ID NUMBER 18 Site unique identifier. Valid only for UPDATE action.
PARTY_SITE_ID NUMBER 18 Party Site Identifier
PARTY_SITE_NAME VARCHAR2 240 User-defined name for the site
VENDOR_INTERFACE_ID NUMBER 18 Supplier interface record unique identifier
VENDOR_ID NUMBER 18 Supplier unique identifier
VENDOR_NAME VARCHAR2 360 Supplier Name
VENDOR_SITE_CODE VARCHAR2 240 Site name
VENDOR_SITE_CODE_NEW VARCHAR2 240 New value provided for supplier site name. Valid only for UPDATE action.
VENDOR_SITE_CODE_ALT VARCHAR2 320 Alternate supplier site code
PRC_BU_ID NUMBER 18 Procurement business unit identifier
PROCUREMENT_BUSINESS_UNIT_NAME VARCHAR2 240 Procurement business unit name
IMPORT_REQUEST_ID NUMBER 18 Import request identifier
STATUS VARCHAR2 30 Status
IMPORT_ACTION VARCHAR2 10 Indicates whether the record is to be created or updated via import. Valid values are CREATE and UPDATE.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
PURCHASING_SITE_FLAG VARCHAR2 1 Indicates whether purchasing is allowed from this site
RFQ_ONLY_SITE_FLAG VARCHAR2 1 Indicates whether or not this site only accepts RFQs
PAY_SITE_FLAG VARCHAR2 1 Indicates whether or not payments are allowed to this site
ATTENTION_AR_FLAG VARCHAR2 1 Indicates whether payments are to be sent to the Accounts Receivable department
ADDRESS_LINE1 VARCHAR2 240 Obsolete- First line of supplier address Obsolete
ADDRESS_LINES_ALT VARCHAR2 560 Obsolete- Alternate address line Obsolete
ADDRESS_LINE2 VARCHAR2 240 Obsolete- Second line of supplier address Obsolete
ADDRESS_LINE3 VARCHAR2 240 Obsolete- Third line of supplier address Obsolete
ADDRESS_LINE4 VARCHAR2 240 Obsolete- Fourth line of supplier address Obsolete
CITY VARCHAR2 60 Obsolete- City name Obsolete
STATE VARCHAR2 60 Obsolete- State name or abbreviation Obsolete
ZIP VARCHAR2 60 Obsolete- Postal code Obsolete
POSTAL_PLUS4_CODE VARCHAR2 10 Obsolete- Four digit extension to the United States Postal ZIP code. Obsolete
PROVINCE VARCHAR2 60 Obsolete- Province Obsolete
COUNTRY VARCHAR2 60 Obsolete- Country name Obsolete
COUNTY VARCHAR2 60 Obsolete- County Obsolete
AREA_CODE VARCHAR2 10 Area code
PHONE VARCHAR2 15 Phone
CUSTOMER_NUM VARCHAR2 25 Customer number with the supplier site
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 30 Default freight terms type
FOB_LOOKUP_CODE VARCHAR2 25 Default free-on-board type
FAX VARCHAR2 15 Supplier site facsimile number
FAX_AREA_CODE VARCHAR2 10 Supplier site area code for facsimile number
TERMS_DATE_BASIS VARCHAR2 25 Date from which Payables calculates a scheduled payment
PAY_GROUP_LOOKUP_CODE VARCHAR2 25 Pyament group type
PAYMENT_PRIORITY NUMBER Payment priority
TERMS_ID NUMBER 18 Payment terms unique identifier
TERMS_NAME VARCHAR2 50 Payment terms name
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 Indicates if Oracle Payables should always take discount from 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 if Oracle Payables should place payments for this supplier on hold
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 1 Indicates if Oracle Payables should put all payments for this supplier on hold
HOLD_REASON VARCHAR2 240 Reason for placing the supplier on payment hold
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 1 Indicates if unmatched invoices should be put on hold
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 1 Level of automatic tax calculation for supplier
HOLD_BY NUMBER 18 Hold by
HOLD_DATE DATE Hold date
HOLD_FLAG VARCHAR2 1 Hold flag
PURCHASING_HOLD_REASON VARCHAR2 240 Hold reason for purchasing
TAX_REPORTING_SITE_FLAG VARCHAR2 1 Indicates whether or not this site is 1099 reporting site
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 1 Indicates if the freight amount is to be excluded from discount
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PAY_ON_CODE VARCHAR2 25 When to create an invoice.
DEFAULT_PAY_SITE_ID NUMBER 18 Payment site for the site in which the receipt was entered
DEFAULT_PAY_SITE_CODE VARCHAR2 15 Payment site code 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
PCARD_SITE_FLAG VARCHAR2 1 Indicates whether or not the site allows use of procurement cards
MATCH_OPTION VARCHAR2 25 Indicates whether invoices are matched to a purchase order or to a receipt
MATCH_APPROVAL_LEVEL VARCHAR2 1 Describes the match approval level of the supplier
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code of country of manufacture
CREATE_DEBIT_MEMO_FLAG VARCHAR2 25 Indicates if a Debit memo should be created when goods are returned to supplier
SUPPLIER_NOTIF_METHOD VARCHAR2 25 The preferred notification method for the supplier
EMAIL_ADDRESS VARCHAR2 2000 E-mail address of the supplier contact
PRIMARY_PAY_SITE_FLAG VARCHAR2 1 Indicates whether or not this is the default pay site for the supplier
SHIPPING_CONTROL VARCHAR2 30 Indicates the party responsible for arranging transportation: Supplier or Buyer
TOLERANCE_ID NUMBER 18 Tolerance Template Identifier
TOLERANCE_NAME VARCHAR2 255 Tolerance Template Name
GAPLESS_INV_NUM_FLAG VARCHAR2 1 Gapless Invoice Numbering Flag
SELLING_COMPANY_IDENTIFIER VARCHAR2 10 Unique Selling Company Identifier for Supplier
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE6 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE7 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE8 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE9 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE10 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP1 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP2 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP3 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP4 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP5 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP6 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP7 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP8 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP9 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_TIMESTAMP10 TIMESTAMP Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1 Yes or No flag indicating whether documents payable for this payee should be prevented from being grouped with other like documents payable for payment.
IBY_BANK_CHARGE_BEARER VARCHAR2 30 Bearer of bank charge cost
BANK_INSTRUCTION1_CODE VARCHAR2 30 Code of first bank instruction
BANK_INSTRUCTION2_CODE VARCHAR2 30 Code of second bank instrcution
BANK_INSTRUCTION_DETAILS VARCHAR2 255 Additional bank instrcution details
PAYMENT_REASON_CODE VARCHAR2 30 Payment reason code
PAYMENT_REASON_COMMENTS VARCHAR2 240 Free text field available for entering a reason
DELIVERY_CHANNEL_CODE VARCHAR2 30 Default delivery channel code
PAYMENT_FORMAT_CODE VARCHAR2 30 Default payment format code
SETTLEMENT_PRIORITY VARCHAR2 30 Priority for payments settlement
PAYMENT_TEXT_MESSAGE1 VARCHAR2 256 Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2 VARCHAR2 256 Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3 VARCHAR2 256 Text message for use in payment processing
PAYEE_SERVICE_LEVEL_CODE VARCHAR2 30 Default Service Level Code set for the payee. Values come from table IBY_PAYMENT_CODES_VL with payment_code_type 'SERVICE_LEVEL'. Ex: Book Transaction(BKTR), Urgent Payment(URGP).
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 30 Default payment method type
PROGRAM_APP_NAME VARCHAR2 50 Program Application name
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CARRIER_ID NUMBER 18 Carrier identifier
CARRIER VARCHAR2 360 Carrier Name
LANG_CODE VARCHAR2 4 Obsolete- Language code Obsolete
LANG_DESC VARCHAR2 30 Obsolete- Language description Obsolete
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 1 Allow substitute receipts flag
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 1 Allow unordered receipts flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 25 Enforce ship to location code
QTY_RCV_EXCEPTION_CODE VARCHAR2 25 Quantity received exception code
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 25 Receipt days exception code
INSPECTION_REQUIRED_FLAG VARCHAR2 1 Inspection required flag
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Receipt required flag
QTY_RCV_TOLERANCE NUMBER Quantity received tolerance
DAYS_EARLY_RECEIPT_ALLOWED NUMBER Days early receipt allowed
RECEIVING_ROUTING_ID NUMBER 18 Receiving routing identifier
SHIPPING_NETWORK_LOCATION NUMBER 18 Shipping network location
PHONE_COUNTRY_CODE VARCHAR2 10 Phone country code
PHONE_EXTENSION VARCHAR2 20 Phone extension
FAX_COUNTRY_CODE VARCHAR2 10 Fax country code
INACTIVE_DATE DATE Inactive date
DAYS_LATE_RECEIPT_ALLOWED NUMBER Days late receipt allowed
EXCLUDE_TAX_FROM_DISCOUNT VARCHAR2 1 Indicates whether the tax amount to be excluded from the discount
VAT_CODE VARCHAR2 30 VAT code
VAT_REGISTRATION_NUM VARCHAR2 20 VAT registration number
SHIP_VIA_LOOKUP_CODE VARCHAR2 25 Default carrier type
REMIT_ADVICE_DELIVERY_METHOD VARCHAR2 30 Default delivery method set on the payee level. If the Override with Payee Delivery Method Preference flag on the Payment Process Profile is turned off, the setting here is ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED.
REMITTANCE_EMAIL VARCHAR2 255 E-mail address at which the payee wishes to receive remittance advice.
SERVICES_TOLERANCE_ID NUMBER 18 Services tolerance identifier
SERVICES_TOLERANCE VARCHAR2 255 Service tolerance name
B2B_SITE_CODE VARCHAR2 256 B2B Supplier Site Code
EDI_LOCATION VARCHAR2 20 EDI Location
AGING_PERIOD_DAYS NUMBER 5 The maximum number of days the material may be on consignment.
AGING_ONSET_POINT VARCHAR2 30 The mutually agreed event point at which consigned material begins to age.
CONSUMPTION_ADVICE_FREQUENCY VARCHAR2 30 The frequency at which the 'Create Consumption Advice' program will be run for all consumption transactions for consigned inventory purchased under one agreement.
CONSUMPTION_ADVICE_SUMMARY VARCHAR2 30 The granularity at which consumption advices will be generated.
PAY_ON_USE_FLAG VARCHAR2 1 Flag indicating whether self-billing is enabled for consigned material.
LOAD_REQUEST_ID NUMBER 18 Indicates the id of the job that loaded the rows into the interface table.
BUILDING VARCHAR2 240 Obsolete- Specific building name or number at a given address Obsolete
BUYER_MANAGED_TRANSPORT_FLAG VARCHAR2 1 BUYER_MANAGED_TRANSPORT_FLAG
B2B_COMM_METHOD_CODE VARCHAR2 30 B2B_COMM_METHOD_CODE
FLOOR_NUMBER VARCHAR2 40 Obsolete- Specific floor number at a given address or in a particular building when building number is provided Obsolete
ADDRESS_LINES_PHONETIC VARCHAR2 560 Obsolete- Phonetic or Kana representation of the Kanji address lines (used in Japan) Obsolete
ADDR_ELEMENT_ATTRIBUTE1 VARCHAR2 150 Obsolete- Additional address element to support flexible address format Obsolete
ADDR_ELEMENT_ATTRIBUTE2 VARCHAR2 150 Obsolete- Additional address element to support flexible address format Obsolete
ADDR_ELEMENT_ATTRIBUTE3 VARCHAR2 150 Obsolete- Additional address element to support flexible address format Obsolete
ADDR_ELEMENT_ATTRIBUTE4 VARCHAR2 150 Obsolete- Additional address element to support flexible address format Obsolete
ADDR_ELEMENT_ATTRIBUTE5 VARCHAR2 150 Obsolete- Additional address element to support flexible address format Obsolete
MODE_OF_TRANSPORT_CODE VARCHAR2 30 Method of transportation for a Carrier.
SERVICE_LEVEL_CODE VARCHAR2 30 Priority of method of transportation for a Carrier. Values come from table WSH_LOOKUPS with lookup_type 'WSH_SERVICE_LEVELS'. Ex: Next day air(1DA) ,Express(EXP)
BANK_CHARGE_DEDUCTION_TYPE VARCHAR2 1 Type of deduction for bank charges. Values are Standard, Negotiated, and None.
PAYMENT_HOLD_DATE DATE Payment Hold Date
PO_ACK_REQD_CODE VARCHAR2 30 Indicates whether the supplier is required to send an acknowledgment to verify receipt of the purchasing document.
PO_ACK_REQD_DAYS NUMBER The number of days, from receipt of the purchasing document, the supplier must provide acknowledgement.
INVOICE_CHANNEL VARCHAR2 30 Supplier site attribute to capture the invoice channel information.

Indexes

Index Uniqueness Tablespace Columns
POZ_SUPPLIER_SITES_INT_N1 Non Unique Default VENDOR_INTERFACE_ID
POZ_SUPPLIER_SITES_INT_N2 Non Unique Default REQUEST_ID
POZ_SUPPLIER_SITES_INT_N3 Non Unique Default UPPER("BATCH_ID"), VENDOR_SITE_INTERFACE_ID
POZ_SUPPLIER_SITES_INT_PK Unique Default VENDOR_SITE_INTERFACE_ID