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