indexes, Oracle Fusion, Table Structure

AP_INVOICE_LINES_ALL: Columns, Index & Salient Points

AP_INVOICE_LINES_ALL is one of the most important table in P2P Cycle. The table AP_INVOICE_LINES_ALL used by Oracle Fusion to store the line level data of AP invoices. if you are looking to connect the AP invoice to any entity like PO/ Project etc, most probably this is your table like you can use PO_DISTRIBUTION_ID to connect AP invoice to PO Distribution. similarly Project and task id can be used to find the task info which has caused the invoice line to be created. So let’s see the table structure and the indexes:

(By the way, I was helped by this book a great deal, just in case you want to refer. No no.. I am neither the author nor the publisher of this book. )

AP_INVOICE_LINES_ALL: Table Structure

COLUMN_NAMEDATA_TYPENULLABLE
 INVOICE_IDNUMBER
 LINE_NUMBERNUMBER
 LINE_TYPE_LOOKUP_CODEVARCHAR2(100)
 REQUESTER_IDNUMBER
 DESCRIPTIONVARCHAR2(960)
 LINE_SOURCEVARCHAR2(120)
 ORG_IDNUMBER
 LINE_GROUP_NUMBERNUMBER
 INVENTORY_ITEM_IDNUMBER
 ITEM_DESCRIPTIONVARCHAR2(960)
 SERIAL_NUMBERVARCHAR2(140)
 MANUFACTURERVARCHAR2(120)
 MODEL_NUMBERVARCHAR2(160)
 WARRANTY_NUMBERVARCHAR2(60)
 GENERATE_DISTSVARCHAR2(4)
 MATCH_TYPEVARCHAR2(100)
 DISTRIBUTION_SET_IDNUMBER
 ACCOUNT_SEGMENTVARCHAR2(100)
 BALANCING_SEGMENTVARCHAR2(100)
 COST_CENTER_SEGMENTVARCHAR2(100)
 OVERLAY_DIST_CODE_CONCATVARCHAR2(1000)
 DEFAULT_DIST_CCIDNUMBER
 PRORATE_ACROSS_ALL_ITEMSVARCHAR2(4)
 ACCOUNTING_DATEDATE
 PERIOD_NAMEVARCHAR2(60)
 DEFERRED_ACCTG_FLAGVARCHAR2(4)
 DEF_ACCTG_START_DATEDATE
 DEF_ACCTG_END_DATEDATE
 DEF_ACCTG_NUMBER_OF_PERIODSNUMBER
 DEF_ACCTG_PERIOD_TYPEVARCHAR2(120)
 SET_OF_BOOKS_IDNUMBER
 AMOUNTNUMBER
 BASE_AMOUNTNUMBER
 ROUNDING_AMTNUMBER
 QUANTITY_INVOICEDNUMBER
 UNIT_MEAS_LOOKUP_CODEVARCHAR2(100)
 UNIT_PRICENUMBER
 WFAPPROVAL_STATUSVARCHAR2(120)
 USSGL_TRANSACTION_CODEVARCHAR2(120)
 DISCARDED_FLAGVARCHAR2(4)
 ORIGINAL_AMOUNTNUMBER
 ORIGINAL_BASE_AMOUNTNUMBER
 ORIGINAL_ROUNDING_AMTNUMBER
 CANCELLED_FLAGVARCHAR2(4)
 INCOME_TAX_REGIONVARCHAR2(40)
 TYPE_1099VARCHAR2(40)
 STAT_AMOUNTNUMBER
 PREPAY_INVOICE_IDNUMBER
 PREPAY_LINE_NUMBERNUMBER
 INVOICE_INCLUDES_PREPAY_FLAGVARCHAR2(4)
 CORRECTED_INV_IDNUMBER
 CORRECTED_LINE_NUMBERNUMBER
 PO_HEADER_IDNUMBER
 PO_LINE_IDNUMBER
 PO_RELEASE_IDNUMBER
 PO_LINE_LOCATION_IDNUMBER
 PO_DISTRIBUTION_IDNUMBER
 RCV_TRANSACTION_IDNUMBER
 FINAL_MATCH_FLAGVARCHAR2(4)
 ASSETS_TRACKING_FLAGVARCHAR2(4)
 ASSET_BOOK_TYPE_CODEVARCHAR2(120)
 ASSET_CATEGORY_IDNUMBER
 PROJECT_IDNUMBER
 TASK_IDNUMBER
 EXPENDITURE_TYPEVARCHAR2(120)
 EXPENDITURE_ITEM_DATEDATE
 EXPENDITURE_ORGANIZATION_IDNUMBER
 PA_QUANTITYNUMBER
 PA_CC_AR_INVOICE_IDNUMBER
 PA_CC_AR_INVOICE_LINE_NUMNUMBER
 PA_CC_PROCESSED_CODEVARCHAR2(4)
 AWARD_IDNUMBER
 AWT_GROUP_IDNUMBER
 REFERENCE_1VARCHAR2(120)
 REFERENCE_2VARCHAR2(120)
 RECEIPT_VERIFIED_FLAGVARCHAR2(4)
 RECEIPT_REQUIRED_FLAGVARCHAR2(4)
 RECEIPT_MISSING_FLAGVARCHAR2(4)
 JUSTIFICATIONVARCHAR2(960)
 EXPENSE_GROUPVARCHAR2(320)
 START_EXPENSE_DATEDATE
 END_EXPENSE_DATEDATE
 RECEIPT_CURRENCY_CODEVARCHAR2(60)
 RECEIPT_CONVERSION_RATENUMBER
 RECEIPT_CURRENCY_AMOUNTNUMBER
 DAILY_AMOUNTNUMBER
 WEB_PARAMETER_IDNUMBER
 ADJUSTMENT_REASONVARCHAR2(960)
 MERCHANT_DOCUMENT_NUMBERVARCHAR2(320)
 MERCHANT_NAMEVARCHAR2(320)
 MERCHANT_REFERENCEVARCHAR2(960)
 MERCHANT_TAX_REG_NUMBERVARCHAR2(320)
 MERCHANT_TAXPAYER_IDVARCHAR2(320)
 COUNTRY_OF_SUPPLYVARCHAR2(20)
 CREDIT_CARD_TRX_IDNUMBER
 COMPANY_PREPAID_INVOICE_IDNUMBER
 CC_REVERSAL_FLAGVARCHAR2(4)
 CREATION_DATETIMESTAMP(6)
 CREATED_BYVARCHAR2(256)
 LAST_UPDATED_BYVARCHAR2(256)
 LAST_UPDATE_DATETIMESTAMP(6)
 LAST_UPDATE_LOGINVARCHAR2(128)
 PROGRAM_APPLICATION_IDNUMBER
 PROGRAM_IDNUMBER
 PROGRAM_UPDATE_DATEDATE
 REQUEST_IDNUMBER
 ATTRIBUTE_CATEGORYVARCHAR2(600)
 ATTRIBUTE1VARCHAR2(600)
 ATTRIBUTE2VARCHAR2(600)
 ATTRIBUTE3VARCHAR2(600)
 ATTRIBUTE4VARCHAR2(600)
 ATTRIBUTE5VARCHAR2(600)
 ATTRIBUTE6VARCHAR2(600)
 ATTRIBUTE7VARCHAR2(600)
 ATTRIBUTE8VARCHAR2(600)
 ATTRIBUTE9VARCHAR2(600)
 ATTRIBUTE10VARCHAR2(600)
 ATTRIBUTE11VARCHAR2(600)
 ATTRIBUTE12VARCHAR2(600)
 ATTRIBUTE13VARCHAR2(600)
 ATTRIBUTE14VARCHAR2(600)
 ATTRIBUTE15VARCHAR2(600)
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(600)
 GLOBAL_ATTRIBUTE1VARCHAR2(600)
 GLOBAL_ATTRIBUTE2VARCHAR2(600)
 GLOBAL_ATTRIBUTE3VARCHAR2(600)
 GLOBAL_ATTRIBUTE4VARCHAR2(600)
 GLOBAL_ATTRIBUTE5VARCHAR2(600)
 GLOBAL_ATTRIBUTE6VARCHAR2(600)
 GLOBAL_ATTRIBUTE7VARCHAR2(600)
 GLOBAL_ATTRIBUTE8VARCHAR2(600)
 GLOBAL_ATTRIBUTE9VARCHAR2(600)
 GLOBAL_ATTRIBUTE10VARCHAR2(600)
 GLOBAL_ATTRIBUTE11VARCHAR2(600)
 GLOBAL_ATTRIBUTE12VARCHAR2(600)
 GLOBAL_ATTRIBUTE13VARCHAR2(600)
 GLOBAL_ATTRIBUTE14VARCHAR2(600)
 GLOBAL_ATTRIBUTE15VARCHAR2(600)
 GLOBAL_ATTRIBUTE16VARCHAR2(600)
 GLOBAL_ATTRIBUTE17VARCHAR2(600)
 GLOBAL_ATTRIBUTE18VARCHAR2(600)
 GLOBAL_ATTRIBUTE19VARCHAR2(600)
 GLOBAL_ATTRIBUTE20VARCHAR2(600)
 LINE_SELECTED_FOR_APPL_FLAGVARCHAR2(4)
 PREPAY_APPL_REQUEST_IDNUMBER
 APPLICATION_IDNUMBER
 PRODUCT_TABLEVARCHAR2(120)
 REFERENCE_KEY1VARCHAR2(600)
 REFERENCE_KEY2VARCHAR2(600)
 REFERENCE_KEY3VARCHAR2(600)
 REFERENCE_KEY4VARCHAR2(600)
 REFERENCE_KEY5VARCHAR2(600)
 PURCHASING_CATEGORY_IDNUMBER
 COST_FACTOR_IDNUMBER
 CONTROL_AMOUNTNUMBER
 ASSESSABLE_VALUENUMBER
 TOTAL_REC_TAX_AMOUNTNUMBER
 TOTAL_NREC_TAX_AMOUNTNUMBER
 TOTAL_REC_TAX_AMT_FUNCL_CURRNUMBER
 TOTAL_NREC_TAX_AMT_FUNCL_CURRNUMBER
 INCLUDED_TAX_AMOUNTNUMBER
 PRIMARY_INTENDED_USEVARCHAR2(120)
 INTENDED_USE_CLASSIF_IDNUMBER
 TAX_ALREADY_CALCULATED_FLAGVARCHAR2(4)
 SHIP_TO_LOCATION_IDNUMBER
 PRODUCT_TYPEVARCHAR2(960)
 PRODUCT_CATEGORYVARCHAR2(960)
 PRODUCT_FISC_CLASSIFICATIONVARCHAR2(960)
 PROD_FC_CATEG_IDNUMBER
 USER_DEFINED_FISC_CLASSVARCHAR2(960)
 TRX_BUSINESS_CATEGORYVARCHAR2(960)
 SUMMARY_TAX_LINE_IDNUMBER
 TAX_REGIME_CODEVARCHAR2(120)
 TAXVARCHAR2(120)
 TAX_JURISDICTION_CODEVARCHAR2(120)
 TAX_STATUS_CODEVARCHAR2(120)
 TAX_RATE_IDNUMBER
 TAX_RATE_CODEVARCHAR2(600)
 TAX_RATENUMBER
 TAX_CODE_IDNUMBER
 HISTORICAL_FLAGVARCHAR2(4)
 TAX_CLASSIFICATION_CODEVARCHAR2(120)
 SOURCE_APPLICATION_IDNUMBER
 SOURCE_EVENT_CLASS_CODEVARCHAR2(120)
 SOURCE_ENTITY_CODEVARCHAR2(120)
 SOURCE_TRX_IDNUMBER
 SOURCE_LINE_IDNUMBER
 SOURCE_TRX_LEVEL_TYPEVARCHAR2(120)
 RETAINED_AMOUNTNUMBER
 RETAINED_AMOUNT_REMAININGNUMBER
 RETAINED_INVOICE_IDNUMBER
 RETAINED_LINE_NUMBERNUMBER
 LINE_SELECTED_FOR_RELEASE_FLAGVARCHAR2(4)
 LINE_OWNER_ROLEVARCHAR2(1280)
 DISPUTABLE_FLAGVARCHAR2(4)
 RCV_SHIPMENT_LINE_IDNUMBER
 PJC_CONTEXT_CATEGORYVARCHAR2(160)
 PJC_PROJECT_IDNUMBER
 PJC_TASK_IDNUMBER
 PJC_EXPENDITURE_TYPE_IDNUMBER
 PJC_EXPENDITURE_ITEM_DATEDATE
 PJC_ORGANIZATION_IDNUMBER
 PJC_BILLABLE_FLAGVARCHAR2(4)
 PJC_CAPITALIZABLE_FLAGVARCHAR2(4)
 PJC_WORK_TYPE_IDNUMBER
 PJC_CONTRACT_IDNUMBER
 PJC_CONTRACT_LINE_IDNUMBER
 PJC_FUNDING_ALLOCATION_IDNUMBER
 PJC_RESERVED_ATTRIBUTE1VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE2VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE3VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE4VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE5VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE6VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE7VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE8VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE9VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE10VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE1VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE2VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE3VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE4VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE5VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE6VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE7VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE8VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE9VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE10VARCHAR2(600)
 ATTRIBUTE_NUMBER1NUMBER
 ATTRIBUTE_NUMBER2NUMBER
 ATTRIBUTE_NUMBER3NUMBER
 ATTRIBUTE_NUMBER4NUMBER
 ATTRIBUTE_NUMBER5NUMBER
 ATTRIBUTE_DATE1DATE
 ATTRIBUTE_DATE2DATE
 ATTRIBUTE_DATE3DATE
 ATTRIBUTE_DATE4DATE
 ATTRIBUTE_DATE5DATE
 GLOBAL_ATTRIBUTE_NUMBER1NUMBER
 GLOBAL_ATTRIBUTE_NUMBER2NUMBER
 GLOBAL_ATTRIBUTE_NUMBER3NUMBER
 GLOBAL_ATTRIBUTE_NUMBER4NUMBER
 GLOBAL_ATTRIBUTE_NUMBER5NUMBER
 GLOBAL_ATTRIBUTE_DATE1DATE
 GLOBAL_ATTRIBUTE_DATE2DATE
 GLOBAL_ATTRIBUTE_DATE3DATE
 GLOBAL_ATTRIBUTE_DATE4DATE
 GLOBAL_ATTRIBUTE_DATE5DATE
 OBJECT_VERSION_NUMBERNUMBER
 JOB_DEFINITION_NAMEVARCHAR2(400)
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)
 BUDGET_DATEDATE
 FUNDS_STATUSVARCHAR2(120)
 LCM_ENABLED_FLAGVARCHAR2(4)
 CONSUMPTION_ADVICE_HEADER_IDNUMBER
 CONSUMPTION_ADVICE_LINE_IDNUMBER
 SHIP_FROM_LOCATION_IDNUMBER
 FINAL_DISCHARGE_LOCATION_IDNUMBER
 FOS_XFACE_FLAGVARCHAR2(4)
 MATCHING_RULE_SET_IDNUMBER
 MATCHING_RULE_IDNUMBER
 FISCAL_CHARGE_TYPEVARCHAR2(120)
 SHIP_TO_CUST_LOCATION_IDNUMBER
 DEF_ACCTG_ACCRUAL_CCIDNUMBER
