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 |