AP_INVOICE_LINES_ALL
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. An invoice can have one or more invoice lines. An invoice line can have one or more invoice distributions. An invoice line represents goods (direct or indirect materials), service(s), and/or associated tax/freight/miscellaneous charges invoiced from a supplier. An invoice line should contain all the attributes that are present on the physical or electronic invoice presented by the supplier. These attributes should suffice in specifying the charge/expense/asset information that makes up the invoice line. An invoice line can be of any of the following types: Item, Freight, Miscellaneous, Tax, Prepayment or Withholding Tax. Prepayment Lines are generated via prepayment application. Item type lines may represent a match to a purchase order or receipt, a price correction against an existing purchase order or receipt matched invoice line, a quantity correction against an existing purchase order or receipt matched invoice line, an invoice correction against an existing non-matched invoice line or a non-matched invoice line. Freight and Miscellaneous lines may represent a match to a Receipt or may be non-matched. Freight and Miscellaneous type lines may be allocated to Item type lines whenever they are not themselves matched to a receipt. Rules for allocation may be entered in the Allocations module. Allocations are stamped on the distributions for such a Freight or Miscellaneous type line. Lines may be generated automatically via any of the following methods: . Match to purchase order or receipt requested from the invoice header . Generation of freight automatically from the invoice header . Generation of Item line from Distribution Set requested from the invoice header . Generation of Freight/Miscellaneous from purchase order or receipt matching windows . Prepayment application Lines will also be created during import of Open Interface invoices. It is the distributions for a line, and not the line itself, that will carry the status relative to Validation, Encumbrance, and Accounting. Furthermore, it is the Distributions for a line that get transferred to Oracle Assets and/or processed by Oracle Projects. However, lines will contain an Approval status. A line may be discarded on its own or as part of cancellation of the invoice. A discarded line will have an amount of 0 and will be marked as discarded. During discarding of a line, appropriate distributions are generated to reverse the effect of any existing distributions for the line
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AP_INVOICE_LINES_ALL_PK |
INVOICE_ID, LINE_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
---|---|---|---|---|---|---|---|
INVOICE_ID | NUMBER | 18 | Yes | Invoice line number associated with the event. | Active | ||
LINE_NUMBER | NUMBER | 18 | Yes | Number of the invoice line. | Active | ||
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes. | Active | ||
REQUESTER_ID | NUMBER | 18 | The name of the person who the requested items are intended for. | Active | |||
DESCRIPTION | VARCHAR2 | 240 | Description of the invoice line. | Active | |||
LINE_SOURCE | VARCHAR2 | 30 | Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE | Active | |||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | ||
LINE_GROUP_NUMBER | NUMBER | Group number assigned to the line during the Open Interface Import process to be used for generation of allocation rules | Active | ||||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID | Active | ||||
ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item in the invoice line. | Active | |||
SERIAL_NUMBER | VARCHAR2 | 35 | Number indicating place in a series, used for identification. | Active | |||
MANUFACTURER | VARCHAR2 | 30 | Manufacturer of an asset or item. | Active | |||
MODEL_NUMBER | VARCHAR2 | 40 | Model number of the invoice line item. | Active | |||
WARRANTY_NUMBER | VARCHAR2 | 15 | Warranty number of the item that is available for item lines. | Active | |||
GENERATE_DISTS | VARCHAR2 | 1 | Flag indicating whether distributions for the invoice line should be generated dynamically whenever possible | Active | |||
MATCH_TYPE | VARCHAR2 | 25 | Indicates the type of match if any. Validated against AP_LOOKUP_CODES with lookup type as INVOICE LINE MATCH TYPE | Active | |||
DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier to be used in the generation of distributions for a line | Active | |||
ACCOUNT_SEGMENT | VARCHAR2 | 25 | Account segment value for overlay in generation of accounting flexfield during distribution generation | Active | |||
BALANCING_SEGMENT | VARCHAR2 | 25 | Balancing segment value for overlay in generation of accounting flexfield during distribution generation | Active | |||
COST_CENTER_SEGMENT | VARCHAR2 | 25 | Cost Center segment value for overlay in generation of accounting flexfield during distribution generation | Active | |||
OVERLAY_DIST_CODE_CONCAT | VARCHAR2 | 250 | Concatenated segments for overlay in generation of accounting flexfield during distribution generation | Active | |||
DEFAULT_DIST_CCID | NUMBER | 18 | Account to be used for automatic generation of a single distribution | Active | |||
PRORATE_ACROSS_ALL_ITEMS | VARCHAR2 | 1 | A value of Y indicates that the Freight or Miscellaneous type line should be prorated across all Item type lines | Active | |||
ACCOUNTING_DATE | DATE | Yes | Accounting date for invoice line. Used for defaulting to distributions | Active | |||
PERIOD_NAME | VARCHAR2 | 15 | Accounting date for invoice line. Used for defaulting to distributions | Active | |||
DEFERRED_ACCTG_FLAG | VARCHAR2 | 1 | Accounting date for invoice line. Used for defaulting to distributions | Active | |||
DEF_ACCTG_START_DATE | DATE | The start date of the deferred expense period | Active | ||||
DEF_ACCTG_END_DATE | DATE | The end date of the deferred expense period | Active | ||||
DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE | Active | ||||
DEF_ACCTG_PERIOD_TYPE | VARCHAR2 | 30 | Period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses. Validated against XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE | Active | |||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Ledger identifier of the invoice line. | Active | ||
AMOUNT | NUMBER | Yes | Line amount in invoice currency | Active | |||
BASE_AMOUNT | NUMBER | Line amount in functional currency | Active | ||||
ROUNDING_AMT | NUMBER | Amount corresponding to rounding amount included in BASE_AMOUNT if any | Active | ||||
QUANTITY_INVOICED | NUMBER | Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines | Active | ||||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | 25 | Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE | Active | |||
UNIT_PRICE | NUMBER | Price charged per unit of a good or service. | Active | ||||
WFAPPROVAL_STATUS | VARCHAR2 | 30 | Yes | Indicates if an invoice line has been approved. | Active | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | USSGL Transaction Code for creating U.S. Standard General Ledger journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE | Active | |||
DISCARDED_FLAG | VARCHAR2 | 1 | A value of Y indicates that the line has been discarded. When a line is discarded all its distributions are reversed and the AMOUNT is set to 0 | Active | |||
ORIGINAL_AMOUNT | NUMBER | Amount of the line before discarding of the line or cancellation of the invoice | Active | ||||
ORIGINAL_BASE_AMOUNT | NUMBER | Base amount of the line before discarding of the line or cancellation of the invoice | Active | ||||
ORIGINAL_ROUNDING_AMT | NUMBER | Rounding amount of the line before discarding of the line or cancellation of the invoice | Active | ||||
CANCELLED_FLAG | VARCHAR2 | 1 | Indicates if invoice line is canceled. | Active | |||
INCOME_TAX_REGION | VARCHAR2 | 10 | Reporting region for invoice line for 1099 supplier. Defaults down to distributions | Active | |||
TYPE_1099 | VARCHAR2 | 10 | Indicates the category of the withholding tax rates. | Active | |||
STAT_AMOUNT | NUMBER | Amount associated with a distribution for measuring statistical quantities. Used only for transferring the information during Open Interface Import process | Active | ||||
PREPAY_INVOICE_ID | NUMBER | 18 | Invoice identifier for Prepayment invoice applied via current invoice line | Active | |||
PREPAY_LINE_NUMBER | NUMBER | Line number for Prepayment line applied via current invoice line | Active | ||||
INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | 1 | Y indicates that prepayment is included in the invoice amount | Active | |||
CORRECTED_INV_ID | NUMBER | 18 | Invoice identifier for invoice corrected via current line. For price, quantity, or invoice line corrections | Active | |||
CORRECTED_LINE_NUMBER | NUMBER | Invoice line number for invoice line corrected via current line. For price, quantity, or invoice line corrections | Active | ||||
PO_HEADER_ID | NUMBER | A commercial document that is used to request a seller to supply a product or service in return for payment. | Active | ||||
PO_LINE_ID | NUMBER | A line identifier for the line record on a transaction. The Purchase Order Line describes an item or service, with a price and quantity ordered. | Active | ||||
PO_RELEASE_ID | NUMBER | Number of the purchase order release associated with the invoice correction | Active | ||||
PO_LINE_LOCATION_ID | NUMBER | Ship-to location for the purchase order schedule. | Active | ||||
PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution line which indicates the accounting transactions for the goods or services. | Active | ||||
RCV_TRANSACTION_ID | NUMBER | Line on the shipment receipt. | Active | ||||
FINAL_MATCH_FLAG | VARCHAR2 | 1 | Indicates if an invoice is the last one being matched to a PO, so that the PO is no longer available for matching. | Active | |||
ASSETS_TRACKING_FLAG | VARCHAR2 | 1 | Y indicates that the item should be treated as an asset | Active | |||
ASSET_BOOK_TYPE_CODE | VARCHAR2 | 30 | Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets | Active | |||
ASSET_CATEGORY_ID | NUMBER | 18 | Asset Category. Defaults to the distributions candidate for transfer to Oracle Assets | Active | |||
PROJECT_ID | NUMBER | 18 | Project identifier for project related invoice lines | Active | |||
TASK_ID | NUMBER | 18 | Task identifier for project related invoice lines | Active | |||
EXPENDITURE_TYPE | VARCHAR2 | 30 | Expenditure type for project related invoice lines | Active | |||
EXPENDITURE_ITEM_DATE | DATE | Expenditure item date for project related Invoice Lines | Active | ||||
EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Expenditure organization identifier for project related invoice lines | Active | |||
PA_QUANTITY | NUMBER | Project item quantity for project related invoice lines | Active | ||||
PA_CC_AR_INVOICE_ID | NUMBER | 18 | For an intercompany invoice from Oracle Projects, this is the identifier of the corresponding receivable intercompany invoice in Oracle Receivables | Active | |||
PA_CC_AR_INVOICE_LINE_NUM | NUMBER | 18 | For an intercompany invoice from Oracle Projects, this is the line number of the corresponding receivable intercompany invoice in Oracle Receivables | Active | |||
PA_CC_PROCESSED_CODE | VARCHAR2 | 1 | The processing status of this invoice line by Oracle Projects in the receiver operating unit | Active | |||
AWARD_ID | NUMBER | 18 | Reserved for use by Oracle Grants Management. Defaults to distributions | Active | |||
AWT_GROUP_ID | NUMBER | 18 | Withholding tax group identifier | Active | |||
REFERENCE_1 | VARCHAR2 | 30 | A reference to a record in another application | Active | |||
REFERENCE_2 | VARCHAR2 | 30 | A reference to a record in another application | Active | |||
RECEIPT_VERIFIED_FLAG | VARCHAR2 | 1 | Indicates whether receipts verified | Active | |||
RECEIPT_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether receipts required | Active | |||
RECEIPT_MISSING_FLAG | VARCHAR2 | 1 | Indicates whether receipts missing | Active | |||
JUSTIFICATION | VARCHAR2 | 240 | Reason, fact, circumstance, or explanation that justifies or defends. | Active | |||
EXPENSE_GROUP | VARCHAR2 | 80 | Expense group associated with the invoice line. | Active | |||
START_EXPENSE_DATE | DATE | Date when incurred expense started. Used for expense reports | Active | ||||
END_EXPENSE_DATE | DATE | Date when incurred expense ended. Used for expense reports | Active | ||||
RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of receipt. Used for expense reports | Active | |||
RECEIPT_CONVERSION_RATE | NUMBER | Exchange rate for currency of receipt. Used for expense reports | Active | ||||
RECEIPT_CURRENCY_AMOUNT | NUMBER | Amount in receipt currency. Used for expense reports | Active | ||||
DAILY_AMOUNT | NUMBER | Daily expense amount. Used for expense reports | Active | ||||
WEB_PARAMETER_ID | NUMBER | Self-Service Web Applications parameter identifier | Active | ||||
ADJUSTMENT_REASON | VARCHAR2 | 240 | Reason for adjustment on the invoice line. | Active | |||
MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | 80 | Third party document number. Used for expense reports | Active | |||
MERCHANT_NAME | VARCHAR2 | 80 | Third party name. Used for expense reports | Active | |||
MERCHANT_REFERENCE | VARCHAR2 | 240 | Third party reference. Used for expense reports | Active | |||
MERCHANT_TAX_REG_NUMBER | VARCHAR2 | 80 | Third party tax registration number. Used for expense reports | Active | |||
MERCHANT_TAXPAYER_ID | VARCHAR2 | 80 | Third party tax identification number. Used for expense reports | Active | |||
COUNTRY_OF_SUPPLY | VARCHAR2 | 5 | Country where services or goods were originated. Used for expense reports | Active | |||
CREDIT_CARD_TRX_ID | NUMBER | 18 | Credit card transaction identifier | Active | |||
COMPANY_PREPAID_INVOICE_ID | NUMBER | 18 | Invoice ID when this line is a prepaid credit card transaction | Active | |||
CC_REVERSAL_FLAG | VARCHAR2 | 1 | Invoice ID when this line is a prepaid credit card transaction | Active | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
PROGRAM_APPLICATION_ID | NUMBER | 18 | Who column: indicates the application identifier of the row. | Active | |||
PROGRAM_ID | NUMBER | 18 | Who column: indicates the identifier of the row. | Active | |||
PROGRAM_UPDATE_DATE | DATE | Who column: indicates the date and time of the creation of the row. | Active | ||||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (AP_INVOICE_LINES) | Active | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
LINE_SELECTED_FOR_APPL_FLAG | VARCHAR2 | 1 | A value of Y indicates that this line on the prepayment invoice is selected for prepayment application | Active | |||
PREPAY_APPL_REQUEST_ID | NUMBER | 18 | Request identifier of the Payables Open Interface Import program that selected this line on the prepayment invoice for prepayment application | Active | |||
APPLICATION_ID | NUMBER | 18 | Unique identifier that identifies the application from where the invoice originated. | Active | |||
PRODUCT_TABLE | VARCHAR2 | 30 | Name of the product source table used for generating an invoice line. | Active | |||
REFERENCE_KEY1 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY2 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY3 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY4 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY5 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
PURCHASING_CATEGORY_ID | NUMBER | 18 | Item category unique identifier | Active | |||
COST_FACTOR_ID | NUMBER | 18 | Identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on. | Active | |||
CONTROL_AMOUNT | NUMBER | Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document. | Active | ||||
ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis. | Active | ||||
TOTAL_REC_TAX_AMOUNT | NUMBER | Total recoverable tax allocated to this taxable line. | Active | ||||
TOTAL_NREC_TAX_AMOUNT | NUMBER | Total non-recoverable tax allocated to this taxable line. | Active | ||||
TOTAL_REC_TAX_AMT_FUNCL_CURR | NUMBER | Total recoverable tax amount in functional currency. | Active | ||||
TOTAL_NREC_TAX_AMT_FUNCL_CURR | NUMBER | Total non recoverable tax amount in functional currency. | Active | ||||
INCLUDED_TAX_AMOUNT | NUMBER | Included tax amount for taxable line of type inclusive. | Active | ||||
PRIMARY_INTENDED_USE | VARCHAR2 | 30 | Tax Driver: The purpose for which a product may be used. The actual use will be stored at the distribution level. | Active | |||
INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Tax Driver: Intended use identifier | ||||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | 1 | Internal processing flag for Payables, indicating whether tax has already been calculated. | Active | |||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched. | Active | |||
PRODUCT_TYPE | VARCHAR2 | 240 | Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user. | Active | |||
PRODUCT_CATEGORY | VARCHAR2 | 240 | Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. | Active | |||
PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Tax Driver: Product fiscal classification | Active | |||
PROD_FC_CATEG_ID | NUMBER | 18 | Tax Driver: Product fiscal classification identifier | ||||
USER_DEFINED_FISC_CLASS | VARCHAR2 | 240 | Tax Driver: Fiscal Classification. | Active | |||
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Tax Driver: Transactions category assigned by user. | Active | |||
SUMMARY_TAX_LINE_ID | NUMBER | Cross reference to E-Business Tax repository. | Active | ||||
TAX_REGIME_CODE | VARCHAR2 | 30 | Tax Regime Code: The set of tax rules that determines the treatment of one or more taxes administered by a tax authority. e.g., VAT Regime in Argentina. | Active | |||
TAX | VARCHAR2 | 30 | A classification of a charge imposed by a government through a fiscal or tax authority. | Active | |||
TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Internal ID of the Tax Jurisdiction. | Active | |||
TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code. e.g., taxable standard rate, zero rated, exempt, non-taxable. | Active | |||
TAX_RATE_ID | NUMBER | 18 | Internal identifier for tax rate effective on the invoice date. | Active | |||
TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate name associated with tax rate identifier. Tax_rate_id is unique while a tax_rate_code may have different tax rates based on date ranges. | Active | |||
TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time. | Active | ||||
TAX_CODE_ID | NUMBER | 18 | Identifier for existing tax code in Payables. Necessary for upgrade and reporting purposes. | Active | |||
HISTORICAL_FLAG | VARCHAR2 | 1 | Flag to represents whether the document / invoice has been upgraded from a prior release or whether it has been newly created. | Active | |||
TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Tax classification code used by Procure To Pay products. | Active | |||
SOURCE_APPLICATION_ID | NUMBER | Source document application identifier. | Active | ||||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Source document event class code. | Active | |||
SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Entity code of the source document. | Active | |||
SOURCE_TRX_ID | NUMBER | Source document transaction identifier. | Active | ||||
SOURCE_LINE_ID | NUMBER | Source document transaction line identifier. | Active | ||||
SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | |||
RETAINED_AMOUNT | NUMBER | Retained amount | Active | ||||
RETAINED_AMOUNT_REMAINING | NUMBER | Retained amount available for release | Active | ||||
RETAINED_INVOICE_ID | NUMBER | 18 | Retained invoice identifier. | Active | |||
RETAINED_LINE_NUMBER | NUMBER | Retained invoice line number | Active | ||||
LINE_SELECTED_FOR_RELEASE_FLAG | VARCHAR2 | 1 | Flag to indicate invoice is currently being processed for release. | Active | |||
LINE_OWNER_ROLE | VARCHAR2 | 320 | This column contains the owner of invoice line derived by AME rule. | Active | |||
DISPUTABLE_FLAG | VARCHAR2 | 1 | Indicates whether the line is disputable | Active | |||
RCV_SHIPMENT_LINE_ID | NUMBER | 18 | Receipt Shipment line unique identifier.Used for Receipt matching. | Active | |||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project related standardized code collection | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project related transaction is incurred | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project related item is available to be billed to customers | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project related item is eligible for capitalization | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project related classification of the worked performed | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_CONTRACT_ID | NUMBER | 18 | Contract Identified.Used when Oracle Contract Billing or Oracle Grants Accounting is installed | Active | |||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. Used when Oracle Contract Billing or Oracle Grants Accounting is installed | Active | |||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override | Active | |||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||||
BUDGET_DATE | DATE | Budgetary Calendar Period Date applicable for funds check | |||||
FUNDS_STATUS | VARCHAR2 | 30 | Funds status for an invoice line. | ||||
LCM_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether invoice line is enabled for landed cost management. | ||||
CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Consumption advice header identifier. Used for consumption advice matching. | ||||
CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Consumption advice line identifier. Used for consumption advice matching. | ||||
SHIP_FROM_LOCATION_ID | NUMBER | 18 | Ship-from location identifier. | ||||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Final discharge location identifier. | ||||
FOS_XFACE_FLAG | VARCHAR2 | 1 | Indicates whether the invoice line information has been interfaced to Supply Chain Financial Flow Orchestration. | ||||
MATCHING_RULE_SET_ID | NUMBER | 18 | Matching rule set identifier of the associated matching rule that was used to update matching information for the invoice line. | ||||
MATCHING_RULE_ID | NUMBER | 18 | Matching rule identifier that was used to update matching information for the invoice line. | ||||
FISCAL_CHARGE_TYPE | VARCHAR2 | 30 | Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE. | ||||
SHIP_TO_CUST_LOCATION_ID | NUMBER | 18 | Location where the supplier should ship the goods. | ||||
DEF_ACCTG_ACCRUAL_CCID | NUMBER | 18 | Accrual account that is initially debited for deferred expenses | ||||
TRANSACTION_LINE_GEOGRAPHY_ID | NUMBER | 18 | Tax driver: Expenses location identifier used for tax calculation for payment requests. | ||||
ACC_REFERENCE_VALUE1 | VARCHAR2 | 4000 | Stores reference information from Oracle Subledger Accounting. This is a free text field. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
AP_INVOICE_LINES_ALL | ap_invoices_all | INVOICE_ID |
AP_INVOICE_LINES_ALL | ap_invoices_all | CORRECTED_INV_ID |
AP_INVOICE_LINES_ALL | ap_invoice_lines_all | CORRECTED_INV_ID, CORRECTED_LINE_NUMBER |
AP_INVOICE_LINES_ALL | po_headers_all | PO_HEADER_ID |
AP_INVOICE_LINES_ALL | po_line_locations_all | PO_LINE_ID |
AP_INVOICE_LINES_ALL | po_distributions_all | PO_DISTRIBUTION_ID |
AP_INVOICE_LINES_ALL | rcv_transactions | RCV_TRANSACTION_ID |
AP_INVOICE_LINES_ALL | fa_categories_b | ASSET_CATEGORY_ID |
AP_INVOICE_LINES_ALL | pjf_projects_all_b | PJC_PROJECT_ID |
AP_INVOICE_LINES_ALL | po_line_locations_all | PO_LINE_LOCATION_ID |
AP_INVOICE_LINES_ALL | ap_invoices_all | PA_CC_AR_INVOICE_ID |
AP_INVOICE_LINES_ALL | ap_invoice_lines_all | PA_CC_AR_INVOICE_ID, PA_CC_AR_INVOICE_LINE_NUM |
AP_INVOICE_LINES_ALL | ap_awt_groups | AWT_GROUP_ID |
AP_INVOICE_LINES_ALL | ap_awt_tax_rates_all | TAX_RATE_ID |
AP_INVOICE_LINES_ALL | ap_invoices_all | RETAINED_INVOICE_ID |
AP_INVOICE_LINES_ALL | egp_system_items_b | INVENTORY_ITEM_ID, ORG_ID |
AP_INVOICE_LINES_ALL | ap_invoice_lines_all | RETAINED_INVOICE_ID, RETAINED_LINE_NUMBER |
AP_INVOICE_LINES_ALL | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
AP_INVOICE_LINES_ALL | gl_ledgers | SET_OF_BOOKS_ID |
AP_INVOICE_LINES_ALL | rcv_shipment_lines | RCV_SHIPMENT_LINE_ID |
AP_INVOICE_LINES_ALL | gl_ussgl_transaction_codes | SET_OF_BOOKS_ID, USSGL_TRANSACTION_CODE |
AP_INVOICE_LINES_ALL | ap_invoices_all | PREPAY_INVOICE_ID |
AP_INVOICE_LINES_ALL | ap_invoice_lines_all | PREPAY_INVOICE_ID, PREPAY_LINE_NUMBER |
fa_adj_src_lines_t | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
fa_asset_invoices | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
ap_prepay_history_all | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
ap_prepay_history_all | ap_invoice_lines_all | PREPAY_INVOICE_ID, PREPAY_LINE_NUM |
ap_apinv_approvers | ap_invoice_lines_all | INVOICE_ID, LINE_NUMBER |
ap_invoice_lines_all | ap_invoice_lines_all | CORRECTED_INV_ID, CORRECTED_LINE_NUMBER |
ap_invoice_lines_all | ap_invoice_lines_all | PA_CC_AR_INVOICE_ID, PA_CC_AR_INVOICE_LINE_NUM |
ap_invoice_lines_all | ap_invoice_lines_all | RETAINED_INVOICE_ID, RETAINED_LINE_NUMBER |
ap_invoice_lines_all | ap_invoice_lines_all | PREPAY_INVOICE_ID, PREPAY_LINE_NUMBER |
ap_allocation_rules | ap_invoice_lines_all | INVOICE_ID, CHRG_INVOICE_LINE_NUMBER |
fa_mc_asset_invoices | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
fa_mass_additions | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
ap_invoice_distributions_all | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
AP_INVOICE_LINES_N1 | Non Unique | FUSION_TS_TX_IDX | ACCOUNTING_DATE | Active |
AP_INVOICE_LINES_N10 | Non Unique | FUSION_TS_TX_IDX | LINE_SELECTED_FOR_APPL_FLAG | Active |
AP_INVOICE_LINES_N11 | Non Unique | FUSION_TS_TX_DATA | INVOICE_ID | Obsolete |
AP_INVOICE_LINES_N12 | Non Unique | FUSION_TS_TX_DATA | LINE_TYPE_LOOKUP_CODE | |
AP_INVOICE_LINES_N13 | Non Unique | Default | SET_OF_BOOKS_ID, ORG_ID, ACCOUNTING_DATE, AMOUNT, DISCARDED_FLAG | |
AP_INVOICE_LINES_N14 | Non Unique | Default | INVOICE_ID, SUMMARY_TAX_LINE_ID | |
AP_INVOICE_LINES_N2 | Non Unique | FUSION_TS_TX_IDX | RCV_TRANSACTION_ID | Active |
AP_INVOICE_LINES_N3 | Non Unique | FUSION_TS_TX_IDX | PO_LINE_LOCATION_ID | Active |
AP_INVOICE_LINES_N4 | Non Unique | FUSION_TS_TX_IDX | PJC_PROJECT_ID, PJC_TASK_ID | Active |
AP_INVOICE_LINES_N5 | Non Unique | FUSION_TS_TX_IDX | AWARD_ID | Obsolete |
AP_INVOICE_LINES_N6 | Non Unique | FUSION_TS_TX_IDX | CORRECTED_INV_ID | Active |
AP_INVOICE_LINES_N7 | Non Unique | FUSION_TS_TX_IDX | PREPAY_INVOICE_ID | Obsolete |
AP_INVOICE_LINES_N8 | Non Unique | FUSION_TS_TX_IDX | PREPAY_INVOICE_ID, PREPAY_LINE_NUMBER | Active |
AP_INVOICE_LINES_N9 | Non Unique | FUSION_TS_TX_IDX | PO_HEADER_ID | Active |
AP_INVOICE_LINES_U1 | Unique | FUSION_TS_TX_IDX | INVOICE_ID, LINE_NUMBER | Active |