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_NAME | DATA_TYPE | NULLABLE |
INVOICE_ID | NUMBER | N |
LINE_NUMBER | NUMBER | N |
LINE_TYPE_LOOKUP_CODE | VARCHAR2(100) | N |
REQUESTER_ID | NUMBER | Y |
DESCRIPTION | VARCHAR2(960) | Y |
LINE_SOURCE | VARCHAR2(120) | Y |
ORG_ID | NUMBER | N |
LINE_GROUP_NUMBER | NUMBER | Y |
INVENTORY_ITEM_ID | NUMBER | Y |
ITEM_DESCRIPTION | VARCHAR2(960) | Y |
SERIAL_NUMBER | VARCHAR2(140) | Y |
MANUFACTURER | VARCHAR2(120) | Y |
MODEL_NUMBER | VARCHAR2(160) | Y |
WARRANTY_NUMBER | VARCHAR2(60) | Y |
GENERATE_DISTS | VARCHAR2(4) | Y |
MATCH_TYPE | VARCHAR2(100) | Y |
DISTRIBUTION_SET_ID | NUMBER | Y |
ACCOUNT_SEGMENT | VARCHAR2(100) | Y |
BALANCING_SEGMENT | VARCHAR2(100) | Y |
COST_CENTER_SEGMENT | VARCHAR2(100) | Y |
OVERLAY_DIST_CODE_CONCAT | VARCHAR2(1000) | Y |
DEFAULT_DIST_CCID | NUMBER | Y |
PRORATE_ACROSS_ALL_ITEMS | VARCHAR2(4) | Y |
ACCOUNTING_DATE | DATE | N |
PERIOD_NAME | VARCHAR2(60) | Y |
DEFERRED_ACCTG_FLAG | VARCHAR2(4) | Y |
DEF_ACCTG_START_DATE | DATE | Y |
DEF_ACCTG_END_DATE | DATE | Y |
DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Y |
DEF_ACCTG_PERIOD_TYPE | VARCHAR2(120) | Y |
SET_OF_BOOKS_ID | NUMBER | N |
AMOUNT | NUMBER | N |
BASE_AMOUNT | NUMBER | Y |
ROUNDING_AMT | NUMBER | Y |
QUANTITY_INVOICED | NUMBER | Y |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2(100) | Y |
UNIT_PRICE | NUMBER | Y |
WFAPPROVAL_STATUS | VARCHAR2(120) | N |
USSGL_TRANSACTION_CODE | VARCHAR2(120) | Y |
DISCARDED_FLAG | VARCHAR2(4) | Y |
ORIGINAL_AMOUNT | NUMBER | Y |
ORIGINAL_BASE_AMOUNT | NUMBER | Y |
ORIGINAL_ROUNDING_AMT | NUMBER | Y |
CANCELLED_FLAG | VARCHAR2(4) | Y |
INCOME_TAX_REGION | VARCHAR2(40) | Y |
TYPE_1099 | VARCHAR2(40) | Y |
STAT_AMOUNT | NUMBER | Y |
PREPAY_INVOICE_ID | NUMBER | Y |
PREPAY_LINE_NUMBER | NUMBER | Y |
INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2(4) | Y |
CORRECTED_INV_ID | NUMBER | Y |
CORRECTED_LINE_NUMBER | NUMBER | Y |
PO_HEADER_ID | NUMBER | Y |
PO_LINE_ID | NUMBER | Y |
PO_RELEASE_ID | NUMBER | Y |
PO_LINE_LOCATION_ID | NUMBER | Y |
PO_DISTRIBUTION_ID | NUMBER | Y |
RCV_TRANSACTION_ID | NUMBER | Y |
FINAL_MATCH_FLAG | VARCHAR2(4) | Y |
ASSETS_TRACKING_FLAG | VARCHAR2(4) | Y |
ASSET_BOOK_TYPE_CODE | VARCHAR2(120) | Y |
ASSET_CATEGORY_ID | NUMBER | Y |
PROJECT_ID | NUMBER | Y |
TASK_ID | NUMBER | Y |
EXPENDITURE_TYPE | VARCHAR2(120) | Y |
EXPENDITURE_ITEM_DATE | DATE | Y |
EXPENDITURE_ORGANIZATION_ID | NUMBER | Y |
PA_QUANTITY | NUMBER | Y |
PA_CC_AR_INVOICE_ID | NUMBER | Y |
PA_CC_AR_INVOICE_LINE_NUM | NUMBER | Y |
PA_CC_PROCESSED_CODE | VARCHAR2(4) | Y |
AWARD_ID | NUMBER | Y |
AWT_GROUP_ID | NUMBER | Y |
REFERENCE_1 | VARCHAR2(120) | Y |
REFERENCE_2 | VARCHAR2(120) | Y |
RECEIPT_VERIFIED_FLAG | VARCHAR2(4) | Y |
RECEIPT_REQUIRED_FLAG | VARCHAR2(4) | Y |
RECEIPT_MISSING_FLAG | VARCHAR2(4) | Y |
JUSTIFICATION | VARCHAR2(960) | Y |
EXPENSE_GROUP | VARCHAR2(320) | Y |
START_EXPENSE_DATE | DATE | Y |
END_EXPENSE_DATE | DATE | Y |
RECEIPT_CURRENCY_CODE | VARCHAR2(60) | Y |
RECEIPT_CONVERSION_RATE | NUMBER | Y |
RECEIPT_CURRENCY_AMOUNT | NUMBER | Y |
DAILY_AMOUNT | NUMBER | Y |
WEB_PARAMETER_ID | NUMBER | Y |
ADJUSTMENT_REASON | VARCHAR2(960) | Y |
MERCHANT_DOCUMENT_NUMBER | VARCHAR2(320) | Y |
MERCHANT_NAME | VARCHAR2(320) | Y |
MERCHANT_REFERENCE | VARCHAR2(960) | Y |
MERCHANT_TAX_REG_NUMBER | VARCHAR2(320) | Y |
MERCHANT_TAXPAYER_ID | VARCHAR2(320) | Y |
COUNTRY_OF_SUPPLY | VARCHAR2(20) | Y |
CREDIT_CARD_TRX_ID | NUMBER | Y |
COMPANY_PREPAID_INVOICE_ID | NUMBER | Y |
CC_REVERSAL_FLAG | VARCHAR2(4) | Y |
CREATION_DATE | TIMESTAMP(6) | N |
CREATED_BY | VARCHAR2(256) | N |
LAST_UPDATED_BY | VARCHAR2(256) | N |
LAST_UPDATE_DATE | TIMESTAMP(6) | N |
LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
PROGRAM_APPLICATION_ID | NUMBER | Y |
PROGRAM_ID | NUMBER | Y |
PROGRAM_UPDATE_DATE | DATE | Y |
REQUEST_ID | NUMBER | Y |
ATTRIBUTE_CATEGORY | VARCHAR2(600) | Y |
ATTRIBUTE1 | VARCHAR2(600) | Y |
ATTRIBUTE2 | VARCHAR2(600) | Y |
ATTRIBUTE3 | VARCHAR2(600) | Y |
ATTRIBUTE4 | VARCHAR2(600) | Y |
ATTRIBUTE5 | VARCHAR2(600) | Y |
ATTRIBUTE6 | VARCHAR2(600) | Y |
ATTRIBUTE7 | VARCHAR2(600) | Y |
ATTRIBUTE8 | VARCHAR2(600) | Y |
ATTRIBUTE9 | VARCHAR2(600) | Y |
ATTRIBUTE10 | VARCHAR2(600) | Y |
ATTRIBUTE11 | VARCHAR2(600) | Y |
ATTRIBUTE12 | VARCHAR2(600) | Y |
ATTRIBUTE13 | VARCHAR2(600) | Y |
ATTRIBUTE14 | VARCHAR2(600) | Y |
ATTRIBUTE15 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE1 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE2 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE3 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE4 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE5 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE6 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE7 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE8 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE9 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE10 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE11 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE12 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE13 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE14 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE15 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE16 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE17 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE18 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE19 | VARCHAR2(600) | Y |
GLOBAL_ATTRIBUTE20 | VARCHAR2(600) | Y |
LINE_SELECTED_FOR_APPL_FLAG | VARCHAR2(4) | Y |
PREPAY_APPL_REQUEST_ID | NUMBER | Y |
APPLICATION_ID | NUMBER | Y |
PRODUCT_TABLE | VARCHAR2(120) | Y |
REFERENCE_KEY1 | VARCHAR2(600) | Y |
REFERENCE_KEY2 | VARCHAR2(600) | Y |
REFERENCE_KEY3 | VARCHAR2(600) | Y |
REFERENCE_KEY4 | VARCHAR2(600) | Y |
REFERENCE_KEY5 | VARCHAR2(600) | Y |
PURCHASING_CATEGORY_ID | NUMBER | Y |
COST_FACTOR_ID | NUMBER | Y |
CONTROL_AMOUNT | NUMBER | Y |
ASSESSABLE_VALUE | NUMBER | Y |
TOTAL_REC_TAX_AMOUNT | NUMBER | Y |
TOTAL_NREC_TAX_AMOUNT | NUMBER | Y |
TOTAL_REC_TAX_AMT_FUNCL_CURR | NUMBER | Y |
TOTAL_NREC_TAX_AMT_FUNCL_CURR | NUMBER | Y |
INCLUDED_TAX_AMOUNT | NUMBER | Y |
PRIMARY_INTENDED_USE | VARCHAR2(120) | Y |
INTENDED_USE_CLASSIF_ID | NUMBER | Y |
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2(4) | Y |
SHIP_TO_LOCATION_ID | NUMBER | Y |
PRODUCT_TYPE | VARCHAR2(960) | Y |
PRODUCT_CATEGORY | VARCHAR2(960) | Y |
PRODUCT_FISC_CLASSIFICATION | VARCHAR2(960) | Y |
PROD_FC_CATEG_ID | NUMBER | Y |
USER_DEFINED_FISC_CLASS | VARCHAR2(960) | Y |
TRX_BUSINESS_CATEGORY | VARCHAR2(960) | Y |
SUMMARY_TAX_LINE_ID | NUMBER | Y |
TAX_REGIME_CODE | VARCHAR2(120) | Y |
TAX | VARCHAR2(120) | Y |
TAX_JURISDICTION_CODE | VARCHAR2(120) | Y |
TAX_STATUS_CODE | VARCHAR2(120) | Y |
TAX_RATE_ID | NUMBER | Y |
TAX_RATE_CODE | VARCHAR2(600) | Y |
TAX_RATE | NUMBER | Y |
TAX_CODE_ID | NUMBER | Y |
HISTORICAL_FLAG | VARCHAR2(4) | Y |
TAX_CLASSIFICATION_CODE | VARCHAR2(120) | Y |
SOURCE_APPLICATION_ID | NUMBER | Y |
SOURCE_EVENT_CLASS_CODE | VARCHAR2(120) | Y |
SOURCE_ENTITY_CODE | VARCHAR2(120) | Y |
SOURCE_TRX_ID | NUMBER | Y |
SOURCE_LINE_ID | NUMBER | Y |
SOURCE_TRX_LEVEL_TYPE | VARCHAR2(120) | Y |
RETAINED_AMOUNT | NUMBER | Y |
RETAINED_AMOUNT_REMAINING | NUMBER | Y |
RETAINED_INVOICE_ID | NUMBER | Y |
RETAINED_LINE_NUMBER | NUMBER | Y |
LINE_SELECTED_FOR_RELEASE_FLAG | VARCHAR2(4) | Y |
LINE_OWNER_ROLE | VARCHAR2(1280) | Y |
DISPUTABLE_FLAG | VARCHAR2(4) | Y |
RCV_SHIPMENT_LINE_ID | NUMBER | Y |
PJC_CONTEXT_CATEGORY | VARCHAR2(160) | Y |
PJC_PROJECT_ID | NUMBER | Y |
PJC_TASK_ID | NUMBER | Y |
PJC_EXPENDITURE_TYPE_ID | NUMBER | Y |
PJC_EXPENDITURE_ITEM_DATE | DATE | Y |
PJC_ORGANIZATION_ID | NUMBER | Y |
PJC_BILLABLE_FLAG | VARCHAR2(4) | Y |
PJC_CAPITALIZABLE_FLAG | VARCHAR2(4) | Y |
PJC_WORK_TYPE_ID | NUMBER | Y |
PJC_CONTRACT_ID | NUMBER | Y |
PJC_CONTRACT_LINE_ID | NUMBER | Y |
PJC_FUNDING_ALLOCATION_ID | NUMBER | Y |
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2(600) | Y |
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2(600) | Y |
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2(600) | Y |
ATTRIBUTE_NUMBER1 | NUMBER | Y |
ATTRIBUTE_NUMBER2 | NUMBER | Y |
ATTRIBUTE_NUMBER3 | NUMBER | Y |
ATTRIBUTE_NUMBER4 | NUMBER | Y |
ATTRIBUTE_NUMBER5 | NUMBER | Y |
ATTRIBUTE_DATE1 | DATE | Y |
ATTRIBUTE_DATE2 | DATE | Y |
ATTRIBUTE_DATE3 | DATE | Y |
ATTRIBUTE_DATE4 | DATE | Y |
ATTRIBUTE_DATE5 | DATE | Y |
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Y |
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Y |
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Y |
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Y |
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Y |
GLOBAL_ATTRIBUTE_DATE1 | DATE | Y |
GLOBAL_ATTRIBUTE_DATE2 | DATE | Y |
GLOBAL_ATTRIBUTE_DATE3 | DATE | Y |
GLOBAL_ATTRIBUTE_DATE4 | DATE | Y |
GLOBAL_ATTRIBUTE_DATE5 | DATE | Y |
OBJECT_VERSION_NUMBER | NUMBER | N |
JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
BUDGET_DATE | DATE | Y |
FUNDS_STATUS | VARCHAR2(120) | Y |
LCM_ENABLED_FLAG | VARCHAR2(4) | Y |
CONSUMPTION_ADVICE_HEADER_ID | NUMBER | Y |
CONSUMPTION_ADVICE_LINE_ID | NUMBER | Y |
SHIP_FROM_LOCATION_ID | NUMBER | Y |
FINAL_DISCHARGE_LOCATION_ID | NUMBER | Y |
FOS_XFACE_FLAG | VARCHAR2(4) | Y |
MATCHING_RULE_SET_ID | NUMBER | Y |
MATCHING_RULE_ID | NUMBER | Y |
FISCAL_CHARGE_TYPE | VARCHAR2(120) | Y |
SHIP_TO_CUST_LOCATION_ID | NUMBER | Y |
DEF_ACCTG_ACCRUAL_CCID | NUMBER | Y |
Indexes
INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN NAME |
AP_INVOICE_LINES_N1 | NORMAL | NONUNIQUE | ACCOUNTING_DATE |
AP_INVOICE_LINES_N10 | NORMAL | NONUNIQUE | LINE_SELECTED_FOR_APPL_FLAG |
AP_INVOICE_LINES_N12 | NORMAL | NONUNIQUE | LINE_TYPE_LOOKUP_CODE |
AP_INVOICE_LINES_N13 | NORMAL | NONUNIQUE | SET_OF_BOOKS_ID |
AP_INVOICE_LINES_N13 | NORMAL | NONUNIQUE | ORG_ID |
AP_INVOICE_LINES_N13 | NORMAL | NONUNIQUE | ACCOUNTING_DATE |
AP_INVOICE_LINES_N13 | NORMAL | NONUNIQUE | AMOUNT |
AP_INVOICE_LINES_N13 | NORMAL | NONUNIQUE | DISCARDED_FLAG |
AP_INVOICE_LINES_N14 | NORMAL | NONUNIQUE | INVOICE_ID |
AP_INVOICE_LINES_N14 | NORMAL | NONUNIQUE | SUMMARY_TAX_LINE_ID |
AP_INVOICE_LINES_N2 | NORMAL | NONUNIQUE | RCV_TRANSACTION_ID |
AP_INVOICE_LINES_N3 | NORMAL | NONUNIQUE | PO_LINE_LOCATION_ID |
AP_INVOICE_LINES_N4 | NORMAL | NONUNIQUE | PJC_PROJECT_ID |
AP_INVOICE_LINES_N4 | NORMAL | NONUNIQUE | PJC_TASK_ID |
AP_INVOICE_LINES_N6 | NORMAL | NONUNIQUE | CORRECTED_INV_ID |
AP_INVOICE_LINES_N8 | NORMAL | NONUNIQUE | PREPAY_INVOICE_ID |
AP_INVOICE_LINES_N8 | NORMAL | NONUNIQUE | PREPAY_LINE_NUMBER |
AP_INVOICE_LINES_N9 | NORMAL | NONUNIQUE | PO_HEADER_ID |
AP_INVOICE_LINES_U1 | NORMAL | UNIQUE | INVOICE_ID |
AP_INVOICE_LINES_U1 | NORMAL | UNIQUE | LINE_NUMBER |
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..
1 thought on “AP_INVOICE_LINES_ALL: Columns, Index & Salient Points”
Comments are closed.