Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, October 16, 2012

Auto Invoice Interface Tables



1- RA_INTERFACE_LINES
2- RA_INTERFACE_SALESCREDITS
3- RA_INTERFACE_DISTRIBUTIONS
4- RA_INTERFACE_ERRORS

Receivables uses these tables to temporarily store transaction data from your original system. The fourth table, RA_INTERFACE_ERRORS is only used by AutoInvoice to store information about interface data that failed validation.

RA_INTERFACE_LINES

This table stores information about your transaction lines. 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.


1- ACCOUNTING_ RULE_DURATION : Enter the accounting rule duration for this transaction. If LINE_TYPE = 'LINE' or you are passing header freight, and this transaction uses a variable duration accounting rule, you must enter a value in this column. If LINE_TYPE = 'TAX' ', 'CHARGES' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits, do not enter a value in this column.
Validation: Accounting periods must be defined for the duration of the accounting rule in GL_PERIODS and RA_INTERFACE_LINES.GL_DATE and RA_INTERFACE_LINES.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.ACCOUNTING_ RULE_DURATION



2- ACCOUNTING_ RULE_ID : Enter the accounting rule id for this transaction. If LINE_TYPE = 'LINE' or you are passing header freight, this column is optional. For invoice lines with rules, you must enter either a value in this column or in ACCOUNTING_RULE_NAME, depending on the value you entered for your batch source. If you entered a value in ACCOUNTING_RULE_NAME, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX', 'CHARGES' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column; AutoInvoice uses the accounting rule from the transaction you are crediting.
Validation: Must exist in RA_RULES.RULE_ID and RA_RULES.TYPE = 'A' or 'ACC_DUR'. If LINE_TYPE = 'CHARGES', then this column must be null.
Destination: RA_CUSTOMER_TRX_LINES.ACCOUNTING_ RULE_ID


3- 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 you are passing freight for a specific line, do not enter a value in this column. 7 For credit memos do not enter a value in this column. AutoInvoice uses the accounting rule from the transaction you are crediting.
Validation: Must exist in RA_RULES.NAME and RA_RULES.TYPE = 'A' or 'ACC_DUR'. If LINE_TYPE = 'CHARGES', then this column must be null.
Destination: None

4- ACCTD_AMOUNT : Do not enter a value. Receivables does not currently use this column.
Validation: None
Destination: None

5- AGREEMENT_ NAME : Enter the name of the customer agreement for this transaction. If LINE_TYPE = 'LINE', 'CHARGES' or you are passing header freight, this column is optional. Depending on the value you entered for your batch source, you can enter either a value in this column or in AGREEMENT_ID. For invoice lines against a commitment, AutoInvoice will default the agreement from the commitment if AGREEMENT_NAME and AGREEMENT_ID are null and a agreement exists for the commitment. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column, AutoInvoice uses the customer agreement from the transaction you are crediting.
Validation: Must exist in SO_AGREEMENTS.NAME
Destination: None

6- 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.
Validation: Must exist in SO_AGREEMENTS.ID
Destination: None

7- AMOUNT : Enter the revenue amount for this transaction. If LINE_TYPE = 'LINE' and this transaction is neither a freight-only nor a tax-only line, you must enter a value in this column. If this transaction is a dummy line for freight-only or tax-only, do not enter a value in this column. AutoInvoice ignores any values you enter in this column if this transaction is a dummy line. If LINE_TYPE = 'TAX', a value must be entered in either this column or the tax_rate column. Any exemptions must be factored into either of the two columns. If LINE_TYPE = 'FREIGHT' and you are passing either header freight or freight for a specific line, you must enter a value in this column. If LINE_TYPE = 'CHARGES', do not enter a value in this column. If this line has AMOUNT_INCLUDES_TAX set to Yes, the sales credits and line amounts for this column must include tax. For credit memos and on-account credits, enter the credit amount for this transaction.
Validation: If LINE_TYPE = 'CHARGES', then this column must be null. AutoInvoice will correct revenue amounts that have the wrong currency precision.
Destination: If you are not using suspense, RA_CUSTOMER_TRX_LINES.REVENUE_ AMOUNT and RA_CUSTOMER_TRX_LINES. EXTENDED_AMOUNT. If you are using suspense, RA_CUSTOMER_TRX_LINES. REVENUE_AMOUNT.

8- 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.
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.AMOUNT_ INCLUDES_TAX_FLAG

9- ATTRIBUTE1-15 : Enter the Descriptive 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.ATTRIBUTE1-15

10- ATTRIBUTE_ CATEGORY : Enter the Descriptive 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.ATTRIBUTE_ CATEGORY

11- 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.
Validation: Must exist in RA_BATCH_SOURCES.NAME and RA_BATCH_SOURCES.BATCH_SOURCE_TYPE = 'FOREIGN'
Destination: RA_BATCHES.BATCH_SOURCE_ID and RA_CUSTOMER_TRX.BATCH_SOURCE_ID

12- COMMENTS : Enter comments about this transaction. If LINE_TYPE = 'LINE', 'CHARGES' or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or your are passing freight for a specific line, do not enter text in this column.
Validation: None
Destination: RA_CUSTOMER_TRX.COMMENTS

13- 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.
Validation: None
Destination: RA_CUSTOMER_TRX.EXCHANGE_DATE

14- 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.
Validation: If RA_INTERFACE_LINES.CONVERSION_TYPE = 'User' then this column must not be null; otherwise, it must be null.
Destination: RA_CUSTOMER_TRX.EXCHANGE_RATE

14- CONVERSION_ TYPE : Enter the exchange rate type for this transaction. If the currency of the transaction is the same as the base currency, enter 'User' and set CONVERSION_RATE to 1. You must enter a value in this column.
Validation: Must exist in GL_DAILY_CONVERSION_TYPES. CONVERSION_TYPE
Destination: RA_CUSTOMER_TRX.EXCHANGE_RATE_TYPE

15- CREDIT_METHOD_ FOR_ACCT_RULE: Enter the credit method for crediting a transaction which uses an accounting rule. Choices include PRORATE, LIFO, or UNIT. If this transaction is a credit memo against a transaction which uses an accounting rule and LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, you must enter a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. AutoInvoice will ignore any value that you enter in this column. For on-account credits do not enter a value in this column.
Validation: Must be either 'PRORATE', 'LIFO', 'UNIT' or NULL
Destination: RA_CUSTOMER_TRX.CREDIT_METHOD_FOR_ RULES

