PayablesInvoiceLine

An invoice line represents a specific item or charge listed on an invoice. It provides a detailed breakdown of the products, services, or expenses included in the invoice, along with their respective quantities, unit prices, and total amounts. Invoice lines record 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.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesInvoiceLinesExtract**

  An invoice line represents a specific item or charge listed on an invoice. It provides a detailed breakdown of the products, services, or expenses included in the invoice, along with their respective quantities, unit prices, and total amounts. Invoice lines record 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.

  Label, Plural Label

  Payables Invoice Line, Payables Invoice Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountSegment (string)

    The overlay account segment value overwrites the defaulted account segment value for an invoice line. The account segment is that part of the distribution combination that determines whether an account is an asset, liability, owner's equity, revenue, or expense account.

    Label

    Overlay Account Segment

  • accountingDate (date)

    The accounting date for the invoice line. It's used to default the accounting date to invoice distributions.

    Label

    Invoice Line Accounting Date

    Properties

    • searchable
    • not nullable
  • adjustmentReason (string)

    The reason for the invoice line adjustment.

    Label

    Invoice Line Adjustment Reason

  • assessableValue (big-decimal)

    The deemed price at which a product is valued by a tax authority, for tax calculation purposes.

    Label

    Assessable Value

  • assetBookTypeCode (string)

    The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets.

    Label

    Asset Book

  • assetsTrackingFlag (boolean)

    Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value if true, then it indicates the item should be transferred to Oracle Fusion Assets.

    Label

    Track as Asset

  • balancingSegment (string)

    The overlay balancing segment overwrites the defaulted balancing segment for an invoice line. A balancing segment is a segment that you define so that Oracle Fusion General Ledger automatically balances all journal entries for each value of this segment.

    Label

    Overlay Primary Balancing Segment

  • baseAmount (big-decimal)

    The invoice line amount in the ledger currency.

    Label

    Accounted Amount

  • budgetDate (date)

    The budgetary calendar period date applicable for funds checking.

    Label

    Budget Date

  • cancelledFlag (boolean)

    Indicates whether an invoice line is canceled. Possible values are null, Y or N. If the value is Y, then it indicates that the line has been canceled.

    Label

    Cancellation Status

  • controlAmount (big-decimal)

    The user-entered value to ensure that the calculated tax will be the same as the tax on the physical document.

    Label

    Tax Control Amount

  • costCenterSegment (string)

    The overlay cost center segment overwrites the defaulted cost center segment for an invoice line. The cost center segment is an organizational element of a chart of accounts typically used for assigning revenues and expenses.

    Label

    Overlay Cost Center Segment

  • countryOfSupply (string)

    The country where services or goods were originated. Used for expense reports.

    Label

    Country of Supply

  • createdBy (string)

    The user who created the invoice line.

    Label

    Created By

    Properties

    • not nullable
  • creditCardReversalFlag (boolean)

    Indicates if the prepaid credit card transaction line distributions are reversed or not. A value of Y indicates that the distributions are reversed.

    Label

    Credit Card Reversal

  • deferredAccountingEndDate (date)

    The multiperiod accounting end date on the invoice line.

    Label

    Multiperiod Accounting End Date

  • deferredAccountingFlag (boolean)

    Indicates whether the expense is allocated across multiple accounting periods.

    Label

    Deferred Accounting Option

  • deferredAccountingNumberOfPeriods (big-decimal)

    The number of periods for multiperiod accounting to accrue deferred expenses.

    Label

    Number of Periods

  • deferredAccountingPeriodType (string)

    The period type for multiperiod accounting to accrue deferred expenses.

    Label

    Period Type

  • deferredAccountingStartDate (date)

    The multiperiod accounting start date on the invoice line.

    Label

    Multiperiod Accounting Start Date

  • discardedFlag (boolean)

    Indicates that the line is canceled when an invoice is canceled. When a line is canceled all its distributions are reversed and the amount is set to 0. The default value is false. If the value is true, then it indicates that the line has been canceled.

    Label

    Discarded

  • disputableFlag (boolean)

    Indicates whether the line is disputable.

    Label

    Disputable

  • finalMatchStatus (enumeration: FinalMatchStatus)

    Indicates if an invoice is the last one being matched to a purchase order, making the purchase order schedule no longer available for matching to other invoices. A value of Y indicates the purchase order schedule is finally closed and invoices can no longer be matched to it.

    Label

    Final Match

    Type

    • Module: oraErpCorePayablesInvoices

    • Enumeration Type: FinalMatchStatus

    Valid Values

    • D
    • N
    • R
    • Y
  • fiscalChargeType (string)

    The subclassification for an invoice line type of Freight or Miscellaneous.

    Label

    Fiscal Charge Type

  • generateDistributions (string)

    Indicates whether distributions for the invoice line should be generated dynamically whenever possible.

    Label

    Generate Distributions

  • includedOnInvoiceFlag (boolean)

    Indicates whether the prepayment is included in the invoice amount. Possible values are Y and N. A value of Y indicates that prepayment is included.

    Label

    Included on Invoice

  • includedTaxAmount (big-decimal)

    The amount of tax that's included in the invoice.

    Label

    Included Tax Amount

  • incomeTaxRegion (string)

    The reporting region for the invoice line for the 1099 supplier.

    Label

    Income Tax Region

  • intendedUseIdentifer (int64)

    The identifier of the tax driver used to determine and calculate the applicable taxes for the line.

  • interfacedToSupplyChainFinancialOrchestrationFlag (boolean)

    Indicates whether the invoice line information has been interfaced to Supply Chain Financial Flow Orchestration.

    Label

    Supply Chain Financial Flow Orchestration Validation Status Interface Indicator.

  • invoiceId (int64)

    The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.

    Label

    Invoice ID

    Properties

    • searchable
    • sortable
    • not nullable
  • invoiceLineDescription (string)

    The description of the invoice line.

    Label

    Invoice Line Description

  • itemDescription (string)

    The description of the item on the invoice line.

    Label

    Item Description

  • landedCostManagementEnabledFlag (boolean)

    Indicates if the invoice line is enabled for landed cost.

    Label

    Landed Cost Enabled

  • lineAmount (big-decimal)

    The line amount in the invoice currency.

    Label

    Amount

    Properties

    • not nullable
  • lineGroupNumber (big-decimal)

    The line group number assigned to the line during the Import Payables Invoices process. This is used for allocation of charge lines during the import process.

    Label

    Line Group Number

  • lineNumber (int64)

    The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.

    Label

    Number

    Properties

    • searchable
    • sortable
    • not nullable
  • lineOwnerRole (string)

    The owner of invoice line derived by AME rule.

    Label

    Invoice Line Owner

  • lineSelectedForPrepaymentApplicationFlag (boolean)

    Indicates if the line on the prepayment invoice is selected for prepayment application.

    Label

    Line Selected for Prepayment Application

  • lineSelectedForReleaseFlag (boolean)

    Indicates that the invoice line is being processed for retainage release. A value of Y indicates that the line is under processing.

    Label

    Line Selected for Release

  • manufacturer (string)

    The name of the manufacturer of the asset or item on the invoice line.

    Label

    Manufacturer

  • merchantDocumentNumber (string)

    The number on the receipt issued by the merchant. Used for expense reports.

    Label

    Merchant Document Number

  • merchantName (string)

    Name of the merchant where the expense was incurred. Used for expense reports.

    Label

    Merchant Name

  • merchantReference (string)

    Purchase identification of a transaction provided by the merchant at the point of sale. Used for expense reports.

    Label

    Merchant Reference

  • merchantTaxRegistrationNumber (string)

    Unique sequence of letters or numbers assigned to the merchant by a tax authority when it's registered and by which the merchant registration is identified.

    Label

    Merchant Tax Registration Number

  • merchantTaxpayerIdentificationNumber (string)

    The unique identifier of the merchant tax payer.

    Label

    Merchant Taxpayer ID

  • modelNumber (string)

    The model number of the invoice line item.

    Label

    Model

  • originalAmount (big-decimal)

    The original amount of the invoice line before the line or invoice was canceled.

    Label

    Original Amount

  • originalBaseAmount (big-decimal)

    The original amount of the invoice line before the line or invoice was canceled in the ledger currency.

    Label

    Original Accounted Amount

  • originalRoundingAmount (big-decimal)

    The rounding amount of the invoice line before it was canceled.

    Label

    Original Rounding Amount

  • overlayDistributionCodeConcatenated (string)

    The distribution combination that overwrites the intended distribution combination for an invoice line.

    Label

    Overlay Distribution

  • periodName (string)

    The accounting period for the invoice line.

    Label

    Period Name

  • prepaymentApplicationRequestIdentifer (int64)

    The request identifier of the Import Payables Invoices process that's used to lock a particular invoice line in the database while processing it.

  • primaryIntendedUse (string)

    A tax driver used to determine and calculate the applicable taxes for the line.

    Label

    The intended use of an inventory item or noninventory-based product fiscal classification, when the intended use is a factor either in tax determination or tax recovery.

  • productCategory (string)

    The taxable nature of a noninventory based item to determine tax or tax reporting purposes.

    Label

    Product Category

  • productFiscalClassification (string)

    The tax classification used by a tax authority to categorize a product.

    Label

    Product Fiscal Classification for the invoice line.

  • productTable (string)

    The name of the product source table used for generating the invoice line. This is used during Import Payables Invoices process.

    Label

    Product Table

  • productType (string)

    The type of product that defaults from the inventory item attributes. Possible values are Goods or Services.

    Label

    Product Type

  • projectsProcessingStatus (string)

    The processing status of the invoice line by Oracle Fusion Projects in the receiving business unit.

    Label

    Intercompany Receivables Invoice Processed Code

  • projectsQuantity (big-decimal)

    The quantity billed to a project.

    Label

    Quantity billed to a project.

  • projectsReceivableIntercompanyInvoiceLineNumber (int64)

    For an intercompany invoice from Oracle Fusion Projects, this is the line number of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.

    Label

    Intercompany Invoice Line

    Properties

    • not nullable
  • prorateAcrossAllItemsFlag (boolean)

    Indicates that the Freight or Miscellaneous type line should be prorated across all existing Item type lines. The default value is false. If the value if true, then it indicates the charge line should be prorated across all item type lines.

    Label

    Prorate Across All Item Lines

  • quantityInvoiced (big-decimal)

    The quantity of items invoiced including matched invoice lines, price corrections, quantity corrections, and unmatched invoice lines.

    Label

    Quantity

  • referenceKey1 (string)

    The primary key information that uniquely identifies a record in another product's view.

    Label

    Reference Key 1

  • referenceKey2 (string)

    This is the invoice line reference key 2. Primary key information that will uniquely identify a record in other products view.

    Label

    Reference Key 2

  • referenceKey3 (string)

    This is the invoice line reference key 3. Primary key information that will uniquely identify a record in other products view.

    Label

    Reference Key 3

  • referenceOne (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 1

  • referenceTwo (string)

    The reference information from the Oracle Projects expense reports.

    Label

    Reference 2

  • requestIdentifier (int64)

    Properties

    • not nullable
  • retainedAmount (big-decimal)

    Retained amount on the invoice line of the standard invoice.

    Label

    Retainage

  • retainedAmountRemaining (big-decimal)

    Retained amount available for release on the standard invoice line.

    Label

    Retainage Remaining

  • roundingAmount (big-decimal)

    The amount that was added to the line to ensure that the total of the line amounts add up to the invoice amount in ledger currency.

    Label

    Rounding Amount

  • serialNumber (string)

    The serial number of an asset or item on the invoice line.

    Label

    Serial Number

  • sourceDocumentTransactionLevelType (string)

    The level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

    Label

    Source Transaction Level Type

  • sourceEntityCode (string)

    Indicates the source of the invoice lines. This is used during Import Payables Invoices process.

    Label

    Source Entity Code

  • sourceEventClassCode (string)

    The class code of the source document event.

    Label

    Source Event Class Code

  • statisticalAmount (big-decimal)

    The amount associated with a distribution for measuring statistical quantities.

    Label

    Statistical Quantity

  • tax (string)

    The classification of a charge imposed by a government through a fiscal or tax authority.

    Label

    Tax Name

  • taxAlreadyCalculatedFlag (boolean)

    Identifies whether tax has already been calculated for the invoice line.

    Label

    Tax Already Calculated Indicator

  • taxClassificationCode (string)

    The tax classification code used for tax calculation.

    Label

    Tax Classification

  • taxJurisdictionCode (string)

    The code of the tax jurisdiction associated with the tax rate on the invoice line.

    Label

    Tax Jurisdiction Code

  • taxRate (big-decimal)

    The rate specified for a tax rate name.

    Label

    Rate

  • taxRateCode (string)

    The tax rate code associated with the tax rate identifier.

    Label

    Tax Rate Code

  • taxStatusCode (string)

    The code of the tax status associated with the tax rate on the invoice line.

    Label

    Tax Status

  • timeCreated (date-time)

    The date and time when the invoice line was created.

    Label

    Time Created

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the invoice line was last updated.

    Label

    Last Update Date

    Properties

    • searchable
    • not nullable
  • totalNonRecoverableTaxAmount (big-decimal)

    The total nonrecoverable tax allocated to this taxable invoice line.

    Label

    Total Nonrecoverable Tax Amount

  • totalNonRecoverableTaxAmountFunctionalCurrency (big-decimal)

    The total nonrecoverable tax amount in the ledger currency.

    Label

    Total Nonrecoverable Tax Amount Ledger Currency

  • totalRecoverableTaxAmount (big-decimal)

    The total recoverable tax allocated to this taxable invoice line.

    Label

    Total Recoverable Tax Amount

  • totalRecoverableTaxAmountFunctionalCurrency (big-decimal)

    The total recoverable tax amount in ledger currency.

    Label

    Total Recoverable Tax Amount in Ledger Currency

  • transactionBusinessCategory (string)

    The transaction category assigned to the invoice line. Used to identify and classify business transactions for the purpose of tax calculation.

    Label

    Transaction Business Category

  • unitPrice (big-decimal)

    The unit price of a good or service.

    Label

    Unit Price

  • updatedBy (string)

    The use who last updated the invoice line.

    Label

    Last Updated By

    Properties

    • not nullable
  • userDefinedFiscalClassification (string)

    A classification for any tax requirement that you can't define using the existing fiscal classification types.

    Label

    User-Defined Fiscal Classification

  • warrantyNumber (string)

    The warranty number of the item on the invoice line.

    Label

    Warranty Number

  Expand all

  Collapse all

  Reference Object

  • application (TaxonomyNode)

    The unique identifier of the application from where the invoice originated.

    Business Object

    TaxonomyNode

    Expand all

    Collapse all

    Fields

    • alternativeId (int64)

      The alternative identifier of the taxonomy node.

      Label

      Alternative ID

      Properties

      • searchable
      • sortable
      • not nullable

  • assetCategory (AssetAbstractCategory)

    A category represents the classification of assets, such as buildings, computer equipment, furniture and fixtures, and land. Assets are grouped based on the financial accounts and depreciation rules.

    Business Object

    AssetAbstractCategory

    Expand all

    Collapse all

    Fields

    • categoryId (int64)

      The identifier of the asset category.

      Label

      Category ID

      Properties

      • searchable
      • sortable
      • not nullable

  • automaticWithholdingTaxGroup (PayablesAutomaticTaxWithholdingGroup)

    The automatic tax withholding group contains withholding tax groups. Each withholding tax group contains one or more withholding tax codes.

    Business Object

    PayablesAutomaticTaxWithholdingGroup

    Expand all

    Collapse all

    Fields

    • groupId (int64)

      The unique identifier for the withholding tax group.

      Label

      Group ID

      Properties

      • searchable
      • sortable
      • not nullable

  • companyPrepaidInvoice (PayablesInvoiceTransaction)

    The identifier of the invoice for prepaid credit card transactions.

    Business Object

    PayablesInvoiceTransaction

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique identifier of the invoice that's generated while creating the invoice.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceNumber (string)

      The unique number for supplier invoice.

      Label

      Invoice Number

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceTypeDiscriminator (string)

      The discriminator to distinguish Payables Invoice and Payment Request subtypes.

      Label

      Discriminator

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
      • updatable

  • consumptionAdvice (ConsumptionAdviceHeader)

    The identifier of the consignment advice associated with the invoice line.

    Business Object

    ConsumptionAdviceHeader

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely describes the consumption advice header ID.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • consumptionAdviceLine (ConsumptionAdviceLine)

    The identifier of the consignment advice line associated with the invoice line.

    Business Object

    ConsumptionAdviceLine

    Expand all

    Collapse all

    Fields

    • lineId (int64)

      Value that uniquely describes the consumption advice line ID.

      Label

      Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • correctedInvoiceLine (PayablesInvoiceLine)

    The identifier of the invoice corrected by this invoice line. Used for price, quantity, or invoice line corrections.

    Business Object

    PayablesInvoiceLine

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • lineNumber (int64)

      The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Number

      Properties

      • searchable
      • sortable
      • not nullable

  • creditCardTransaction (CorporateCardTransaction)

    The identifier of the credit card transaction.

    Business Object

    CorporateCardTransaction

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the corporate card transaction.

      Label

      Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • defaultDistributionAccount (GeneralLedgerAccount)

    The accounting flexfield used for automatic generation of a single distribution.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

  • deferredAccount (GeneralLedgerAccount)

    The accrual account used in multiperiod accounting to accrue deferred expenses.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

  • distributionSet (PayablesDistributionSet)

    The distribution set represents a collection of invoices for automatic distribution.

    Business Object

    PayablesDistributionSet

    Expand all

    Collapse all

    Fields

    • distributionSetId (int64)

      The unique identifier of an invoice distribution set.

      Label

      Distribution Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • expenditureBusinessUnit (BusinessUnit)

    The identifier for the project expenditure organization associated with the invoice distribution.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • finalDischargeLocation (Location)

    The location of the final destination for the purchases made.

    Business Object

    Location

    Expand all

    Collapse all

    Fields

    • id (int64)

      Foreign key to the FA_LOCATIONS table.

      Label

      Location ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fiscalCategory (Category)

    The tax classification used by a tax authority to categorize a product.

    Business Object

    Category

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs.

      Label

      Item Category

      Properties

      • searchable
      • sortable
      • not nullable

  • fundsStatus (StandardLookupCode)

    The status of the funds check and reservation for the invoice line. A list of accepted values is defined in the lookup type XCC_BC_FUNDS_STATUSES.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceHeader (PayablesInvoiceTransaction)

    An invoice transaction represents details of all the transactions related to purchases made for producing goods and services or managing business operations, excluding payment requests, taxes, joint ventures, and intercompany transactions.

    Business Object

    PayablesInvoiceTransaction

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique identifier of the invoice that's generated while creating the invoice.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceNumber (string)

      The unique number for supplier invoice.

      Label

      Invoice Number

      Properties

      • searchable
      • sortable
      • not nullable
    • invoiceTypeDiscriminator (string)

      The discriminator to distinguish Payables Invoice and Payment Request subtypes.

      Label

      Discriminator

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
      • updatable

  • invoiceLineMatchType (ERPLookupCode)

    Indicates whether the invoice line is matched to a purchase order or to a receipt of material.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceLineSource (ERPLookupCode)

    The source of the invoice line. A list of accepted values is defined in the lookup type LINE SOURCE.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceLineType (ERPLookupCode)

    Type of the invoice line. Valid values are Item, Freight, Tax, and Miscellaneous.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • item (Item)

    The identifier of the inventory item on the invoice line.

    Business Object

    Item

    Expand all

    Collapse all

    Fields

    • itemId (int64)

      Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.

      Label

      Item

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • lineApprovalStatus (ERPLookupCode)

    Approval status associated with the invoice line, as determined by the invoice approval workflow.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • matchedUnitOfMeasure (UnitOfMeasure)

    The unit of measure used for the invoiced quantity when this distribution is matched.

    Business Object

    UnitOfMeasure

    Expand all

    Collapse all

    Fields

    • code (string)

      User-supplied short code that identifies the unit of measure. This attribute is required.

      Label

      Code

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • order (Order)

    The identifier of the purchase order document number that's matched to the invoice line.

    Business Object

    Order

    Expand all

    Collapse all

    Fields

    • orderHeaderId (int64)

      Value that uniquely identifies the purchase order header.

      Label

      Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • payablesIncomeTaxType (Payables1099IncomeTaxType)

    The 1099 income tax type represents a certain type of nonemployment income tax assigned to a supplier.

    Business Object

    Payables1099IncomeTaxType

    Expand all

    Collapse all

    Fields

    • incomeTaxType (string)

      The type of income tax.

      Label

      Income Tax Type

      Properties

      • searchable
      • sortable
      • not nullable

  • prepayInvoice (PayablesInvoiceLine)

    The identifier of the prepayment invoice applied to the invoice line.

    Business Object

    PayablesInvoiceLine

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • lineNumber (int64)

      The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Number

      Properties

      • searchable
      • sortable
      • not nullable

  • project (Project)

    The unique identifier of the project associated with the invoice distribution.

    Business Object

    Project

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the project.

      Label

      Project ID

      Properties

      • searchable
      • sortable
      • not nullable

  • purchaseOrderDistribution (OrderDistribution)

    Specifies the allocation or distribution of the total value of a purchase order schedule across cost centers, or accounts within an organization.

    Business Object

    OrderDistribution

    Expand all

    Collapse all

    Fields

    • poDistributionId (int64)

      Value that uniquely identifies the purchase order distribution.

      Label

      Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • purchaseOrderLine (OrderLine)

    Details of the goods or services to be purchased from the supplier including the item to purchase, unit of measure, price, and quantity.

    Business Object

    OrderLine

    Expand all

    Collapse all

    Fields

    • orderLineId (int64)

      Value that uniquely identifies the purchase order or agreement line.

      Label

      Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • purchaseOrderLocation (OrderSchedule)

    Shipping and delivery details for the ordered items such as promised delivery date, requested delivery date, and ship-to location.

    Business Object

    OrderSchedule

    Expand all

    Collapse all

    Fields

    • scheduleId (int64)

      Value that uniquely identifies the document shipment schedule.

      Label

      Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • purchasingCategory (Category)

    The unique identifier for the item category.

    Business Object

    Category

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs.

      Label

      Item Category

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptCurrency (Currency)

    The line amount in the expense receipt currency. Used for expense reports.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • receivingShipmentLine (ReceivingShipmentLine)

    The unique identifier of the receipt shipment line. This is used for receipt matching for the invoice line.

    Business Object

    ReceivingShipmentLine

    Expand all

    Collapse all

    Fields

    • lineId (int64)

      Value that uniquely identifies the shipment line.

      Label

      Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receivingTransaction (ReceivingTransaction)

    The unique identifier of the shipment receipt to which the invoice line is matched.

    Business Object

    ReceivingTransaction

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely describes the receiving transaction.

      Label

      ID

      Properties

      • searchable
      • sortable
      • not nullable

  • requestor (Worker)

    The name of the person who requested the goods or services.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • retainedInvoiceLine (PayablesInvoiceLine)

    The identifier of the original invoice on which the amount was retained. This attribute is populated for the invoice lines of the retainage release invoice.

    Business Object

    PayablesInvoiceLine

    Expand all

    Collapse all

    Fields

    • invoiceId (int64)

      The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable
    • lineNumber (int64)

      The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.

      Label

      Number

      Properties

      • searchable
      • sortable
      • not nullable

  • shipFromLocation (Address)

    The identifier of the ship-from location.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • shipToCustomerLocation (Address)

    Location to which the supplier should ship the goods.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • shipToLocation (Location)

    The identifier of the ship-to location. This refers to the location where the goods and services have been shipped to by the supplier.

    Business Object

    Location

    Expand all

    Collapse all

    Fields

    • id (int64)

      Surrogate identifier for the location.

      Label

      Location Identifier

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • summaryTaxLine (SummaryTaxLine)

    Summary tax line provides summarized information for transaction tax lines associated with a Payable transaction.

    Business Object

    SummaryTaxLine

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the summary tax line associated with this tax line.

      Label

      Summary Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxRegime (TaxRegime)

    The code of the tax regime associated with the tax rate on the invoice line.

    Business Object

    TaxRegime

    Expand all

    Collapse all

    Fields

    • code (string)

      A unique code for a tax regime. A tax regime is the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.

      Label

      Tax Regime Code

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top