Skip Headers

Oracle Receivables Reference Guide
Release 12.1
Part Number E13512-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Receivables Table and Column Descriptions

AutoInvoice 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

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, Oracle Receivables User Guide.

Important: The following columns of the AutoInvoice interface table RA_INTERFACE_LINES_ALL have become obsolete in R12:

Instead of these fields, Autoinvoice requires you to populate the PAYMENT_TRXN_EXTENSION_ID. You can obtain this by calling the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension before populating the Autoinvoice tables.

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.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

For credit memos, do not enter a value in this column, AutoInvoice uses the customer agreement from the transaction you are crediting.

Variable Description
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.

Variable Description
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.

Variable Description
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.
Destination: RA_CUSTOMER_TRX_LINES_ALL.AMOUNT_INCLUDES_TAX_FLAG

ADDRESS_VERIFICATION_CODE

The credit card address verification code provided by Oracle Payment Server.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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 this transaction is a credit memo against a transaction which uses an accounting rule and CREDIT_METHOD_FOR_ACCT_RULE is UNIT, then AutoInvoice rejects the credit memo if the credit quantity exceeds the quantity on the target invoice line.

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.

Variable Description
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.

Variable Description
Validation: Must be either 'PRORATE', 'LIFO', 'FIFO' or NULL.
Destination: RA_CUSTOMER_TRX_ALL.CREDIT_METHOD_FOR_INSTALLMENTS

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.

Variable Description
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_TRX_ID

This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value into this column using your grouping rules.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: RA_CUST_TRX_TYPES_ALL.NAME
Destination: None

DESCRIPTION

This is a required column in AutoInvoice. Enter the description for this transaction.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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, Oracle Receivables User Guide.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_ALL.ATTRIBUTE_CATEGORY

HEADER_GDF_ATTRIBUTE1-30

Reserved for country-specific functionality.

Variable Description
Validation: Performed by Oracle Global Financials
Destination: RA_CUSTOMER_TRX_ALL.GLOBAL_ATTRIBUTE1-30

HEADER_GDF_ATTR_CATEGORY

Reserved for country-specific functionality.

Variable Description
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.

If this transaction is not a credit memo, AutoInvoice defaults a value into this column using RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.

Variable Description
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_number||ship_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.

Variable Description
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'.

Variable Description
Validation: None
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must be between 0 and the invoice's accounting rule duration (inclusive).
Destination: RA_CUSTOMER_TRX_LINES_ALL.LAST_PERIOD_TO_CREDIT

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.

Variable Description
Validation: None
Destination: None

LINE_GDF_ATTRIBUTE1-20

Reserved for country-specific functionality.

Variable Description
Validation: Performed by Oracle Global Financials
Destination: RA_CUSTOMER_TRX_LINES_ALL.GLOBAL_ATTRIBUTE1-20

LINE_GDF_ATTR_CATEGORY

Reserved for country-specific functionality.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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 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.

Variable Description
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.

Variable Description
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).

Variable Description
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.

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.

Variable Description
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 multiple organization environment.

Variable Description
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.

Variable Description
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.

Variable Description
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 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.

Variable Description
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_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_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.

Variable Description
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 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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
Destination: RA_CUSTOMER_TRX_ALL.BILL_TO_CUSTOMER_ID

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.

Variable Description
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.

Variable Description
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.

For credit memos do not enter a value in this column, AutoInvoice uses the Ship-To address from the transaction you are crediting.

Variable Description
Validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_ADDRESS_REF = HZ_PARTY_SITES.ORIG_SYSTEM_REFERENCE 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_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.

Variable Description
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.

Variable Description
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_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.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Populate this column for invoices and credit memos.

Variable Description
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.

Variable Description
Validation: Must exist in AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SET_ID
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.

Variable Description
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.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID

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.

Variable Description
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.

If LINE_TYPE = ''TAX' or you are passing freight for a specific line, do not enter a value in this column.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: None

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.