16- 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.
Validataion: Must be either 'PRORATE', 'LIFO', 'FIFO' or NULL.
Destination: RA_CUSTOMER_TRX.CREDIT_METHOD_FOR_ INSTALLMENTS

17- CURRENCY_CODE : Enter the currency code for this transaction. You must enter a value in this column. For credit memos enter the currency code of the invoice you are crediting.
Validation: Must exist in FND_CURRENCIES.CURRENCY_CODE
Destination: RA_CUSTOMER_TRX.INVOICE_CURRENCY_ CODE and
AR_PAYMENT_SCHEDULES. INVOICE_CURRENCY_CODE

18- CUSTOMER_BANK_ ACCOUNT_ID : Enter the Bill-To customer bank account id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in CUSTOMER_BANK_ACCOUNT_NAME. If you entered a value in CUSTOMER_BANK_ACCOUNT_NAME, AutoInvoice defaults a value in this column. If the payment method is of type 'Automatic', and this column is NULL, AutoInvoice will default a value for you. For more details on how AutoInvoice defaults and validates customer banks, see: Passing Payment Methods and Customer Bank Accounts. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: Must exist in AP_BANK_ACCOUNTS.BANK_ACCOUNT_ID. If the payment method is of type 'Manual', RA_INTERFACE_LINES.CUSTOMER_BANK_ ACCOUNT_ID must be NULL.
Destination: RA_CUSTOMER_TRX.CUSTOMER_BANK_ ACCOUNT_ID

19- CUSTOMER_BANK_ ACCOUNT_NAME : Enter the Bill-To customer bank account name for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in CUSTOMER_BANK_ACCOUNT_ID. If the payment method is of type 'Automatic' and this column is NULL, AutoInvoice will default a value for you. For more details on how AutoInvoice defaults and validates customer banks, see: Passing Payment Methods and Customer Bank Accounts. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: AP_BANK_ACCOUNTS.BANK_ACCOUNT_ NAME If the payment method is of type 'Manual', RA_INTERFACE_LINES.CUSTOMER_BANK_ ACCOUNT_NAME must be NULL.
Destination: None

20- CUSTOMER_TRX_ID : This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value into this column using your grouping rules.
Validation: None
Destination: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID, AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ ID, RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_ ID, and RA_CUST_TRX_LINE_GL_DIST.CUSTOMER_ TRX_ID.

21- CUST_TRX_TYPE_ID : Enter the transaction type id for this transaction. This column is optional, but depending on the value you entered for your batch source you must enter either a value in this column or in CUST_TRX_TYPE_NAME. If you entered a value in CUST_TRX_TYPE_NAME, AutoInvoice defaults a value in this column. For invoice lines against a commitment, AutoInvoice defaults the invoice transaction type from the transaction type of the commitment if CUST_TRX_TYPE_ID and CUST_TRX_TYPE_NAME are null. For credit memos you must enter the id of the credit memo transaction type which has been assigned to the transaction you are crediting.
Validation: Must exist in RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
Destination: RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID

22- CUST_TRX_ TYPE_NAME : Enter the transaction type name for this transaction. This column is optional, but depending on the value you entered for your batch source you must enter either a value in this column or in CUST_TRX_TYPE_ID. For invoice lines against a commitment, AutoInvoice defaults the invoice transaction type from the transaction type of the commitment if CUST_TRX_TYPE_ID and CUST_TRX_TYPE_NAME are null. For credit memos you must enter the name of the credit memo transaction type which has been assigned to the transaction you are crediting.
Validation: RA_CUST_TRX_TYPES.NAME
Destination: None

23- DESCRIPTION : This is a required column in AutoInvoice. Enter the description for this transaction.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.DESCRIPTION

24- DOCUMENT_ NUMBER : Enter the document number for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight and the creation method for the sequence numbering of this transaction is Manual, you must enter a value in this column. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight and the creation method is Automatic, do not enter a value in this column. AutoInvoice will create a unique document number. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: Number must not already exist in Oracle Receivables
Destination: RA_CUSTOMER_TRX.DOC_SEQUENCE_VALUE

25- 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.DOC_SEQUENCE_ID

26- EXCEPTION_ID : This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value in this column when a tax exception occurs. If your transaction is a credit memo, AutoInvoice defaults the tax exemption id of the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES. ITEM_EXCEPTION_RATE_ID

27- 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.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.TAX_EXEMPTION_ID

28- FOB_POINT : Enter the FOB point for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the FOB point from the transaction you are crediting.
Validation: Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUPS.LOOKUP_TYPE = 'FOB'. Must be less than or equal to 30 characters in length.
Destination: RA_CUSTOMER_TRX.FOB_POINT

29- 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 date, see: Determining Dates.
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.
Destination: RA_CUST_TRX_LINE_GL_DIST.GL_DATE

30- HEADER_ ATTRIBUTE1-15 : Enter Descriptive Flexfield attribute information. Descriptive Flexfield attributes let you store additional columns, the contents of which you define. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or 'FREIGHT', do not enter values in these columns.
Validation: None
Destination: RA_CUSTOMER_TRX.ATTRIBUTE1-15

31- HEADER_ ATTRIBUTE_ CATEGORY : Enter Descriptive Flexfield attribute category information which is shared between this transaction and other transactions. Descriptive Flexfield categories allow you to store different categories of attributes. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line', do not enter values in these columns.
Validation: None
Destination: RA_CUSTOMER_TRX.ATTRIBUTE_CATEGORY

32-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.REFERENCE_ LINE_ID.
Validation: None
Destination: RA_CUSTOMER_TRX.INITIAL_CUSTOMER_ TRX_ID

33- INTERFACE_LINE_ ATTRIBUTE1-15 : Enter the line Transaction Flexfield for this transaction. A Transaction Flexfield is a combination of attribute values which you use to uniquely identify this transaction in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system. This is the primary key for RA_INTERFACE_LINES. You must enter values for enabled attributes. When you import transactions with multiple lines using AutoInvoice, only those columns from RA_INTERFACE_LINES.INTERFACE_LINE_ATTRIBUTE1-15 that have the same value for each of the lines will appear in the RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE1-15 columns for any customizations.
Interface lines belonging to the same transaction are ordered by the following SQL clause: waybill_numbership_via asc, ship_date_actual desc The attributes of the first line from the ordered lines will appear in the header attributes.
If a transaction has only one line, then RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE1-15 will be the same as RA_INTERFACE_LINES.INTERFACE_LINE_ATTRIBUTE1-15.
Validation: Must not already exist together with INTERFACE_LINE_CONTEXT in RA_CUSTOMER_TRX_LINES. INTERFACE_LINE_ATTRIBUTE1-15, INTERFACE_LINE_CONTEXT and all enabled attributes must have values.
Destination: RA_CUSTOMER_TRX.INTERFACE_HEADER_ ATTRIBUTE1-15 and RA_CUSTOMER_TRX_LINES.INTERFACE_LINE_ATTRIBUTE1-15

