Auto Invoice Table and Column Descriptions

Below is a detailed description of the four interface tables Receivables uses to temporarily
store transaction data from your original system. Each column has important, detailed
information you need to know to successfully run AutoInvoice. AutoInvoice uses the
fifth table, RA_INTERFACE_ERRORS_ALL, to store information about interface data
that failed validation.
Interface Tables
• RA_INTERFACE_LINES_ALL, page F-40
• RA_INTERFACE_SALESCREDITS_ALL, page F-81
• RA_INTERFACE_DISTRIBUTIONS_ALL, page F-85
• AR_INTERFACE_CONTS_ALL, page F-90
• RA_INTERFACE_ERRORS_ALL, page F-91
Oracle Receivables Table and Column Descriptions F-39
Table Name: RA_INTERFACE_LINES_ALL
This table stores transaction header and line information. AutoInvoice uses
Transaction Flexfields to uniquely identify each transaction that you import into
Receivables. AutoInvoice always uses the Line Transaction Flexfield structure for
both the Link-to and Reference information when importing invoices. For more
information, see: Transaction Flexfields., page 3-214
ACCOUNTING_RULE_DURATION
Enter the accounting rule duration for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, and this transaction uses a
variable duration accounting rule, you must enter a value in this column.
If LINE_TYPE = ’TAX’ ’, ’CHARGES’ or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos and on-account credits, do not enter a value in this column.
Validation:
Accounting periods must be defined for the duration of the accounting
rule in GL_PERIODS and RA_INTERFACE_LINES_ALL.GL_DATE and
RA_INTERFACE_LINES_ALL.RULE_START_DATE must be in a period that has a
status of ’Open’ or ’Future’. The value in this column must be a positive integer.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.ACCOUNTING_RULE_DURATION
ACCOUNTING_RULE_ID
Enter the accounting rule ID for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, this column is optional. For
invoice lines with rules, you must enter either a value in this column or in
ACCOUNTING_RULE_NAME, depending on the value you entered for your batch
source. If you entered a value in ACCOUNTING_RULE_NAME, AutoInvoice defaults
a value in this column.
If LINE_TYPE = ’TAX’, ’CHARGES’ or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos, do not enter a value in this column; AutoInvoice uses the accounting
rule from the transaction you are crediting.
Validation:
Must exist in RA_RULES.RULE_ID and RA_RULES.TYPE = ’A’ or ’ACC_DUR’. If
LINE_TYPE = ’CHARGES’, then this column must be null.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.ACCOUNTING_RULE_ID
ACCOUNTING_RULE_NAME
Enter the accounting rule name for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, this column is optional. For
invoice lines with rules, you must enter either a value in this column or in
ACCOUNTING_RULE_ID, depending on the value you entered for your batch source.
F-40 Oracle Receivables User Guide
If LINE_TYPE = ’TAX,’ ’CHARGES,’ or if you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the accounting
rule from the transaction you are crediting.
Validation:
Must exist in RA_RULES.NAME and RA_RULES.TYPE = ’A’ or ’ACC_DUR’. If
LINE_TYPE = ’CHARGES’, then this column must be null.
Destination:
None
ACCTD_AMOUNT
Do not enter a value. Receivables does not currently use this column.
Validation:
None
Destination:
None
AGREEMENT_NAME
Enter the name of the customer agreement for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’ or you are passing header freight, this column
is optional. Depending on the value you entered for your batch source, you can
enter either a value in this column or in AGREEMENT_ID. For invoice lines against
a commitment, AutoInvoice will default the agreement from the commitment if
AGREEMENT_NAME and AGREEMENT_ID are null and a agreement exists for the
commitment.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column, AutoInvoice uses the customer
agreement from the transaction you are crediting.
Validation:
Must exist in SO_AGREEMENTS.NAME
Destination:
None
AGREEMENT_ID
Enter the customer agreement ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’ or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source, you can enter
either a value in this column or in AGREEMENT_NAME. For invoice lines against
a commitment, AutoInvoice will default the agreement from the commitment if
AGREEMENT_NAME and AGREEMENT_ID are null and a agreement exists for the
commitment.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line do not enter a value
in this column.
Oracle Receivables Table and Column Descriptions F-41
For credit memos, do not enter a value in this column, AutoInvoice uses the customer
agreement from the transaction you are crediting.
Validation:
Must exist in SO_AGREEMENTS.ID
Destination:
None
AMOUNT
Enter the revenue amount for this transaction.
If LINE_TYPE = ’LINE’ and this transaction is neither a freight-only nor a tax-only
line, you must enter a value in this column. If this transaction is a dummy line for
freight-only or tax-only, do not enter a value in this column. AutoInvoice ignores any
values you enter in this column if this transaction is a dummy line.
If LINE_TYPE = ’TAX’, a value must be entered in either this column or the tax_rate
column. Any exemptions must be factored into either of the two columns.
If LINE_TYPE = ’FREIGHT’ and you are passing either header freight or freight for a
specific line, you must enter a value in this column.
If LINE_TYPE = ’CHARGES’, do not enter a value in this column.
If this line has AMOUNT_INCLUDES_TAX set to Yes, the sales credits and line amounts
for this column must include tax.
For credit memos and on-account credits, enter the credit amount for this transaction.
Validation:
If LINE_TYPE = ’CHARGES’, then this column must be null. AutoInvoice will correct
revenue amounts that have the wrong currency precision.
Destination:
If Create Clearing is set to No for this transaction batch source (suspense/clearing
account not used), RA_CUSTOMER_TRX_LINES_ALL.REVENUE_AMOUNT and
RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT.
If Create Clearing is set to Yes for this transaction batch source (suspense/clearing
account used), RA_CUSTOMER_TRX_LINES_ALL.REVENUE_AMOUNT.
AMOUNT_INCLUDES_TAX_FLAG
This column controls whether the amount for this transaction line includes tax. If
this column is set to ’Y’, this line is assigned to a tax inclusive tax code. If this is a tax
group, this column should be null.
AutoInvoice only uses this column if the tax code assigned to this line has Allow
Override set to Yes for the Tax Inclusive calculation.
Populate this column for invoices only. For regular credit memos, AutoInvoice always
uses the AMOUNT_INCLUDES_TAX_FLAG value from the invoice that you are
crediting.
Validation:
If this is a tax code and Allow Override is set to No, this should be equal to either the
setting of the Amount Includes Tax option for this tax code or null. Additionally, if
Allow Override is set to No the Amount Includes Tax flag at the line level must equal
the Allow Override flag for this tax code.
F-42 Oracle Receivables User Guide
Destination:
RA_CUSTOMER_TRX_LINES_ALL.AMOUNT_INCLUDES_TAX_FLAG
APPROVAL_CODE
The payment approval code provided by the credit card issuer to indicate funds are
available from the user’s account.
Validation
None
Destination
RA_CUSTOMER_TRX_ALL.APPROVAL_CODE
ADDRESS_VERIFICATION_CODE
The credit card address verification code provided by Oracle Payment Server.
Validation
None
Destination
RA_CUSTOMER_TRX_ALL.ADDRESS_VERIFICATION_CODE
ATTRIBUTE1-15
Enter the Invoice Line Information Flexfield attribute information for this
transaction. Descriptive Flexfield attributes allow you to store additional columns, the
contents of which you define. These columns are optional.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.ATTRIBUTE1-15
Note: To ensure that AutoInvoice accurately groups your imported invoices, do not
include newline or carriage return characters (chr(10) or chr(13)) in these Descriptive
Flexfield columns.
ATTRIBUTE_CATEGORY
Enter the Invoice Line Information Flexfield category information for this
transaction. Descriptive Flexfield categories allow you to store different categories of
attributes. This column is optional.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.ATTRIBUTE_CATEGORY
BATCH_SOURCE_NAME
Enter the name of the batch source for this transaction. AutoInvoice uses your
batch source to determine your transaction and batch numbering method and your
AutoInvoice processing options. You must enter a value in this column.
Oracle Receivables Table and Column Descriptions F-43
Validation:
Must exist in RA_BATCH_SOURCES_ALL.NAME and RA_BATCH_SOURCES_ALL.
BATCH_SOURCE_TYPE = ’FOREIGN’
Destination:
RA_BATCHES_ALL.BATCH_SOURCE_ID and RA_CUSTOMER_TRX_ALL.BATCH_
SOURCE_ID
COMMENTS
Enter comments about this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’ or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or your are passing freight for a specific line, do not enter text
in this column.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.COMMENTS
CONS_BILLING_NUMBER
Enter the number for this consolidated bill.
A consolidated bill number is used for grouping a set of invoices under one bill.
Validation:
Must not already exist in AR_CONS_INV_ALL.CONS_BILLING_NUMBER and
AR_CONS_INV_ALL.CONS_INV_TYPE=’MINV’
Destination:
AR_CONS_INV_ALL.CONS_BILLING_NUMBER
CONVERSION_DATE
Enter the exchange rate date for this transaction. If you do not enter a date, AutoInvoice
uses the transaction date as the default. If the currency of the transaction line is the
same as the base currency, then leave this column null. If a credit memo is being
processed, AutoInvoice uses the conversion date of the invoice that the credit memo is
against, and not the credit memo transaction date.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.EXCHANGE_DATE
CONVERSION_RATE
Enter the exchange rate for this transaction.
If CONVERSION_TYPE is User, you MUST enter a value in this column; otherwise do
not enter a value. If the currency of the transaction is the same as the base currency, enter
’User’ and set CONVERSION_RATE to 1.
F-44 Oracle Receivables User Guide
Validation:
If RA_INTERFACE_LINES_ALL.CONVERSION_TYPE = ’User’ then this column must
not be null; otherwise, it must be null.
Destination:
RA_CUSTOMER_TRX_ALL.EXCHANGE_RATE
CONVERSION_TYPE
Enter the exchange rate type for this transaction. If the currency of the transaction is the
same as the base currency, enter ’User’ and set CONVERSION_RATE to 1. You must
enter a value in this column.
Validation:
Must exist in GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE
Destination:
RA_CUSTOMER_TRX_ALL.EXCHANGE_RATE_TYPE
CREDIT_METHOD_FOR_ACCT_RULE
Enter the credit method for crediting a transaction which uses an accounting
rule. Choices include PRORATE, LIFO, or UNIT.
If this transaction is a credit memo against a transaction which uses an accounting rule
and LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, you must
enter a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column. AutoInvoice will ignore any value that you enter in this column.
For on-account credits do not enter a value in this column.
Validation:
Must be either ’PRORATE’, ’LIFO’, ’UNIT’ or NULL
Destination:
RA_CUSTOMER_TRX_ALL.CREDIT_METHOD_FOR_RULES
CREDIT_METHOD_FOR_INSTALLMENTS
Enter the credit method for crediting a transaction that uses split payment terms. Choices
include PRORATE, LIFO, or FIFO.
If this transaction is a credit memo against a transaction that uses split payment terms
and LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, you may enter
a value in this column. If you do not enter a value, AutoInvoice defaults to PRORATE.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column. AutoInvoice will ignore any value that you enter in this column.
For on-account credits do not enter a value in this column.
Validation:
Must be either ’PRORATE’, ’LIFO’, ’FIFO’ or NULL.
Destination:
RA_CUSTOMER_TRX_ALL.CREDIT_METHOD_FOR_INSTALLMENTS
Oracle Receivables Table and Column Descriptions F-45
CURRENCY_CODE
Enter the currency code for this transaction. You must enter a value in this column.
For credit memos ennter the currency code of the invoice you are crediting.
Validation:
Must exist in FND_CURRENCIES.CURRENCY_CODE
Destination:
RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE and AR_PAYMENT_
SCHEDULES_ALL.INVOICE_CURRENCY_CODE
CUSTOMER_BANK_ACCOUNT_ID
Enter the Bill-To customer bank account ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in CUSTOMER_BANK_ACCOUNT_NAME. If you entered a
value in CUSTOMER_BANK_ACCOUNT_NAME, AutoInvoice defaults a value in this
column.
If the payment method is of type ’Automatic’, and this column is NULL, AutoInvoice
will default a value for you. For more details on how AutoInvoice defaults and validates
customer banks, see: Passing Payment Methods and Customer Bank Accounts, page
3-204.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Must exist in AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID.
If the payment method is of type ’Manual’, RA_INTERFACE_LINES_ALL.CUSTOMER_
BANK_ACCOUNT_ID must be NULL.
Destination:
RA_CUSTOMER_TRX_ALL.CUSTOMER_BANK_ACCOUNT_ID
CUSTOMER_BANK_ACCOUNT_NAME
Enter the Bill-To customer bank account name for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in CUSTOMER_BANK_ACCOUNT_ID.
If the payment method is of type ’Automatic’ and this column is NULL, AutoInvoice
will default a value for you. For more details on how AutoInvoice defaults and validates
customer banks, see: Passing Payment Methods and Customer Bank Accounts, page
3-204.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME
If the payment method is of type ’Manual’, RA_INTERFACE_LINES_ALL.CUSTOMER_
BANK_ACCOUNT_NAME must be NULL.
F-46 Oracle Receivables User Guide
Destination:
None
CUSTOMER_TRX_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
into this column using your grouping rules.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID, AR_PAYMENT_SCHEDULES_ALL.
CUSTOMER_TRX_ID, RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID, and
RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID.
CUST_TRX_TYPE_ID
Enter the transaction type ID for this transaction.
This column is optional, but depending on the value you entered for your batch source
you must enter either a value in this column or in CUST_TRX_TYPE_NAME. If you
entered a value in CUST_TRX_TYPE_NAME, AutoInvoice defaults a value in this
column.
For invoice lines against a commitment, AutoInvoice defaults the invoice transaction
type from the transaction type of the commitment if CUST_TRX_TYPE_ID and
CUST_TRX_TYPE_NAME are null.
For credit memos you must enter the ID of the credit memo transaction type which has
been assigned to the transaction you are crediting.
Validation:
Must exist in RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID
Destination:
RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID
CUST_TRX_TYPE_NAME
Enter the transaction type name for this transaction.
This column is optional, but depending on the value you entered for your batch source
you must enter either a value in this column or in CUST_TRX_TYPE_ID.
For invoice lines against a commitment, AutoInvoice defaults the invoice transaction
type from the transaction type of the commitment if CUST_TRX_TYPE_ID and
CUST_TRX_TYPE_NAME are null.
For credit memos you must enter the name of the credit memo transaction type which
has been assigned to the transaction you are crediting.
Validation:
RA_CUST_TRX_TYPES_ALL.NAME
Destination:
None
DESCRIPTION
This is a required column in AutoInvoice. Enter the description for this transaction.
Oracle Receivables Table and Column Descriptions F-47

Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.DESCRIPTION
DOCUMENT_NUMBER
Enter the document number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight and the creation
method for the sequence numbering of this transaction is Manual, you must enter
a value in this column.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight and the creation
method is Automatic, do not enter a value in this column. AutoInvoice will create a
unique document number.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Number must not already exist in Oracle Receivables
Destination:
RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_VALUE
DOCUMENT_NUMBER_SEQUENCE_ID
This column is used by AutoInvoice and should be left null. AutoInvoice uses this
column to store the document sequence ID for this transaction.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_ID
EXCEPTION_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
in this column when a tax exception occurs.
If your transaction is a credit memo, AutoInvoice defaults the tax exemption ID of the
transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.ITEM_EXCEPTION_RATE_ID
EXEMPTION_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
in this column when this transaction is partially or fully exempt from tax.
For credit memos AutoInvoice defaults the tax exception ID of the transaction you are
crediting.
F-48 Oracle Receivables User Guide
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPTION_ID
FOB_POINT
Enter the FOB point for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the FOB point
from the transaction you are crediting.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUPS.LOOKUP_TYPE
= ’FOB’. Must be less than or equal to 30 characters in length.
Destination:
RA_CUSTOMER_TRX_ALL.FOB_POINT
GL_DATE
Enter the general ledger date for this transaction. The GL date determines the accounting
period that you record this transaction to your general ledger. If the Post To GL option
on the transaction type of the transaction being passed is set to No, the GL_DATE
column should be NULL.
If LINE_TYPE = ’LINE’, ’CHARGES’, and you are passing transactions without rules or
you are passing header freight, this column is optional.
If LINE_TYPE = ’LINE’ and you are importing transactions with rules, do not enter a
date in this column.
If LINE_TYPE = ’TAX’ or ’FREIGHT’, do not enter a value in this column.
For credit memos, AutoInvoice defaults to the date you run AutoInvoice, unless the
transaction you are crediting is billed in arrears. In that case, AutoInvoice defaults to the
GL date of the transaction you are crediting.
For a more details on general ledger dates, see: Determining Dates, page 3-222.
Validation:
Must be in an open or future enterable accounting period and the period must exist
in GL_PERIOD_STATUSES. If ’Post To GL’ is set to No on the transaction type of the
transaction being passed, column must be NULL.
If your invoice uses Bill in Arrears as the invoicing rule, then the GL_DATE column
should be NULL.
Destination:
RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE
HEADER_ ATTRIBUTE1-15
Enter Descriptive Flexfield attribute information for the Transaction Information
Flexfield. Descriptive Flexfield attributes let you store additional columns, the contents
of which you define.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or ’FREIGHT’, do not enter values in these columns.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.ATTRIBUTE1-15
Note: To ensure that AutoInvoice accurately groups your imported invoices, do not
include newline or carriage return characters (chr(10) or chr(13)) in these Descriptive
Flexfield columns.
HEADER_ATTRIBUTE_CATEGORY
For the Transaction Information Flexfield, enter Descriptive Flexfield attribute category
information which is shared between this transaction and other transactions. Descriptive
Flexfield categories allow you to store different categories of attributes.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line’, do not enter values
in these columns.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.ATTRIBUTE_CATEGORY
HEADER_GDF_ATTRIBUTE1-30
Reserved for country-specific functionality.
Validation:
Performed by Oracle Global Financials
Destination:
RA_CUSTOMER_TRX_ALL.GLOBAL_ATTRIBUTE1-30
HEADER_GDF_ATTR_CATEGORY
Reserved for country-specific functionality.
Validation:
Performed by Oracle Global Financials
Destination:
RA_CUSTOMER_TRX_ALL.GLOBAL_ATTRIBUTE_CATEGORY
INITIAL_CUSTOMER_TRX_ID
This column is used by AutoInvoice and should be left null.
F-50 Oracle Receivables User Guide
If this transaction is not a credit memo, AutoInvoice defaults a value into this column
using RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID
INTERFACE_LINE_ATTRIBUTE1-15
Enter the Line Transaction Flexfield for this transaction. The Line Transaction Flexfield
is a combination of attribute values that you use to uniquely identify this transaction
line in your original system. The reference value you enter here provides you with an
audit trail from Receivables back to your original system. You must enter values for
enabled attributes.
Receivables copies the Line Transaction Flexfield to the Invoice Transaction
Flexfield. When you import transactions with multiple lines using AutoInvoice, the
attributes of the first line from the ordered lines will appear in the Invoice Transaction
Flexfield.
Note: Interface lines belonging to the same transaction are ordered by
the following SQL clause:
waybill_numbership_via asc,
ship_date_actual desc
If a transaction has only one line, then the Invoice Transaction Flexfield will be the same
as the Line Transaction Flexfield.
Validation:
Must not already exist together with INTERFACE_LINE_CONTEXT in
RA_INTERFACE_LINES_ALL and RA_CUSTOMER_TRX_LINES_ALL.
All enabled attributes for a given INTERFACE_LINE_CONTEXT must have
values. Different attribute columns may be enabled depending on the value in the
INTERFACE_LINE_CONTEXT column.
Destination:
RA_CUSTOMER_TRX_ALL.INTERFACE_HEADER_ATTRIBUTE1-15 and
RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE1-15
Note: To ensure that AutoInvoice accurately groups your imported invoices, do not
include newline or carriage return characters (chr(10) or chr(13)) in these Descriptive
Flexfield columns.
INTERFACE_LINE_CONTEXT
This is a required column in AutoInvoice. Enter the context of the Line Transaction
Flexfield entered in columns INTERFACE_LINE_ATTRIBUTE1-15. If you pass
information with global context, set this column to ’Global Data Elements’.
Validation:
None
Oracle Receivables Table and Column Descriptions F-51
Destination:
RA_CUSTOMER_TRX_ALL.INTERFACE_HEADER_CONTEXT and
RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_CONTEXT
INTERFACE_LINE_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
in this column using the RA_CUSTOMER_TRX_LINES_S sequence.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID
INTERFACE_STATUS
This column is used by AutoInvoice and should be left null. If AutoInvoice sets this
column to ’P’ then the line has been transferred successfully.
INTERNAL_NOTES
Enter internal notes for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing freight header, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter text
in this column.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.INTERNAL_NOTES
INVENTORY_ITEM_ID
Enter the inventory item ID for this transaction.
If LINE_TYPE = ’LINE’, or ’CHARGES’ this column is optional. Depending on the
value you entered for your batch source you can enter either a value in this column or
a combination of segment values in MTL_SYSTEM_ITEMS_SEG1-20. If you specify
segments in your batch source, AutoInvoice defaults a value in this column.
If LINE_TYPE = ’TAX’ or ’FREIGHT’, do not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the value from
the transaction you are crediting.
Validation:
Must exist in MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID and MTL_SYSTEM_
ITEMS.INVOICE_ENABLED_FLAG = ’Y’.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.INVENTORY_ITEM_ID
INVOICING_RULE_ID
Enter the invoicing rule ID for this transaction.
F-52 Oracle Receivables User Guide
If LINE_TYPE = ’LINE’ or you are passing header freight, this column is optional. For
invoice lines with rules, you must enter either a value in this column or in
INVOICING_RULE_NAME, depending on the value you entered for your batch
source. If you specify invoicing rule name in your batch source, AutoInvoice defaults
a value in this column.
If LINE_TYPE = ’TAX’, ’CHARGES’, or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the invoicing
rule from the transaction you are crediting.
Validation:
Must exist in RA_RULES.RULE_ID and RA_RULES.RULE_ID = -2 or -3. If you enter
an invoicing rule you must also enter an accounting rule. If LINE_TYPE = ’CHARGES’
then this column must be null.
Destination:
RA_CUSTOMER_TRX_ALL.INVOICING_RULE_ID
INVOICING_RULE_NAME
Enter the invoicing rule name for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, this column is optional. For
invoice lines with rules, you must enter either a value in this column or in
INVOICING_RULE_ID, depending on the value you entered for your batch source. You
can enter a value in this column or in INVOICING_RULE_ID.
If LINE_TYPE = ’TAX’, ’CHARGES’ or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the invoicing
rule from the transaction you are crediting.
Validation:
Must exist in RA_RULES.RULE_ID and RA_RULES.RULE_ID = -2 or -3. If you enter
an invoicing rule you must also enter an accounting rule. If LINE_TYPE = ’CHARGES’
then this column must be null.
Destination:
None
LAST_PERIOD_TO_CREDIT
For unit credit memos, enter the last period number from which you want to start
crediting.
If this transaction is a credit memo against a transaction which uses an accounting rule
and LINE_TYPE = ’LINE’, CREDIT_METHOD_FOR_ACCT_RULE = ’UNIT’, or you are
passing header freight, you may enter a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column. AutoInvoice will ignore any value that you enter in this column.
Validation:
Must be between 0 and the invoice’s accounting rule duration (inclusive).
Destination:
RA_CUSTOMER_TRX_LINES_ALL.LAST_PERIOD_TO_CREDIT
Oracle Receivables Table and Column Descriptions F-53
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_LINES_ALL table for processing.
Validation:
None
Destination:
None
LINE_GDF_ATTRIBUTE1-20
Reserved for country-specific functionality.
Validation:
Performed by Oracle Global Financials
Destination:
RA_CUSTOMER_TRX_LINES_ALL.GLOBAL_ATTRIBUTE1-20
LINE_GDF_ATTR_CATEGORY
Reserved for country-specific functionality.
Validation:
Performed by Oracle Global Financials
Destination:
RA_CUSTOMER_TRX_LINES_ALL.GLOBAL_ATTRIBUTE_CATEGORY
LINE_NUMBER
This column is used by AutoInvoice and should be left null. AutoInvoice ignores any
values passed in this column and always numbers the lines sequentially starting with the
number 1 and in the order determined by the line ordering rule.
LINE_TYPE
Enter ’LINE’, ’TAX’, ’FREIGHT’ or ’CHARGES’ to specify the line type for this
transaction. (CHARGES refers to finance charges.) You must enter a value in this column.
For credit memos enter the type of line you are crediting.
Validation:
Must be ’LINE’, ’TAX’, ’FREIGHT’ or ’CHARGES’
Destination:
RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE
LINK_TO_LINE_ ATTRIBUTE1-15
Enter the link to your Transaction Flexfield attribute values.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, do not enter
values in these columns.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, you must enter a
value. Use link to line attributes to associate this tax or freight line to another transaction
line in RA_INTERFACE_LINES_ALL. All tax lines and freight for specific lines must be
associated with a line that has a LINE_TYPE of ’LINE’. Enter the same combination of
attribute values as the transaction to which you want to associate with.
F-54 Oracle Receivables User Guide
For credit memos applied to tax lines, you must use these columns to link your credit
memo tax lines to your credit memo transaction. Similarly, for credit memos applied to
freight lines you must also use these columns to link your credit memo freight line to
your credit memo transaction.
If you are applying a credit memo against a tax line which is linked to a transaction, you
must enter a dummy credit memo transaction with a zero revenue amount and use
these columns to link to your credit memo tax line. Similarly, if you are applying a
credit memo against a freight line which is linked to a transaction, you must also enter a
dummy credit memo transaction with a zero revenue amount and use these columns
to link to your credit memo freight line.
Validation:
The transaction that you link to must have a LINE_TYPE = ’LINE’. You can only link
at most one freight line to another transaction. You cannot link a transaction that has a
LINE_TYPE = ’LINE’ or ’CHARGES’ to another transaction.
Destination:
None
LINK_TO_LINE_CONTEXT
Enter the context name of the Transaction Flexfield data that you entered in
RA_INTERFACE_LINES_ALL.LINK_TO_LINE_ATTRIBUTE1-15.
Validation:
None
Destination:
None
LINK_TO_LINE_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
into this column using RA_INTERFACE_LINES_ALL.LINK_TO_LINE_ATTRIBUTE1-15
and RA_INTERFACE_LINES_ALL.LINK_TO_LINE_CONTEXT.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.LINK_TO_CUST_TRX_LINE_ID
LOCATION_SEGMENT_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a
value into this column if you are crediting a sales tax line.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.LOCATION_SEGMENT_ID
MEMO_LINE_ID
Enter the standard memo line ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
Oracle Receivables Table and Column Descriptions F-55
a value in this column or in MEMO_LINE_NAME. If you specify memo line name in
your batch source, AutoInvoice defaults a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the memo
line from the transaction you are crediting.
Validation:
Must exist in AR_MEMO_LINES_ALL.MEMO_LINE_ID
Destination:
RA_CUSTOMER_TRX_LINES_ALL.MEMO_LINE_ID
MEMO_LINE_NAME
Enter the name of the standard memo line for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in MEMO_LINE_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the memo
line from the transaction you are crediting.
Validation:
Must exist in AR_MEMO_LINES_ALL.NAME
Destination:
None
MOVEMENT_ID
This column is used to pass movement statistics that are tied to the shipment information
and passed through AutoInvoice.
AutoInvoice will populate the column RA_CUSTOMER_TRX_LINES_ALL.
MOVEMENT_ID with RA_INTERFACE_LINES_ALL.MOVEMENT_ID and
updates MTL_MOVEMENT_STATISTICS with transaction information (for
example, customer_trx_id, batch_id, customer_trx_line_id).
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.MOVEMENT_ID
MTL_SYSTEM_ITEMS_SEG1-20
Assign a System Item Flexfield value for each segment you enable in Receivables. For
example, if you enable six System Item Flexfield segments, you must enter six values in
columns MTL_SYSTEM_ITEMS_SEG1-6. Be sure to enter the correct segment value. For
example, value ’01’ is not the same as ’1’.
If LINE_TYPE = ’LINE’ or ’CHARGES’, these columns are optional. Depending on the
value you entered for your batch source you can enter either values in these columns or
in INVENTORY_ITEM_ID.
F-56 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or ’FREIGHT’, do not enter values in these columns.
For credit memos do not enter values in these columns. AutoInvoice uses the values
from the transaction you are crediting.
For debit memos do not enter values in these columns.
Validation:
Valid combination of System Item Flexfield segment values
Destination:
None
ORG_ID
Enter the ID of the organization that this transaction belongs to. This column is
mandatory in a multi-org environment.
Validation:
AutoInvoice imports transactions whose ORG_ID matches the value of the
MO: Operating Unit profile option.
Destination:
None.
ORIGINAL_GL_DATE
Stores the value of the GL_DATE column before AutoInvoice modifies the GL date. This
column is used by AutoInvoice and should not be populated by the user.
Validation:
None
Destination:
None
ORIG_SYSTEM_BATCH_NAME
Enter the batch name for this transaction. This column is optional.
AutoInvoice does not perform any validation on this column but uses the value entered
when grouping transactions into invoices.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.ORIG_SYSTEM_BATCH_NAME
ORIG_SYSTEM_BILL_ADDRESS_ID
Enter the Bill-To customer address ID for this transaction. This Bill-To customer address
ID is for the Bill-To customer you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or
ORIG_SYSTEM_BILL_CUSTOMER_ID.
If no default Remit_To Address has been specified, then AutoInvoice uses the Bill-To
address to determine the Remit-To address for the customer. If the Remit-To address
cannot be determined, then AutoInvoice will reject the transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you must enter
Oracle Receivables Table and Column Descriptions F-57
either a value in this column or in ORIG_SYSTEM_BILL_ADDRESS_REF. If you specify
the Bill-To customer address reference in your batch source, AutoInvoice defaults
a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADDRESS_ID = HZ_CUST_
ACCT_SITE.CUSTOMER_SITE_ID and RA_INTERFACE_LINES_ALL.ORIG_
SYSTEM_BILL_CUSTOMER_ID = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
and HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID = HZ_CUST_ACCT_S
ITE.CUST_ACCOUNT_ID and HZ_CUST_ACCT_SITE.CUSTOMER_SITE_ID
= HZ_CUST_SITE_USES.CUST_ACCT_SITE_ID and RA_SITE_USES.SITE_USE_CODE
= ’BILL_TO’
Destination:
None
ORIG_SYSTEM_BILL_ADDRESS_REF
Enter the Bill-To customer address reference from your original system. This reference
is for the Bill-To customer you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or
ORIG_SYSTEM_BILL_CUSTOMER_ID. The reference value you enter here provides you
with an audit trail from Receivables back to your original system.
If no default Remit_To Address has been specified, then AutoInvoice uses the Bill-To
address to determine the Remit-To address for the customer. If the Remit-To address
cannot be determined, then AutoInvoice will reject the transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in ORIG_SYSTEM_BILL_ADDRESS_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADDRESS_REF
= HZ_PARTY_SITES.ORIG_SYSTEM_REFERENCE and CUSTOMER_REF
= HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE and HZ_CUST_ACCOUNTS.
CUST_ACCOUNT_ID = HZ_CUST_ACCT_SITE.CUST_ACCOUNT_ID and HZ_CUST_
ACCT_SITE.CUSTOMER_SITE_ID = HZ_CUST_SITE_USES.CUST_ACCT_SITE_ID and
RA_SITE_USES.SITE_USE_CODE = ’BILL_TO’
Destination:
None
ORIG_SYSTEM_BILL_CONTACT_ID
Enter the Bill-To contact ID for this transaction. This Bill-To contact ID must be for
the Bill-To customer that you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or
ORIG_SYSTEM_BILL_CUSTOMER_ID.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_BILL_CONTACT_REF. If you specify the
F-58 Oracle Receivables User Guide
Bill-To customer contact reference in your batch source, AutoInvoice defaults a value
in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUSTOMER_ID
= HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.
ORIG_SYSTEM_BILL_CONTACT_ID = HZ_CUST_SITE_USES.CUSTOMER_SITE_ID
Destination:
RA_CUSTOMER_TRX_ALL.BILL_TO_CONTACT_ID
ORIG_SYSTEM_BILL_CONTACT_REF
Enter the Bill-To contact reference from your original system. This reference is for
the Bill-To customer that you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or
ORIG_SYSTEM_BILL_CUSTOMER_ID. The reference value you enter here provides you
with an audit trail from Oracle Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_BILL_CONTACT_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUSTOMER_ID = HZ_CUST_
ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.ORIG_
SYSTEM_BILL_CONTACT_REF = RA_CONTACTS.ORIG_SYSTEM_REFERENCE
Destination:
None
ORIG_SYSTEM_BILL_CUSTOMER_ID
Enter the Bill-To customer ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column
is optional. Depending on the value you entered for your batch source you must
enter either a value in this column or in ORIG_SYSTEM_BILL_CUSTOMER_REF. If
you specify the Bill-To customer reference in your batch source, AutoInvoice defaults
a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos you must enter the Bill-To customer ID or the Bill-To customer ID of
a related customer of the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
Destination:
RA_CUSTOMER_TRX_ALL.BILL_TO_CUSTOMER_ID
Oracle Receivables Table and Column Descriptions F-59
ORIG_SYSTEM_ BILL_CUSTOMER_REF
Enter a value you can use to uniquely identify this Bill-To customer in your original
system. The reference value you enter here provides you with an audit trail from Oracle
Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in ORIG_SYSTEM_BILL_CUSTOMER_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos you must enter the Bill-To customer reference or the Bill-To customer
reference of a related customer of the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE
Destination:
None
ORIG_SYSTEM_SHIP_ADDRESS_ID
Enter the Ship-To customer address ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_ADDRESS_REF. If you specify the
Ship-To address reference in your batch source, AutoInvoice defaults a value in this
column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column; AutoInvoice uses the Ship-To
address from the transaction you are crediting.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_ADDRESS_ID = HZ_CUST_
ACCT_SITE.CUSTOMER_SITE_ID and RA_INTERFACE_LINES_ALL.ORIG_
SYSTEM_SHIP_CUSTOMER_ID = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
and HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID = HZ_CUST_ACCT_SITE.CUST_
ACCOUNT_ID and HZ_CUST_ACCT_SITE.CUSTOMER_SITE_ID = HZ_CUST_SITE_
USES.CUST_ACCT_SITE_ID and HZ_CUST_SITE_USES.SITE_USE_CODE = ’SHIP_TO’
Destination:
None
ORIG_SYSTEM_SHIP_ADDRESS_REF
Enter a value you can use to uniquely identify this Ship-To customer address in your
original system. The reference value you enter here provides you with an audit trail from
Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_ADDRESS_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
F-60 Oracle Receivables User Guide
For credit memos do not enter a value in this column, AutoInvoice uses the Ship-To
address from the transaction you are crediting.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_ADDRESS_REF
= HZ_PARTY_SITES.ORIG_SYSTEM_REFERENCE and RA_INTERFACE_L
INES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID = HZ_CUST_ACCOUNTS.
CUST_ACCOUNT_ID and HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
= HZ_CUST_ACCT_SITE.CUST_ACCOUNT_ID and HZ_CUST_ACCT_SITE.
CUSTOMER_SITE_ID = HZ_CUST_SITE_USES.CUST_ACCT_SITE_ID and
HZ_CUST_SITE_USES.SITE_USE_CODE = ’SHIP_TO’
Destination:
None
ORIG_SYSTEM_SHIP_CONTACT_ID
Enter the Ship-To contact ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_CONTACT_REF. If you specify the
Ship-To contact reference in your batch source, AutoInvoice defaults a value in this
column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To
contact from the transaction you are crediting.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID
= HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.
ORIG_SYSTEM_SHIP_CONTACT_ID = HZ_CUST_SITE_USES.CUSTOMER_SITE_ID
Destination:
RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID
ORIG_SYSTEM_SHIP_CONTACT_REF
Enter a value you can use to uniquely identify this Ship-To contact in your original
system. The reference value you enter here provides you with an audit trail from
Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_CONTACT_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To
contact from the transaction you are crediting.
Validation:
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID
= HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_
Oracle Receivables Table and Column Descriptions F-61
ALL.ORIG_SYSTEM_SHIP_CONTACT_REF = HZ_CUST_ACCOUNT_ROLES.ORIG_
SYSTEM_REFERENCE
Destination:
None
ORIG_SYSTEM_SHIP_CUSTOMER_ ID
Enter the Ship-To customer ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_CUSTOMER_REF. If you specify the
Ship-To customer reference in your batch source, AutoInvoice defaults a value in this
column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To
customer from the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
Destination:
RA_CUSTOMER_TRX_ALL.SHIP_TO_CUSTOMER_ID
ORIG_SYSTEM_SHIP_CUSTOMER_REF
Enter a value you can use to uniquely identify this Ship-To customer in your original
system. The reference value you enter here provides you with an audit trail from
Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SHIP_CUSTOMER_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To
customer from the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE
Destination:
None
ORIG_SYSTEM_SOLD_CUSTOMER_ID
Enter the Sold-To customer ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SOLD_CUSTOMER_REF. If you specify the
Sold-To customer reference in your batch source, AutoInvoice defaults a value in this
column.
F-62 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value. AutoInvoice uses the Sold-To customer from
the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
Destination:
RA_CUSTOMER_TRX_ALL.SOLD_TO_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_REF
Enter a value you can use to uniquely identify this Sold-To customer in your original
system. The reference value you enter here provides you with an audit trail from
Receivables back to your original system.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in ORIG_SYSTEM_SOLD_CUSTOMER_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value, AutoInvoice uses the Sold-To customer from
the transaction you are crediting.
Validation:
Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE
Destination:
None
OVERRIDE_AUTO_ACCOUNTING_FLAG
This column controls whether the code combination ID of the Accounting Flexfield
for this accounting distribution, populated by the feeder system, should override
AutoAccounting.
AutoInvoice uses this column only if the passed transaction line is assigned a valid
lookup code from the AR_REVENUE_CONTINGENCIES lookup type. Lookup codes
are passed to the RA_INTERFACE_LINES_ALL table.
Populate this column for invoices and credit memos.
Validation:
Value should be Y or N.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.OVERRIDE_AUTO_ACCOUNTING_FLAG
PAYMENT_SET_ID
This column contains a unique internal ID number that matches prepaid invoices with
their prepayment receipts. This column should be populated only within a prepayments
flow.
Validation:
Must exist in AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SET_ID
Oracle Receivables Table and Column Descriptions F-63
Destination:
RA_CUSTOMER_TRX_LINES_ALL.PAYMENT_SET_ID
PAYING_CUSTOMER_ID
This column is used by AutoInvoice and should be left null. Please refer to the section on
Automatic Receipts for details on how AutoInvoice determines the paying customer.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PAYING_CUSTOMER_ID
PAYING_SITE_USE_ID
This column is used by AutoInvoice and should be left null. Please refer to the section on
Automatic Receipts for details on how AutoInvoice determines the paying site use.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID
PAYMENT_SERVER_ORDER_NUM
A number that indicates the credit card payment was authorized by Oracle Payment
Server.
Validation
None
Destination
RA_CUSTOMER_TRX_ALL.PAYMENT_SERVER_ORDER_NUM
PREVIOUS_CUSTOMER_TRX_ID
This column is used by AutoInvoice and should be left null.
For credit memos, AutoInvoice defaults a value into this column using
RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID and RA_CUSTOMER_
TRX_LINES_ALL.CUSTOMER_TRX_ID
PRIMARY_SALESREP_ID
Enter the primary salesperson ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and you entered
Yes for the Require Salesreps system option, you must enter either a value in this column
or in PRIMARY_SALESREP_NUMBER. Otherwise this column is optional. The value
that you enter depends on the value you entered for your batch source. If you specify the
primary salesrep ID in your batch source, AutoInvoice defaults a value in this column.
F-64 Oracle Receivables User Guide
If LINE_TYPE = ”TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Must exist in RA_SALESREPS.SALESREP_ID
Destination:
RA_CUSTOMER_TRX_ALL.PRIMARY_SALESREP_ID
PRIMARY_SALESREP_NUMBER
Enter the primary salesperson number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and you entered
Yes for the Require Salesreps system option, you must enter either a value in this column
or in PRIMARY_SALESREP_ID. Otherwise this column is optional. The value that you
enter depends on the value you entered for your batch source.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Must exist in RA_SALESREPS.SALESREP_NUMBER
Destination:
None
PRINTING_OPTION
Enter the printing option for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. AutoInvoice defaults to the printing option that you entered for this transaction
type, if one was entered.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUP.LOOKUP_TYPE
= ’INVOICE_PRINT_OPTIONS’
Destination:
RA_CUSTOMER_TRX_ALL.PRINTING_OPTION
PROMISED_COMMITMENT_AMOUNT
Enter the amount of an existing deposit to use as payment towards a specific transaction.
When an order is imported into Receivables with a value in this column, Receivables
adjusts the resulting invoice and reduces the deposit balance by the lesser of the
promised amount, the commitment balance, or the remaining amount due on the invoice.
If this column has no value, then the commitment adjustment will be for the lesser of the
total outstanding commitment or the total balance of the transaction.
Validation:
None
Destination:
None
Oracle Receivables Table and Column Descriptions F-65
PURCHASE_ORDER
Enter the purchase order number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the purchase
order number from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER
PURCHASE_ORDER_DATE
Enter the date of the purchase order for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the purchase
order date from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
Enter the purchase order revision for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos, do not enter a value in this column. AutoInvoice uses the purchase
order revision from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER_REVISION
QUANTITY
If this transaction is an invoice or credit memo line and LINE_TYPE = ’LINE’ or you are
passing header freight, this column is optional. For invoice lines, enter the number of
units shipped. For credit memo lines, enter the number of units you are crediting. If you
do not enter a value in this column, AutoInvoice uses AMOUNT as the extended amount
F-66 Oracle Receivables User Guide
for this transaction. If this transaction is a dummy line for either freight only or tax
only, AutoInvoice ignores the value you enter in this column.
If this is a Credit Memo line and LINE_TYPE = ’LINE’, CREDIT_METHOD_FOR_
ACCT_RULE = ’UNIT’ then this column is mandatory.
For Debit Memos, if LINE_TYPE = ’CHARGES’, set quantity to 1.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For Credit Memos, if LINE_TYPE = ’CHARGES’, set quantity to 1 or -1.
Validation:
For Debit Memos lines with LINE_TYPE = ’CHARGES’, quantity must be 1. For Credit
Memo lines with LINE_TYPE = ’CHARGES’, this column must be 1 or -1.
For Credit Memo lines with LINE_TYPE = ’LINE’ and CREDIT_METHOD_FOR_ACCT_
RULE = ’UNIT’ then this column must not be null.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.QUANTITY_INVOICED if this transaction is
an invoice line. RA_CUSTOMER_TRX_LINES_ALL.QUANTITY_CREDITED if this
transaction is a credit memo line.
QUANTITY_ORDERED
Enter the original number of units ordered for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing freight for a specific line, this
column is optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a
value in this field.
For credit memos, do not enter a value in this column. AutoInvoice uses the quantity
ordered from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.QUANTITY_ORDERED
REASON_CODE
Enter the reason code for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in REASON_CODE_MEANING. If you specify the reason code
meaning in your batch source, AutoInvoice defaults a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits this column is optional.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE. This lookup type is either
INVOICING_REASON or CREDIT_MEMO_REASON
Oracle Receivables Table and Column Descriptions F-67
Destination:
RA_CUSTOMER_TRX_LINES_ALL.REASON_CODE and RA_CUSTOMER_TRX_ALL.
REASON_CODE
REASON_CODE_MEANING
Enter the meaning of the reason code for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in REASON_CODE.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits this column is optional.
Validation:
Must exist in AR_LOOKUPS.MEANING. This lookup type is either
INVOICING_REASON or CREDIT_MEMO_REASON
Destination:
None
RECEIPT_METHOD_ID
Enter the payment method ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in RECEIPT_METHOD_NAME. If you specify the payment
method name in your batch source, AutoInvoice defaults a value in this column.
AutoInvoice always defaults the payment method using the following hierarchy:
1. primary receipt method of the parent primary bill-to site
2. primary receipt method of the parent customer
3. primary receipt method of the bill-to site
4. primary receipt method of the bill-to customer
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a
value in this field.
Validation:
Must exist in AR_RECEIPT_METHODS.RECEIPT_METHOD_ID and must belong to
the bill-to customer or the parent. Additionally, the payment method must have at
least one bank account in the same currency as the transaction or have its Receipts
Multi-Currency flag set to Yes.
Destination:
RA_CUSTOMER_TRX_ALL.RECEIPT_METHOD_ID
RECEIPT_METHOD_NAME
Enter the name of the payment method for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter either
a value in this column or in RECEIPT_METHOD_ID.
F-68 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a
value in this field.
Validation:
Must exist in AR_RECEIPT_METHODS.NAME and must belong to the bill-to customer
or the parent.
Destination:
None
REFERENCE_LINE_ATTRIBUTE1-15
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and
this transaction is a credit memo, you must enter either the Transaction
Flexfield of the transaction line you are crediting in these columns or the
RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction you
are crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID. Otherwise, do
not enter values in these columns.
If LINE_TYPE = ’TAX’ and this transaction is a credit memo, you must enter either
the Transaction Flexfield of the tax line you are crediting in these columns or the
RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction
tax line you are crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.
Otherwise, do not enter values in these columns.
If LINE_TYPE= ’FREIGHT’ and this transaction is a credit memo, you must enter either
the Transaction Flexfield of the freight line you are crediting in these columns or the
RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction
freight line you are crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.
Otherwise, do not enter values in these columns.
For on-account credits do not enter values in these columns.
Validation:
Must exist in RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE1-15
or RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ATTRIBUTE1-15
Destination:
None
REFERENCE_LINE_CONTEXT
Enter the context name of the Transaction Flexfield data entered in RA_INTERFACE_L
INES_ALL.REFERENCE_LINE_ATTRIBUTE1-15. You must enter a value in this column
if you entered values in RA_INTERFACE_LINES_ALL.ATTRIBUTE1-15.
Validation:
Must exist in RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_CONTEXT or
RA_INTERFACE_LINES_ALL.INTERFACE_LINE_CONTEXT
Destination:
None
REFERENCE_LINE_ID
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and this
transaction is a credit memo, you must enter the RA_CUSTOMER_TRX_LINES_ALL.
CUSTOMER_TRX_LINE_ID of the transaction line you are crediting in this column or
Oracle Receivables Table and Column Descriptions F-69
the Transaction Flexfield in REFERENCE_LINE_ATTRIBUTE1-15. Otherwise, do not
enter a value.
If LINE_TYPE = ’LINE’ and this transaction is an invoice against a commitment, you
must enter the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the
commitment line you are referencing.
If LINE_TYPE= ’TAX’ and this transaction is a credit memo, you must enter
the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the
tax line you are crediting in these columns or the Transaction Flexfield in
REFERENCE_LINE_ATTRIBUTE1-15. Otherwise, do not enter a value in this column.
If LINE_TYPE = ’FREIGHT’ and this transaction is a credit memo, you must
enter the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the
freight line you are crediting in these columns or the Transaction Flexfield in
REFERENCE_LINE_ATTRIBUTE1-15. Otherwise, do not enter a value in this column.
For on-account credits, do not enter a value in this column.
Validation:
Must exist in RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_LINE_ID if this
transaction is a credit memo. Otherwise, RA_CUSTOMER_TRX_LINES_ALL.INITIAL_
CUSTOMER_TRX_LINE_ID
RELATED_BATCH_SOURCE_NAME
Enter the name of the batch source of the document to which this transaction is related.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you can enter a value
in this column and the related transaction number in RELATED_TRX_NUMBER. Or, you
can enter the related customer transaction ID in RELATED_CUSTOMER_TRX_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits do not enter a value in this column.
Validation:
RA_INTERFACE_LINES_ALL.RELATED_BATCH_SOURCE_NAME = RA_BATCH_
SOURCES_ALL.NAME and RA_INTERFACE_LINES_ALL.RELATED_TRX_NUMBER
= RA_CUSTOMER_TRX_ALL.TRX_NUMBER and RA_BATCH_SOURCES_ALL.
BATCH_SOURCE_ID = RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID
Destination:
None
RELATED_CUSTOMER_TRX_ID
Enter the customer transaction ID of the document to which this transaction is related.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this
column is optional. Depending on the value you entered for your batch source
you can enter a value in this column. Or, you can enter the related transaction
number in RELATED_TRX_NUMBER and the related batch source name in
RELATED_BATCH_SOURCE_NAME.
F-70 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits do not enter a value in this column.
Validation:
Must exist in RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID
Destination:
RA_CUSTOMER_TRX_ALL.RELATED_CUSTOMER_TRX_ID
RELATED_TRX_NUMBER
Enter the document number to which this transaction is related.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this
column is optional. Depending on the value you entered for your batch source
you can enter a value in this column and the related batch source name in
RELATED_BATCH_SOURCE_NAME. Or, you can enter the related customer transaction
ID in RELATED_CUSTOMER_TRX_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits do not enter a value in this column.
Validation:
RA_INTERFACE_LINES_ALL.RELATED_BATCH_SOURCE_NAME = RA_BATCH_
SOURCES_ALL.NAME and RA_INTERFACE_LINES_ALL.RELATED_TRX_NUMBER
= RA_CUSTOMER_TRX_ALL.TRX_NUMBER and RA_BATCH_SOURCES_ALL.
BATCH_SOURCE_ID = RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID
Destination:
None
REQUEST_ID
This column is used by AutoInvoice and should be left null.
Validation:
None
Destination:
The REQUEST_ID column in RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_
LINES_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, AR_PAYMENT_SCHEDULES_
ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_ADJUSTMENTS_ALL and
RA_CUST_TRX_LINE_SALESREPS_ALL.
RULE_START_DATE
Enter the date that you want to start the accounting rule for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, this column is optional. If you
specify Specific Date in your accounting rule do not enter a value in this column.
If LINE_TYPE = ’TAX’, ’CHARGES’, or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column.
For more information about rule start dates, see: Determining Dates, page 3-222.
Oracle Receivables Table and Column Descriptions F-71
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.RULE_START_DATE
SALES_ORDER
Enter the sales order number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the sales order
number from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER
SALES_ORDER_DATE
Enter the date of the sales order for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the sales order
date from the transaction you are crediting.
Enter the date of the revenue order for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the revenue
order date from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_DATE
SALES_ORDER_LINE
Enter the sales order line number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
F-72 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the sales order
line number from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_LINE
SALES_ORDER_REVISION
Enter the sales order revision for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the sales order
revision from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_REVISION
SALES_ORDER_SOURCE
Enter the source of the sales order for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the source of the
sales order from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_SOURCE
SALES_TAX_ID
This column is used by AutoInvoice and should be left null.
For credit memos, AutoInvoice defaults to the sales tax ID of the transaction you are
crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.SALES_TAX_ID
Oracle Receivables Table and Column Descriptions F-73
SET_OF_BOOKS_ID
Optionally enter the set of books ID for this transaction. If no value exists, then
Receivables defaults the set of books from the System Options window for the
organization that is specified in the ORG_ID column.
Validation:
Must exist in AR_SYSTEM_PARAMETERS_ALL.SET_OF_BOOKS_ID
Destination:
RA_CUSTOMER_TRX_ALL.SET_OF_BOOKS_ID
SHIP_DATE_ACTUAL
Enter the shipment date for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the earliest
shipment date from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.SHIP_DATE_ACTUAL
SHIP_VIA
Enter the ship via code for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the ship via
code from the transaction you are crediting.
Validation:
ORG_FREIGHT.FREIGHT_CODE = RA_INTERFACE_LINES_ALL.SHIP_VIA and
ORG_FREIGHT.ORGANIZATION_ID = RA_INTERFACE_LINES_ALL.WAREHOUSE_
ID. RA_INTERFACE_LINES_ALL.SHIP_VIA must be less than or equal to 25 characters
in length.
Destination:
RA_CUSTOMER_TRX_ALL.SHIP_VIA
TAX_CODE
Enter the tax code for this tax line.
If LINE_TYPE = ’CHARGES’, or ’FREIGHT’, do not enter a value in this column.
If LINE_TYPE = ’LINE’, this column is optional.
If LINE_TYPE = ’TAX’, this column is mandatory.
F-74 Oracle Receivables User Guide
For credit memos, AutoInvoice defaults the tax code from the transaction you are
crediting.
Validation:
Must exist in AR_VAT_TAX.TAX_CODE
Destination:
None
TAX_EXEMPT_FLAG
If LINE_TYPE = ’LINE’, this column is optional. The value you enter here controls
how a line is taxed. Enter ’E’ if you want AutoInvoice to exempt an invoice line that
would normally be taxed and your system option ’Use Customer Exemptions’ is set to
Yes. If you enter ’E’ you must enter a value for TAX_EXEMPT_REASON_CODE or
TAX_EXEMPT_REASON_CODE_MEANING, depending on your batch source option.
Enter ’R’ if you want AutoInvoice to force tax on an invoice line, ignoring any exemption
certificates that may be on file. Enter ’S’ if you want tax to be calculated as per the normal
procedures set up in Receivables.
For all other line types and credit memos,, do not enter a value in this column.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE. Lookup type is TAX_CONTROL_FLAG.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPT_FLAG
TAX_EXEMPT_NUMBER
Enter the tax exempt number for this transaction. If LINE_TYPE = ’LINE’ and
tax_exempt_flag = ’E’, then you may enter a value in this column. Otherwise, do not
enter a value in this column.
For all other line types, do not enter a value in this column.
For credit memos, do not enter a value in this column.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPT_NUMBER
TAX_EXEMPT_REASON_CODE
Enter the tax exempt reason code for this transaction. If LINE_TYPE = ’LINE’ and
tax_exempt_flag = ’E’, then depending on your batch source option, Memo Reason, you
must enter a value in this column or in TAX_EXEMPT_REASON_CODE_MEANING. If
you specify a tax exempt reason code meaning in your batch source, AutoInvoice
defaults the code in this column.
For all other line types, do not enter a value in this column.
For credit memos do not enter a value in this column.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE. Lookup type is TAX_REASON.
Oracle Receivables Table and Column Descriptions F-75
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPT_REASON_CODE
TAX_EXEMPT_REASON_CODE_MEANING
Enter the tax exempt reason code meaning for this transaction. If LINE_TYPE = ’LINE’ and
tax_exempt_flag = ’E’, then depending on your batch source option, Memo Reason, you
must enter a value in this column or in TAX_EXEMPT_REASON_CODE. Otherwise, do
not enter a value in this column.
For all other line types and credit memos, do not enter a value in this column.
Validation:
Must exist in AR_LOOKUPS.MEANING. Lookup type is TAX_REASON.
Destination:
None
TAX_PRECEDENCE
Enter the precedence number for this tax line. This column is used to compute tax
compounding.
If LINE_TYPE = ’LINE’, ’CHARGES’, or ’FREIGHT’, do not enter a value in this column.
If LINE_TYPE = ’TAX’ and you allow compound tax, you can enter a value in this
column. Otherwise do not enter a value.
If you are passing freight for a specific line, do not enter a value in this column.
For credit memos AutoInvoice defaults the tax precedence from the transaction you
are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_PRECEDENCE
TAX_RATE
Enter the tax rate for this tax line.
If LINE_TYPE = ’LINE’, ’CHARGES’, or ’FREIGHT’, do not enter a value in this column.
If LINE_TYPE = ’TAX’, you must enter a value either in this column or the AMOUNT
column. Any exemptions for the tax lines must be factored into the tax rate.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.TAX_RATE
TERM_ID
Enter the payment term ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in TERM_NAME. If you specify term name in your batch
source, AutoInvoice defaults a value in this column.
F-76 Oracle Receivables User Guide
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits do not enter a value in this column.
Validation:
Must exist in RA_TERMS.TERM_ID
Destination:
RA_CUSTOMER_TRX_ALL.TERM_ID
TERM_NAME
Enter the name of the payment term for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in TERM_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos and on-account credits do not enter a value in this column.
Validation:
Must exist in RA_TERMS.NAME
Destination:
None
TERRITORY_ID
Enter the territory ID for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column
is optional. Depending on the value you entered for your batch source you can
enter either a value in this column or a combination of territory segment values in
TERRITORY_SEGMENT1-20. If you specify the combination of territory segment values
in your batch source, AutoInvoice defaults a value in this column.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the territory
from the transaction you are crediting.
Validation:
Must exist in RA_TERRITORIES.TERRITORY_ID
Destination:
RA_CUSTOMER_TRX_ALL.TERRITORY_ID
TERRITORY_SEGMENT1-20
Assign a Territory Flexfield value for each segment you enable in Receivables. For
example, if you enable six Territory Flexfield segments, you must enter six values in
columns TERRITORY_SEGMENT1-6. Be sure to enter the correct segment value. For
example, value ’01’ is not the same as ’1’.
Oracle Receivables Table and Column Descriptions F-77
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, these columns
are optional. Depending on the value you entered for your batch source you can enter
either values in these columns or in TERRITORY_ID.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter values
in these columns.
For credit memos do not enter values in these columns. AutoInvoice uses the territory
from the transaction you are crediting.
Validation:
Valid combination of Territory Flexfield segment values from RA_TERRITORIES
Destination:
None
TRANSLATED_DESCRIPTION
The translated description of this transaction line (used for multi-lingual support)
Validation
None
Destination
RA_CUSTOMER_TRX_LINES_ALL.TRANSLATED_DESCRIPTION
TRX_DATE
Enter the transaction date for this transaction.
If TRX_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. If this transaction is an invoice or debit memo line, you can enter the invoice
date. If this transaction is a credit memo line, you can enter the credit memo date. If this
transaction is an invoice line and uses an Arrears Invoice invoicing rule, do not enter
a value in this column.
If you do not enter a transaction date, AutoInvoice uses the general ledger date for
invoice and debit memo lines. For credit memo lines, AutoInvoice uses the following
hierarchy: credit memo general ledger date, and the general ledger date for the invoice’s
receivable distribution or the date in the Run AutoInvoice window, whichever is later.
When child invoices are created against a commitment, AutoInvoice ensures that the
child invoice’s transaction date falls between the commitment’s start and end dates.
If TRX_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.TRX_DATE
TRX_NUMBER
Enter the number for this transaction.
If TRX_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and your batch
source has Automatic Invoice Numbering set to No, you must enter a value in this
column.
F-78 Oracle Receivables User Guide
If TRX_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, and your batch
source has Automatic Invoice Numbering set to Yes, do not enter a value in this
column. AutoInvoice inserts a unique number in this column.
If TRX_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
Must not already exist in RA_CUSTOMER_TRX_ALL.TRX_NUMBER and
RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID
Destination:
RA_CUSTOMER_TRX_ALL.TRX_NUMBER and AR_PAYMENT_SCHEDULES_ALL.
TRX_NUMBER
UOM_CODE
Enter the unit of measure code for this transaction.
If LINE_TYPE = ’LINE’ and the line has an item you must enter either a value in this
column or in UOM_NAME. If this a freight-only line, a tax-only line, or a line with
no item, this column is optional.
If LINE_TYPE = ’LINE’ and you are passing a dummy line for either a tax-only or
freight-only line, AutoInvoice ignores what you enter here.
If LINE_TYPE = ’TAX’, ’CHARGES’, or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the unit of
measure from the transaction you are crediting.
Validation:
Must exist in MTL_UNITS_OF_MEASURE.UOM_CODE. If Line_type
= ’CHARGES’, then this column must be null.
Destination:
RA_CUSTOMER_TRX_LINES_ALL.UOM_CODE
UOM_NAME
Enter the unit of measure name for this transaction.
If LINE_TYPE = ’LINE’ and the line has an item you must enter either a value in this
column or in UOM_CODE. If this a freight-only line, a tax-only line, or a line with no
item, this column is optional.
If LINE_TYPE = ’LINE’ or you are passing header freight, and you are passing a dummy
line for either a tax-only or freight-only line, AutoInvoice ignores what you enter here.
If LINE_TYPE = ’TAX’, ’CHARGES’, or you are passing freight for a specific line, do
not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the unit of
measure from the transaction you are crediting.
Validation:
Must exist in MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE. If LINE_TYPE
= ’CHARGES’ then this column must be null.
Oracle Receivables Table and Column Descriptions F-79
Destination:
None
UNIT_SELLING_PRICE
Enter the selling price per unit for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional. If you do not enter a value in this column, AutoInvoice defaults to the amount
in RA_INTERFACE_LINES_ALL.AMOUNT as the amount/quantity for this transaction.
If LINE_TYPE = ’LINE’ or you are passing header freight, and you are passing a dummy
line for either a tax-only or freight-only line, AutoInvoice ignores the value you enter
here.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.UNIT_SELLING_PRICE
UNIT_STANDARD_PRICE
Enter the standard price per unit for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the unit standard
price from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.UNIT_STANDARD_PRICE
USSGL_TRANSACTION_CODE
Enter the transaction code for this transaction. If this transaction is linked to another
transaction, you must enter the same transaction code as the one to which it is
linked. This column is optional.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.DEFAULT_USSGL_TRANSACTION_CODE
USSGL_TRANSACTION_CODE_CONTEXT
This column is not currently used by AutoInvoice.
Validation:
None
F-80 Oracle Receivables User Guide
Destination:
None
VAT_TAX_ID
This column is used by AutoInvoice and should be left null. If you enter a value in
TAX_CODE, AutoInvoice defaults a value in this column.
For credit memos AutoInvoice defaults to the VAT tax ID of the transaction you are
crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_LINES_ALL.VAT_TAX_ID
WAREHOUSE_ID
This column identifies the ship-from location and can be used to control taxation. Within
the US, the Warehouse ID is important when calculating tax on the Origin/Modified
Origin state sales tax (outside the US, you can use Tax Groups and Conditions to build
a schedule of multiple conditional taxes based on both the ship-from and ship-to
County/County/State or Provinces).
Validation
None
Destination
RA_CUSTOMER_TRX_LINES_ALL.WAREHOUSE_ID
WAYBILL_NUMBER
Enter the waybill number for this transaction.
If LINE_TYPE = ’LINE’, ’CHARGES’, or you are passing header freight, this column is
optional.
If LINE_TYPE = ’TAX’ or you are passing freight for a specific line do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the waybill
number from the transaction you are crediting.
Validation:
None
Destination:
RA_CUSTOMER_TRX_ALL.WAYBILL_NUMBER
Table Name: RA_INTERFACE_SALESCREDITS_ALL
This table stores sales credit information for your transactions. This table must be
populated if your AutoAccounting is set up to derive segment values based on the
salesrep. If AutoAccounting does not depend on salesrep, then the value you enter
in the Require Salesrep field of the System Options window and Allow Sales Credits
field in the Transaction Sources window will determine whether you must enter sales
credit information. See: AutoAccounting, page 2-38 and Defining Receivables
Options, page 2-129.
Oracle Receivables Table and Column Descriptions F-81
If you are importing invoices, debit memos and on-account credits and your system
option requires a salesperson, you must provide sales credit information, regardless of
the value entered in the Allow Sales Credit field for your transaction batch source.
If you are importing credit memos and your system option requires that you enter
a salesperson, you can provide sales credit information. If you do not provide
sales credit information, AutoInvoice uses sales credit information from the invoice
you are crediting. If the invoice you are crediting does not have sales credit
information, AutoInvoice creates a 100% ’No Sales Credit’ line for this invoice. This sales
credit line is then used to determine the sales credit amount for the credit memo.
Regardless of the type of transaction you are importing, if your system option does not
require salesperson, but your transaction batch source allows sales credits, you can
provide sales credit information. AutoInvoice will validate it and pass this information
with your transaction. If your system option does not require salesperson and your
transaction batch source does not allow sales credits, do not provide sales credit
information. AutoInvoice ignores any values that you pass.
ATTRIBUTE1-15
Enter the Descriptive Flexfield attribute information for this sales or revenue credit
assignment. 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_LINES_SALESREPS_ALL.ATTRIBUTE1-15
ATTRIBUTE_CATEGORY
Enter the Descriptive Flexfield category information for this sales credit
assignment. Descriptive Flexfield categories allow you to store different categories of
attributes. This column is optional.
Validation:
None
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.ATTRIBUTE_CATEGORY
INTERFACE_LINE_ATTRIBUTE1-15
Enter the same Transaction Flexfield for the transaction with which you want to associate
this sales or revenue credit assignment. The values you enter here provide you with an
audit trail from Receivables back to your original system. You must enter a value for
each attribute you enabled.
INTERFACE_LINE_CONTEXT
Enter the context name of the Transaction Flexfield data that you entered in
RA_INTERFACE_SALESCREDITS_ALL.INTERFACE_LINE_ATTRIBUTE1-15. You
must enter a value in this column.
Validation:
None
F-82 Oracle Receivables User Guide