Variable Description
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.

Variable Description
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.

Variable Description
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 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.

If this transaction is a credit memo against a transaction which uses an accounting rule and CREDIT_METHOD_FOR_ACCT_RULE is UNIT, then AutoInvoice rejects the credit memo if the credit quantity exceeds the quantity on the target invoice line.

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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must exist in AR_LOOKUPS.LOOKUP_CODE. This lookup type is either INVOICING_REASON or CREDIT_MEMO_REASON
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.

Variable Description
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 receipt 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 receipt method name in your batch source, AutoInvoice defaults a value in this column.

AutoInvoice always defaults the receipt 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.

Variable Description
Validation: Must exist in AR_RECEIPT_METHODS.RECEIPT_METHOD_ID and must belong to the bill-to customer or the parent. Additionally, the receipt 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 receipt 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.

If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this field.

Variable Description
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.

Variable Description
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_LINES_ALL.REFERENCE_LINE_ATTRIBUTE1-15. You must enter a value in this column if you entered values in RA_INTERFACE_LINES_ALL.ATTRIBUTE1-15.

Variable Description
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 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.

Note: Note: An invoice can be attached to only one commitment. Upon import, if an invoice has multiple lines where different commitment line values are provided in the REFERENCE_LINE_ID column, then Receivables creates one or more invoices, accordingly.

Tip: If an invoice has multiple lines but a commitment's balance covers only a partial invoice amount, then Receivables can still create a single invoice upon import. To accomplish this, all lines must have the same commitment line value but, using the PROMISED_COMMITMENT_AMOUNT column, some invoice lines will deplete the commitment's remaining balance while other invoice lines will have an allocated commitment value of zero.

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.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
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, Oracle Receivables User Guide.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_LINES_ALL.RULE_START_DATE

RULE_END_DATE

Enter the date that you want to end the accounting rule for this transaction.

This column is required if the accounting rule is either Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods.

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, Oracle Receivables User Guide.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_LINES_ALL.RULE_END_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.

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_TAX_ID

SET_OF_BOOKS_ID

Optionally enter the ledger ID for this transaction. If no value exists, then Receivables defaults the ledger from the System Options window for the organization that is specified in the ORG_ID column.

Variable Description
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.

Variable Description
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.

Variable Description
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

SOURCE_DATA_KEY1-5

Enter line group attributes that link one or more transaction lines into groups.

Receivables uses groups during line-level cash application.

See: Applying Receipts in Detail, Oracle Receivables User Guide.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_LINES_ALL.SOURCE_DATA_KEY1-5

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.

For credit memos, AutoInvoice defaults the tax code from the transaction you are crediting.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must exist in AR_LOOKUPS.LOOKUP_CODE. Lookup type is TAX_REASON.
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.

Variable Description
Validation: Must exist in AR_LOOKUPS.MEANING. Lookup type is TAX_REASON.
Destination: None

TAX_PRECEDENCE

Important: This column is obsolete and should not be populated.

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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
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'.

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.

Variable Description
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)

Variable Description
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.

Variable Description
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.

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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must exist in MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE. If LINE_TYPE = 'CHARGES' then this column must be null.
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: RA_CUSTOMER_TRX_LINES_ALL.DEFAULT_USSGL_TRANSACTION_CODE

USSGL_TRANSACTION_CODE_CONTEXT

This column is not currently used by AutoInvoice.

Variable Description
Validation: None
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.

Variable Description
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).

Variable Description
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.

Variable Description
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, Oracle Receivables Implementation Guide and Defining Receivables System Options, Oracle Receivables Implementation Guide.

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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: None

ORG_ID

Enter the ID of the organization that this transaction belongs to. This column is mandatory in a multiple organization environment.

Variable Description
Validation: AutoInvoice imports transactions whose ORG_ID matches the value of the MO: Operating Unit profile option.
Destination: None.

REQUEST_ID

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