34- 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 lines with global context, set this column to 'Global Data Elements'.
Validation: None
Destination: RA_CUSTMER_TRX_LINES.INTERFACE_LINE_ CONTEXT

35- INTERFACE_ LINE_ID : This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value in this column using the RA_CUSTOMER_TRX_LINES_S sequence.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_LINE_ID

36- 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.

37- INTERNAL_NOTES : Enter internal notes for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing freight header, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter text in this column.
Validation: None
Destination: RA_CUSTOMER_TRX.INTERNAL_NOTES

38- INVENTORY_ ITEM_ID : Enter the inventory item id for this transaction. If LINE_TYPE = 'LINE', or 'CHARGES' this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or a combination of segment values in MTL_SYSTEM_ITEMS_SEG1-20. If you specify segments in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or 'FREIGHT', do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the value from the transaction you are crediting.
Validation: Must exist in MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID and MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG = 'Y'.
Destination: RA_CUSTOMER_TRX_LINES.INVENTORY_ITEM_ID

39- 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.
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.INVOICING_RULE_ID

40- 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 INVOICE_RULE_ID. If LINE_TYPE = 'TAX', 'CHARGES' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the invoicing rule from the transaction you are crediting.
Validation: Must exist in RA_RULES.RULE_ID and RA_RULES.RULE_ID = -2 or -3. If you enter an invoicing rule you must also enter an accounting rule. If LINE_TYPE = 'CHARGES' then this column must be null.
Destination: None

41- LAST_PERIOD_ TO_CREDIT : For unit credit memos, enter the last period number from which you want to start crediting. If this transaction is a credit memo against a transaction which uses an accounting rule and LINE_TYPE = 'LINE', CREDIT_METHOD_FOR_ACCT_RULE = 'UNIT', or you are passing header freight, you may enter a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. AutoInvoice will ignore any value that you enter in this column.
Validation: Must be between 0 and the invoice's accounting rule duration (inclusive).
Destination: RA_CUSTOMER_TRX_LINES.LAST_PERIOD_TO_CREDIT

42- 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 table for processing.
Validation: None
Destination: None

43- 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.

44- 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 are crediting.
Validation: Must be 'LINE', 'TAX', 'FREIGHT' or 'CHARGES'
Destination: RA_CUSTOMER_TRX_LINES.LINE_TYPE

45- 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 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.
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

46- LINK_TO_LINE_ CONTEXT : Enter the context name of the Transaction Flexfield data that you entered in RA_INTERFACE_LINES.LINK_TO_LINE_ATTRIBUTE1-15.
Validation: None
Destination: None

47- 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.LINK_TO_LINE_ATTRIBUTE1-15 and RA_INTERFACE_LINES.LINK_TO_LINE_CONTEXT.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.LINK_TO_CUST_ TRX_LINE_ID

48- LOCATION_ SEGMENT_ID : This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value into this column if you are crediting a sales tax line.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.LOCATION_ SEGMENT_ID

49- 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.
Validation: Must exist in AR_MEMO_LINES.MEMO_LINE_ID
Destination: RA_CUSTOMER_TRX_LINES.MEMO_LINE_ID

50- MEMO_LINE_NAME : Enter the name of the standard memo line for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in MEMO_LINE_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the memo line from the transaction you are crediting.
Validation: Must exist in AR_MEMO_LINES.NAME
Destination: None

51- 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.movement_id with RA_INTERFACE_LINES.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.movement_id

52- 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.
Validation: Valid combination of System Item Flexfield segment values
Destination: None

53- ORG_ID : This column has been added for future Oracle Applications functionality and can be left null.
Validation: None
Destination: None

54- ORIG_SYSTEM_ BATCH_NAME : Enter the batch name for this transaction. This column is optional. AutoInvoice does not perform any validation on this column but uses the value entered when grouping transactions into invoices.
Validation: None
Destination: RA_CUSTOMER_TRX.ORIG_SYSTEM_BATCH_ NAME

55- 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, AutoInvoice uses the Bill-To address to determine the Remit-To address for the customer. AutoInvoice will not import transactions that have inactive addresses or addresses with an inactive Bill To business purpose. In addition, if the Remit-To address cannot be determined, 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.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ ADDRESS_ID = RA_ADDRESSES.ADDRESS_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CUSTOMER_ID = RA_CUSTOMERS.CUSTOMER_ID and RA_CUSTOMERS.CUSTOMER_ID = RA_ADDRESSES.CUSTOMER_ID and RA_ADDRESSES.ADDRESS_ID = RA_SITE_USES.ADDRESS_ID and RA_SITE_USES.SITE_USE_CODE = 'BILL_TO'
Destination: None

56- 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, AutoInvoice uses the Bill-To address to determine the Remit-To address for the customer. AutoInvoice will not import transactions that have inactive addresses or addresses with an inactive Bill To business purpose. In addition, if the Remit-To address cannot be determined, AutoInvoice will reject the transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in ORIG_SYSTEM_BILL_ADDRESS_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ ADDRESS_REF = RA_ADDRESSES.ORIG_SYSTEM_REFERENCE and RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CUSTOMER_REF = RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE and RA_CUSTOMERS.CUSTOMER_ID = RA_ADDRESSES.CUSTOMER_ID and RA_ADDRESSES.ADDRESS_ID = RA_SITE_USES.ADDRESS_ID and RA_SITE_USES.SITE_USE_CODE = 'BILL_TO'
Destination: None

57- 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.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CUSTOMER_ID = RA_CONTACTS.CUSTOMER_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CONTACT_ID = RA_CONTACTS.CONTACT_ID
Destination: RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID

