Oracle Fusion · Data dictionary
RA_CUST_TRX_LINE_GL_DIST_ALL
ReceivablesUsed in 2 subject areas11 reporting columns
Receivables (RA), GL distribution lines per AR transaction line.
Primary key: CUST_TRX_LINE_GL_DIST_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNT_CLASS | ● | Account class. | |
| ACCTD_AMOUNT | ● | Acctd amount. | |
| AMOUNT | ● | Amount. | |
| COLLECTED_TAX_CONCAT_SEG | ● | Collected tax concat segment. | |
| COMMENTS | ● | Comments. | |
| CONCATENATED_SEGMENTS | ● | Concatenated segments. | |
| CUST_TRX_LINE_GL_DIST_ID | PK | ○ | Identifier for the customer transaction line general ledger distribution. |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| ORIGINAL_GL_DATE | ● | Original general ledger date. | |
| PERCENT | ● | Percent. | |
| POSTING_CONTROL_ID | ● | Identifier for the posting control. |
2 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to RA_CUST_TRX_LINE_GL_DIST_ALL.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for RA_CUST_TRX_LINE_GL_DIST_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table