AutoInvoice Interface Table RA_INTERFACE_LINES

ACCOUNTING_RULE_DURATION

Enter the number of periods in the revenue scheduling rule for this transaction.

If LINE_TYPE = LINE or you're passing header freight, and this transaction uses a revenue scheduling rule with a variable schedule, you must enter a value in this column.

If LINE_TYPE = TAX, CHARGES, or you're passing freight for a specific line, don’t enter a value in this column.

For credit memos and on-account credits, don’t enter a value in this column.

validation: Accounting periods must be defined for the periods of the revenue scheduling 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 revenue scheduling rule ID for this transaction.

If LINE_TYPE = LINE or you're passing header freight, this column is optional. For invoice lines with revenue scheduling rules, you must enter a value either in this column or in the ACCOUNTING_RULE_NAME column, depending on the setting of the Revenue Scheduling Rule option (Value, ID, None) in the Import Information section of the transaction source. If you enter a value in the ACCOUNTING_RULE_NAME column, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX, CHARGES, or you're passing freight for a specific line, don’t enter a value in this column.

For credit memos, don’t enter a value in this column. AutoInvoice uses the revenue scheduling rule of the transaction you're crediting.

validation: Must exist in RA_RULES.RULE_ID and RA_RULES.TYPE = A or ACC_DUR. If LINE_TYPE = CHARGES, then this column must be null.
destination: RA_CUSTOMER_TRX_LINES_ALL.ACCOUNTING_RULE_ID

ACCOUNTING_RULE_NAME

Enter the revenue scheduling rule name for this transaction.

If LINE_TYPE = LINE or you're passing header freight, this column is optional. For invoice lines with revenue scheduling rules, you must enter a value either in this column or in the ACCOUNTING_RULE_ID column, depending on the setting of the Revenue Scheduling Rule option (Value, ID, None) in the Import Information section of the transaction source.

If LINE_TYPE = TAX, CHARGES, or if you're passing freight for a specific line, don't enter a value in this column.

For credit memos don't enter a value in this column. AutoInvoice uses the revenue scheduling rule of the transaction you're crediting.

validation: Must exist in RA_RULES.NAME and RA_RULES.TYPE = A or ACC_DUR. If LINE_TYPE = CHARGES, then this column must be null.
destination: None.

ACCTD_AMOUNT

don't enter a value. This column isn't currently used.

validation: None.
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, don't 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're passing either header freight or freight for a specific line, you must enter a value in this column.

If LINE_TYPE = CHARGES, don't enter a value in this column.

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

For credit memos and on-account credits, enter the credit amount for this transaction.

validation: If LINE_TYPE = CHARGES, then this column must be null. AutoInvoice corrects revenue amounts that have an incorrect currency precision.
destination: If the Create clearing option on the transaction source isn't enabled: RA_CUSTOMER_TRX_LINES_ALL.REVENUE_AMOUNT and RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT. If the Create clearing option on the transaction source is enabled: 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 Yes, then this line is assigned to a tax inclusive tax rate code.

AutoInvoice only uses this column if the tax rate code assigned to this line has the Allow Override and Entry of Inclusive Tax Lines option enabled on the corresponding tax regime.

Populate this column for invoices only. For regular credit memos, AutoInvoice always uses the AMOUNT_INCLUDES_TAX_FLAG column value from the invoice that you're crediting.

validation: If this is a tax rate code and the Allow Override and Entry of Inclusive Tax Lines option isn't enabled, this should be equal to either the setting of the Amount Includes Tax option for this tax rate code or null. Additionally, if the Allow Override and Entry of Inclusive Tax Lines option isn't enabled, then the Amount Includes Tax option at the line level must equal the Allow Override option setting for this tax rate code.
destination: RA_CUSTOMER_TRX_LINES_ALL.AMOUNT_INCLUDES_TAX_FLAG

APPROVAL_CODE

The payment approval code provided by the credit card issuer to indicate that funds are available from the user account.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.APPROVAL_CODE

ADDRESS_VERIFICATION_CODE

The credit card address verification code provided by the Payments Server.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.ADDRESS_VERIFICATION_CODE

ASSESSABLE_VALUE

Enter the assessable value of the item on the transaction line.

The assessable value is the price at which a product is valued by a tax authority for a given tax, for tax calculation purposes.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

ATTRIBUTE1-15

Enter the Invoice Line Information Flexfield attribute information for this transaction.

Descriptive Flexfield attributes allow you to store additional columns, the contents of which you define. These columns are optional.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.ATTRIBUTE1-15. To ensure that AutoInvoice accurately groups your imported invoices, don't include newline or carriage return characters (chr(10) or chr(13)) in Descriptive Flexfield columns.

ATTRIBUTE_CATEGORY

Enter the Invoice Line Information Flexfield category information for this transaction.

Descriptive Flexfield categories allow you to store different categories of attributes. This column is optional.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.ATTRIBUTE_CATEGORY

BATCH_SOURCE_NAME

Enter the name of the transaction source for this transaction. AutoInvoice uses the transaction source to determine the transaction numbering method and the AutoInvoice processing options. You must enter a value in this column.

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.

BU_NAME

Enter the name of a specific business unit to process imported transactions for.

validation: AutoInvoice imports transactions either for the business unit specified or all business units the user has access to.
destination: None.

COMMENTS

Enter comments about this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or your are passing freight for a specific line, don't enter text in this column.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.COMMENTS

CONS_BILLING_NUMBER

Enter the number for this consolidated bill.

A consolidated bill number is used for grouping a set of invoices under one bill.

Note: This column isn't currently supported.