58-ORIG_SYSTEM_ BILL_CONTACT_REF : Enter the Bill-To contact reference from your original system. This reference is for the Bill-To customer that you entered in ORIG_SYSTEM_BILL_CUSTOMER_REF or ORIG_SYSTEM_BILL_CUSTOMER_ID. The reference value you enter here provides you with an audit trail from Oracle Receivables back to your original system. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_BILL_CONTACT_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CUSTOMER_ID = RA_CONTACTS.CUSTOMER_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ CONTACT_REF = RA_CONTACTS.ORIG_SYSTEM_REFERENCE
Destination: None

59- ORIG_SYSTEM_ BILL_CUSTOMER_ID : Enter the Bill-To customer id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in ORIG_SYSTEM_BILL_CUSTOMER_REF. If you specify the Bill-To customer reference in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos you must enter the Bill-To customer id or the Bill-To customer id of a related customer of the transaction you are crediting.
Validation: Must exist in RA_CUSTOMERS.CUSTOMER_ID
Destination: RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID

60- ORIG_SYSTEM_ BILL_CUSTOMER_ REF : Enter a value you can use to uniquely identify this Bill-To customer in your original system. The reference value you enter here provides you with an audit trail from Oracle Receivables back to your original system. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in ORIG_SYSTEM_BILL_CUSTOMER_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos you must enter the Bill-To customer reference or the Bill-To customer reference of a related customer of the transaction you are crediting.
Validation: Must exist in RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE
Destination: None

61- ORIG_SYSTEM_ SHIP_ADDRESS_ID : Enter the Ship-To customer address id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SHIP_ADDRESS_REF. If you specify the Ship-To address reference in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column; AutoInvoice uses the Ship-To address from the transaction you are crediting.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ ADDRESS_ID = RA_ADDRESSES.ADDRESS_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CUSTOMER_ID = RA_CUSTOMERS.CUSTOMER_ID and RA_CUSTOMERS.CUSTOMER_ID = RA_ADDRESSES.CUSTOMER_ID and RA_ADDRESSES.ADDRESS_ID = RA_SITE_USES.ADDRESS_ID and RA_SITE_USES.SITE_USE_CODE = 'SHIP_TO'
Destination: None

62- 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.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ ADDRESS_REF = RA_ADDRESSES.ORIG_SYSTEM_REFERENCE and RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CUSTOMER_ID = RA_CUSTOMERS.CUSTOMER_ID and RA_CUSTOMERS.CUSTOMER_ID = RA_ADDRESSES.CUSTOMER_ID and RA_ADDRESSES.ADDRESS_ID = RA_SITE_USES.ADDRESS_ID and RA_SITE_USES.SITE_USE_CODE = 'SHIP_TO'
Destination: None

63- ORIG_SYSTEM_ SHIP_CONTACT_ID : Enter the Ship-To contact id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SHIP_CONTACT_REF. If you specify the Ship-To contact reference in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To contact from the transaction you are crediting.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CUSTOMER_ID = RA_CONTACTS.CUSTOMER_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CONTACT_ID = RA_CONTACTS.CONTACT_ID
Destination: RA_CUSTOMER_TRX.SHIP_TO_CONTACT_ID

64- ORIG_SYSTEM_ SHIP_CONTACT_REF : Enter a value you can use to uniquely identify this Ship-To contact in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SHIP_CONTACT_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To contact from the transaction you are crediting.
Validation: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CUSTOMER_ID = RA_CONTACTS.CUSTOMER_ID and RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ CONTACT_REF = RA_CONTACTS.ORIG_SYSTEM_REFERENCE
Destination: None

65- ORIG_SYSTEM_ SHIP_CUSTOMER_ ID : Enter the Ship-To customer id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SHIP_CUSTOMER_REF. If you specify the Ship-To customer reference in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To customer from the transaction you are crediting.
Validation: Must exist in RA_CUSTOMERS.CUSTOMER_ID
Destination: RA_CUSTOMER_TRX.SHIP_TO_CUSTOMER_ID

66- ORIG_SYSTEM_ SHIP_CUSTOMER_ REF : Enter a value you can use to uniquely identify this Ship-To customer in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SHIP_CUSTOMER_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the Ship-To customer from the transaction you are crediting.
Validation: Must exist in RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE
Destination: None

67- 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.
Validation: Must exist in RA_CUSTOMERS.CUSTOMER_ID
Destination: RA_CUSTOMER_TRX.SOLD_TO_CUSTOMER_ID

68- ORIG_SYSTEM_ SOLD_CUSTOMER_ REF : Enter a value you can use to uniquely identify this Sold-To customer in your original system. The reference value you enter here provides you with an audit trail from Receivables back to your original system. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in ORIG_SYSTEM_SOLD_CUSTOMER_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value, AutoInvoice uses the Sold-To customer from the transaction you are crediting.
Validation: Must exist in RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE
Destination: None

69- PAYING_ CUSTOMER_ID : This column is used by AutoInvoice and should be left null. Please refer to the section on Automatic Receipts for details on how AutoInvoice determines the paying customer.
Validation: None
Destination: RA_CUSTOMER_TRX.PAYING_CUSTOMER_ID

70- PAYING_ CUSTOMER_ID : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: RA_CUSTOMER_TRX.PAYING_CUSTOMER_ID

71- PAYING_SITE_ USE_ID : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: RA_CUSTOMER_TRX.PAYING_SITE_USE_ID

72- PAYING_ SITE_USE_ID : This column is used by AutoInvoice and should be left null. Please refer to the section on Automatic Receipts for details on how AutoInvoice determines the paying site use.
Validation: None
Destination: RA_CUSTOMER_TRX.PAYING_SITE_USE_ID

73- 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.REFERENCE_LINE_ID.
Validation: None
Destination: RA_CUSTOMER_TRX.PREVIOUS_CUSTOMER_ TRX_ID and
RA_CUSTOMER_TRX_LINES. CUSTOMER_TRX_ID

75- 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.
Validation: Must exist in RA_SALESREPS.SALESREP_ID
Destination: RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID

76- PRIMARY_ SALESREP_NUMBER : Enter the primary salesperson number for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, and you entered Yes for the Require Salesreps system option, you must enter either a value in this column or in PRIMARY_SALESREP_ID. Otherwise this column is optional. The value that you enter depends on the value you entered for your batch source. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: Must exist in RA_SALESREPS.SALESREP_NUMBER
Destination: None

