FIF Ap Detail Publish

Contains the unique identifier for the record.

This column contains the application from which the record originated.

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.

The number of the invoice line. This column holds the sequence number from the IM_AP_STAGE_DETAIL table.

Type of invoice line. Valid values are ITEM, FREIGHT, TAX, and MISCELLANEOUS.

The amount of the invoice line to import. Enter amount without thousands separator and use '.' as the decimal separator.

Quantity that was invoiced. Oracle Retail target column INVOICE_QUANTITY on FIF_AP_DETAIL_PUBLISH.

The price charged per unit of a good or service.

Unit of measure for quantity invoiced.

Line Description. This can contain the tran code.

Purchase order number used for PO matching.

Purchase order line number used for PO matching.

Purchase order schedule number used for PO matching.

Purchase order distribution line number used for PO matching.

Description of line items. Oracle Retail target column ITEM_DESCRIPTION on FIF_AP_DETAIL_PUBLISH.

Blanket purchase order release number used for PO matching.

A key flexfield that is used to group similar spend items for reporting.

Receipt Number used for receipt matching.

The line on the receipt to which an invoice will be matched.

Consumption advice number used for consumption advice matching.

The line on the consumption advice to which an invoice is matched.

Packing slip identifier. Oracle Retail target column PACKING_SLIP on FIF_AP_DETAIL_PUBLISH.

Indicates if an invoice is the last one being matched to a PO, so that the PO will no longer be available for matching to other invoices.

Account combination used for creating invoice distribution.

Used to create invoice distributions automatically when an invoice is not matched to a purchase order or when you do not want to enter invoice distribution information manually.

Date on which the invoice line will be accounted.

The overlay primary balancing segment overwrites the defaulted balancing segment for an invoice line.

The overlay primary balancing segment overwrites the defaulted balancing segment for an invoice line.

The overlay cost center segment overwrites the defaulted cost center segment for an invoice line.

Represents a tax rate code or a group of tax rate codes.

A location that is designated as the place where goods are received from a supplier.

A location that is designated as the place from where the goods are shipped by the supplier.

A location that is designated as the final destination location for the purchases made by the customer.

Transactions category assigned by user. Used to identify and classify business transactions for the purpose of tax calculation.

A unique identifier for a product fiscal classification. A classification used by a tax authority to categorize a product for a tax.

A tax classification that represents the purpose for which a product is used.

A classification for any tax requirement that you cannot define using the existing fiscal classification types.

Type of product. Valid values are GOODS, SERVICES, and null. If left null, the value will be taken from PO.

User-enterable amount to be used as taxable basis. Enter amount without thousands separator and use '.' as the decimal separator.

The classification code defined for a noninventory based item.

Optional, user-enterable amount with which the calculated tax should match. Enter amount without thousands separator and use '.' as the decimal separator.

A unique code for a tax regime. A tax regime is the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.

The name of the classification of a charge imposed by a government through a fiscal or tax authority.

A unique code for a tax status. A tax status is the taxable nature of a product in the context of a transaction for a tax.

A unique code for a tax jurisdiction. A tax jurisdiction is a geographic area where a tax is levied by a specific tax authority.

A unique code for a tax rate for the external financial system. A tax rate is the rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity.

The rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity.

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

The 1099 type of the payments made to a supplier.

Tax regions such as states and territories of the United States.

Indicates that the freight or miscellaneous line is prorated across all item lines on an invoice.

A number assigned to the invoice lines for the purpose of prorating charges to a group of lines with the identical line group number value.

Cost component class name. Cost component classes are used to identify the individual buckets or component costs that make up the total cost of an item

Statistical quantity based on the unit of measure.

Indicates that the invoice line should be transferred to Oracle Fusion Assets.

Asset book which defaults to the distributions for lines for transfer to Oracle Fusion Assets.

Defaults to the distributions for candidate lines for transfer to Oracle Fusion Assets.

Unique sequence of numbers and letters used to identify individual items.

Indicates the name of a manufacturer of an asset or item.

The model number of the invoice line item.

A number assigned to the written warranty given to the buyer to repair or replace defective parts free of charge for a stated period of time.

Indicator used for price correction when a supplier sends an invoice for a change in unit price for an invoice that has been matched to a purchase order.

Invoice number of the invoice that the price correction invoice is correcting.

Invoice line subject to the price correction.

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.

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.

The ID assigned to the project to which an invoice expense is charged.

The ID assigned to a step in a project.

A classification of cost that you assign to an expenditure item on a project.

The date when work is performed and charged to a project and task.

An organization that owns project events, incurs expenditures, and holds budgets for a project.

The number assigned to the project to which an invoice expense is charged.

The number assigned to a step in a project.

A classification of cost that you assign to an expenditure item on a project.

An organization that owns project events, incurs expenditures, and holds budgets for a project.

Id of the source funding the project.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_2 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_3 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_4 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_5 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_6 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_7 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_8 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_9 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_RESERVED_ATTRIBUTE_10 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_1 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_2 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_3 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_4 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_5 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_6 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_7 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_8 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_9 on FIF_AP_DETAIL_PUBLISH.

Oracle internal use only. Oracle Retail target column PJC_USER_DEFINED_ATTRIBUTE_10 on FIF_AP_DETAIL_PUBLISH.

Subclassification for invoice line type of Freight or Miscellaneous.

Date when multiperoid accounting starts.

Date when multiperoid accounting ends.

Accrual account that is initially debited for deferred expenses.

Name of the project to which the invoice expense is charged.

Name of the task used to build the transaction descriptive flexfield for project-related transaction distributions.

Classification of project-related work performed.

Contract name used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

Contract number used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

Name of the source funding the project.

Number of the source funding the project.

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

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