validation: Doesn’t 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 conversion date for this transaction. If you don't enter a date, AutoInvoice uses the transaction date as the default. If the currency of the transaction line is the same as the ledger currency, then leave this column null.

For credit memos, AutoInvoice uses the conversion date of the invoice that the credit memo is against, and not the credit memo transaction date.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.EXCHANGE_DATE

CONVERSION_RATE

Enter the conversion rate for this transaction.

If CONVERSION_TYPE is User, you must enter a value in this column; otherwise don't enter a value. If the currency of the transaction is the same as the ledger currency, enter User and set CONVERSION_RATE to 1.

validation: If RA_INTERFACE_LINES_ALL.CONVERSION_TYPE = User, then this column can’t be null; otherwise, it must be null.
destination: RA_CUSTOMER_TRX_ALL.EXCHANGE_RATE

CONVERSION_TYPE

Enter the conversion rate type for this transaction. If the currency of the transaction is the same as the ledger currency, enter User and set CONVERSION_RATE to 1. You must enter a value in this column.

validation: Must exist in GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE.
destination: RA_CUSTOMER_TRX_ALL.EXCHANGE_RATE_TYPE

CREDIT_METHOD_FOR_ACCT_RULE

Enter the credit method for crediting a transaction that uses a revenue scheduling rule. Valid values are PRORATE, LIFO, and UNIT.

If this transaction is a credit memo against a transaction that uses a revenue scheduling rule and LINE_TYPE = LINE, CHARGES, or you're passing header freight, you must enter a value in this column.

If this transaction is a credit memo against a transaction that uses a revenue scheduling rule and CREDIT_METHOD_FOR_ACCT_RULE = 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're passing freight for a specific line, don't enter a value in this column. AutoInvoice ignores any value that you enter in this column. For on-account credits, don't enter a value in this column.

validation: Must be either PRORATE, LIFO, UNIT, or NULL.
destination: RA_CUSTOMER_TRX_ALL.CREDIT_METHOD_FOR_RULES

CREDIT_METHOD_FOR_INSTALLMENTS

Enter the credit method for crediting a transaction that uses split payment terms. Valid values are PRORATE, LIFO, and FIFO.

If this transaction is a credit memo against a transaction that uses split payment terms and LINE_TYPE = LINE, CHARGES, or you're passing header freight, you can enter a value in this column. If you don't enter a value, AutoInvoice uses the default value PRORATE.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column. AutoInvoice ignores any value that you enter in this column. For on-account credits, don't enter a value in this column.

validation: Must be either PRORATE, LIFO, FIFO, or NULL.
destination: RA_CUSTOMER_TRX_ALL.CREDIT_METHOD_FOR_INSTALLMENTS

CURRENCY_CODE

Enter the currency for this transaction. You must enter a value in this column.

For credit memos, enter the currency of the invoice that you're crediting.

validation: Must exist in FND_CURRENCIES.CURRENCY_CODE.
destination: RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE and AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE.

CUSTOMER_BANK_ACCOUNT_ID

Enter the bill-to customer bank account ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Customer Bank Account option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the CUSTOMER_BANK_ACCOUNT_NAME column. If you enter a value in the CUSTOMER_BANK_ACCOUNT_NAME column, AutoInvoice enters a corresponding ID in this column.

If the receipt method is of type Automatic and this column is null, AutoInvoice populates a value for you.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: Must exist in AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID. If the receipt method is of type Manual, RA_INTERFACE_LINES_ALL.CUSTOMER_BANK_ACCOUNT_ID must be null.
destination: RA_CUSTOMER_TRX_ALL.CUSTOMER_BANK_ACCOUNT_ID

CUSTOMER_BANK_ACCOUNT_NAME

Enter the bill-to customer bank account name for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Customer Bank Account option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the CUSTOMER_BANK_ACCOUNT_ID column.

If the receipt method is of type Automatic and this column is null, AutoInvoice populates a value for you.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME. If the receipt method is of type Manual, RA_INTERFACE_LINES_ALL.CUSTOMER_BANK_ACCOUNT_NAME must be null.
destination: None.

CUSTOMER_TRX_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using the AutoInvoice grouping rule.

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. Depending on the setting of the Transaction Type option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the CUST_TRX_TYPE_NAME column. If you enter a value in the CUST_TRX_TYPE_NAME column, AutoInvoice enters a corresponding ID in this column.

For credit memos, you must enter the ID of the credit memo transaction type assigned to the transaction you're crediting.

validation: Must exist in RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID.
destination: RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID

CUST_TRX_TYPE_NAME

Enter the transaction type name for this transaction.

This column is optional. Depending on the setting of the Transaction Type option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the CUST_TRX_TYPE_ID column.

For credit memos, you must enter the name of the credit memo transaction type assigned to the transaction you're crediting.

validation: RA_CUST_TRX_TYPES_ALL.NAME
destination: None.

DEFAULT_TAXATION_COUNTRY

Enter the default taxation country.

The default taxation country is the country of taxation for tax calculation purposes.

validation: None.
destination: RA_CUSTOMER_TRX_ALL

DESCRIPTION

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

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.DESCRIPTION

DOCUMENT_NUMBER

Enter the document sequence number for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're 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're passing header freight, and the creation method for the sequence numbering of this transaction is Automatic, don't enter a value in this column. AutoInvoice generates a unique document sequence number.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: The number can’t already exist.
destination: RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_VALUE

DOCUMENT_NUMBER_SEQUENCE_ID

This column is used by AutoInvoice and should be left null. AutoInvoice uses this column to store the document sequence ID for this transaction.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_ID

DOCUMENT_SUB_TYPE

Enter the document fiscal classification code for the transaction line.

