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   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 16     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