FIF Ap Head Publish

Contains the unique identifier for the record.

This column contains the application from which the record originated.

This column holds the sequence number from the IM_AP_STAGE_HEAD table and will not be extracted.

Unique identifier for this invoice. You assign the same value to the invoices lines in the AP_INVOICE_LINES_INTERFACE table to identify the data as belonging to the same invoice.

Sold to business unit name for the external financial system.

Indicates the feeder system from which an invoice is imported.

Unique number for supplier invoice.

Monetary value of the invoice.

The date that appears on a supplier invoice.

Unique Supplier Name. Either Supplier Name or Supplier Number is required.

Unique number for the external financial system to identify a supplier. Either Supplier Name or Supplier Number is required.

The physical location of the supplier. This entity models how the buying organization conducts business with the supplier.

Currency of the invoice. Enter three-letter ISO 4217 currency code. If you do not enter a value, then the supplier site currency code will default during invoice import.

Currency of the payment. Enter the three-letter ISO 4217 code. If you do not enter a value, then the supplier site payment currency will default during invoice import.

Invoice Description. Oracle Retail target column DESCRIPTION on FIF_AP_HEAD_PUBLISH.

Import set can be used to limit the import to invoices with a particular set. You can import data for the same source by specifying a unique import set for each request. This reduces the processing time of your import. Payables Open Interface Import imports data with the source and Import Set combination you specify.

The type of invoice being imported, such as standard invoice, credit memo or prepayment. Valid values are STANDARD, CREDIT and PREPAYMENT.

The name of the legal entity for the external financial system that belongs to your own corporate structure (enterprise). If left null, will be derived as per the rules below in the order of the priority.

A unique sequence of letters and numbers assigned to a party or party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.

A unique sequence of letters and numbers assigned to a party or party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.

A unique sequence of letters and numbers assigned to a first party by a tax authority when it is registered, and by which the first party registration is identified.

A unique sequence of letters and numbers assigned to a supplier or supplier site by a tax authority when it is registered, and by which the supplier or supplier site registration is identified.

Payment terms for the external financial system used to create installments and to calculate due dates, discount dates, and discount amounts for each invoice

Date used by the payment term on the invoice to calculate discount dates and due date.

The date when goods were received.

The date when Invoice were received.

Accounting date which is defaulted to invoice distributions.

Indicates the mode of payment of the invoice.

Represents a group or a category of suppliers or invoices into a single pay run, for example: employees, merchandise, nonmerchandise, government, domestic, and international.

Indicates whether an invoice should be paid with its own payment document, without including other invoices for the supplier. The valid values are Y, N and null. Generally, if left blank, value of this field will be defaulted from the setup.

Invoice amount applicable to discount. Enter amount without thousands separator and use '.' as the decimal separator.

Invoice number of the prepayment.

Line on a prepayment that can be applied to an invoice.

The amount of prepayment applied to the invoice. This amount must be positive. Enter amount without thousands separator and use '.' as the decimal separator.

The accounting date to be used for the prepayment application. If left null, the accounting date of the invoice is used.

This indicates if Prepayment is included in invoice amount. The valid values are Y, N and null. If left null it will be taken as N.

The source of a currency conversion rate, such as spot, corporate or other user defined rate types. This is required only for non-ledger currency invoices.

The date as of which a conversion rate is used to convert invoice amount into functional currency.

Conversion rate for foreign currency invoices. This needs to be provided only if the conversion rate type is User.

Account to which liability is recorded in acrrual basis of accounting.

Value used to classify documents for document sequencing purposes.

A unique internal identifier assigned to a document. Required only if the document category code has an assignment type of Manual.

The first name of the person who the requested items are intended for.

The last name of the person who the requested items are intended for.

The employee number of the employee who the requested items are intended for.

Text that is included on an electronic payment that tells the bank how to execute the payment.

Bearer of bank charge cost. Oracle Retail target column BANK_CHARGE_BEARER on FIF_AP_HEAD_PUBLISH.

The supplier that receives payment on behalf of the supplier on the invoice.

Unique number to identify a supplier.

The address belonging to the supplier or party who receives payment.

Number representing payment priority of a scheduled payment. The valid value is any number between 1 and 99.

Instruction to a bank that indicates the priority for executing a payment. Valid values are EXPRESS, NORMAL.

A single digit used to validate the unique remittance identifier.

A single digit used to validate the unique remittance identifier

Codes provided by a country's government or central bank.

Comments indicating the reason for creating the payment.

The remittance message that is passed on to the supplier at the time of payment.

The remittance message that is passed on to the supplier at the time of payment.

The remittance message that is passed on to the supplier at the time of payment.

Group used to apply multiple withholding taxes to an invoice line.

Location where a supplier sends shipments for goods or services

This country sets the context for other tax drivers. The value defaults to the legal entity country but can be overridden by the user.

In certain countries, a tax or governmental authority defines and classifies document types for reporting purposes.

Use this column to record internal sequence number for supplier-issued tax invoices.

Use this column to record the invoice number for supplier issued.

This field is used to record the date the company receives or records the supplier issued tax invoice and is required to comply with reporting requirements.

Conversion date entered for taxes on a supplier invoice.

Conversion rate entered for taxes on a supplier invoice.

Code that identifies the location or port through which the invoiced goods entered the country.

Correction Year for the invoice being corrected will be entered as a 4-digit character field where only numbers are allowed.

Correction Period for the invoice being corrected

Use this column to record the import document number

Use this column to record the import document date

Amount with which the calculated sales tax should match.

Indicates whether tax should be calculated or not for the imported invoice.

Indicates if the tax monetary amount should be added to the total invoice monetary amount when importing.

User-defined descriptive flexfield context sensitive segments configured to capture additional information on the invoice.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Structure definition of the global descriptive flexfield.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

Segment of the descriptive flexfield used to hold user-defined information for the current table.

This column holds the system date and time stamp of the creation of the posting header record.

Attachment external URL. Oracle Retail target column ATTACHMENT_EXT_URL on FIF_AP_HEAD_PUBLISH.

This column holds the user who created the record.

This column holds the record creation date.

This column holds the user who last updated the record.

This column holds the date time when the record was last updated.

This holds the external Organization Unit Reference id.

This will hold the unique run id to be used by the extract job when populating the fif_publish table. This will allow multiple publish within a day to identify the record for a particular run to support republish for a particular extract run. Value will be one up number for every day starting at 1.