1. Tables and Views for Financials
  2. AP_INVOICE_LINES_ALL_

AP_INVOICE_LINES_ALL_

AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

AP_INVOICE_LINES_ALL_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_ID, LINE_NUMBER

Columns

Name Datatype Length Precision Not-null Comments 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 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 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 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 Ledger identifier of the invoice line. Active
AMOUNT NUMBER 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 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 Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 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. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. 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 Active
PJC_PROJECT_ID NUMBER 18 Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_TASK_ID NUMBER 18 Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_EXPENDITURE_TYPE_ID NUMBER 18 Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_EXPENDITURE_ITEM_DATE DATE Date on which a project related transaction is incurred Active
PJC_ORGANIZATION_ID NUMBER 18 Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_BILLABLE_FLAG VARCHAR2 1 Flag that indicates if a project related item is available to be billed to customers Active
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 Flag that indicates if a project related item is eligible for capitalization Active
PJC_WORK_TYPE_ID NUMBER 18 Identifier for project related classification of the worked performed 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 Active
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user definable project information 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 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
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.
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.

Indexes

Index Uniqueness Tablespace Columns Status
AP_INVOICE_LINES_ALL_N1_ Non Unique Default INVOICE_ID, LINE_NUMBER
AP_INVOICE_LINES_ALL_U1_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_ID, LINE_NUMBER Active