[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICE_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INVOICE_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INVOICE_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INVOICE_ID
LINE_NUMBER
|
| AP_INVOICE_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACCOUNTING_DATE
|
| AP_INVOICE_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_SELECTED_FOR_APPL_FLAG
|
| AP_INVOICE_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SET_OF_BOOKS_ID
ORG_ID
ACCOUNTING_DATE
AMOUNT
DISCARDED_FLAG
|
| AP_INVOICE_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RCV_TRANSACTION_ID
|
| AP_INVOICE_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_LINE_LOCATION_ID
|
| AP_INVOICE_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| AP_INVOICE_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AWARD_ID
|
| AP_INVOICE_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CORRECTED_INV_ID
|
| AP_INVOICE_LINES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREPAY_INVOICE_ID
PREPAY_LINE_NUMBER
|
| AP_INVOICE_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
| LINE_NUMBER | NUMBER | Yes | Invoice line number | |
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes. |
| REQUESTER_ID | NUMBER | (15) | Requester of goods or services on invoice line. Used by Invoice Workflow Approval process to generate list of approvers. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID. | |
| DESCRIPTION | VARCHAR2 | (240) | Invoice line description | |
| LINE_SOURCE | VARCHAR2 | (30) | Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| LINE_GROUP_NUMBER | NUMBER | Group number assigned to the line during the Open Interface Import process to be used for generation of allocation rules | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier. Validated against MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number for item | |
| MANUFACTURER | VARCHAR2 | (30) | Name of manufacturer | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model information | |
| WARRANTY_NUMBER | VARCHAR2 | (15) | Warranty number | |
| GENERATE_DISTS | VARCHAR2 | (1) | Flag indicating whether distributions for the invoice line should be generated dynamically whenever possible | |
| MATCH_TYPE | VARCHAR2 | (25) | Indicates the type of match if any. Validated against AP_LOOKUP_CODES with lookup type as INVOICE LINE MATCH TYPE | |
| DISTRIBUTION_SET_ID | NUMBER | (15) | Distribution set identifier to be used in the generation of distributions for a line | |
| ACCOUNT_SEGMENT | VARCHAR2 | (25) | Account segment value for overlay in generation of accounting flexfield during distribution generation | |
| BALANCING_SEGMENT | VARCHAR2 | (25) | Balancing segment value for overlay in generation of accounting flexfield during distribution generation | |
| COST_CENTER_SEGMENT | VARCHAR2 | (25) | Cost Center segment value for overlay in generation of accounting flexfield during distribution generation | |
| OVERLAY_DIST_CODE_CONCAT | VARCHAR2 | (250) | Concatenated segments for overlay in generation of accounting flexfield during distribution generation | |
| DEFAULT_DIST_CCID | NUMBER | (15) | Account to be used for automatic generation of a single distribution | |
| 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 | |
| ACCOUNTING_DATE | DATE | Yes | Accounting date for invoice line. Used for defaulting to distributions | |
| PERIOD_NAME | VARCHAR2 | (15) | Accounting date for invoice line. Used for defaulting to distributions | |
| DEFERRED_ACCTG_FLAG | VARCHAR2 | (1) | Accounting date for invoice line. Used for defaulting to distributions | |
| DEF_ACCTG_START_DATE | DATE | The start date of the deferred expense period | ||
| DEF_ACCTG_END_DATE | DATE | The end date of the deferred expense period | ||
| DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE | ||
| 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 | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| AMOUNT | NUMBER | Yes | Line amount in invoice currency | |
| BASE_AMOUNT | NUMBER | Line amount in functional currency | ||
| ROUNDING_AMT | NUMBER | Amount corresponding to rounding amount included in BASE_AMOUNT if any | ||
| QUANTITY_INVOICED | NUMBER | Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines | ||
| UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for QUANTITY_INVOICED. Validated against MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE | |
| UNIT_PRICE | NUMBER | Unit price | ||
| WFAPPROVAL_STATUS | VARCHAR2 | (30) | Yes | Status of invoice line in Invoice Line Approval Workflow process. Default value is NOT REQUIRED |
| 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 | |
| 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 | |
| ORIGINAL_AMOUNT | NUMBER | Amount of the line before discarding of the line or cancellation of the invoice | ||
| ORIGINAL_BASE_AMOUNT | NUMBER | Base amount of the line before discarding of the line or cancellation of the invoice | ||
| ORIGINAL_ROUNDING_AMT | NUMBER | Rounding amount of the line before discarding of the line or cancellation of the invoice | ||
| CANCELLED_FLAG | VARCHAR2 | (1) | A value of Y indicates that the line has been cancelled | |
| INCOME_TAX_REGION | VARCHAR2 | (10) | Reporting region for invoice line for 1099 supplier. Defaults down to distributions | |
| TYPE_1099 | VARCHAR2 | (10) | Income tax type | |
| STAT_AMOUNT | NUMBER | Amount associated with a distribution for measuring statistical quantities. Used only for transferring the information during Open Interface Import process | ||
| PREPAY_INVOICE_ID | NUMBER | (15) | Invoice identifier for Prepayment invoice applied via current invoice line | |
| PREPAY_LINE_NUMBER | NUMBER | Line number for Prepayment line applied via current invoice line | ||
| INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | (1) | Y indicates that prepayment is included in the invoice amount | |
| CORRECTED_INV_ID | NUMBER | (15) | Invoice identifier for invoice corrected via current line. For price, quantity, or invoice line corrections | |
| CORRECTED_LINE_NUMBER | NUMBER | Invoice line number for invoice line corrected via current line. For price, quantity, or invoice line corrections | ||
| PO_HEADER_ID | NUMBER | Purchase order header identifier. Used for PO matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID | ||
| PO_LINE_ID | NUMBER | Purchase order line identifier. Used for PO matching. Validated against PO_LINES_ALL.PO_LINE_ID | ||
| PO_RELEASE_ID | NUMBER | Purchase order release identifier. Used for PO matching. Validated against PO_RELEASES_ALL.PO_RELEASE_ID | ||
| PO_LINE_LOCATION_ID | NUMBER | Purchase order line location identifier. Used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID | ||
| PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution identifier. Used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID | ||
| RCV_TRANSACTION_ID | NUMBER | Receipt identifier. Used for RCV matching. Validated against RCV_TRANSACTIONS.TRANSACTION_ID | ||
| FINAL_MATCH_FLAG | VARCHAR2 | (1) | Final match indicator | |
| ASSETS_TRACKING_FLAG | VARCHAR2 | (1) | Y indicates that the item should be treated as an asset | |
| ASSET_BOOK_TYPE_CODE | VARCHAR2 | (15) | Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets | |
| ASSET_CATEGORY_ID | NUMBER | (15) | Asset Category. Defaults to the distributions candidate for transfer to Oracle Assets | |
| PROJECT_ID | NUMBER | (15) | Project identifier for project related invoice lines | |
| TASK_ID | NUMBER | (15) | Task identifier for project related invoice lines | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type for project related invoice lines | |
| EXPENDITURE_ITEM_DATE | DATE | Expenditure item date for project related Invoice Lines | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Expenditure organization identifier for project related invoice lines | |
| PA_QUANTITY | NUMBER | Project item quantity for project related invoice lines | ||
| PA_CC_AR_INVOICE_ID | NUMBER | (15) | For an intercompany invoice from Oracle Projects, this is the identifier of the corresponding receivable intercompany invoice in Oracle Receivables | |
| PA_CC_AR_INVOICE_LINE_NUM | NUMBER | (15) | For an intercompany invoice from Oracle Projects, this is the line number of the corresponding receivable intercompany invoice in Oracle Receivables | |
| PA_CC_PROCESSED_CODE | VARCHAR2 | (1) | The processing status of this invoice line by Oracle Projects in the receiver operating unit | |
| AWARD_ID | NUMBER | (15) | Reserved for use by Oracle Grants Management. Defaults to distributions | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier | |
| REFERENCE_1 | VARCHAR2 | (30) | A reference to a record in another application | |
| REFERENCE_2 | VARCHAR2 | (30) | A reference to a record in another application | |
| RECEIPT_VERIFIED_FLAG | VARCHAR2 | (1) | Indicates whether receipts verified | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether receipts required | |
| RECEIPT_MISSING_FLAG | VARCHAR2 | (1) | Indicates whether receipts missing | |
| JUSTIFICATION | VARCHAR2 | (240) | Expense justificatio | |
| EXPENSE_GROUP | VARCHAR2 | (80) | Expense group | |
| START_EXPENSE_DATE | DATE | Date when incurred expense started. Used for expense reports | ||
| END_EXPENSE_DATE | DATE | Date when incurred expense ended. Used for expense reports | ||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of receipt. Used for expense reports | |
| RECEIPT_CONVERSION_RATE | NUMBER | Exchange rate for currency of receipt. Used for expense reports | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Amount in receipt currency. Used for expense reports | ||
| DAILY_AMOUNT | NUMBER | Daily expense amount. Used for expense reports' | ||
| WEB_PARAMETER_ID | NUMBER | Self-Service Web Applications parameter identifier | ||
| ADJUSTMENT_REASON | VARCHAR2 | (240) | Reason for expense adjustment | |
| MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | Third party document number. Used for expense reports | |
| MERCHANT_REFERENCE | VARCHAR2 | (240) | Third party reference. Used for expense reports | |
| MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | Third party tax registration number. Used for expense reports | |
| MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | Third party tax identification number. Used for expense reports | |
| COUNTRY_OF_SUPPLY | VARCHAR2 | (5) | Country where services or goods were originated. Used for expense reports | |
| CREDIT_CARD_TRX_ID | NUMBER | (15) | Credit card transaction identifier | |
| COMPANY_PREPAID_INVOICE_ID | NUMBER | (15) | Invoice ID when this line is a prepaid credit card transaction | |
| CC_REVERSAL_FLAG | VARCHAR2 | (1) | Invoice ID when this line is a prepaid credit card transaction | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Enhanced Who column | |
| PROGRAM_ID | NUMBER | (15) | Enhanced Who column | |
| PROGRAM_UPDATE_DATE | DATE | Enhanced Who column | ||
| REQUEST_ID | NUMBER | (15) | Enhanced Who column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_SELECTED_FOR_APPL_FLAG | VARCHAR2 | (1) | A value of Y indicates that this line on the prepayment invoice is selected for prepayment application | |
| PREPAY_APPL_REQUEST_ID | NUMBER | (15) | Request identifier of the Payables Open Interface Import program that selected this line on the prepayment invoice for prepayment application | |
| APPLICATION_ID | NUMBER | (15) | Application Identifier | |
| PRODUCT_TABLE | VARCHAR2 | (30) | Product source table name | |
| REFERENCE_KEY1 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY2 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY3 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY4 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY5 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| PURCHASING_CATEGORY_ID | NUMBER | (15) | Item category unique identifier | |
| COST_FACTOR_ID | NUMBER | (15) | 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. | |
| CONTROL_AMOUNT | NUMBER | Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document. | ||
| ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis. | ||
| TOTAL_REC_TAX_AMOUNT | NUMBER | Total recoverable tax allocated to this taxable line. | ||
| TOTAL_NREC_TAX_AMOUNT | NUMBER | Total non-recoverable tax allocated to this taxable line. | ||
| TOTAL_REC_TAX_AMT_FUNCL_CURR | NUMBER | Total recoverable tax amount in functional currency. | ||
| TOTAL_NREC_TAX_AMT_FUNCL_CURR | NUMBER | Total non recoverable tax amount in functional currency. | ||
| INCLUDED_TAX_AMOUNT | NUMBER | Included tax amount for taxable line of type inclusive. | ||
| 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. | |
| TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | Internal processing flag for Payables, indicating whether tax has already been calculated. | |
| SHIP_TO_LOCATION_ID | NUMBER | (15) | Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched. | |
| 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. | |
| PRODUCT_CATEGORY | VARCHAR2 | (240) | Tax Driver: Product category. | |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | Tax Driver: Product fiscal classification | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | Tax Driver: Fiscal Classification. | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Tax Driver: Transactions category assigned by user. | |
| SUMMARY_TAX_LINE_ID | NUMBER | Cross reference to E-Business Tax repository. | ||
| 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. | |
| TAX | VARCHAR2 | (30) | A classification of a charge imposed by a government through a fiscal or tax authority. | |
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | Internal ID of the Tax Jurisdiction. | |
| TAX_STATUS_CODE | VARCHAR2 | (30) | Tax status code. e.g., taxable standard rate, zero rated, exempt, non-taxable. | |
| TAX_RATE_ID | NUMBER | (15) | Internal identifier for tax rate effective on the invoice date. | |
| 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. | |
| TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time. | ||
| TAX_CODE_ID | NUMBER | (15) | Identifier for existing tax code in Payables. Necessary for upgrade and reporting purposes. | |
| 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. | |
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax classifiation code used by Procure To Pay products. | |
| SOURCE_APPLICATION_ID | NUMBER | Source document application identifier. | ||
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | (30) | Source document event class code. | |
| SOURCE_ENTITY_CODE | VARCHAR2 | (30) | Source document entity code. | |
| SOURCE_TRX_ID | NUMBER | Source document transaction identifier. | ||
| SOURCE_LINE_ID | NUMBER | Source document transaction line identifier. | ||
| 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. | |
| RETAINED_AMOUNT | NUMBER | Retained amount | ||
| RETAINED_AMOUNT_REMAINING | NUMBER | Retained amount available for release | ||
| RETAINED_INVOICE_ID | NUMBER | (15) | Retained Invoice Identifier | |
| RETAINED_LINE_NUMBER | NUMBER | Retained invoice line number | ||
| LINE_SELECTED_FOR_RELEASE_FLAG | VARCHAR2 | (1) | Flag to indicate invoice is currently being processesed for release | |
| LINE_OWNER_ROLE | VARCHAR2 | (320) | This column contains the owner of invoice line derived by AME rule. | |
| DISPUTABLE_FLAG | VARCHAR2 | (1) | Indicates whether the line is disputable | |
| RCV_SHIPMENT_LINE_ID | NUMBER | (15) | Receipt Shipment line unique identifier.Used for Receipt matching. | |
| AIL_INVOICE_ID | NUMBER | (15) | Not used | |
| AIL_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Not used | |
| AIL_INVOICE_ID2 | NUMBER | (15) | Not used | |
| AIL_DISTRIBUTION_LINE_NUMBER2 | NUMBER | (15) | Not used | |
| AIL_INVOICE_ID3 | NUMBER | (15) | Not used | |
| AIL_DISTRIBUTION_LINE_NUMBER3 | NUMBER | (15) | Not used | |
| AIL_INVOICE_ID4 | NUMBER | (15) | Not used | |
| PAY_AWT_GROUP_ID | NUMBER | (15) | This field contains Withholding tax id which will be applied during the payment time | |
| MERCHANT_NAME#1 | VARCHAR2 | (240) | Third party name. Used for expense reports |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE
, REQUESTER_ID
, DESCRIPTION
, LINE_SOURCE
, ORG_ID
, LINE_GROUP_NUMBER
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, SERIAL_NUMBER
, MANUFACTURER
, MODEL_NUMBER
, WARRANTY_NUMBER
, GENERATE_DISTS
, MATCH_TYPE
, DISTRIBUTION_SET_ID
, ACCOUNT_SEGMENT
, BALANCING_SEGMENT
, COST_CENTER_SEGMENT
, OVERLAY_DIST_CODE_CONCAT
, DEFAULT_DIST_CCID
, PRORATE_ACROSS_ALL_ITEMS
, ACCOUNTING_DATE
, PERIOD_NAME
, DEFERRED_ACCTG_FLAG
, DEF_ACCTG_START_DATE
, DEF_ACCTG_END_DATE
, DEF_ACCTG_NUMBER_OF_PERIODS
, DEF_ACCTG_PERIOD_TYPE
, SET_OF_BOOKS_ID
, AMOUNT
, BASE_AMOUNT
, ROUNDING_AMT
, QUANTITY_INVOICED
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, WFAPPROVAL_STATUS
, USSGL_TRANSACTION_CODE
, DISCARDED_FLAG
, ORIGINAL_AMOUNT
, ORIGINAL_BASE_AMOUNT
, ORIGINAL_ROUNDING_AMT
, CANCELLED_FLAG
, INCOME_TAX_REGION
, TYPE_1099
, STAT_AMOUNT
, PREPAY_INVOICE_ID
, PREPAY_LINE_NUMBER
, INVOICE_INCLUDES_PREPAY_FLAG
, CORRECTED_INV_ID
, CORRECTED_LINE_NUMBER
, PO_HEADER_ID
, PO_LINE_ID
, PO_RELEASE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, RCV_TRANSACTION_ID
, FINAL_MATCH_FLAG
, ASSETS_TRACKING_FLAG
, ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID
, PA_QUANTITY
, PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM
, PA_CC_PROCESSED_CODE
, AWARD_ID
, AWT_GROUP_ID
, REFERENCE_1
, REFERENCE_2
, RECEIPT_VERIFIED_FLAG
, RECEIPT_REQUIRED_FLAG
, RECEIPT_MISSING_FLAG
, JUSTIFICATION
, EXPENSE_GROUP
, START_EXPENSE_DATE
, END_EXPENSE_DATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT
, DAILY_AMOUNT
, WEB_PARAMETER_ID
, ADJUSTMENT_REASON
, MERCHANT_DOCUMENT_NUMBER
, MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY
, CREDIT_CARD_TRX_ID
, COMPANY_PREPAID_INVOICE_ID
, CC_REVERSAL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, LINE_SELECTED_FOR_APPL_FLAG
, PREPAY_APPL_REQUEST_ID
, APPLICATION_ID
, PRODUCT_TABLE
, REFERENCE_KEY1
, REFERENCE_KEY2
, REFERENCE_KEY3
, REFERENCE_KEY4
, REFERENCE_KEY5
, PURCHASING_CATEGORY_ID
, COST_FACTOR_ID
, CONTROL_AMOUNT
, ASSESSABLE_VALUE
, TOTAL_REC_TAX_AMOUNT
, TOTAL_NREC_TAX_AMOUNT
, TOTAL_REC_TAX_AMT_FUNCL_CURR
, TOTAL_NREC_TAX_AMT_FUNCL_CURR
, INCLUDED_TAX_AMOUNT
, PRIMARY_INTENDED_USE
, TAX_ALREADY_CALCULATED_FLAG
, SHIP_TO_LOCATION_ID
, PRODUCT_TYPE
, PRODUCT_CATEGORY
, PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY
, SUMMARY_TAX_LINE_ID
, TAX_REGIME_CODE
, TAX
, TAX_JURISDICTION_CODE
, TAX_STATUS_CODE
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE
, TAX_CODE_ID
, HISTORICAL_FLAG
, TAX_CLASSIFICATION_CODE
, SOURCE_APPLICATION_ID
, SOURCE_EVENT_CLASS_CODE
, SOURCE_ENTITY_CODE
, SOURCE_TRX_ID
, SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE
, RETAINED_AMOUNT
, RETAINED_AMOUNT_REMAINING
, RETAINED_INVOICE_ID
, RETAINED_LINE_NUMBER
, LINE_SELECTED_FOR_RELEASE_FLAG
, LINE_OWNER_ROLE
, DISPUTABLE_FLAG
, RCV_SHIPMENT_LINE_ID
, AIL_INVOICE_ID
, AIL_DISTRIBUTION_LINE_NUMBER
, AIL_INVOICE_ID2
, AIL_DISTRIBUTION_LINE_NUMBER2
, AIL_INVOICE_ID3
, AIL_DISTRIBUTION_LINE_NUMBER3
, AIL_INVOICE_ID4
, PAY_AWT_GROUP_ID
, MERCHANT_NAME#1
FROM AP.AP_INVOICE_LINES_ALL;
AP.AP_INVOICE_LINES_ALL does not reference any database object
AP.AP_INVOICE_LINES_ALL is referenced by following:
AP
AP_INVOICE_LINES_ALL#
|
|
|
|