77- PRINTING_OPTION : Enter the printing option for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. AutoInvoice defaults to the printing option that you entered for this transaction type, if one was entered. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: Must exist in AR_LOOKUPS.LOOKUP_CODE and AR_LOOKUP.LOOKUP_TYPE = 'INVOICE_PRINT_OPTIONS'
Destination: RA_CUSTOMER_TRX.PRINTING_OPTION

78- PURCHASE_ORDER : Enter the purchase order number for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the purchase order number from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX.PURCHASE_ORDER

79- PURCHASE_ ORDER_DATE : Enter the date of the purchase order for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the purchase order date from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX.PURCHASE_ORDER_ DATE

80- PURCHASE_ ORDER_REVISION : Enter the purchase order revision for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos, do not enter a value in this column. AutoInvoice uses the purchase order revision from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX.PURCHASE_ORDER_ REVISION

81- 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.
For Debit Memos, if LINE_TYPE = 'CHARGES', set quantity to 1.
If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
For Credit Memos, if LINE_TYPE = 'CHARGES', set quantity to 1 or -1.
Validation: For Debit Memos lines with LINE_TYPE = 'CHARGES', quantity must be 1. For Credit Memo lines with LINE_TYPE = 'CHARGES', this column must be 1 or -1. For Credit Memo lines with LINE_TYPE = 'LINE' and CREDIT_METHOD_FOR_ACCT_RULE = 'UNIT' then this column must not be null.
Destination: RA_CUSTOMER_TRX_LINES.QUANTITY_ INVOICED if this transaction is an invoice line. RA_CUSTOMER_TRX_LINES.QUANTITY_ CREDITED if this transaction is a credit memo line.

82- QUANTITY_ ORDERED : Enter the original number of units ordered for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing freight for a specific line, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this field. For credit memos, do not enter a value in this column. AutoInvoice uses the quantity ordered from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.QUANTITY_ ORDERED

83- REASON_CODE : Enter the reason code for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in REASON_CODE_MEANING. If you specify the reason code meaning in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits this column is optional.
Validation: Must exist in AR_LOOKUPS.LOOKUP_CODE. This lookup type is either INVOICING_REASON or CREDIT_MEMO_REASON
Destination: RA_CUSTOMER_TRX_LINES.REASON_CODE and

84- RA_CUSTOMER_TRX.REASON_CODE : REASON_CODE_ MEANING
Enter the meaning of the reason code for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in REASON_CODE. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits this column is optional.
Validation: Must exist in AR_LOOKUPS.MEANING. This lookup type is either INVOICING_REASON or CREDIT_MEMO_REASON
Destination: None

85- RECEIPT_METHOD_ ID : Enter the payment method id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in RECEIPT_METHOD_NAME. If you specify the payment method name in your batch source, AutoInvoice defaults a value in this column. AutoInvoice always defaults the payment method using the following hierarchy:
1. primary receipt method of the parent primary bill-to site
2. primary receipt method of the parent customer
3. primary receipt method of the bill-to site
4. primary receipt method of the bill-to customer
If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this field.
Validation: Must exist in AR_RECEIPT_METHODS.RECEIPT_METHOD_ ID and must belong to the bill-to customer or the parent. Additionally, the payment method must have at least one bank account in the same currency as the transaction or have its' Receipts Multi-Currency flag set to Yes.
Destination: RA_CUSTOMER_TRX.RECEIPT_METHOD_ID

86- RECEIPT_METHOD_NAME : Enter the name of the payment method for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or in RECEIPT_METHOD_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this field.
Validation: Must exist in AR_RECEIPT_METHODS.NAME and must belong to the bill-to customer or the parent.
Destination: None

87- 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.CUSTOMER_TRX_LINE_ID of the transaction you are crediting in RA_INTERFACE_LINES.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.CUSTOMER_TRX_LINE_ID of the transaction tax line you are crediting in RA_INTERFACE_LINES.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.CUSTOMER_TRX_LINE_ID of the transaction freight line you are crediting in RA_INTERFACE_LINES.REFERENCE_LINE_ID. Otherwise, do not enter values in these columns. For on-account credits do not enter values in these columns.
Validation: Must exist in RA_CUSTOMER_TRX_LINES.INTERFACE_LINE_ATTRIBUTE1-15 or RA_INTERFACE_LINES.INTERFACE_LINE_ ATTRIBUTE1-15
Destination: None

88- REFERENCE_LINE_ CONTEXT : Enter the context name of the Transaction Flexfield data entered in RA_INTERFACE_LINES.REFERENCE_LINE_ATTRIBUTE1-15. You must enter a value in this column if you entered values in RA_INTERFACE_LINES.ATTRIBUTE1-15.
Validation: Must exist in: RA_CUSTOMER_TRX_LINES.INTERFACE_LINE_CONTEXT or RA_INTERFACE_LINES.INTERFACE_LINE_ CONTEXT
Destination: None

89- 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.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. CUSTOMER_TRX_LINE_ID of the commitment line you are referencing. If LINE_TYPE= 'TAX' and this transaction is a credit memo, you must enter the RA_CUSTOMER_TRX_LINES.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.CUSTOMER_TRX_LINE_ID of the freight line you are crediting in these columns or the Transaction Flexfield in REFERENCE_LINE_ATTRIBUTE1-15. Otherwise, do not enter a value in this column. For on-account credits, do not enter a value in this column.
Validation: Must exist in RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_LINE_ID.
Destination: RA_CUSTOMER_TRX_LINES.PREVIOUS_ CUSTOMER_TRX_LINE_ID if this transaction is a credit memo. Otherwise, RA_CUSTOMER_TRX_ LINES.INITIAL_CUSTOMER_TRX_LINE_ID

90- RELATED_BATCH_ SOURCE_NAME : Enter the name of the batch source of the document to which this transaction is related. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter a value in this column and the related transaction number in RELATED_TRX_NUMBER. Or, you can enter the related customer transaction id in RELATED_CUSTOMER_TRX_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits do not enter a value in this column.
Validation: RA_INTERFACE_LINES.RELATED_BATCH_ SOURCE_NAME = RA_BATCH_SOURCES.NAME and RA_INTERFACE_LINES.RELATED_TRX_ NUMBER = RA_CUSTOMER_TRX.TRX_NUMBER and RA_BATCH_SOURCES.BATCH_SOURCE_ID = RA_CUSTOMER_TRX.BATCH_SOURCE_ID
Destination: None

91- 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.
Validation: Must exist in RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
Destination: RA_CUSTOMER_TRX.RELATED_CUSTOMER_ TRX_ID