Variable Description
Validation: None
Destination: None

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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: Must exist in JTF_RS_GROUP_USAGES.GROUP_ID and have JTF_RS_GROUP_USAGES.USAGE = 'SALES'
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST_ALL.ATTRIBUTE1-15

ATTRIBUTE_CATEGORY

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

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: None

INTERIM_TAX_CCID

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

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: None

ORG_ID

Enter the ID of the organization that this transaction belongs to. This column is mandatory in a multiple organization environment.

Variable Description
Validation: AutoInvoice imports transactions whose ORG_ID matches the value of the MO: Operating Unit profile option.
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.

Variable Description
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.

Variable Description
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.

Variable Description
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, Oracle Receivables User Guide.

CONTINGENCY_ID

Identifies the revenue contingency, according to this table:

Contingency Name Contingency ID
Explicit Acceptance 2
Customer Creditworthiness 3
Doubtful Collectibility 4
Extended Payment Term 5
Cancellation 7
Fiscal Funding Clause 8
Refund 9
Forfeitures 10
Leasing Doubtful Collectibility 12
Impaired Loans 13
Variable Description
Validation: None.
Destination: AR_LINE_CONTS_ALL.CONTINGENCY_ID

EXPIRATION_DATE

Indicates expiration date of contingency. For time-based contingencies, enter either expiration date or expiration days.

Variable Description
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.

Variable Description
Validation: None.
Destination: AR_LINE_CONTS_ALL.CONTINGENCY_CODE

EXPIRATION_EVENT_DATE

Indicates the expiration of the contingency removal event.

Variable Description
Validation: None.
Destination: AR_LINE_CONTS_ALL.EXPIRATION_EVENT_DATE

INTERFACE_CONTINGENCY_ID

Contingency identifier.

Variable Description
Validation: None
Destination: None

ORG_ID

Enter the ID of the organization that this transaction belongs to. This column is mandatory in a multiple organization environment.

Variable Description
Validation: AutoInvoice imports transactions whose ORG_ID matches the value of the MO: Operating Unit profile option.
Destination: None.

PARENT_LINE_ID

Identifies the original parent order line from Oracle Order Management. Child invoice lines inherit contingencies from the parent line, and cannot be updated.

Variable Description
Validation: None
Destination: None

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, Oracle Receivables User Guide. 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, Oracle Receivables User Guide.

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.

Variable Description
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.

Variable Description
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.

Variable Description
Validation: None
Destination: None

INVALID_VALUE

The invalid value that failed validation displays in this column, if applicable.

Variable Description
Validation: None
Destination: None

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.

Variable Description
Validation: None
Destination: None

MESSAGE_TEXT

The message text is stored in this column.

Variable Description
Validation: None
Destination: None

Related Topics

Importing Transactions Using AutoInvoice, Oracle Receivables User Guide

Using AutoInvoice, Oracle Receivables User Guide

Lockbox Table and Column Descriptions

When you submit the Import, Validation, and Post Batch steps of AutoLockbox, Receivables stores receipt information in temporary application tables until it is approved for the next step. For example, the Validation step checks data in the AutoLockbox tables for compatibility with Receivables before passing the information into the Receipt and QuickCash tables. The following sections describe these tables.

Related Topics

Receipt and QuickCash Tables

Lockbox Interface Table and Column Descriptions

Running AutoLockbox, Oracle Receivables User Guide

Receipt and QuickCash Tables

When you run the Validation step, Lockbox transfers receipt data into the following QuickCash tables:

AR_INTERIM_CASH_RECEIPTS_ALL

AR_INTERIM_CASH_RCPT_LINES_ALL

When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:

AR_CASH_RECEIPTS_ALL

AR_RECEIVABLES_APPLICATIONS_ALL

AR_CASH_RECEIPT_HISTORY_ALL

Related Topics

Lockbox Interface Table and Column Descriptions

Lockbox Interface Table and Column Descriptions