AP_INVOICE_LINES_ALL Table Structure

Indexes

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN NAME
 AP_INVOICE_LINES_N1NORMALNONUNIQUEACCOUNTING_DATE
 AP_INVOICE_LINES_N10NORMALNONUNIQUELINE_SELECTED_FOR_APPL_FLAG
 AP_INVOICE_LINES_N12NORMALNONUNIQUELINE_TYPE_LOOKUP_CODE
 AP_INVOICE_LINES_N13NORMALNONUNIQUESET_OF_BOOKS_ID
 AP_INVOICE_LINES_N13NORMALNONUNIQUEORG_ID
 AP_INVOICE_LINES_N13NORMALNONUNIQUEACCOUNTING_DATE
 AP_INVOICE_LINES_N13NORMALNONUNIQUEAMOUNT
 AP_INVOICE_LINES_N13NORMALNONUNIQUEDISCARDED_FLAG
 AP_INVOICE_LINES_N14NORMALNONUNIQUEINVOICE_ID
 AP_INVOICE_LINES_N14NORMALNONUNIQUESUMMARY_TAX_LINE_ID
 AP_INVOICE_LINES_N2NORMALNONUNIQUERCV_TRANSACTION_ID
 AP_INVOICE_LINES_N3NORMALNONUNIQUEPO_LINE_LOCATION_ID
 AP_INVOICE_LINES_N4NORMALNONUNIQUEPJC_PROJECT_ID
 AP_INVOICE_LINES_N4NORMALNONUNIQUEPJC_TASK_ID
 AP_INVOICE_LINES_N6NORMALNONUNIQUECORRECTED_INV_ID
 AP_INVOICE_LINES_N8NORMALNONUNIQUEPREPAY_INVOICE_ID
 AP_INVOICE_LINES_N8NORMALNONUNIQUEPREPAY_LINE_NUMBER
 AP_INVOICE_LINES_N9NORMALNONUNIQUEPO_HEADER_ID
 AP_INVOICE_LINES_U1NORMALUNIQUEINVOICE_ID
 AP_INVOICE_LINES_U1NORMALUNIQUELINE_NUMBER
AP_INVOICE_LINES_ALL Indexes

Related Posts

AP_INVOICES_ALL
AP Payment Query

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

1 thought on “AP_INVOICE_LINES_ALL: Columns, Index & Salient Points”

Comments are closed.