# DW_SUPPLIER_D

This table stores information about supplier level attributes.

## Details

Module: Supplier Model

## Key Columns

SUPPLIER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SUPPLIER_ID | NUMBER | 38 | 0 | True | Supplier unique identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
SUPPLIER_NUMBER | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
SUPPLIER_PARTY_ID | NUMBER | 38 | 0 |  | Party Identifier | DW_PARTY_ID | PARTY_ID
ALTERNATE_NAME | VARCHAR2 | 512 |  |  | Additional name for the party |  |
ORGANIZATION_TYPE_CODE | VARCHAR2 | 32 |  |  | IRS organization type | DW_SUPPLIER_ORG_TYPE_LKP_TL | ORGANIZATION_TYPE_CODE
SUPPLIER_TYPE_CODE | VARCHAR2 | 32 |  |  | Supplier type | DW_SUPPLIER_TYPE_LKP_TL | SUPPLIER_TYPE_CODE
BUSINESS_RELATIONSHIP | VARCHAR2 | 32 |  |  | Business relationship of the enterprise with the supplier. | DW_SUPPLIER_BUS_RELATIONSHIP_LKP_TL | BUSINESS_RELATIONSHIP_CODE
START_DATE_ACTIVE | DATE |  |  |  | Date on which the supplier became active |  |
END_DATE_ACTIVE | DATE |  |  |  | Date on which the supplier became inactive |  |
CREATION_SOURCE | VARCHAR2 | 32 |  |  | Code of the source from which the supplier was created. | DW_SUPPLIER_SOURCE_LKP_TL | SUPPLIER_SOURCE_LKP_CODE
ONE_TIME_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the supplier is a one-time supplier | DW_YN_LKP_TL | YN_LKP_CODE
TAXPAYER_COUNTRY_CODE | VARCHAR2 | 16 |  |  | Country code used to validate the Taxpayer ID for this supplier |  |
INCOME_TAX_ID_FLAG | VARCHAR2 | 16 |  |  | Income tax flag identifier | DW_YN_LKP_TL | YN_LKP_CODE
SUPPLIER_PARTY_NUMBER | VARCHAR2 | 32 |  |  | Party number |  |
DUNS_NUMBER | VARCHAR2 | 32 |  |  | D-U-N-S number of the party. |  |
SUPPLIER_PARTY_NAME | VARCHAR2 | 512 |  |  | Party name |  |
ESTABLISHED_YEAR | NUMBER | 38 | 0 |  | Year of establishment. |  |
PRIMARY_PAYMENT_METHOD | VARCHAR2 | 32 |  |  | Primary Payment method code of Supplier. | DW_AP_PAYMENT_METHOD_LKP_TL | AP_PAYMENT_METHOD_LKP_CODE
PRIMARY_PAY_MTHD_START_DATE | DATE |  |  |  | Date when an explicit assignment of a payment method to an external payee becomes active. |  |
PRIMARY_PAY_MTHD_END_DATE | DATE |  |  |  | Date when an explicit assignment of a payment method to an external payee becomes inactive. |  |
TAX_COUNTRY_CODE | VARCHAR2 | 16 |  |  | Country code used to validate the tax registration number for this party tax profile |  |
TAX_REGISTRATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Code to indicate registration type |  |
TAX_REGISTRATION_NUMBER | VARCHAR2 | 64 |  |  | Tax registration number for this party tax profile. |  |
INCOME_TAX_ID | VARCHAR2 | 32 |  |  | Income Tax Identifier |  |
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Date and time of the creation of the row. |  |
CREATION_DATE | DATE |  |  |  | Date of the creation of the row. |  |
CREATED_BY | VARCHAR2 | 64 |  |  | User who created the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Date and time of the last update of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | User who last updated the row. |  |

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