RA_CUST_TRX_LINE_GL_DIST_ALL
The RA_CUST_TRX_LINE_GL_DIST_ALL table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line. Fusion Oracle Receivables creates one row for each accounting distribution, and at least one accounting distribution must exist for each invoice or credit memo line. Each row in this table includes the general ledger account and the amount of the accounting entry. The AMOUNT column is required even though this column is null allowed. Receivables uses this information to post the proper amounts to Oracle Fusion Subledger Accounting. If your invoice or credit memo has a transaction type where Post to GL is set to No, Receivables assigns Null to the GL_DATE column. If AutoAccounting is unable to complete your general ledger default accounts using the AutoAccounting rules that you defined, incomplete general ledger accounts are stored in the CONCATENATED_SEGMENTS column. If you are importing a transaction through AutoInvoice and the accounting date of your transaction is in a closed accounting period, AutoInvoice uses the accounting date of the first open accounting period and stores the original accounting date in the ORIGINAL_GL_DATE column. The ACCOUNT_CLASS column defines this distribution row type. A REC value in the ACCOUNT_CLASS column represents the receivable account and contains the total invoice amount. At most, two REC rows may exist: one row with the ACCOUNT_SET_FLAG column set to Y, and one row with the ACCOUNT_SET_FLAG column set to N. The LATEST_REC_FLAG column joins the row that is set to N. The ACCOUNT_SET_FLAG column is Y if this row is part of an account set. An account set, which is a set of rows that represents a model distribution, is used for invoices with rules. The rows in an account set indicate how Receivables should create the actual distribution rows and what percentage of the actual distribution Receivables should allocate to each account. For invoices with rules, Receivables does not create the distributions when the invoice is initially created. Instead, Receivables creates the invoices when the Revenue Recognition program is run. The primary key for this table is CUST_TRX_LINE_GL_DIST_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
RA_CUST_TRX_LINE_GL_DIST_PK |
CUST_TRX_LINE_GL_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| CUST_TRX_LINE_GL_DIST_ID | NUMBER | 18 | Yes | Revenue distribution identifier | Active | ||
| TRANSFER_TO_COSTING | VARCHAR2 | 1 | Flag 'N' indicates the lines need to be transferred to Costing & 'NULL' indicates the lines are transferred to costing | ||||
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Transaction line identifier. | Active | |||
| CODE_COMBINATION_ID | NUMBER | 18 | General Ledger account identifier. | Active | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifies the ledger associated with the distribution line. | Active | ||
| 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 | |||
| PERCENT | NUMBER | Percent of the line amount represented by this record | Active | ||||
| AMOUNT | NUMBER | Amount of this record in the foreign currency | Active | ||||
| GL_DATE | DATE | Accounting date. | Active | ||||
| GL_POSTED_DATE | DATE | Date posted | Active | ||||
| CUST_TRX_LINE_SALESREP_ID | NUMBER | 18 | Sales representative credit identifier. | Active | |||
| COMMENTS | VARCHAR2 | 240 | Comment about the revenue distribution | Active | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | Active | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | Active | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | Active | ||||
| CONCATENATED_SEGMENTS | VARCHAR2 | 240 | Revenue account | Active | |||
| ORIGINAL_GL_DATE | DATE | Original accounting date derived by Revenue Recognition process. This date may be different than the actual accounting date if the period is not open when accounting is created. | Active | ||||
| POST_REQUEST_ID | NUMBER | 18 | Posting batch identifier | Active | |||
| POSTING_CONTROL_ID | NUMBER | 18 | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted | Active | ||
| ACCOUNT_CLASS | VARCHAR2 | 20 | Yes | Freight, Receivable, Revenue, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, or Charges account type | Active | ||
| RA_POST_LOOP_NUMBER | NUMBER | 18 | Not currently used. | Active | |||
| CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Transaction identifier | Active | ||
| ACCOUNT_SET_FLAG | VARCHAR2 | 1 | Yes | Indicates if this is an account set record. Y for yes, N otherwise. | Active | ||
| ACCTD_AMOUNT | NUMBER | Amount of this record in the functional currency | Active | ||||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Line Distributions (RA_CUST_TRX_LINE_GL_DIST) | Active | ||
| LATEST_REC_FLAG | VARCHAR2 | 1 | This column identifies the latest record in this table with an ACCOUNT_CLASS of REC. It can have the following values: Y-latest REC record, N-not the latest REC record, or null-not a REC record. One Y exists for each CUSTOMER_TRX_ID. | Active | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | ||
| COLLECTED_TAX_CCID | NUMBER | 18 | Code combination ID for collected tax account (used if the tax is deferred) | Active | |||
| COLLECTED_TAX_CONCAT_SEG | VARCHAR2 | 240 | Concatenated segments for the collected tax account | Active | |||
| REVENUE_ADJUSTMENT_ID | NUMBER | 18 | Revenue adjustment identifier. | Active | |||
| REV_ADJ_CLASS_TEMP | VARCHAR2 | 30 | Temporary lookup code that indicates type of adjusted revenue | Active | |||
| REC_OFFSET_FLAG | VARCHAR2 | 1 | Y indicates that the record is an UNBILL or UNEARN line paired with the transaction's REC row. Null indicates another type of line or an UNBILL or UNEARN line paired with a REV line. | Active | |||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier. | Active | |||
| USER_GENERATED_FLAG | VARCHAR2 | 1 | User-generated flag | 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 | ||
| ROUNDING_CORRECTION_FLAG | VARCHAR2 | 1 | Indicates a rounding correction. | Active | |||
| 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. | ||||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_CUST_TRX_LINE_GL_DIST_ALL | gl_code_combinations | COLLECTED_TAX_CCID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | ra_customer_trx_lines_all | CUSTOMER_TRX_LINE_ID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | gl_code_combinations | CODE_COMBINATION_ID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | ra_cust_trx_line_salesreps_all | CUST_TRX_LINE_SALESREP_ID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | ar_revenue_adjustments_all | REVENUE_ADJUSTMENT_ID |
| RA_CUST_TRX_LINE_GL_DIST_ALL | xla_events | EVENT_ID, PROGRAM_APPLICATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| RA_CUST_TRX_LINE_GLD_N10 | Non Unique | Default | REQUEST_ID, CUSTOMER_TRX_LINE_ID, ACCOUNT_SET_FLAG | |
| RA_CUST_TRX_LINE_GL_DIST_N1 | Non Unique | FUSION_TS_TX_DATA | CUSTOMER_TRX_LINE_ID, ACCOUNT_SET_FLAG, GL_DATE | Active |
| RA_CUST_TRX_LINE_GL_DIST_N2 | Non Unique | FUSION_TS_TX_DATA | GL_DATE, ACCOUNT_CLASS, LATEST_REC_FLAG, ORG_ID | Active |
| RA_CUST_TRX_LINE_GL_DIST_N3 | Non Unique | FUSION_TS_TX_DATA | CUST_TRX_LINE_SALESREP_ID | Active |
| RA_CUST_TRX_LINE_GL_DIST_N5 | Non Unique | FUSION_TS_TX_DATA | SET_OF_BOOKS_ID, POSTING_CONTROL_ID, GL_DATE | Active |
| RA_CUST_TRX_LINE_GL_DIST_N6 | Non Unique | FUSION_TS_TX_DATA | CUSTOMER_TRX_ID, ACCOUNT_CLASS, LATEST_REC_FLAG, CODE_COMBINATION_ID | Active |
| RA_CUST_TRX_LINE_GL_DIST_N7 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID | Obsolete |
| RA_CUST_TRX_LINE_GL_DIST_N8 | Non Unique | FUSION_TS_TX_DATA | REVENUE_ADJUSTMENT_ID | Active |
| RA_CUST_TRX_LINE_GL_DIST_N9 | Non Unique | FUSION_TS_TX_DATA | EVENT_ID | Active |
| RA_CUST_TRX_LINE_GL_DIST_U1 | Unique | FUSION_TS_TX_DATA | CUST_TRX_LINE_GL_DIST_ID | Active |