1. Tables and Views for Financials
  2. RA_INTERFACE_DISTRIBUTIONS_ALL

RA_INTERFACE_DISTRIBUTIONS_ALL

The RA_INTERFACE_DISTRIBUTIONS_ALL table contains information about the accounting distributions for transactions that were imported using AutoInvoice. If you do not use AutoAccounting, you must enter accounting distributions for your transactions. If your accounting distributions are for transactions that use accounting rules, you must enter the percentages instead of the amounts, for your distribution lines. If you enter the amounts, AutoInvoice ignores those values. If your accounting distributions are for transactions that do not use accounting rules, you can enter either the percentages or amounts, depending on the value that you entered for your batch source. If you enter an amount, AutoInvoice requires that the sum of the distribution amounts equals the total amount of the transaction. If you enter a percent, AutoInvoice requires that the sum of the distribution percentages equals 100 for each account class that you pass. The primary key for this table is INTERFACE_DISTRIBUTION_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
INTERFACE_DISTRIBUTION_ID NUMBER 18 Oracle internal use only. Interface distribution identifier.
INTERFACE_DISTRIBUTION_GUID VARCHAR2 32 Oracle internal use only. Global interface identifier.
INTERFACE_LINE_ID NUMBER 18 Oracle internal use only. Interface line identifier.
INTERFACE_LINE_CONTEXT VARCHAR2 30 Oracle internal use only. Unique global identifier.
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
ACCOUNT_CLASS VARCHAR2 20 Yes Accounting distribution account class. Valid values: REV, FREIGHT, TAX, REC, CHARGES, UNBILL, UNEARN.
AMOUNT NUMBER Accounting distribution amount. Based upon the batch source, use either an amount or a percent. Do not use thousand separators. Use: period (.) or comma (,) as decimal separator.
PERCENT NUMBER Ledger identifier. Use Manage Primary Ledgers task to find valid ledger identifiers. If left blank, defaults from system options for the business unit.
INTERFACE_STATUS VARCHAR2 1 Oracle internal use only. Interface status.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CODE_COMBINATION_ID NUMBER 18 Accounting distribution currency code. Use Manage Currencies task to identify valid values. Use three character ISO currency code. Example: US Dollars is USD.
SEGMENT1 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT2 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT3 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT4 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT5 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT6 VARCHAR2 25 Original system batch name for grouping transactions. Free text field. Not validated.
SEGMENT7 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT8 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT9 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT10 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT11 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT12 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT13 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT14 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT15 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT16 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT17 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT18 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT19 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT20 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT21 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT22 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT23 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT24 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT25 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT26 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT27 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT28 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT29 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
SEGMENT30 VARCHAR2 25 Segment value for the Accounting key flexfield for the accounting distribution. Use Manage Account Combinations task to identify valid values.
COMMENTS VARCHAR2 240 Accounting distribution comments. Free text field. Not validated.
ATTRIBUTE_CATEGORY VARCHAR2 30 Conversion rate type. Use Manage Conversion Rate Types task to identify valid values. To provide a conversion rate for the line use: User. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE1 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE2 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE3 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE4 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE5 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE6 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE7 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE8 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE9 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE10 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE11 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE12 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE13 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE14 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ATTRIBUTE15 VARCHAR2 150 Segment value for Interface Distributions descriptive flexfield. Interface Distributions (RA_INTERFACE_DISTRIBUTIONS)
ACCTD_AMOUNT NUMBER Distribution accounted amount. Value is optional. Currency precision is enforced.
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 30 Segment value for Line Transactions Flexfield descriptive flexfield.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ORG_ID NUMBER 18 Business unit identifier. Use Manage Business units task to identify valid values.
INTERIM_TAX_CCID NUMBER 18 Oracle internal use only. Interim tax code combination identifier.
INTERIM_TAX_SEGMENT1 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT2 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT3 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT4 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT5 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT6 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT7 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT8 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT9 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT10 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT11 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT12 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT13 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT14 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT15 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT16 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT17 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT18 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT19 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT20 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT21 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT22 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT23 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT24 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT25 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT26 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT27 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT28 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT29 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
INTERIM_TAX_SEGMENT30 VARCHAR2 25 Segment value for the Accounting key flexfield for the interim tax account. Use Manage Account Combinations task to identify valid values.
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.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
BU_NAME VARCHAR2 240 Indicates the name of the business unit associated with the row.
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_INTERFACE_DISTRIBUTIONS_ALL gl_code_combinations CODE_COMBINATION_ID
RA_INTERFACE_DISTRIBUTIONS_ALL gl_code_combinations INTERIM_TAX_CCID

Indexes

Index Uniqueness Tablespace Columns
RA_INTERFACE_DISTRIBUTIONS_N1 Non Unique Default INTERFACE_LINE_ID
RA_INTERFACE_DISTRIBUTIONS_U1 Unique Default INTERFACE_DISTRIBUTION_ID
RA_INTERFACE_DISTRIBUTIONS_U2 Unique Default INTERFACE_DISTRIBUTION_GUID
RA_INTERFACE_DIST_N2 Non Unique Default REQUEST_ID, ACCOUNT_CLASS