DW_SUPPLIER_D
This table stores information about supplier level attributes.
Details
Module: Supplier Model
Key Columns
SUPPLIER_ID
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. |