When you run the Import step of AutoLockbox, Receivables stores receipt data from your bank file in the AR_PAYMENTS_INTERFACE_ALL Lockbox Interface table. Following is a detailed description of this table.

Each column in the AR_PAYMENTS_INTERFACE_ALL table has important, detailed information you need to successfully run AutoLockbox. The Destination column gives you the interim QuickCash tables and the actual Receivables applications tables to which the data is transferred from the AR_PAYMENTS_INTERFACE_ALL table.

Understanding the AR_PAYMENTS_INTERFACE_ALL Table

This section lists the columns in the AR_PAYMENTS_INTERFACE_ALL table, providing each column's type, source, and destination.

TRANSMISSION_RECORD_ID (NUMBER(15))

CREATION_DATE (DATE)

CREATED_BY (NUMBER(15))

LAST_UPDATE_LOGIN (NUMBER(15))

LAST_UPDATED_BY (NUMBER(15))

LAST_UPDATE_DATE (DATE)

RECORD_TYPE (NOT NULL) (VARCHAR2(2))

STATUS (VARCHAR2(30))

TRANSMISSION_REQUEST_ID (NUMBER(15))

TRANSMISSION_ID (NUMBER(15))

DESTINATION_ACCOUNT (VARCHAR2(25))

ORIGINATION (VARCHAR2(25))

DESPOSIT_DATE (DATE)

GL_DATE (DATE)

DEPOSIT_TIME (VARCHAR2(8))

TRANSMISSION_RECORD_COUNT (NUMBER(15))

TRANSMISSION_AMOUNT (NUMBER)

TRANSFERRED_RECEIPT_COUNT (NUMBER)

TRANSFERRED_RECEIPT_AMOUNT (NUMBER)

LOCKBOX_NUMBER (VARCHAR2(30))

LOCKBOX_BATCH_COUNT (NUMBER)

LOCKBOX_RECORD_COUNT (NUMBER)

LOCKBOX_AMOUNT (NUMBER)

BATCH_NAME (VARCHAR2(25))

BATCH_AMOUNT (NUMBER)

BATCH_RECORD_COUNT (NUMBER(15))

ITEM_NUMBER (NUMBER)

CURRENCY_CODE (VARCHAR2(15))

EXCHANGE_RATE (NUMBER)

EXCHANGE_RATE_TYPE (VARCHAR2(30))

REMITTANCE_AMOUNT (NUMBER)

TRANSIT_ROUTING_NUMBER (VARCHAR2(25))

ACCOUNT (VARCHAR2(30))

CUSTOMER_BANK_ACCOUNT_ID (NUMBER(15))

ANTICIPATED_CLEARING_DATE (DATE)

CHECK_NUMBER (VARCHAR2(30))

SPECIAL_TYPE (VARCHAR2(20))

CUSTOMER_NUMBER (VARCHAR2(30))

OVERFLOW_INDICATOR (VARCHAR2(1))

OVERFLOW_SEQUENCE (NUMBER)

CUSTOMER_ID (NUMBER (15))

BILL_TO_LOCATION (VARCHAR2(40))

CUSTOMER_SITE_USE_ID (NUMBER(15))

RECEIPT_DATE (DATE)

RECEIPT_METHOD (VARCHAR2(30))

RECEIPT_METHOD_ID (NUMBER(15))

INVOICE1-8 (VARCHAR2(50))

MATCHING1_DATE - MATCHING8_DATE (DATE)

RESOLVED_MATCHING_NUMBER1-8 (NUMBER)

RESOLVED_MATCHING1_DATE - RESOLVED_MATCHING8_DATE (DATE)

MATCH_RESOLVED_USING (VARCHAR2(30))

RESOLVED_MATCHING1_INSTALLMENT - RESOLVED_ MATCHING8_INSTALLMENT (NUMBER)

INVOICE1_STATUS - INVOICE8_STATUS (VARCHAR2(30))

COMMENTS (NUMBER)

