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. You can't join across them in OTBI, the owned conformed model joins them on shared 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