92- RELATED_TRX_ NUMBER : Enter the document number to which this transaction is related. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter a value in this column and the related batch source name in RELATED_BATCH_SOURCE_NAME. Or, you can enter the related customer transaction id in RELATED_CUSTOMER_TRX_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits do not enter a value in this column.
Validation: RA_INTERFACE_LINES.RELATED_BATCH_ SOURCE_NAME = RA_BATCH_SOURCES.NAME and RA_INTERFACE_LINES.RELATED_TRX_ NUMBER = RA_CUSTOMER_TRX.TRX_NUMBER and RA_BATCH_SOURCES.BATCH_SOURCE_ID = RA_CUSTOMER_TRX.BATCH_SOURCE_ID
Destination: None

93- REQUEST_ID : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: The REQUEST_ID column in RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST, AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, AR_ADJUSTMENTS and RA_CUST_TRX_LINE_SALESREPS.

94- 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. Please refer to the Deriving Dates section for a more details on rule start date.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.RULE_START_ DATE

95- SALES_ORDER : Enter the sales order number for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the sales order number from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX__LINES.SALES_ORDER

96- SALES_ORDER_ DATE : Enter the date of the sales order for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the sales order date from the transaction you are crediting.
Enter the date of the revenue order for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the revenue order date from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.SALES_ORDER_ DATE

97- 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.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.SALES_ORDER_ LINE

98- SALES_ORDER_ REVISION : Enter the sales order revision for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the sales order revision from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.SALES_ORDER_ REVISION

99- SALES_ORDER_ SOURCE : Enter the source of the sales order for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the source of the sales order from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.SALES_ORDER_ SOURCE

100- SALES_TAX_ID : This column is used by AutoInvoice and should be left null. For credit memos, AutoInvoice defaults to the sales tax id of the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.SALES_TAX_ID

101- SET_OF_BOOKS_ID : Enter the set of books id for this transaction. You must enter a value in this column.
Validation: Must exist in AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID
Destination: RA_CUSTOMER_TRX.SET_OF_BOOKS_ID

102- 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 shipment date from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX.SHIP_DATE_ACTUAL

103- SHIP_VIA : Enter the ship via code for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the ship via code from the transaction you are crediting.
Validation: ORG_FREIGHT_CODE = RA_INTERFACE_LINES.SHIP_VIA and ORG_FREIGHT.ORGANIZATION_ID = (Your Organization ID) RA_INTERFACE_LINES.SHIP_VIA must be less than or equal to 25 characters in length.
Destination: RA_CUSTOMER_TRX.SHIP_VIA

104- TAX_CODE : Enter the tax code for this tax line.
If LINE_TYPE = 'LINE', 'CHARGES', or 'FREIGHT', do not enter a value in this column. If LINE_TYPE = 'TAX', this column is mandatory. For credit memos, AutoInvoice defaults the tax code from the transaction you are crediting.
Validation: Must exist in AR_VAT_TAX.TAX_CODE
Destination: None

105- 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, do not enter a value in this column. For credit memos, do not enter a value in this column.
Validation: Must exist in AR_LOOKUPS.LOOKUP.CODE Lookup type is TAX_CONTROL_FLAG
Destination: RA_CUSTOMER_TRX_LINES. TAX_EXEMPT_FLAG

106- TAX_EXEMPT_ NUMBER : Enter the tax exempt number for this transaction. If LINE_TYPE = 'LINE' and tax_exempt_flag = 'E', then you may enter a value in this column. Otherwise, do not enter a value in this column. For all other line types, do not enter a value in this column. For credit memos, do not enter a value in this column.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES. TAX_EXEMPT_NUMBER

107- TAX_EXEMPT_ REASON_CODE : Enter the tax exempt reason code for this transaction. If LINE_TYPE = 'LINE' and tax_exempt_flag = 'E', then depending on your batch source option, Memo Reason, you must enter a value in this column or in TAX_EXEMPT_REASON_CODE_MEANING. If you specify a tax exempt reason code meaning in your batch source, AutoInvoice defaults the code in this column. For all other line types, do not enter a value in this column. For credit memos do not enter a value in this column.
Validation: Must exist in AR_LOOKUPS.LOOKUP.CODE Lookup type is TAX_REASON
Destination: RA_CUSTOMER_TRX_LINES. TAX_EXEMPT_REASON_CODE

108- 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, do not enter a value in this column. For credit memos do not enter a value in this column.
Validation: Must exist in AR_LOOKUPS.MEANING. Lookup type is TAX_REASON
Destination: None

109- TAX_PRECEDENCE : Enter the precedence number for this tax line. This column is used to compute tax compounding.
If LINE_TYPE = 'LINE', 'CHARGES', or 'FREIGHT', do not enter a value in this column. If LINE_TYPE = 'TAX' and you allow compound tax, you can enter a value in this column. Otherwise do not enter a value. If you are passing freight for a specific line, do not enter a value in this column. For credit memos AutoInvoice defaults the tax precedence from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.TAX_ PRECEDENCE

110- TAX_RATE : Enter the tax rate for this tax line.
If LINE_TYPE = 'LINE', 'CHARGES', or 'FREIGHT', do not enter a value in this column. If LINE_TYPE = 'TAX', you must enter a value either in this column or the AMOUNT column. Any exemptions for the tax lines must be factored into the tax rate.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.TAX_RATE

111- 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.
Validation: Must exist in RA_TERMS.TERM_ID
Destination: RA_CUSTOMER_TRX.TERM_ID

112- TERM_NAME : Enter the name of the payment term for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in TERM_ID. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits do not enter a value in this column.
Validation: Must exist in RA_TERMS.NAME
Destination: None

113- TERRITORY_ID : Enter the territory id for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. Depending on the value you entered for your batch source you can enter either a value in this column or a combination of territory segment values in TERRITORY_SEGMENT1-20. If you specify the combination of territory segment values in your batch source, AutoInvoice defaults a value in this column. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the territory from the transaction you are crediting.
Validation: Must exist in RA_TERRITORIES.TERRITORY_ID
Destination: RA_CUSTOMER_TRX.TERRITORY_ID

114- 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.
Validation: Valid combination of Territory Flexfield segment values from RA_TERRITORIES Destination: None

115- 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 on the Submit Requests window, whichever is later.
When child invoices are created against a commitment, AutoInvoice ensures that the child invoice's transaction date falls between the commitment's start and end dates.
If TRX_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: None
Destination: RA_CUSTOMER_TRX.TRX_DATE