ATTRIBUTE_CATEGORY (VARCHAR2(30))

ATTRIBUTE1-15 (CHAR(40))

INVOICE1_INSTALLMENT - INVOICE8_INSTALLMENT (NUMBER)

CUSTOMER_NAME_ALT (VARCHAR2(320))

CUSTOMER_BANK_NAME (VARCHAR2(320))

CUSTOMER_BANK_BRANCH_NAME (VARCHAR2(320))

REMITTANCE_BANK_NAME (VARCHAR2(320))

REMITTANCE_BANK_BRANCH_NAME (VARCHAR2(320))

BANK_TRX_CODE (VARCHAR2(30))

AMOUNT_APPLIED1-8 (NUMBER)

AMOUNT_APPLIED_FROM1-8 (NUMBER)

INVOICE_CURRENCY_CODE1-8 (VARCHAR2(15))

TRANS_TO_RECEIPT_RATE1-8 (NUMBER)

CUSTOMER_REFERENCE_1-8 (VARCHAR2(100))

CUSTOMER_REASON1-8 (VARCHAR2(30))

Assigning Values to Columns

You must assign values to all of the following columns in the AR_PAYMENTS_INTERFACE_ALL table for AutoLockbox to successfully convert data into receipts.

Variable Description
STATUS Enter the value AR_PLB_NEW_RECORD for all records inserted into this table. The sample SQL*Loader control files Receivables provides fill this column in for you.
DEPOSIT_DATE Enter the date on which this transmission was actually deposited into your bank account. This date can be on any of the record types in your transmission. Each unique deposit date determines a batch of transmission records. For example, if you enter two unique deposit dates for your transmission, AutoLockbox divides your transmission into two batches of receipts.
RECORD_TYPE Identify your record type. For example, if this is a batch header record, and your bank uses the value 3 to identify batch headers, enter 3 in this column. Find out from your bank what character they use to identify each one. Keep in mind that not all banks use all of the record types. Assign values to identify the following types of records:
TRANSMISSION HEADER
TRANSMISSION TRAILER
LOCKBOX HEADERS
LOCKBOX TRAILERS
BATCH HEADERS
BATCH TRAILERS
PAYMENT RECORDS
PAYMENT OVERFLOW RECORDS
SERVICE HEADER

Receivables lets you determine what information you want to include in you header, trailer, and receipt records. You can reference any of the above types when you define the different records for your transmission format. Below are examples of how you might want to define these.

Assigning Values to Transmission Header and Trailer Records

If your record type is either a Transmission Header or a Transmission Trailer, then enter the following columns with the values you described. Transmission Headers and Trailers mark the beginning and ends of a specific data file. They usually contain information such as destination account, origination number, deposit date, and deposit time. You may have a Transmission Header without a Transmission Trailer, AutoLockbox does not require that you specify either of these record types in your transmission format. For each transmission you can only have one transmission header and one transmission trailer.

Variable Description
TRANSMISSION_RECORD_COUNT Enter the number of records that you are importing. Include all of the types of records in the count: headers, trailers, receipts and overflow records. If the transmission format includes the transmission header or trailer, Lockbox counts all records in this transmission. The validated count includes all receipts and detail records transferred to the interim table.
TRANSMISSION_AMOUNT Enter the amount of the transmission. This is the sum of all of the receipt amounts within the transmission.
DESTINATION_ACCOUNT Enter your account number at the sending bank.
ORIGINATION Enter the sending bank's transit routing number.
DEPOSIT_DATE Enter the date this transmission was actually deposited in your bank account. When you use SQL*Loader to import your data, it converts the date to the Oracle date format.
DEPOSIT_TIME Enter the time the deposit was made.

Assigning Values to Lockbox Header or Trailer Records

