AutoInvoice Interface Table RA_INTERFACE_DISTRIBUTIONS_ALL

This table stores accounting distributions for transactions created by AutoInvoice.

AutoInvoice doesn't require you to enter accounting distributions for your transactions. If you don't use AutoAccounting, then you must manually enter accounting distributions for your transactions.

If your accounting distributions are for transactions that use revenue scheduling rules, you can only enter percentages. If you enter amounts, AutoInvoice ignores these values.

If your accounting distributions are for transactions that don't use revenue scheduling rules, you can enter either percentages or amounts, depending on the value you entered for your transaction source:

If you enter an amount, AutoInvoice requires that the distribution amounts add up to the amount of the transaction.
If you enter a percentage, AutoInvoice requires that the distribution percentages add up to 100 for each account class that you pass.

Distributions in RA_INTERFACE_DISTRIBUTIONS_ALL are linked to the appropriate transaction lines in RA_INTERFACE_LINES_ALL from the Line Transaction Flexfield. Though the distribution for the REC account class is at the invoice level, it may be linked to any transaction line of the invoice in RA_INTERFACE_LINES_ALL. AutoInvoice will then correctly transfer all distributions to RA_CUST_TRX_LINE_GL_DIST_ALL.

ACCOUNT_CLASS

Enter the account class for this accounting distribution. AutoInvoice uses the account class you enter here to determine the type of account you’re supplying for this accounting distribution. You must enter a value for this column.

validation: Valid values are REV, FREIGHT, TAX, REC, CHARGES, UNBILL, and UNEARN. If the transaction uses the In Advance invoicing rule, don’t enter UNBILL in this column. If the transaction uses the In Arrears invoicing rule, don’t enter UNEARN in this column.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS

ACCTD_AMOUNT

This column is optional. If you selected Amount as the Revenue Account Allocation option on the transaction source, then AutoInvoice accepts whatever is passed in this column without validation. If this column is null, then AutoInvoice computes the accounted amount for this distribution line. For imported amounts in the ledger currency, AutoInvoice rejects the line if you enter a value in the ACCTD_AMOUNT column that doesn't equal the line amount.

validation: None.
destination: None.

AMOUNT

Enter the amount for this accounting distribution.

If this accounting distribution is for a transaction that doesn't use a revenue scheduling rule, you must enter a value either in this column or in the PERCENT column, depending on the value you entered for the Revenue Account Allocation option on the transaction source. If you specify Percent, AutoInvoice computes the amount in this column.

Don’t enter a value in this column if either of these is true:

This accounting distribution is for a transaction that uses a revenue scheduling rule.
This accounting distribution is a receivables (REC) account. If this distribution is for a receivables account, you must enter 100 in RA_INTERFACE_DISTRIBUTIONS_ALL.PERCENT.

If this line has AMOUNT_INCLUDES_TAX set to Yes, the sales credits and line amounts for this column must include tax.

validation: If this transaction doesn't use a revenue scheduling rule, the sum of all distribution amounts for this transaction of a given line type must equal the amount of the transaction. AutoInvoice corrects amounts that have incorrect currency precision.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT

ATTRIBUTE1-15

Enter the Descriptive Flexfield attribute information for this accounting distribution. Descriptive Flexfield attributes allow you to store additional columns, the contents of which you define. These columns are optional.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.ATTRIBUTE1-15

ATTRIBUTE_CATEGORY

Enter the Descriptive Flexfield category information for this accounting distribution. Descriptive Flexfield categories allow you to store different categories of attributes. This column is optional.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.ATTRIBUTE_CATEGORY

CODE_COMBINATION_ID

Enter the code combination ID of the Accounting Flexfield for this accounting distribution.

This column is optional. Depending on the value you selected for the Accounting Flexfield option on the transaction source, you must either enter a value in this column or enter a combination of segment values in the SEGMENT1-30 column. If you selected Segment on the transaction source, AutoInvoice enters a corresponding ID in this column.

validation: Must exist in GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.COLLECTED_TAX_CCID, if tax is deferred; otherwise, RA_CUST_TRX_LINE_GL_DIST_ALL.CODE_COMBINATION_ID.

COMMENTS

Enter comments about this accounting distribution. This column is optional.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.COMMENTS

INTERFACE_DISTRIBUTION_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using the sequence RA_CUST_TRX_LINE_GL_DIST_S. This is the primary key for RA_INTERFACE_DISTRIBUTIONS_ALL.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.CUST_TRX_LINE_GL_DIST_ID

INTERFACE_LINE_ATTRIBUTE1-15

Enter the same Line Transaction Flexfield for the transaction with which you want to associate this accounting distribution. You must enter a value for each attribute you enabled for the Line Transaction Flexfield.

validation: None.
destination: None.

INTERFACE_LINE_CONTEXT

This is a required column in AutoInvoice. Enter the context of the Line Transaction Flexfield entered in the INTERFACE_LINE_ATTRIBUTE1-15 column.

validation: If you pass lines with global context, set this column to Global Data Elements.
destination: RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_CONTEXT

INTERFACE_LINE_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using INTERFACE_LINE_ATTRIBUTE1-15 and INTERFACE_LINE_CONTEXT.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_LINE_ID

INTERFACE_STATUS

This column is used by AutoInvoice and should be left null.

validation: None.
destination: None.

INTERIM_TAX_CCID

This column identifies the tax account used for deferred tax amounts.

validation: None.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.CODE_COMBINATION_ID

INTERIM_TAX_SEGMENT1-30

Enter an Accounting Flexfield value for each segment you enable in Receivables. This flexfield represents the Interim (deferred) tax account. For example, if you enable six Accounting Flexfield segments, you must enter six values in columns SEGMENT1-6. Be sure to enter the correct segment value. For example, the value 01 isn’t the same as 1.

Depending on the value you selected for the Accounting Flexfield option on the transaction source, you must either enter a combination of segment values here or enter a value in the CODE_COMBINATION_ID column.

validation: Valid combination of Accounting Flexfield segment values must exist in GL_CODE_COMBINATIONS.
destination: None.

LAST_UPDATE_LOGIN

This column is used by AutoInvoice and should be left null. AutoInvoice updates this column when it selects rows from the RA_INTERFACE_DISTRIBUTIONS_ALL table for processing.

validation: None.
destination: None.

PERCENT

Enter the percent for this accounting distribution.

If this accounting distribution is for a transaction that doesn't use a revenue scheduling rule, you must enter a value either in this column or in the AMOUNT column, depending on the value you entered for the Revenue Account Allocation option on the transaction source. If you specified Amount, AutoInvoice computes the percentage in this column.

If this accounting distribution is for a transaction that uses a revenue scheduling rule, you must enter a value in this column.

validation: The sum of all accounting distribution percentages for a transaction must add up to 100 for an account class.
destination: RA_CUST_TRX_LINE_GL_DIST_ALL.PERCENT

REQUEST_ID

This column is used by AutoInvoice and should be left null.

validation: None.
destination: None.

SEGMENT1-30

Enter an Accounting Flexfield value for each segment you enable in Receivables. For example, if you enable six Accounting Flexfield segments, you must enter six values in columns SEGMENT1-6. Be sure to enter the correct segment value. For example, the value 01 isn’t the same as 1.

validation: Valid combination of Accounting Flexfield segment values must exist in GL_CODE_COMBINATIONS.
destination: None.