POZ_SUP_ADDRESSES_INT
Interface table to import Supplier Addresses.
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
POZ_SUP_ADDRESSES_INT_PK |
ADDRESS_INTERFACE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ADDRESS_INTERFACE_ID | NUMBER | 18 | Yes | Supplier address interface record unique identifier. | |
REQUEST_SOURCE | VARCHAR2 | 15 | Signifies whether the request is from import or through a web service. Valid values are IMPORT or WEB_SERVICE. Null value for this column is also treated as a request from import | ||
PARTY_SITE_ID | NUMBER | 18 | Supplier address unique identifier. The attribute is obtained from TCA (HZ_PARTY_SITES). | ||
PARTY_SITE_NAME | VARCHAR2 | 240 | Supplier address unique identifier. The attribute is obtained from TCA (HZ_PARTY_SITES). | ||
PARTY_SITE_NAME_NEW | VARCHAR2 | 240 | New address name. | ||
VENDOR_INTERFACE_ID | NUMBER | 18 | Supplier interface record unique identifier. | ||
VENDOR_ID | NUMBER | 18 | Supplier unique identifier. The value can be obtained from the VENDOR_ID column in the POZ_SUPPLIERS table. | ||
VENDOR_NAME | VARCHAR2 | 360 | Supplier Name unique identifier. | ||
IMPORT_STATUS | VARCHAR2 | 30 | Status of the record before or after import. Initially, the status is set to 'NEW' and after processing, the status is turned to 'PROCESSED' or 'REJECTED' based on the outcome. | ||
IMPORT_ACTION | VARCHAR2 | 10 | Indicates if the import process is to create a new record of update an exisiting one. Valid values are CREATE and UPDATE. | ||
COUNTRY | VARCHAR2 | 60 | Address country. | ||
ADDRESS_LINE1 | VARCHAR2 | 240 | First line of supplier address. | ||
ADDRESS_LINE2 | VARCHAR2 | 240 | Second line of supplier address. | ||
ADDRESS_LINE3 | VARCHAR2 | 240 | Third line of supplier address. | ||
ADDRESS_LINE4 | VARCHAR2 | 240 | Fourth line of supplier address. | ||
ADDRESS_LINES_PHONETIC | VARCHAR2 | 560 | Phonetic or Kana representation of the Kanji address lines. (used in Japan) | ||
ADDR_ELEMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
ADDR_ELEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
ADDR_ELEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
ADDR_ELEMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
ADDR_ELEMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
BUILDING | VARCHAR2 | 240 | Specific building name or number at a given address. | ||
FLOOR_NUMBER | VARCHAR2 | 40 | Specific floor number at a given address or in a particular building when building number is provided. | ||
CITY | VARCHAR2 | 60 | City of supplier address. | ||
STATE | VARCHAR2 | 60 | State of supplier address. | ||
PROVINCE | VARCHAR2 | 60 | Province of supplier address. | ||
COUNTY | VARCHAR2 | 60 | County of supplier address. | ||
POSTAL_CODE | VARCHAR2 | 60 | Postal code of supplier address. | ||
POSTAL_PLUS4_CODE | VARCHAR2 | 10 | Four digit extention to the Postal Code. | ||
ADDRESSEE | VARCHAR2 | 360 | Addressee information. | ||
GLOBAL_LOCATION_NUMBER | VARCHAR2 | 40 | Global location numbr that uniquely identifies each location in a trading partners enterprise. | ||
PARTY_SITE_LANGUAGE | VARCHAR2 | 4 | Operating language of the address. Provide language code. | ||
INACTIVE_DATE | DATE | Date from which the address in inactive. Maps to attribute END_DATE_ACTIVE in the TCA table HZ_PARTY_SITES. | |||
PHONE_COUNTRY_CODE | VARCHAR2 | 10 | Country code for address phone. | ||
PHONE_AREA_CODE | VARCHAR2 | 10 | Area code for address phone. | ||
PHONE | VARCHAR2 | 40 | Supplier address phone number. | ||
PHONE_EXTENSION | VARCHAR2 | 20 | Extension for address phone. | ||
FAX_COUNTRY_CODE | VARCHAR2 | 10 | Country code for address fax. | ||
FAX_AREA_CODE | VARCHAR2 | 10 | Area code for address fax. | ||
FAX | VARCHAR2 | 40 | Supplier address fax number. | ||
EMAIL_ADDRESS | VARCHAR2 | 320 | Supplier address email address | ||
ORDERING_PURPOSE_FLAG | VARCHAR2 | 1 | Indicates whether purpose Ordering is allowed for this address. | ||
REMIT_TO_PURPOSE_FLAG | VARCHAR2 | 1 | Indicates whether purpose Remit To is allowed for this address. | ||
RFQ_OR_BIDDING_PURPOSE_FLAG | VARCHAR2 | 1 | Indicates whether purpose RFQ or Bidding is allowed for this address. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Default delivery channel code | ||
BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Code of first bank instruction | ||
BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Code of second bank instruction | ||
BANK_INSTRUCTION_DETAILS | VARCHAR2 | 255 | Additional bank instruction details | ||
SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Priority with which the financial institution or payment system settles payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY. | ||
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 | ||
SERVICE_LEVEL_CODE | VARCHAR2 | 30 | Default Service Level Code | ||
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 | Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from lookup: IBY_BANK_CHARGE_BEARER | ||
PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code | ||
PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Free text field available for entering a reason for the payment | ||
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. | ||
REMIT_ADVICE_EMAIL | VARCHAR2 | 255 | E-mail address at which the payee wishes to receive remittance advice | ||
REMIT_ADVICE_FAX | VARCHAR2 | 100 | Fax number at which the payee wishes to receive remittance advice | ||
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. | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE30 | VARCHAR2 | 255 | 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_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE12 | DATE | 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. | |||
ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Program application name. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Indicates the id of the job that loaded the rows into the interface table. This is used when initial data is made available via a spreadsheet. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | 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. | ||
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. | ||
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. | |
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POZ_SUP_ADDRESSES_INT_N1 | Non Unique | Default | REQUEST_ID |
POZ_SUP_ADDRESSES_INT_N2 | Non Unique | Default | VENDOR_INTERFACE_ID |
POZ_SUP_ADDRESSES_INT_N3 | Non Unique | Default | UPPER("BATCH_ID"), ADDRESS_INTERFACE_ID |
POZ_SUP_ADDRESSES_INT_PK | Unique | Default | ADDRESS_INTERFACE_ID |