1. Tables and Views for Financials
  2. AR_CMGT_CASE_FOLDERS

AR_CMGT_CASE_FOLDERS

This table contains the credit case folders.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

AR_CMGT_CASE_FOLDERS_PK

CASE_FOLDER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CASE_FOLDER_ID NUMBER 18 Yes Case folder unique identifier. Active
CASE_FOLDER_NUMBER VARCHAR2 30 Yes Case folder number. Active
CF_TEMPLATE_ID NUMBER 18 Yes Case folder template unique identifier. Active
CREDIT_CLASSIFICATION_CODE VARCHAR2 30 Credit classifcation of the customer or customer account. Values are based on the lookup AR_CMGT_CREDIT_CLASSIFICATION. Active
DESCRIPTION VARCHAR2 240 Case folder description.
REVIEW_TYPE_CODE VARCHAR2 30 Type of credit review for the case folder. Values are based on the lookup AR_CMGT_REVIEW_TYPE. Active
STATUS_CODE VARCHAR2 30 Case folder status. Values are based on the lookup AR_CMGT_CASE_FOLDER_STATUS. Active
CURRENCY_CODE VARCHAR2 15 Case folder currency code.
PARTY_ID NUMBER 18 Unique party identifier of the customer that the case folder is created for. Active
CUST_ACCOUNT_ID NUMBER 18 Unique identifier of the customer account that the case folder is created for. Active
CUSTOMER_NAME VARCHAR2 240 Customer name.
SCORE_MODEL_ID NUMBER 18 Scoring model unique identifier. Active
SCORE NUMBER Credit score calculated using the scoring model and data point values for the customer.
CREDIT_ANALYST_ID NUMBER 18 Credit analyst Identifier. Active
CURRENT_APPROVER_ID NUMBER 18 Current approver identifier.
CREDIT_LIMIT_AMT NUMBER The current credit limit amount assigned to the customer. Active
AVBL_LIMIT_AMT NUMBER The credit amount that is currently available to the customer.
EXCHANGE_RATE_TYPE VARCHAR2 30 Conversion rate type used for the case folder. Active
REVIEW_CYCLE_CODE VARCHAR2 30 Periodic review cycle defined for the customer or customer account. Values are based on the lookup AR_CMGT_REVIEW_CYCLE. Active
SOURCE_NAME VARCHAR2 60 Source application from which the credit review originated. Active
SOURCE_TRANS_TYPE_CODE VARCHAR2 30 Source transation type.
SOURCE_TRANS_CURRENCY_CODE VARCHAR2 15 Source Transaction currency code.
SOURCE_TRANS_CONTACT_ID NUMBER 18 Source transaction contact identifier.
SOURCE_TRANS_NUM VARCHAR2 60 Source transaction number.
SOURCE_TRANS_AMOUNT NUMBER Requested amount by the source transaction.
MISS_DATA_FLAG VARCHAR2 1 Indicates if the case folder is missing required data points, a credit score, or both.
RECOM_FAIL_FLAG VARCHAR2 1 Indicates if the implementation of recommendations has failed for the case folder.
CREDIT_HOLD_FLAG VARCHAR2 1 Indicates if the customer is on credit hold.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
SOURCE_TRANS_CONTACT VARCHAR2 240 Source transaction contact name
CREDIT_CHECK_REQUESTER_GUID VARCHAR2 64 User who has requested the credit check for a customer or a customer account.
NOTIFICATION_MESSAGE_ID NUMBER 18 Unique identifier for credit check notification.
PRICE_TYPE VARCHAR2 20 Type of price structure associated with the requested amount.
RECURRENCE_PERIOD VARCHAR2 20 Recurrence period when the price type is not one-time.
REQUEST_AUTH_AMOUNT NUMBER The amount requested for credit authorization.
REQUEST_CURRENCY_CODE VARCHAR2 20 The currency associated with the requested authorization amount.
FULFILLMENT_DATE DATE The date and time on which estimated fulfilment occurs for the source transaction.
SHIPMENT_DATE DATE The estimated date that goods will be shipped to the customer for the source transaction.
SALES_ORDER_DATE DATE The date the source transaction (sales order) is created.
OFFSET_DAYS NUMBER 18 The offset days allowed before an authorization becomes expired.
REQUESTOR VARCHAR2 30 The user or system initiating the credit checking request.
ORDER_AMOUNT_LIMIT NUMBER Maximum order amount defined in the credit currency for the customer account.
REQUEST_CUST_ACCOUNT_ID NUMBER 18 Unique identifier of the customer account associated with the credit authorization.
PREAUTH_REQUEST_FLAG VARCHAR2 1 Indicates if the request is a preauthorization credit checking request.
SCORE_LAST_UPDATE_DATE TIMESTAMP This column identifies the date and time the case folder score was last updated.
DATA_POINT_VALUE_UPDATED_FLAG VARCHAR2 1 This column identifies whether a more recently updated value is available for this data point in the unified repository.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_CMGT_CASE_FOLDERS ar_cmgt_cf_template CF_TEMPLATE_ID
ar_cmgt_approval_history ar_cmgt_case_folders CASE_FOLDER_ID
ar_cmgt_cf_recommends ar_cmgt_case_folders CASE_FOLDER_ID
ar_cmgt_cf_dtls ar_cmgt_case_folders CASE_FOLDER_ID

Indexes

Index Uniqueness Tablespace Columns
AR_CMGT_CASE_FOLDERS_U1 Unique Default CASE_FOLDER_ID
AR_CMGT_CASE_FOLDERS_N1 Non Unique Default PARTY_ID