This table contains supplier site information.
Module:
SUPPLIER_SITE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
SUPPLIER_SITE_ID | NUMBER | 38 | 0 | True | Supplier site identifier. | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source Record Identifier for supplier site. It is used as the primary key. | |||
ACTIVE_FLAG | VARCHAR2 | 16 | Indicates an active supplier. | ||||
SUPPLIER_SITE_CODE | VARCHAR2 | 256 | Supplier site code. | ||||
SUPPLIER_SITE_NUMBER | VARCHAR2 | 32 | Supplier site number. | ||||
SUPPLIER_SITE_NAME | VARCHAR2 | 256 | Supplier site name. | ||||
SUPPLIER_RECEIPT_TYPE_CODE | VARCHAR2 | 32 | Supplier Receipt type, Identifies how to consolidate the receipts to create invoices. Possible values are PACKING_SLIP, RECEIPT, or PAY_SITE. | ||||
PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms identifier. | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
PAYMENT_GROUP_CODE | VARCHAR2 | 32 | Payment group type. Values are derived from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAY GROUP. Possible values are Priority, GPS, FOREIGN, Standard, or International. | DW_CODE_VALUES_LKP_TL | CODE | ||
ADDRESS1 | VARCHAR2 | 256 | Address Line 1. | ||||
ADDRESS2 | VARCHAR2 | 256 | Address Line 2. | ||||
CITY | VARCHAR2 | 64 | Supplier location city. Possible value are Cleveland, New York, New Jersey, and so on. | ||||
COUNTY | VARCHAR2 | 64 | Supplier location county. Possible values are Lorrain, New York, Middlesex, and so on. | ||||
POSTAL_CODE | VARCHAR2 | 64 | Supplier location postal code. Possible values are 44105, 10013, 07054, and so on. | ||||
STATE | VARCHAR2 | 64 | Supplier location state. Possible values are OH, NY, NJ, and so on. | ||||
PROVINCE | VARCHAR2 | 64 | Supplier location province. Possible values are ARKANSAS, NEW HAMPSHIRE, ARIZONA, and so on. | ||||
COUNTRY | VARCHAR2 | 32 | Supplier location country code. Possible values are US, GB, CA, and so on. | ||||
PHONE_NUMBER | VARCHAR2 | 32 | Supplier phone number. | ||||
FAX_NUMBER | VARCHAR2 | 64 | Supplier fax number. | ||||
CUSTOMER_NUMBER | VARCHAR2 | 32 | Customer number with the supplier site. | ||||
SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier. | |||
PARTY_ID | NUMBER | 38 | 0 | Party identifier. | |||
PARTY_SITE_ID | NUMBER | 38 | 0 | Party site identifier. | |||
LOCATION_ID | NUMBER | 38 | 0 | Location identifier. | |||
PRC_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Procurement business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
INACTIVE_DATE | DATE | Inactive date of the site. | DW_DAY_D | CALENDAR_DATE | |||
PURCHASING_SITE_FLAG | VARCHAR2 | 16 | Indicates whether you can purchase from this site. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO | DW_CODE_VALUES_LKP_TL | CODE | ||
PCARD_SITE_FLAG | VARCHAR2 | 16 | Indicator of whether the site allows use of procurement cards. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO | DW_CODE_VALUES_LKP_TL | CODE |
Copyright © 2019, 2024, Oracle and/or its affiliates.