116- 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.
Validation: Must not already exist in RA_CUSTOMER_TRX.TRX_NUMBER and RA_CUSTOMER_TRX.BATCH_SOURCE_ID
Destination: RA_CUSTOMER_TRX.TRX_NUMBER and
AR_PAYMENT_SCHEDULES.TRX_NUMBER

117- UOM_CODE : Enter the unit of measure code for this transaction. If LINE_TYPE = 'LINE' and the line has an item you must enter either a value in this column or in UOM_NAME. If this a freight-only line, a tax-only line, or a line with no item, this column is optional. If LINE_TYPE = 'LINE' and you are passing a dummy line for either a tax-only or freight-only line, AutoInvoice ignores what you enter here. If LINE_TYPE = 'TAX', 'CHARGES', or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the unit of measure from the transaction you are crediting.
Validation: Must exist in MTL_UNITS_OF_MEASURE.UOM_CODE. If Line_type = 'CHARGES', then this column must be null.
Destination: RA_CUSTOMER_TRX_LINES.UOM_CODE

118- UOM_NAME : Enter the unit of measure name for this transaction. If LINE_TYPE = 'LINE' and the line has an item you must enter either a value in this column or in UOM_CODE. If this a freight-only line, a tax-only line, or a line with no item, this column is optional. If LINE_TYPE = 'LINE' or you are passing header freight, and you are passing a dummy line for either a tax-only or freight-only line, AutoInvoice ignores what you enter here. If LINE_TYPE = 'TAX', 'CHARGES', or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the unit of measure from the transaction you are crediting.
Validation: Must exist in MTL_UNITS_OF_MEASURE.UNIT_OF_ MEASURE. If LINE_TYPE = 'CHARGES' then this column must be null.
Destination: None

119- 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.AMOUNT as the extended amount 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 what you enter here. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.UNIT_SELLING_ PRICE

120- UNIT_STANDARD_ PRICE : Enter the standard price per unit for this transaction. If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional. If LINE_TYPE = 'TAX' or you are passing freight for a specific line, do not enter a value in this column. For credit memos do not enter a value in this column. AutoInvoice uses the unit standard price from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES. UNIT_STANDARD_PRICE

121- USSGL_ TRANSACTION_ CODE : Enter the transaction code for this transaction. If this transaction is linked to another transaction, you must enter the same transaction code as the one to which it is linked. This column is optional.
Validation: Must be a valid transaction code as defined in your value set for this flexfield.
Destination: RA_CUSTOMER_TRX_LINES.USSGL_TRANSACTION_CODE

122- USSGL_ TRANSACTION_ CODE_CONTEXT : This column is not currently used by AutoInvoice.
Validation: None
Destination: None

123- VAT_TAX_ID : This column is used by AutoInvoice and should be left null. If you enter a value in TAX_CODE, AutoInvoice defaults a value in this column.
For credit memos AutoInvoice defaults to the VAT tax id of the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX_LINES.VAT_TAX_ID

124- WAYBILL_NUMBER : Enter the waybill number for this transaction.
If LINE_TYPE = 'LINE', 'CHARGES', or you are passing header freight, this column is optional.
If LINE_TYPE = 'TAX' or you are passing freight for a specific line do not enter a value in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the waybill number from the transaction you are crediting.
Validation: None
Destination: RA_CUSTOMER_TRX.WAYBILL_NUMBER



RA_INTERFACE_SALESCREDITS

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 and Defining Receivables System Options.
If you are importing invoices, debit memos and on account credits and your system option requires 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.
1- ATTRIBUTE1-15 : Enter the Descriptive Flexfield attribute information for this sales or revenue credit assignment. Descriptive Flexfield attributes allow you to store additional columns, the contents of which you define. These columns are optional.
Validation: None
Destination: RA_CUST_TRX_LINES_SALESREPS. ATTRIBUTE1-15
2- ATTRIBUTE_ CATEGORY : Enter the Descriptive Flexfield category information for this sales credit assignment. Descriptive Flexfield categories allow you to store different categories of attributes. This column is optional.
Validation: None
Destination: RA_CUST_TRX_LINE_SALESREPS.ATTRIBUTE_CATEGORY
3- 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. INTERFACE_LINE_ATTRIBUTE1-15. You must enter a value.
Validation: None
Destination: None
4- 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.INTERFACE_LINE_ ATTRIBUTE1-15.
Validation: None
Destination: RA_CUST_TRX_LINE_SALESREPS.CUSTOMER_TRX_LINE_ID

5- This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value into this column using the sequence RA_CUST_TRX_LINE_SALESREPS_S.
Validation: None
Destination: RA_CUST_TRX_LINE_SALESREPS.CUST_TRX_ LINE_SALESREP_ID

6- INTERFACE_STATUS : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: None

7- 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 table for processing.
Validation: None
Destination: None
8- REQUEST_ID : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: None
9- SALES_CREDIT_ AMOUNT_SPLIT : Enter the sales credit amount for this salesperson. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALES_CREDIT_PERCENT_SPLIT. If you specify the sales credit percent in your batch source, AutoInvoice defaults a value in this column.
Validation: If the sales credit for this sales credit assignment is of type Quota, the sum of sales credit amounts for a transaction must equal the amount of the transaction.
Destination: RA_CUST_TRX_LINE_SALESREPS. REVENUE_AMOUNT_SPLIT if the sales credit type is Quota. RA_CUST_TRX_LINE_SALESREPS. NON_REVENUE_AMOUNT_SPLIT if the sales credit type is not Quota.
10- SALES_CREDIT_ PERCENT_SPLIT : Enter the sales credit percent for this salesperson. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALES_CREDIT_AMOUNT_SPLIT. If you specify the sales or revenue credit amount in your batch source, AutoInvoice defaults a value in this column.
Validation: Your sales or revenue credit percent must be between 0 and 100, and if sales credit type is Quota, the sales credit percentage for a transaction must sum to 100.
11- SALES_CREDIT_ TYPE_ID : Enter the id of the sales credit type for this sales credit assignment. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALES_CREDIT_TYPE_NAME. If you specify the sales credit type name in your batch source, AutoInvoice defaults a value in this column.
Validation: Must exist in SO_SALES_CREDIT_TYPES.SALES_CREDIT_ TYPE_ID
Destination: None
12- SALES_CREDIT_ TYPE_NAME : Enter the name of the sales credit type for this sales credit assignment. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALES_CREDIT_TYPE_ID.
Validation: Must exist in SO_SALES_CREDIT_TYPES.NAME
Destination: None
13- SALESREP_ID : Enter the salesperson id for this sales credit assignment. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALESREP_NUMBER. If you specify the salesperson number in your batch source, AutoInvoice defaults a value in this column.
Validation: Must exist in RA_SALESREPS.SALESREP_ID
Destination: RA_CUST_TRX_LINE_SALESREPS.SALESREP_ID
14- SALESREP_NUMBER : Enter the salesperson number for this sales credit assignment. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or in SALESREP_ID.
Validation: Must exist in RA_SALESREPS.SALESREP_NUMBER
Destination: None
RA_INTERFACE_DISTRIBUTIONS

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 is 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.