If your record type is either a Lockbox Header or a Lockbox Trailer, enter the following columns with the values described. Lockbox Headers usually mark the beginning of a specific lockbox and contain information such as the destination account and origination number. Lockbox Trailers mark the end of specific lockboxes and contain information such as lockbox number, deposit date, lockbox amount and lockbox record count. Although you may have a Lockbox Header without a Lockbox Trailer, AutoLockbox does not require that you specify either of these record types in your transmission format.

Variable Description
LOCKBOX_NUMBER Enter the lockbox name or number that your bank specifies. This is the same value that you entered in the Lockboxes window. LOCKBOX_NUMBER is mandatory on all Lockbox Headers and Trailers.
LOCKBOX_BATCH_COUNT Enter the number of batches in this lockbox.
LOCKBOX_RECORD_COUNT Enter the number of Payment records in this lockbox. Do not include Payment Overflow records.
LOCKBOX_AMOUNT Enter the total value of the receipts in this lockbox.
DESTINATION_ACCOUNT Enter your account number at the sending bank. If this value is included in a Transmission Header or Trailer, you must enter the same value.
ORIGINATION Enter the sending bank's transit routing number. If this value is included in a Transmission Header or Trailer, you must have the same value here.

Assigning Values to Batch Header and Trailer Records

If your record type is either a Batch Header or a Batch Trailer, you can enter the following columns with the values described below. Batch Headers mark the beginning of a specific batch and contain information such as batch number, deposit date, and lockbox number. Batch Trailers mark the end of a specific batch and contain information such as batch number, lockbox number, batch record amount, and batch amount. Although you may have a Batch Header without a Batch Trailer, AutoLockbox does not require that you specify either of these record types in your transmission format.

Variable Description
BATCH_NAME Enter the name or number that the bank uses to identify the batch. This is required for each Batch Header and Trailer record.
BATCH_AMOUNT Enter the total value of all receipts in this batch.
BATCH_RECORD_COUNT Enter the number of receipt records in this batch.
LOCKBOX_NUMBER Enter the lockbox number assigned to receipts in this batch. If the lockbox number is included in your format, it must appear on every batch record.
COMMENTS Enter any free-form comments about this batch.

Assigning Values to Receipt Records

If your record type is a Payment, you can enter the following columns with the values described below. A Payment record usually contains information such as MICR number, batch number, item number, check number, and remittance amount. Some of the values are mandatory for a Payment record, while others are optional. Every transmission must have Payment records.

