This table contains customer site uses details
Module: Receivables
CUSTOMER_SITE_USE_ID
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 | 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 |