Destination:
None
INTERFACE_LINE_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a
value into this column using RA_INTERFACE_SALESCREDITS_ALL.INTERFACE_
LINE_ATTRIBUTE1-15.
Validation:
None
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_LINE_ID
INTERFACE_SALESCREDIT_ID
This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value
into this column using the sequence RA_CUST_TRX_LINE_SALESREPS_S.
Validation:
None
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.CUST_TRX_LINE_SALESREP_ID
INTERFACE_STATUS
This column is used by AutoInvoice and should be left null.
Validation:
None
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_SALESCREDITS_ALL table
for processing.
Validation:
None
Destination:
None
REQUEST_ID
This column is used by AutoInvoice and should be left null.
Validation:
None
Destination:
None
Oracle Receivables Table and Column Descriptions F-83
SALES_CREDIT_AMOUNT_SPLIT
Enter the sales credit amount for this salesperson. This column is optional. Depending
on the value you entered for your batch source you must enter either a value in this
column or in SALES_CREDIT_PERCENT_SPLIT. If you specify the sales credit percent
in your batch source, AutoInvoice defaults a value in this column.
Validation:
If the sales credit for this sales credit assignment is of type Quota, the sum of sales credit
amounts for a transaction must equal the amount of the transaction.
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_AMOUNT_SPLIT if the sales
credit type is Quota. RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_
AMOUNT_SPLIT if the sales credit type is not Quota.
SALES_CREDIT_PERCENT_SPLIT
Enter the sales credit percent for this salesperson. This column is optional. Depending
on the value you entered for your batch source you must enter either a value in this
column or in SALES_CREDIT_AMOUNT_SPLIT. If you specify the sales or revenue
credit amount in your batch source, AutoInvoice defaults a value in this column.
Validation:
Your sales or revenue credit percent must be between 0 and 100, and if sales credit type
is Quota, the sales credit percentage for a transaction must sum to 100.
SALES_CREDIT_TYPE_ID
Enter the ID of the sales credit type for this sales credit assignment. This column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in SALES_CREDIT_TYPE_NAME. If you specify the
sales credit type name in your batch source, AutoInvoice defaults a value in this column.
Validation:
Must exist in SO_SALES_CREDIT_TYPES.SALES_CREDIT_TYPE_ID
Destination:
None
SALES_CREDIT_TYPE_NAME
Enter the name of the sales credit type for this sales credit assignment. This column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in SALES_CREDIT_TYPE_ID.
Validation:
Must exist in SO_SALES_CREDIT_TYPES.NAME
Destination:
None
SALES_GROUP_ID
Enter the sales group ID for this sales credit assignment. This column is optional.
Validation:
Must exist in JTF_RS_GROUP_USAGES.GROUP_ID and have JTF_RS_GROUP_
USAGES.USAGE = ’SALES’
F-84 Oracle Receivables User Guide
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_SALESGROUP_ID or
RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_SALESGROUP_ID
SALESREP_ID
Enter the salesperson ID for this sales credit assignment. This column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in SALESREP_NUMBER. If you specify the salesperson
number in your batch source, AutoInvoice defaults a value in this column.
Validation:
Must exist in RA_SALESREPS.SALESREP_ID
Destination:
RA_CUST_TRX_LINE_SALESREPS_ALL.SALESREP_ID
SALESREP_NUMBER
Enter the salesperson number for this sales credit assignment. This column is
optional. Depending on the value you entered for your batch source you must enter
either a value in this column or in SALESREP_ID.
Validation:
Must exist in RA_SALESREPS.SALESREP_NUMBER
Destination:
None
Table Name: RA_INTERFACE_DISTRIBUTIONS_ALL
If you do not use AutoAccounting, you must enter accounting distributions for your
transactions. Otherwise, AutoInvoice does not require you to enter accounting
distributions for your transactions.
If your accounting distributions are for transactions that use accounting rules, you must
enter the percentages, but not the amounts. If you enter the amounts, AutoInvoice
will ignore 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 you entered for
your batch source. If you enter an amount, AutoInvoice requires that the distribution
amounts sum to the amount of the transaction. If you enter a percent, AutoInvoice
requires that the distribution percentages sum to 100 for each account class that you pass.
Distributions in this table are linked to the appropriate transaction lines in the
ra_interface_lines via the transaction flexfield. Though the distribution for ’REC’
account class is at the invoice level, it may be linked to any transaction line of the
invoice in ra_interface_lines. 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 are supplying for this
accounting distribution. You must enter a value for this column.
Oracle Receivables Table and Column Descriptions F-85
Validation:
Must be either ’REV’, ’FREIGHT’, ’TAX’, ’REC’, ’CHARGES’, ’UNBILL’, or ’UNEARN’. If
the transaction uses the ’Advance Invoice’ invoicing rule, do not enter ’UNBILL’ in
this column. If the transaction uses the ’Arrears Invoice’ invoicing rule, do not enter
’UNEARN’ in this column.
Destination:
RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS
ACCTD_AMOUNT
This column is optional. If you enter ’AMOUNT’ for your batch source option
’Revenue Account Allocation’, then AutoInvoice will accept whatever is passed in this
column without validation. If this column is null, then AutoInvoice will compute the
accounted amount for this distribution line. For imported amounts in the functional
currency, AutoInvoice will reject the line if you enter a value in the ACCTD_AMOUNT
column that does not 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 does not use an accounting
rule and depending on the value you entered for your batch source, you must enter
either a value in this column or in PERCENT. If you specify the percent in your batch
source, AutoInvoice computes the value in this column.
Do not enter a value in this column if this accounting distribution is for a transaction
which uses an accounting rule or if this 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 does not use an accounting rule, the sum of all distribution
amounts for this transaction of a given line type must equal the amount for 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
F-86 Oracle Receivables User Guide
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 entered for your batch source
you must enter either a value in this column or a combination of segment values
in SEGMENT1-30. If you specify the combination of segment values in your batch
source, AutoInvoice defaults a value 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 defaults a
value into 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.
Oracle Receivables Table and Column Descriptions F-87
Validation:
None
Destination:
None
INTERFACE_LINE_CONTEXT
This is a required column in AutoInvoice. Enter the context of the Line Transaction
Flexfield entered in columns INTERFACE_LINE_ATTRIBUTE1-15.
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
defaults a value into 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’ is not the same as ’1’.
Depending on the value you entered for your batch source, you must enter
either a combination of segment values in these columns or a value in
CODE_COMBINATION_ID.
F-88 Oracle Receivables User Guide
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 does not use an accounting
rule and depending on the value you entered for your batch source, you must enter
either a value in this column or in AMOUNT. If you specify the amount in your batch
source, AutoInvoice defaults a value in this column.
If this accounting distribution is for a transaction which uses an accounting rule, you
must enter a value in this column.
Validation:
The sum of all accounting distribution percentages for a transaction must sum 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 to 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’ is not the same as ’1’.
Depending on the value you entered for your batch source, you must enter
either a combination of segment values in these columns or a value in
CODE_COMBINATION_ID.
Oracle Receivables Table and Column Descriptions F-89
Validation:
Valid combination of Accounting Flexfield segment values must exist in
GL_CODE_COMBINATIONS.
Destination:
None
Table Name: AR_INTERFACE_CONTS_ALL
This table stores information about contingencies that impact revenue recognition for
your imported transactions.
See: Event-Based Revenue Management, page 3-32.
CONTINGENCY_CODE
Contingency lookup code of type AR_REVENUE_CONTINGENCIES.
Validation:
Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUPS.LOOKUP_TYPE
= ’AR_REVENUE_CONTINGENCIES’.
Destination:
AR_LINE_CONTS_ALL.CONTINGENCY_CODE
EXPIRATION_DATE
Indicates expiration date of contingency. For time-based contingencies, enter either
expiration date or expiration days.
Validation:
None.
Destination:
AR_LINE_CONTS_ALL.CONTINGENCY_CODE
EXPIRATION_DAYS
Indicates expiration period of contingency. For time-based contingencies, enter either
expiration date or expiration days.
Validation:
None.
Destination:
AR_LINE_CONTS_ALL.CONTINGENCY_CODE
INTERFACE_CONTINGENCY_ID
Contingency identifier.
Validation:
None
Destination:
None
F-90 Oracle Receivables User Guide
Table Name: RA_INTERFACE_ERRORS_ALL
This table stores information about interface lines that failed validation and were not
imported into Receivables tables. Receivables uses the information in this table to
generate the AutoInvoice Validation Report, page 3-188. AutoInvoice identifies all errors
for each transaction line, thus reducing multiple validation and correction cycles. When
you resubmit AutoInvoice, the program deletes the errors for each line selected for
processing. When all of the records have been successfully processed, AutoInvoice
purges any remaining data in this table.
Use the Interface Exceptions window to view all of the errors in RA_INTERFACE_
ERRORS_ALL. For more information, see: Correcting AutoInvoice Exceptions, page
3-190.
INTERFACE_LINE_ID
If both INTERFACE_SALESCREDIT_ID and INTERFACE_DISTRIBUTION_ID
are null, then the row in RA_INTERFACE_LINES_ALL associated with this
INTERFACE_LINE_ID failed validation.
Validation:
None
Destination:
None
INTERFACE_SALESCREDIT_ID
If this column is not null, then the row in RA_INTERFACE_SALESCREDITS_ALL
associated with this INTERFACE_SALESCREDIT_ID failed validation.
Validation:
None
Destination:
None
INTERFACE_DISTRIBUTION_ID
If this column is not null, then the row in RA_INTERFACE_DISTRIBUTIONS_ALL
associated with this INTERFACE_DISTRIBUTION_ID failed validation.
Validation:
None
Destination:
None
INVALID_VALUE
The invalid value that failed validation displays in this column, if applicable.
Validation:
None
Destination:
None
Oracle Receivables Table and Column Descriptions F-91
LINK_TO_LINE_ID
This column displays the INTERFACE_LINE_ID of the line to which this line that
failed validation is linked. For example, you have a tax line that fails and is linked to
an invoice line that fails. In this case, the column stores the INTERFACE_LINE_ID
of the invoice line.
Validation:
None
Destination:
None
MESSAGE_TEXT
The message text is stored in this column.
Validation:
None
Destination:
None
Related Topics
Importing Transactions Using AutoInvoice, page 3-186
Using AutoInvoice, page 3-201
Using the AutoInvoice Import Program, Oracle Financials Common Country Features User
Guide