# DW_PARTY_USG_ASSIGNMENT_D

This table contains information about party usage assignments.

## Details

Module: Supplier Model

## Key Columns

PARTY_USG_ASSIGNMENT_ID

## Columns

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

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