EBS开发_应收发票接口表字段说明

AutoInvoice 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 =