# DW_CUSTOMER_SITE_USES_D

This table contains customer site uses details

## Details

Module: Receivables

## Key Columns

CUSTOMER_SITE_USE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 | True | Site use identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
LOCATION | VARCHAR2 | 256 |  |  | Site use identifier |  |
PARTY_SITE_NUMBER | VARCHAR2 | 32 |  |  | Party Site Number |  |
PARTY_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier |  |
SITE_USE_CODE | VARCHAR2 | 32 |  |  | Business purpose assigned to customer site account, such as Bill-To, Market, and Statements. |  |
CUST_ACCT_PARTY_SITE_ID | NUMBER | 38 | 0 |  | This is the derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, this is concatenation of person_name and suffix. |  |
PARTY_SITE_ID | NUMBER | 38 | 0 |  | Party site identifier |  |
CUST_ACCT_SITE_ID | NUMBER | 38 | 0 |  | The party type can only be Person, Organization, Group. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the creation of the row |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the last update of the row |  |
CUST_ACCT_CREATION_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the creation of the row |  |
CUST_ACCT_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the last update of the row |  |
PARTY_SITE_CREATION_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the creation of the row |  |
PARTY_SITE_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column indicates the date and time of the last update of the row |  |
COLLECTOR_NAME | VARCHAR2 | 32 |  |  | Collector Name |  |

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