Variable Description
LOCKBOX_NUMBER Enter the lockbox number assigned to your receipts. If the lockbox number is included in your format and you do not have batch records, it must be entered for every receipt record.
BATCH_NAME Enter the batch name for this receipt. If batch name is included in your format, it must be entered for every receipt record. Each unique batch name determines a batch of transmission records. For example, if you enter two unique batch names for your transmission, AutoLockbox divides your transmission into two batches of receipts.
ITEM_NUMBER Enter a sequential number to indicate the location of this receipt in this batch. You must enter a value even if your format does not have batch, lockbox, or transmission records. Item Number must be unique within a batch, a lockbox (if batches are not provided), or within a transmission (if neither batches nor lockboxes are provided).
REMITTANCE_AMOUNT Enter the value of the receipt. You must enter a value for each receipt record.
CURRENCY_CODE Enter the currency code for each receipt. Receivables supports AutoLockbox Transmission receipts in different currencies.
EXCHANGE_RATE Enter the exchange rate you want Receivables to use for this currency.
EXCHANGE_RATE_TYPE Enter the type of exchange rate you are using for this receipt. You can enter Corporate, Spot, or User.
RECEIPT_DATE Enter the date that is written on your check. If you are using MICR numbers to identify customers, Lockbox requires that this date be equal to or earlier than the date of this AutoLockbox submission; otherwise, the receipts will be unidentified.
RECEIPT_METHOD Enter the receipt method that you want to associate with this receipt. Receipt methods contain information about your bank, bank account, and receipt accounts. This receipt method must be the same as the one you assigned to the batch source for this lockbox.
CHECK_NUMBER Enter the number printed on the receipt. You must enter a value for each receipt record.
TRANSIT_ROUTING_NUMBER Enter the transit routing number from the receipt. This is optional, but you must enter this number if you enter the account number. Receivables uses transit routing number and account number together to identify the customer (MICR number).
ACCOUNT Enter the bank account number from the receipt. This is optional, but you must enter this number if you enter the transit routing number.
CUSTOMER_NUMBER Enter the number assigned to your customer. This is optional.
INVOICE1-8 Enter the invoice numbers to which you apply this receipt. You do not have to start with INVOICE1 or use all eight of the INVOICE columns on a record before you create a receipt record. You may find a list of valid values in AR_PAYMENT_SCHEDULES.TRX_NUMBER. Do not look at transactions with a class of PMT or GUAR. Invoice numbers are optional.
AMOUNT_APPLIED_FROM1-8 If the receipt currency and the transaction currency are different, enter the amount of the receipt to apply in the receipt currency.
INVOICE_CURRENCY_CODE1-8 If the receipt currency and the transaction currency are different, enter the currency of the transaction (optional). If null, AutoLockbox derives this value from AR_PAYMENT_SCHEDULES_ALL. This field is used for cross currency receipt applications.
TRANS_TO_RECEIPT_RATE 1-8 If the receipt currency and the transaction currency are different, enter the exchange rate used to convert the receipt to the transaction currency. This value is used for cross currency receipt applications when the receipt and transaction currencies do not have a fixed exchange rate.
INVOICE1-8_INSTALLMENT Enter the installment number if your invoice has multiple payment schedules. If you do not specify the installment number for an invoice with multiple payment schedules, Receivables will apply to the oldest payment schedule first. The installment number must be on the same record as the associated invoice number.
AMOUNT_APPLIED1-8 Enter the amount of the receipt to apply to the invoice. You can provide invoice numbers without specifying the amount applied to each of these invoices. If you provide invoice numbers without specifying the amount applied to each invoice, Receivables applies the receipt to the invoices starting with the oldest receipt schedule first. The value of the amount_applied column must be on the same record as the invoice number to which it is applied. For example, you cannot have all of the invoice numbers on the receipt record and all of the amounts applied on the overflow. Applied amounts are optional. If the receipt currency and the transaction currency are different, enter the amount of the receipt to apply in the transaction currency.
COMMENTS Enter any free-form comments about this receipt. Receivables stores this data, but does not display these comments in any of the receipt entry windows.
ATTRIBUTE_CATEGORY Enter the Descriptive Flexfield category information for this receipt.
ATTRIBUTE1-15 Enter the Descriptive Flexfield attributes for this category. You can use this column to transfer additional information about your receipt. For example, if your bank enters and transmits customer name, you can use an attribute column to import this name. The attributes are visible as Descriptive Flexfields in the Receipt windows.
BILL_TO_LOCATION To associate receipts with specific customer sites, enter the billing address for this receipt and include billing location in your transmission format. If the system option Require Billing Location for Receipts is set to Yes, you must enter a value here. In addition, you can set the Require Billing Location field to Yes in the Lockboxes window to require a billing location for a specific lockbox. The value of this field in the Lockboxes window will override the option at the system level. See: Lockboxes, Oracle Receivables Implementation Guide.
CUSTOMER_BANK_NAME The name of the customer's bank.
Variable Description
CUSTOMER_BANK_BRANCH_NAME The name of the customer's bank branch.
REMITTANCE_BANK_NAME The name of the bank that received the payment.
REMITTANCE_BANK_BRANCH_NAME The name of the bank branch that received the payment.

Assigning Values To Overflow Records

If your record type is an Overflow record, enter the following columns with the values described. Some of these values are mandatory, while others are optional. Overflow records allow you to transmit additional information about a receipt that does not fit on the receipt record, such as batch number, item number, sequence number, invoice number, debit memo number, or debit item amounts. The most common use for this record type is to import additional invoice numbers to which the receipt should be applied. An overflow record can have up to eight invoice applications.

