RA_CM_REQUESTS_ALL
The RA_CM_REQUESTS_ALL table contains information for credit memo requests during the invoice dispute process. Receivables creates one row for each request. This table contains all required parameters to initiate a credit memo request workflow. Each row includes general information such as amount, reason, comments, and if the request concerns specific invoice lines or a credit to the total line, tax, or freight amount on the transaction. A value of Y in the LINES_CREDITS_FLAG column indicates the customer made the credit request for specific lines. The CUSTOMER_TRX_ID column is the transaction identifier. CM_CUSTOMER_TRX_ID column stores credit memo identifier once Receivables approves and creates the credit memo. The primary keys for this table are REQUEST_ID and CUSTOMER_TRX_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
RA_CM_REQUESTS_PK |
REQUEST_ID, CUSTOMER_TRX_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Transaction Identifier | ||
CM_CUSTOMER_TRX_ID | NUMBER | 18 | Credit Memo Identifier | |||
URL | VARCHAR2 | 2000 | Not currently used. | |||
LINE_CREDITS_FLAG | VARCHAR2 | 1 | Indicates if line credits are at the line level. Y for a credit request to specific lines. N for a request for header level credit. | |||
LINE_AMOUNT | NUMBER | Amount of header line credit requested | ||||
TAX_AMOUNT | NUMBER | Amount of header tax credit requested | ||||
FREIGHT_AMOUNT | NUMBER | Amount of header freight credit requested | ||||
CM_REASON_CODE | VARCHAR2 | 30 | Reason code identifier for the credit memo | |||
COMMENTS | VARCHAR2 | 1760 | Comments to appear on the credit memo request | |||
STATUS | VARCHAR2 | 20 | Credit memo approval and creation status | |||
APPROVAL_DATE | VARCHAR2 | 20 | Date the request was approved | |||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
TOTAL_AMOUNT | NUMBER | Total amount of credit request | ||||
TERMS_SEQUENCE_NUMBER | NUMBER | The sequence number given to each installment for multiple payment terms. | ||||
TRANSACTION_URL | VARCHAR2 | 2000 | Not currently used. | |||
ACTIVITIES_URL | VARCHAR2 | 2000 | Not currently used. | |||
ORIG_TRX_NUMBER | VARCHAR2 | 30 | Stores the original transaction number when the user is disputing an invoice with the duplicate billing reason code | |||
TAX_EX_CERT_NUM | VARCHAR2 | 30 | Stores the tax exemption certificate when user is entering a dispute | |||
INTERFACE_HEADER_CONTEXT | VARCHAR2 | 30 | Interface header context | |||
INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | 30 | Interface header attribute value | |||
INTERFACE_HEADER_ATTRIBUTE2 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE3 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE4 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE5 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE6 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE7 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE8 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE9 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE10 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE11 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE12 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE13 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE14 | VARCHAR2 | 30 | Interface Header Attribute | |||
INTERFACE_HEADER_ATTRIBUTE15 | VARCHAR2 | 30 | Interface Header Attribute | |||
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. | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE21 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE22 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE23 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE24 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE25 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE26 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE27 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE28 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE29 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE30 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
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. | ||
DISPUTE_SECTION_CODE | VARCHAR2 | 30 | Identifies the requested dispute section. | Active | ||
INTERNAL_COMMENT | VARCHAR2 | 1000 | Internal comment appearing on the credit memo request. | Active | ||
CREDIT_FULL_INVOICE_FLAG | VARCHAR2 | 1 | Indicates whether the credit memo is created for full invoice amount or for the disputed amount. | |||
DISPUTE_TYPE_CODE | VARCHAR2 | 30 | Contains the category or severity of the dispute. Valid values are Ace, Green, Amber, Red & Not Applicable. | |||
REBILL_NUMBER | VARCHAR2 | 240 | Contains the invoice number created for the rebill in place of the original invoice number. | |||
REBILL_GROUP_CODE | VARCHAR2 | 30 | Name of the group that has created the new invoice in place of the original invoice. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
RA_CM_REQUESTS_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
RA_CM_REQUESTS_ALL | ra_customer_trx_all | CM_CUSTOMER_TRX_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
RA_CM_REQUESTS_U1 | Unique | Default | REQUEST_ID, CUSTOMER_TRX_ID |