The document fiscal classification is used to classify transactions that require special documentation to accompany the transaction for tax purposes, as designated by a tax authority.

validation: None.
destination: RA_CUSTOMER_TRX_ALL

EXCEPTION_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column when the transaction has a tax exception.

For credit memos, AutoInvoice enters the tax exception ID of the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.ITEM_EXCEPTION_RATE_ID

EXEMPTION_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column when the transaction has a tax exemption, either full or partial.

For credit memos, AutoInvoice enters the tax exemption ID of the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPTION_ID

FOB_POINT

Enter the FOB (free on board) point for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the FOB point from the transaction you're crediting.

validation: Must exist in AR_LOOKUPS.LOOKUP_CODE, and AR_LOOKUPS.LOOKUP_TYPE = FOB. Must be less than or equal to 30 characters in length.
destination: RA_CUSTOMER_TRX_ALL.FOB_POINT

GL_DATE

Enter the accounting date for this transaction. The accounting date determines the accounting period that the transaction is recorded in the general ledger. If the Post to GL option on the transaction type of the transaction being passed isn't enabled, then this column should be null.

If LINE_TYPE = LINE, CHARGES, and you're passing transactions without rules, or you're passing header freight, this column is optional.

If LINE_TYPE = LINE and you're importing transactions with rules, don't enter a date in this column.

If LINE_TYPE = TAX or FREIGHT, don't enter a date in this column.

For credit memos, AutoInvoice uses the date you run AutoInvoice, unless the transaction you're crediting is billed in arrears. In that case, AutoInvoice uses the accounting date of the transaction you're crediting.

validation: Must be in an Open or Future Enterable accounting period and the period must exist in GL_PERIOD_STATUSES. If the Post to GL option on the transaction type of the transaction being passed isn't enabled, or if the invoice uses the In Arrears invoicing rule, then the 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're passing header freight, these columns are optional.

If LINE_TYPE = TAX or FREIGHT, don't enter values in these columns.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.ATTRIBUTE1-15. To ensure that AutoInvoice accurately groups your imported invoices, don't 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're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter values in these columns.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.ATTRIBUTE_CATEGORY

HEADER_GDF_ATTRIBUTE1-30

Reserved for country-specific functionality.

validation: Performed by Global Financials.
destination: RA_CUSTOMER_TRX_ALL.GLOBAL_ATTRIBUTE1-30

HEADER_GDF_ATTR_CATEGORY

Reserved for country-specific functionality.

validation: Performed by 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 the transaction isn't a credit memo, AutoInvoice enters a value in this column using RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID

INTERCOMPANY_FLAG

This column is used by AutoInvoice to indicate whether a transaction is an intercompany transaction. Valid values are Y or null.

For intercompany transactions, AutoInvoice calls the appropriate program to derive the Receivables code combination ID.

validation: None.
destination: RA_CUSTOMER_TRX_LINES

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 values you enter here provide 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 appear in the Invoice Transaction Flexfield.

Note: Interface lines belonging to the same transaction are ordered by the following SQL clause:

If a transaction has only one line, then the Invoice Transaction Flexfield is the same as the Line Transaction Flexfield.

validation: Can’t 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_ATT RIBUTE1-15 and RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_A TTRIBUTE1-15. To ensure that AutoInvoice accurately groups your imported invoices, don't include newline or carriage return characters (chr(10) or chr(13)) in these Descriptive Flexfield columns.

INTERFACE_LINE_CONTEXT

This is a required column in AutoInvoice. Enter the context of the Line Transaction Flexfield entered in columns INTERFACE_LINE_ATTRIBUTE1-15. If you pass information with global context, set this column to Global Data Elements.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.INTERFACE_HEADER_CON TEXT and RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_CONTEXT.

INTERFACE_LINE_GUID

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

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

INTERFACE_LINE_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using the RA_CUSTOMER_TRX_LINES_S sequence.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID

INTERFACE_STATUS

This column is used by AutoInvoice and should be left null. If AutoInvoice sets this column to P, then the line has been transferred successfully.

validation
destination

INTERNAL_NOTES

Enter internal notes for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter text in this column.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.INTERNAL_NOTES

INVENTORY_ITEM_ID

Enter the inventory item ID for this transaction.