Variable Description
LOCKBOX_NUMBER Enter the number of the lockbox for this receipt. If the lockbox number is included in your format and you do not have any batch records, you must enter this number for each receipt and overflow record.
BATCH_NAME Enter the batch for this overflow record. If the batch name is included in your format, you must enter this name for each overflow record.
ITEM_NUMBER Enter a sequential number to indicate the location of the overflow record in this batch. All overflow records for a receipt have the same item number as the receipt record. You must enter an item number for each overflow record to reference the receipt.
OVERFLOW_INDICATOR Receivables uses this column to indicate overflow records for the current receipt. You determine your overflow indicator in your transmission format. To identify the last overflow record, enter a value that is different from your overflow indicator. For example, in the BAI transmission format, '0' indicates an overflow record. You have three overflow records for a receipt, the first two records have '0' as the overflow indicator and the third record has '9'. Since the third record is not '0', it is identified as the last overflow record. You must enter a value for all overflow records.
OVERFLOW_SEQUENCE Enter a sequential number to indicate the order of overflow records. Within each receipt, the Overflow Sequence usually begins with 1.
AMOUNT_APPLIED_FROM1-8 If the receipt currency and the transaction currency are different, enter the amount of the receipt to apply in the receipt currency.
INVOICE_CURRENCY_CODE1-8 If the receipt currency and the transaction currency are different, enter the currency of the transaction (optional). If null, AutoLockbox derives this value from AR_PAYMENT_SCHEDULES_ALL. This field is used for cross currency receipt applications.
TRANS_TO_RECEIPT_RATE 1-8 If the receipt currency and the transaction currency are different, enter the exchange rate used to convert the receipt to the transaction currency. This value is used for cross currency receipt applications when the receipt and transaction currencies do not have a fixed exchange rate.
INVOICE1-8 Enter the invoice numbers to which you apply this receipt. You do not have to start with INVOICE1, nor use all eight of the INVOICE columns on a record before you create an overflow record. You can find a list of valid values in AR_PAYMENT_SCHEDULES.TRX_NUMBER. Do not look at transactions with a class of PMT or GUAR. You may supply invoice numbers without specifying the amount applied to each invoice. Invoice numbers are optional.
INVOICE1-8_INSTALLMENT Enter the installment number if your invoice has multiple payment schedules. If you do not specify the installment number for an invoice with multiple payment schedules, then Receivables will apply to the oldest payment schedule first. The installment number must be on the same record as the associated invoice number.
AMOUNT_APPLIED1-8 Enter the amount of the receipt to apply to the invoice. If you specify invoice numbers without specifying the amount applied to each invoice, Receivables applies the receipt to the invoices starting with the oldest receipt first. The value of the amount applied column must be on the same record as the invoice number to which the receipt amount is applied.

System Assigned Columns

Receivables assigns values to the columns listed in the table below during the import process. Your import file must leave these columns blank.

Column Name Type
TRANSMISSION_RECORD_ID NUMBER
CREATION_DATE DATE
CREATED_BY NUMBER
LAST_UPDATE_LOGIN NUMBER
LAST_UPDATED_BY NUMBER
LAST_UPDATE_DATE DATE
TRANSMISSION_REQUEST_ID NUMBER
CUSTOMER_ID NUMBER
SPECIAL_TYPE CHAR(20)
GL_DATE DATE
STATUS CHAR(30)
INVOICE1-8_STATUS CHAR(30)
RECEIPT_METHOD_ID NUMBER(15)
TRANSMISSION_ID NUMBER(15)
INVOICE1-8_STATUS VARCHAR2(30)
CUSTOMER_BANK_ACCOUNT_ID NUMBER(15)
CUSTOMER_SITE_USE_ID NUMBER(15)
TRANSFERRED_RECEIPT_COUNT NUMBER
TRANSFERRED_RECEIPT_AMOUNT NUMBER