1- 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.
Validation: Must be either 'REV', 'FREIGHT', 'TAX', 'REC', 'CHARGES', 'UNBILL', or 'UNEARN'. If the transaction uses the 'Advance Invoice' invoicing rule, do no 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. ACCOUNT_CLASS
2- 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.
Validation: None
Destination: None
3- 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.PERCENT.
If this line has AMOUNT_INCLUDES_TAX set to Yes, the sales credits and line amounts for this column must include tax.
Validation: If this transaction does not use an accounting rule, the sum of all distribution amounts for this transaction of a given line type must equal the amount for the transaction. AutoInvoice corrects amounts that have incorrect currency precision.
Destination: RA_CUST_TRX_LINE_GL_DIST.AMOUNT
4- ATTRIBUTE1-15 : Enter the Descriptive Flexfield attribute information for this accounting distribution. Descriptive Flexfield attributes allow you to store additional columns, the contents of which you define. These columns are optional.
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST.ATTRIBUTE1-15
5- ATTRIBUTE_ CATEGORY : Enter the Descriptive Flexfield category information for this accounting distribution. Descriptive Flexfield categories allow you to store different categories of attributes. This column is optional.
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST. ATTRIBUTE_CATEGORY
6- CODE_ COMBINATION_ID : Enter the code combination id of the Accounting Flexfield for this accounting distribution. This column is optional. Depending on the value you entered for your batch source you must enter either a value in this column or a combination of segment values in SEGMENT1-30. If you specify the combination of segment values in your batch source, AutoInvoice defaults a value in this column.
Validation: Must exist in GL_CODE_COMBINATIONS. CODE_COMBINATION_ID
Destination: RA_CUST_TRX_LINE_GL_DIST. CODE_COMBINATION_ID
7- COMMENTS : Enter comments about this accounting distribution. This column is optional.
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST.COMMENTS
8- 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.
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST. CUST_TRX_LINE_GL_DIST_ID
9- INTERFACE_LINE_ ATTRIBUTE1-15 : Enter the same Line Transaction Flexfield for the transaction with which you want to associate this accounting distribution. You must enter a value for each attribute you enabled for the Line Transaction Flexfield.
Validation: None
Destination: None
10- INTERFACE_LINE_ CONTEXT : This is a required column in AutoInvoice. Enter the context of the Line Transaction Flexfield entered in columns INTERFACE_LINE_ATTRIBUTE1-15.
Validation: If you pass lines with global context set this column to 'Global Data Elements'
Destination: RA_CUSTOMER_TRX_LINES>INTERFACE_LINE_CONTEXT
11- INTERFACE_LINE_ID : This column is used by AutoInvoice and should be left null. AutoInvoice defaults a value into this column using INTERFACE_LINE_ATTRIBUTE1-15 and INTERFACE_LINE_CONTEXT.
Validation: None
Destination: RA_CUST_TRX_LINE_GL_DIST. CUSTOMER_TRX_LINE_ID
12- INTERFACE_STATUS : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: None
13- 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 table for processing.
Validation: None
Destination: None
14- PERCENT : Enter the percent for this accounting distribution. If this accounting distribution is for a transaction that does not use an accounting rule and depending on the value you entered for your batch source, you must enter either a value in this column or in AMOUNT. If you specify the amount in your batch source, AutoInvoice defaults a value in this column. If this accounting distribution is for a transaction which uses an accounting rule, you must enter a value in this column.
Validation: The sum of all accounting distribution percentages for a transaction must sum to 100 for an account class.
Destination: RA_CUST_TRX_LINE_GL_DIST.PERCENT
15- REQUEST_ID : This column is used by AutoInvoice and should be left null.
Validation: None
Destination: None
16- 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, 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.
Validation: Valid combination of Accounting Flexfield segment values must exist in GL_CODE_COMBINATIONS.
Destination: None
RA_INTERFACE_ERRORS

This table stores information about interface data that failed validation. The information in this table will be used to generate the AutoInvoice Validation report. AutoInvoice identifies all errors for each transaction line, thus reducing multiple validation and correction cycles. For more information, see: AutoInvoice Reports.

1- INTERFACE_ LINE_ID : If both INTERFACE_SALESCREDIT_ID and INTERFACE_DISTRIBUTION_ID are null, then the row in RA_INTERFACE_LINES associated with this INTERFACE_LINE_ID failed validation.
Validation: None
Destination: None
2- INTERFACE_ SALESCREDIT_ID : If this column is not null, then the row in RA_INTERFACE_SALESCREDITS associated with this INTERFACE_SALESCREDIT_ID failed validation.
Validation: None
Destination: None
3- INTERFACE_ DISTRIBUTION_ID : If this column is not null, then the row in RA_INTERFACE_DISTRIBUTIONS associated with this INTERFACE_DISTRIBUTION_ID failed validation.
Validation: None
Destination: None
4- INVALID_VALUE : The invalid value that failed validation displays in this column, if applicable.
Validation: None
Destination: None
5- LINK_TO_LINE_ID : This column displays the INTERFACE_LINE_ID of the line to which this line that failed validation is linked. For example, you have a tax line that fails and is linked to an invoice line that fails. In this case, the column stores the INTERFACE_LINE_ID of the invoice line.
Validation: None
Destination: None
6- MESSAGE_TEXT : The message text is stored in this column.
Validation: None
Destination: None
Best Blogger TemplatesBest Blogger Tips
Best Blogger Gadgets
Posted by Raju Chinthapatla at 3:38:00 PM
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect