DW_PARTY_USG_ASSIGNMENT_D
This table contains information about party usage assignments.
Details
Module: Supplier Model
Key Columns
PARTY_USG_ASSIGNMENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PARTY_USG_ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Unique identifier for a party usage assignment. | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. System generated Unique Identifier. | |||
| PARTY_ID | NUMBER | 38 | 0 | Unique identifier of party that the party usage is assigned to | DW_PARTY_ID | PARTY_ID | |
| PARTY_USAGE_CODE | VARCHAR2 | 32 | Unique identifier of party usage assigned to the party | DW_PARTY_USAGE_D_TL | PARTY_USAGE_CODE | ||
| EFFECTIVE_START_DATE | DATE | Date at the beginning of the date range within which the row is effective. | |||||
| EFFECTIVE_END_DATE | DATE | Date at the end of the date range within which the row is effective. | |||||
| STATUS_FLAG | VARCHAR2 | 16 | Status Flag | ||||
| CREATION_DATE | TIMESTAMP | The date and time of the creation of the row | |||||
| LAST_UPDATE_DATE | TIMESTAMP | The date and time of the last update of the row. |