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, 2024, Oracle and/or its affiliates.