# DW_SUPPLIER_SITE_D

This table contains supplier site information.

## Details

Module:

## Key Columns

SUPPLIER_SITE_ID

## Columns

Columns
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_SUPSITE_PMT_GRP_NAME_LKP_TL with CODE_TYPE=PAY GROUP. Possible values are Priority, GPS, FOREIGN, Standard, or International. | DW_SUPSITE_PMT_GRP_NAME_LKP_TL | SUPSITE_PMT_GRP_NAME_LKP_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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO | DW_YESNO_LKP_TL | YESNO_LKP_CODE
PCARD_SITE_FLAG | VARCHAR2 | 16 |  |  | Indicator of whether the site allows use of procurement cards. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO | DW_YESNO_LKP_TL | YESNO_LKP_CODE
RFQ_ONLY_SITE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether you can only send RFQs to this site |  |
PAY_SITE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether you can send payments to this site |  |
PRIMARY_PAY_SITE_FLAG | VARCHAR2 | 16 |  |  | Iindicates that this is the default pay site for the supplier |  |
PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Identifier for Procurement Ledger. |  |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period Type of Procurement Business Unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Calendar Name for Procurement business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
INACTIVE_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period Name as per REQUESTED_DATE. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME

Copyright © 2019, 2026, Oracle and/or its affiliates.