If LINE_TYPE = LINE or CHARGES, this column is optional. Depending on the setting of the Inventory Item option (Segment, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or a combination of segment values in the MTL_SYSTEM_ITEMS_SEG1-20 column. If you specified Segment on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or FREIGHT, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the value from the transaction you're crediting.

validation: Must exist in MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID and MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG = Y.
destination: RA_CUSTOMER_TRX_LINES_ALL.INVENTORY_ITEM_ID

INVOICING_RULE_ID

Enter the invoicing rule ID for this transaction.

If LINE_TYPE = LINE or you're passing header freight, this column is optional. For invoice lines with rules, you must enter a value either in this column or in the INVOICING_RULE_NAME column, depending on the setting of the Invoicing Rule option (Value, ID, None) in the Import Information section of the transaction source. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX, CHARGES, or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the invoicing rule from the transaction you're crediting.

validation: Must exist in RA_RULES.RULE_ID and RA_RULES.RULE_ID = -2 or -3. If you enter an invoicing rule, you must also enter a revenue scheduling 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're passing header freight, this column is optional. For invoice lines with rules, you must enter a value either in this column or in the INVOICING_RULE_ID column, depending on the setting of the Invoicing Rule option (Value, ID, None) in the Import Information section of the transaction source.

If LINE_TYPE = TAX, CHARGES or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the invoicing rule from the transaction you're crediting.

validation: Must exist in RA_RULES.RULE_ID and RA_RULES.RULE_ID = -2 or -3. If you enter an invoicing rule, you must also enter a revenue scheduling rule. If LINE_TYPE = CHARGES, then this column must be null.
destination: None.

LAST_PERIOD_TO_CREDIT

For credit memos with a credit method of UNIT, enter the last period number from which you want to start crediting.

If this transaction is a credit memo against a transaction that uses a revenue scheduling rule, and LINE_TYPE = LINE, CREDIT_METHOD_FOR_ACCT_RULE = UNIT, or you're passing header freight, you can enter a value in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column. AutoInvoice ignores any value that you enter in this column.

validation: Must be between 0 and the number of periods inclusive in the invoice revenue scheduling rule.
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.

validation: None.
destination: None.

LINE_GDF_ATTRIBUTE1-20

Reserved for country-specific functionality.

validation: Performed by Global Financials.
destination: RA_CUSTOMER_TRX_LINES_ALL.GLOBAL_ATTRIBUTE1-20

LINE_GDF_ATTR_CATEGORY

Reserved for country-specific functionality.

validation: Performed by Global Financials.
destination: RA_CUSTOMER_TRX_LINES_ALL.GLOBAL_ATTRIBUTE_CATEGORY

LINE_INTENDED_USE

Enter the product intended use code of the transaction line.

The product intended use code identifies situations where the intended use of the product is a factor either in tax determination or the tax recovery rate.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

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.

validation
destination

LINE_TYPE

Enter LINE, TAX, FREIGHT, or CHARGES to specify the line type for this transaction. You must enter a value in this column.

For credit memos, enter the type of line you're crediting.

validation: Must be LINE, TAX, FREIGHT, or CHARGES.
destination: RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE

LINK_TO_LINE_ATTRIBUTE1-15

Enter the link to your Line Transaction Flexfield attribute values.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, don't enter values in these columns.

If LINE_TYPE = TAX or you're 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 that you're associating this transaction 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're 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're applying a credit memo against a freight line which is linked to a transaction, you must also enter a dummy credit memo transaction with a zero revenue amount and use these columns to link to your credit memo freight line.

validation: The transaction that you link to must have a LINE_TYPE = LINE. You can only link at most one freight line to another transaction. You can’t 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 Line Transaction Flexfield data that you entered in RA_INTERFACE_LINES_ALL.LINK_TO_LINE_ATTRIBUTE1-15.

validation: None.
destination: None.

LINK_TO_LINE_ID

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

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.LINK_TO_CUST_TRX_LINE_ID

LOCATION_SEGMENT_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column if you're crediting a sales tax line.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.LOCATION_SEGMENT_ID

MEMO_LINE_ID

Enter the standard memo line ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Memo Line Rule option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the MEMO_LINE_NAME column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the memo line from the transaction you're crediting.

validation: Must exist in AR_MEMO_LINES_ALL.MEMO_LINE_ID.
destination: RA_CUSTOMER_TRX_LINES_ALL.MEMO_LINE_ID

MEMO_LINE_NAME

Enter the name of the standard memo line for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Memo Line Rule option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the MEMO_LINE_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the memo line from the transaction you're crediting.

validation: Must exist in AR_MEMO_LINES_ALL.NAME.
destination: None.

MOVEMENT_ID

This column is used to pass movement statistics that are tied to the shipment information and passed through AutoInvoice.

AutoInvoice populates the column RA_CUSTOMER_TRX_LINES_ALL.MOVEMENT_ID with RA_INTERFACE_LINES_ALL.MOVEMENT_ID and updates MTL_MOVEMENT_STATISTICS with transaction information (for example, customer_trx_id, batch_id, customer_trx_line_id).

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.MOVEMENT_ID

MTL_SYSTEM_ITEMS_SEG1-20

Assign a System Item Flexfield value for each segment you enable in Receivables. For example, if you enable six System Item Flexfield segments, you must enter six values in columns MTL_SYSTEM_ITEMS_SEG1-6. Be sure to enter the correct segment value. For example, value 01 isn't the same as 1.

If LINE_TYPE = LINE or CHARGES, these columns are optional. Depending on the setting of the Inventory Item option (Segment, ID, None) in the Import Information section of the transaction source you can enter values either in these columns or in the INVENTORY_ITEM_ID column.

If LINE_TYPE = TAX or FREIGHT, don't enter values in these columns.

For credit memos, don't enter values in these columns. AutoInvoice uses the values from the transaction you're crediting.

For debit memos, don't enter values in these columns.

validation: Valid combination of System Item Flexfield segment values.
destination: None.

ORIGINAL_GL_DATE

Stores the value of the GL_DATE column before AutoInvoice modifies the accounting date. This column is used by AutoInvoice and shouldn’t be populated by the user.

validation: None.
destination: None.

ORIG_SYSTEM_BATCH_NAME

Enter the batch name for this transaction. This column is optional.

AutoInvoice doesn’t perform any validation on this column, but uses the value entered when grouping transactions into invoices.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.ORIG_SYSTEM_BATCH_NAME

ORIG_SYSTEM_BILL_ADDRESS_ID

Enter the bill-to customer address ID for this transaction. This bill-to customer address ID is for the bill-to customer you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or ORIG_SYSTEM_BILL_CUSTOMER_ID column.

If no default remit-to address is specified, then AutoInvoice uses the bill-to address to determine the remit-to address for the customer. If the remit-to address can’t be determined, then AutoInvoice rejects the transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Bill-to Address option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the ORIG_SYSTEM_BILL_ADDRESS_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADD RESS_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 the ORIG_SYSTEM_BILL_CUSTOMER_REF or ORIG_SYSTEM_BILL_CUSTOMER_ID column. 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 is specified, then AutoInvoice uses the bill-to address to determine the remit-to address for the customer. If the remit-to address can’t be determined, then AutoInvoice rejects the transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Bill-to Address option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the ORIG_SYSTEM_BILL_ADDRESS_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADD RESS_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 the ORIG_SYSTEM_BILL_CUSTOMER_REF or ORIG_SYSTEM_BILL_CUSTOMER_ID column.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Bill-to Contact option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_BILL_CONTACT_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUS TOMER_ID = HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CON TACT_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 the ORIG_SYSTEM_BILL_CUSTOMER_REF or ORIG_SYSTEM_BILL_CUSTOMER_ID column. 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're passing header freight, this column is optional. Depending on the setting of the Bill-to Contact option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_BILL_CONTACT_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUS TOMER_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're passing header freight, this column is optional. Depending on the setting of the Bill-to Customer option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the ORIG_SYSTEM_BILL_CUSTOMER_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, you must enter the bill-to customer ID or the bill-to customer reference of a related customer of the transaction you're crediting.

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 Receivables back to your original system.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Bill-to Customer option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the ORIG_SYSTEM_BILL_CUSTOMER_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, you must enter the bill-to customer reference or the bill-to customer ID of a related customer of the transaction you're crediting.

validation: Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE.
destination: None.

ORIG_SYSTEM_SHIP_ADDRESS_ID

Enter the ship-to customer address ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Ship-to Address option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SHIP_ADDRESS_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column; AutoInvoice uses the ship-to address from the transaction you're crediting.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_ADDRESS_ID = HZ_CUST_ACCT_SITE.CUSTOMER_SITE_ID and RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID and HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID = HZ_CUST_ACCT_SITE.CUST_ACCOUNT_ID and HZ_CUST_ACCT_SITE.CUSTOMER_SITE_ID = HZ_CUST_SITE_USES.CUST_ACCT_SITE_ID and HZ_CUST_SITE_USES.SITE_USE_CODE = SHIP_TO.
destination: None.

ORIG_SYSTEM_SHIP_ADDRESS_REF

Enter a value you can use to uniquely identify this ship-to customer address in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Ship-to Address option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SHIP_ADDRESS_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column, AutoInvoice uses the ship-to address from the transaction you're crediting.

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're passing header freight, this column is optional. Depending on the setting of the Ship-to Contact option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SHIP_CONTACT_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the ship-to contact from the transaction you're crediting.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID = HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CONTACT_ID = HZ_CUST_SITE_USES.CUSTOMER_SITE_ID.
destination: RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID

ORIG_SYSTEM_SHIP_CONTACT_REF

Enter a value you can use to uniquely identify this ship-to contact in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Ship-to Contact option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in ORIG_SYSTEM_SHIP_CONTACT_ID.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the ship-to contact from the transaction you're crediting.

validation: RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CUSTOMER_ID = HZ_CUST_ACCT_ROLES.CUST_ACCOUNT_ID and RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CONTACT_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're passing header freight, this column is optional. Depending on the setting of the Ship-to Customer option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SHIP_CUSTOMER_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the ship-to customer from the transaction you're crediting.

validation: Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID.
destination: RA_CUSTOMER_TRX_ALL.SHIP_TO_CUSTOMER_ID

ORIG_SYSTEM_SHIP_CUSTOMER_REF

Enter a value you can use to uniquely identify this ship-to customer in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Ship-to Customer option (Value, ID, None) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SHIP_CUSTOMER_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the ship-to customer from the transaction you're crediting.

validation: Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE.
destination: None.

ORIG_SYSTEM_SOLD_CUSTOMER_ID

Enter the sold-to customer ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Sold-to Customer option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SOLD_CUSTOMER_REF column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value. AutoInvoice uses the sold-to customer from the transaction you're crediting.

validation: Must exist in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID.
destination: RA_CUSTOMER_TRX_ALL.SOLD_TO_CUSTOMER_ID

ORIG_SYSTEM_SOLD_CUSTOMER_REF

Enter a value you can use to uniquely identify this sold-to customer in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Sold-to Customer option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the ORIG_SYSTEM_SOLD_CUSTOMER_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value. AutoInvoice uses the sold-to customer from the transaction you're crediting.

validation: Must exist in HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE.
destination: None.

OVERRIDE_AUTO_ACCOUNTING_FLAG

This column controls whether the code combination ID of the Accounting Flexfield for this accounting distribution, populated by the feeder system, should override AutoAccounting.

Populate this column for invoices and credit memos.

validation: Value should be Y or N.
destination: RA_CUSTOMER_TRX_LINES_ALL.OVERRIDE_AUTO_ACCOUNTING_FLAG

PAYMENT_SET_ID

This column contains a unique internal ID number that matches prepaid invoices with their prepayment receipts. This column should be populated only within a prepayments flow.

validation: Must exist in AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SET_ID.
destination: RA_CUSTOMER_TRX_LINES_ALL.PAYMENT_SET_ID

PAYING_CUSTOMER_ID

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

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.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID

PAYMENT_SERVER_ORDER_NUM

A number that indicates the credit card payment was authorized by the Payments Server.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PAYMENT_SERVER_ORDER_NUM

PREVIOUS_CUSTOMER_TRX_ID

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

For credit memos, AutoInvoice enters a value in this column using RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID and RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID.

PRIMARY_SALESREP_ID

Enter the primary salesperson ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, and the Require salesperson Receivables system option is enabled, you must enter a value either in this column or in the PRIMARY_SALESREP_NUMBER column. Otherwise this column is optional. The value that you enter here depends on the setting of the Salesperson option (Number or ID) in the Import Information section of the transaction source. If you specified Number on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: Must exist in RA_SALESREPS.SALESREP_ID.
destination: RA_CUSTOMER_TRX_ALL.PRIMARY_SALESREP_ID

PRIMARY_SALESREP_NUMBER

Enter the primary salesperson number for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, and the Require salesperson Receivables system option is enabled, you must enter a value either in this column or in the PRIMARY_SALESREP_ID column. Otherwise this column is optional. The value that you enter here depends on the setting of the Salesperson option (Number or ID) in the Import Information section of the transaction source.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: Must exist in RA_SALESREPS.SALESREP_NUMBER.
destination: None.

PRINTING_OPTION

Enter the printing option for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. AutoInvoice looks in your setup for the printing option for the transaction in this order: Customer Site Profile; Customer Account Profile; Transaction Type of the transaction.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUP.LOOKUP_TYPE = INVOICE_PRINT_OPTIONS.
destination: RA_CUSTOMER_TRX_ALL.PRINTING_OPTION

PRODUCT_CATEGORY

Enter the product category code of the noninventory item on the transaction line.

The product category code is used to classify noninventory items and items that aren’t a good that have a tax requirement for tax determination or tax reporting purposes.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

PRODUCT_FISC_CLASSIFICATION

Enter the product fiscal classification code of the inventory item on the transaction line.

The product fiscal classification is used to classify inventory items that have a tax requirement for tax determination or tax reporting purposes.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

PRODUCT_TYPE

Enter the product type code of the inventory item. Valid values are GOODS and SERVICES.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

PURCHASE_ORDER

Enter the purchase order number for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the purchase order number from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER

PURCHASE_ORDER_DATE

Enter the date of the purchase order for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the purchase order date from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER_DATE

PURCHASE_ORDER_REVISION

Enter the purchase order revision for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the purchase order revision from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.PURCHASE_ORDER_REVISION

QUANTITY

If this transaction is an invoice or credit memo line and LINE_TYPE = LINE, or you're 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're crediting. If you don't 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 and CREDIT_METHOD_FOR_ACCT_RULE = UNIT, then this column is required.

If this transaction is a credit memo against a transaction that uses a revenue scheduling rule and CREDIT_METHOD_FOR_ACCT_RULE = 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're passing freight for a specific line, don't enter a value in this column.

For credit memos, if LINE_TYPE = CHARGES, set quantity to 1 or -1.

validation: For debit memo 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, this column can’t 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're passing freight for a specific line, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this field.

For credit memos, don't enter a value in this column. AutoInvoice uses the quantity ordered from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.QUANTITY_ORDERED

REASON_CODE

Enter the reason code for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Memo Reason option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the REASON_CODE_MEANING column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, this column is optional.

validation: Must exist in AR_LOOKUPS.LOOKUP_CODE. This lookup type is either INVOICING_REASON or CREDIT_MEMO_REASON.
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're passing header freight, this column is optional. Depending on the setting of the Memo Reason option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the REASON_CODE column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, this column is optional.

validation: Must exist in AR_LOOKUPS.MEANING. This lookup type is either INVOICING_REASON or CREDIT_MEMO_REASON.
destination: None.

RECEIPT_METHOD_ID

Enter the receipt method ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Payment Method Rule option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the RECEIPT_METHOD_NAME column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

AutoInvoice selects a receipt method using the following hierarchy:

Primary receipt method of the parent primary bill-to site.
Primary receipt method of the parent customer.
Primary receipt method of the bill-to site.
Primary receipt method of the bill-to customer.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this field.

validation: Must exist in AR_RECEIPT_METHODS.RECEIPT_METHOD_ID and must belong to the bill-to customer or the parent. Additionally, the receipt method must have at least one bank account in the same currency as the transaction.
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're passing header freight, this column is optional. Depending on the setting of the Payment Method Rule option (Value or ID) in the Import Information section of the transaction source, you can enter a value either in this column or in the RECEIPT_METHOD_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this field.

validation: Must exist in AR_RECEIPT_METHODS.NAME and must belong to the bill-to customer or the parent.
destination: None.

REFERENCE_LINE_ATTRIBUTE1-15

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, and this transaction is a credit memo, you must enter either the Line Transaction Flexfield of the transaction line you're crediting in these columns or the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction you're crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID. Otherwise, don't enter values in these columns.

If LINE_TYPE = TAX and this transaction is a credit memo, you must enter either the Line Transaction Flexfield of the tax line you're crediting in these columns or the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction tax line you're crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID. Otherwise, don't enter values in these columns.

If LINE_TYPE = FREIGHT and this transaction is a credit memo, you must enter either the Line Transaction Flexfield of the freight line you're crediting in these columns or the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID of the transaction freight line you're crediting in RA_INTERFACE_LINES_ALL.REFERENCE_LINE_ID. Otherwise, don't enter values in these columns.

For on-account credits, don't enter values in these columns.

validation: Must exist in RA_CUSTOMER_TRX_LINES_ALL.INTERFACE_LINE_ATTRIBUTE1-15 or RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ATTRIBUTE1-15.
destination: None.

REFERENCE_LINE_CONTEXT

Enter the context name of the Line 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.

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're 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're crediting in this column or the Line Transaction Flexfield in the REFERENCE_LINE_ATTRIBUTE1-15 columns. Otherwise, don't enter a value.

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're crediting in this column or the Line Transaction Flexfield in the REFERENCE_LINE_ATTRIBUTE1-15 columns. Otherwise, don't 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're crediting in this column or the Line Transaction Flexfield in the REFERENCE_LINE_ATTRIBUTE1-15 columns. Otherwise, don't enter a value in this column.

For on-account credits, don't enter a value in this column.

validation: Must exist in RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID.
destination: RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_LINE_ID if this transaction is a credit memo. Otherwise, RA_CUSTOMER_TRX_LINES_ALL.INITIAL_CUSTOMER_TRX_LINE_ID.

RELATED_BATCH_SOURCE_NAME

Enter the name of the transaction source of the document to which this transaction is related.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Related Document option (Number, ID, None) in the Import Information section of the transaction source, you can enter a value in this column and the related transaction number in the RELATED_TRX_NUMBER column. Or, you can enter the related customer transaction ID in the RELATED_CUSTOMER_TRX_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.RELATED_BATCH_SOURCE_NAME = RA_BATCH_SOURCES_ALL.NAME and RA_INTERFACE_LINES_ALL.RELATED_TRX_NUMBER = RA_CUSTOMER_TRX_ALL.TRX_NUMBER and RA_BATCH_SOURCES_ALL.BATCH_SOURCE_ID = RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID.
destination: None.

RELATED_CUSTOMER_TRX_ID

Enter the customer transaction ID of the document to which this transaction is related.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Related Document option (Number, ID, None) in the Import Information section of the transaction source, you can enter a value in this column. Or, you can enter the related transaction number in the RELATED_TRX_NUMBER column and the related transaction source name in the RELATED_BATCH_SOURCE_NAME column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, don't enter a value in this column.

validation: Must exist in RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID.
destination: RA_CUSTOMER_TRX_ALL.RELATED_CUSTOMER_TRX_ID

RELATED_TRX_NUMBER

Enter the document number to which this transaction is related.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Related Document option (Number, ID, None) in the Import Information section of the transaction source, you can enter a value in this column and the related transaction source name in the RELATED_BATCH_SOURCE_NAME column. Or, you can enter the related customer transaction ID in the RELATED_CUSTOMER_TRX_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, don't enter a value in this column.

validation: RA_INTERFACE_LINES_ALL.RELATED_BATCH_SOUR CE_NAME = RA_BATCH_SOURCES_ALL.NAME and RA_INTERFACE_LINES_ALL.RELATED_TRX_NUMBER = RA_CUSTOMER_TRX_ALL.TRX_NUMBER and RA_BATCH_SOURCES_ALL.BATCH_SOURCE_ID = RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID.
destination: None.

REQUEST_ID

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

validation: None.
destination: The REQUEST_ID column in RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, AR_PAYMENT_SCHEDULES_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_ADJUSTMENTS_ALL and RA_CUST_TRX_LINE_SALESREPS_ALL.

RULE_START_DATE

Enter the start date for the revenue scheduling rule for this transaction.

If LINE_TYPE = LINE or you're passing header freight, this column is optional.

If LINE_TYPE = TAX, CHARGES, or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.RULE_START_DATE

RULE_END_DATE

Enter the end date for the revenue scheduling rule for this transaction.

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

If LINE_TYPE = LINE or you're passing header freight, this column is optional.

If LINE_TYPE = TAX, CHARGES, or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column.

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're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the sales order number from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER

SALES_ORDER_DATE

Enter the date of the sales order for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the sales order date from the transaction you're crediting.

Enter the date of the revenue order for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the revenue order date from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_DATE

SALES_ORDER_LINE

Enter the sales order line number for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the sales order line number from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_LINE

SALES_ORDER_REVISION

Enter the sales order revision for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the sales order revision from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_REVISION

SALES_ORDER_SOURCE

Enter the source of the sales order for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the source of the sales order from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SALES_ORDER_SOURCE

SALES_TAX_ID

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

For credit memos, AutoInvoice uses the sales tax ID of the transaction you're crediting.

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 AutoInvoice uses the ledger of the business unit assigned to Receivables system options.

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're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the earliest shipment date from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.SHIP_DATE_ACTUAL

SHIP_VIA

Enter the ship_via code for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the ship_via code from the transaction you're crediting.

validation: ORG_FREIGHT.FREIGHT_CODE = RA_INTERFACE_LINES_ALL.SHIP_VIA and ORG_FREIGHT.ORGANIZATION_ID = RA_INTERFACE_LINES_ALL.WAREHOUSE_ID. RA_INTERFACE_LINES_ALL.SHIP_VIA must be less than or equal to 25 characters in length.
destination: RA_CUSTOMER_TRX_ALL.SHIP_VIA

SOURCE_DATA_KEY1-5

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

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.SOURCE_DATA_KEY1-5

TAX_CODE

Enter the tax rate code for this tax line.

If LINE_TYPE = CHARGES or FREIGHT, don't enter a value in this column.

If LINE_TYPE = LINE, this column is optional.

If LINE_TYPE = TAX, this column is required.

For credit memos, AutoInvoice uses the tax rate code from the transaction you're crediting.

validation: Must exist in AR_VAT_TAX.TAX_CODE.
destination: None.

TAX_EXEMPT_FLAG

If LINE_TYPE = LINE, this column is optional. The value you enter here controls how a line is taxed:

Enter E, if you want AutoInvoice to exempt an invoice line that would normally be taxed and the Allow Override of Customer Exemptions profile option is set to Yes. If you enter E, you must enter a value in the TAX_EXEMPT_REASON_CODE or TAX_EXEMPT_REASON_CODE_MEANING column, depending on the setting of the Memo Reason option (Value or ID) in the Import Information section of the transaction source.
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 for Receivables transactions.

For all other line types, don't enter a value in this column.

For credit memos, don't enter a value in this column.

validation: Must exist in AR_LOOKUPS.LOOKUP_CODE. Lookup type is TAX_CONTROL_FLAG.
destination: RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPT_FLAG

TAX_EXEMPT_NUMBER

Enter the tax exempt number for this transaction. If LINE_TYPE = LINE and TAX_EXEMPT_FLAG = E, then you can enter a value in this column. Otherwise, don't enter a value in this column.

For all other line types, don't enter a value in this column.

For credit memos, don't enter a value in this column.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPT_NUMBER

TAX_EXEMPT_REASON_CODE

Enter the tax exempt reason code for this transaction. If LINE_TYPE = LINE and TAX_EXEMPT_FLAG = E, then depending on the setting of the Memo Reason option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the TAX_EXEMPT_REASON_CODE_MEANING column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

For all other line types, don't enter a value in this column.

For credit memos, don't enter a value in this column.

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 the setting of the Memo Reason option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the TAX_EXEMPT_REASON_CODE column. Otherwise, don't enter a value in this column.

For all other line types, don't enter a value in this column.

For credit memos, don't enter a value in this column.

validation: Must exist in AR_LOOKUPS.MEANING. Lookup type is TAX_REASON.
destination: None.

TAX_PRECEDENCE

Enter the precedence number for this tax line. This column is used to compute tax compounding.

If LINE_TYPE = LINE, CHARGES, or FREIGHT, don't enter a value in this column.

If LINE_TYPE = TAX and you allow compound tax, you can enter a value in this column. Otherwise don't enter a value.

If you're passing freight for a specific line, don't enter a value in this column.

For credit memos, AutoInvoice uses the tax precedence from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.TAX_PRECEDENCE

TAX_RATE

Enter the tax rate for this tax line.

If LINE_TYPE = LINE, CHARGES, or FREIGHT, don't enter a value in this column.

If LINE_TYPE = TAX, you must enter a value either in this column or the AMOUNT column. Any exemptions for the tax lines must be factored into the tax rate.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.TAX_RATE

TERM_ID

Enter the payment terms ID for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Payment Terms option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the TERM_NAME column. If you specified Value on the transaction source, AutoInvoice enters a corresponding ID in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, don't enter a value in this column.

validation: Must exist in RA_TERMS.TERM_ID.
destination: RA_CUSTOMER_TRX_ALL.TERM_ID

TERM_NAME

Enter the name of the payment terms for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional. Depending on the setting of the Payment Terms option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the TERM_ID column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos and on-account credits, don't enter a value in this column.

validation: Must exist in RA_TERMS.NAME.
destination: None.

TRANSLATED_DESCRIPTION

The translated description of this transaction line.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.TRANSLATED_DESCRIPTION

TRX_BUSINESS_CATEGORY

Enter the transaction business category code for the transaction line.

The transaction business category is used to classify transactions and as a determining factor in tax calculation.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL

TRX_DATE

Enter the transaction date for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're 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 In Arrears invoicing rule, don't enter a value in this column.

If you don't enter a transaction date, AutoInvoice uses the accounting date for invoice and debit memo lines.

For credit memo lines, AutoInvoice uses the following hierarchy to determine the transaction date, selecting whichever date is later:

Credit memo accounting date.
Accounting date entered in the run of the Import AutoInvoice program.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.TRX_DATE

TRX_NUMBER

Enter the number for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, and the Automatic transaction numbering option on the transaction source isn't enabled, you must enter a value in this column.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, and the Automatic transaction numbering option on the transaction source is enabled, don't enter a value in this column. AutoInvoice inserts a unique number in this column.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

validation: Can’t 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 a value either in this column or in the UOM_NAME column. 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're 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're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the unit of measure from the transaction you're crediting.

validation: Must exist in MTL_UNITS_OF_MEASURE.UOM_CODE. If LINE_TYPE = CHARGES, then this column must be null.
destination: RA_CUSTOMER_TRX_LINES_ALL.UOM_CODE

UOM_NAME

Enter the unit of measure name for this transaction.

If LINE_TYPE = LINE and the line has an item, you must enter a value either in this column or in the UOM_CODE column. 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're 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're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the unit of measure from the transaction you're crediting.

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're passing header freight, this column is optional. If you don't enter a value in this column, AutoInvoice uses the amount in RA_INTERFACE_LINES_ALL.AMOUNT as the amount/quantity for this transaction.

If LINE_TYPE = LINE or you're passing header freight, and you're 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're passing freight for a specific line, don't enter a value in this column.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.UNIT_SELLING_PRICE

UNIT_STANDARD_PRICE

Enter the standard price per unit for this transaction.

If LINE_TYPE = LINE, CHARGES, or you're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the unit standard price from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.UNIT_STANDARD_PRICE

USER_DEFINED_FISC_CLASS

Enter the user-defined fiscal classification code for the transaction line.

Use the user-defined fiscal classification code to classify any tax requirement that you can’t define using existing fiscal classification types.

validation: None.
destination: RA_CUSTOMER_TRX_ALL

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's linked. This column is optional.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.DEFAULT_USSGL_TRANSACTION_CODE

USSGL_TRANSACTION_CODE_CONTEXT

This column isn't currently used by AutoInvoice.

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 enters a corresponding ID in this column.

For credit memos, AutoInvoice uses the VAT tax ID of the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_LINES_ALL.VAT_TAX_ID

WAREHOUSE_ID

This column identifies the ship-from location and can be used to control taxation. Within the US, the Warehouse ID is important when calculating state sales tax.

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're passing header freight, this column is optional.

If LINE_TYPE = TAX or you're passing freight for a specific line, don't enter a value in this column.

For credit memos, don't enter a value in this column. AutoInvoice uses the waybill number from the transaction you're crediting.

validation: None.
destination: RA_CUSTOMER_TRX_ALL.WAYBILL_NUMBER