Invoice Line

Defines information for the invoice lines such as amount, distribution set information, tax determinants, as well as default information to create invoice distributions.

QName: {http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInterfaceService/}InvoiceInterfaceLine

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

How the service data object is related to other service data objects or busine object services
Relationship Type Object or Service

Contained by

Invoice Header

Handled by

Payables Invoice

Attributes

The following table describes attributes in the service data object.

Attributes in the service data object
Name Type Description

AccountSegment

string

Value for account segment of accounting flexfield. Payables overlays this value on the accounting flexfield during import.

AccountingDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Accounting date.

Amount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Line amount.

ApplicationId

long

Application identifier.

AssessableValue

decimal

User-enterable amount to be used as taxable basis.

AssetBookTypeCode

string

Asset book defaults to the distributions candidate for transfer to Oracle Fusion Assets.

AssetCategoryId

long

Asset category defaults to the distributions candidate for transfer to Oracle Fusion Assets.

AssetsTrackingFlag

boolean

Indicates if distribution line is tracked in Oracle Fusion Assets, valid values are Y or N.

Attribute1

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute10

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute11

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute12

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute13

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute14

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute15

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute2

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute3

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute4

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute5

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute6

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute7

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute8

string

Descriptive Flexfield: segment of the user descriptive flexfield.

Attribute9

string

Descriptive Flexfield: segment of the user descriptive flexfield.

AttributeCategory

string

Descriptive Flexfield: structure definition of the user descriptive flexfield.

AwardId

long

Grants requirement to store award.

AwtGroupId

long

Withholding tax group identifier.

AwtGroupName

string

Withholding tax group name.

BalancingSegment

string

Value for balancing segment of accounting flexfield. Payables overlays this value on the accounting flexfield during import.

BudgetDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Budgetary calendar period date applicable for funds check.

ConsumptionAdviceHeaderId

long

Consumption advice header identifier. Used for consumption advice matching.

ConsumptionAdviceLineId

long

Consumption advice line identifier. Used for consumption advice matching.

ConsumptionAdviceLineNumber

int

Consumption advice line number. Used for consumption advice matching.

ConsumptionAdviceNumber

string

Consumption advice number. Used for consumption advice matching.

ControlAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Optional, user-enterable value to ensure that the calculated tax is the same as the physical document.

CostCenterSegment

string

Value for cost center segment of accounting flexfield. Payables overlays this value on the accounting flexfield during import.

CostFactorId

long

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.

CostFactorName

string

Cost component class name. 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.

CreditCardTrxId

long

Credit card transaction ID if the line is a credit card charge.

DefAcctgEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The end date of the deferred expense period.

DefAcctgNumberOfPeriods

decimal

Number of periods to generate deferred expenses. Used in combination with DefAcctgPeriodType. Alternative to DefAcctgEndDate.

DefAcctgPeriodType

string

Period type used in combination with DefAcctgNumberOfPeriods to generate deferred expenses.

DefAcctgStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The start date of the deferred expense period.

DefaultDistCcid

long

Already addressed by lines project tax driver: Code combination identifier of the GL account associated with the transaction line. Note that this is necessary to support the Account Method VAT feature.

DeferredAccountingFlag

boolean

Indicates whether to generate deferred accounting for this line.

Description

string

Invoice line description.

DistCodeCombinationId

long

Accounting flexfield identifier for account associated with a distribution line.

DistCodeConcatenated

string

Accounting flexfield for account associated with a distribution line.

DistributionSetId

long

Distribution set identifier.

DistributionSetName

string

Distribution set name.

ExpenditureItemDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Project expenditure item date used to build default accounting flexfield.

ExpenditureOrganizationId

long

Identifier for project organization used to build default accounting flexfield.

ExpenditureType

string

Project expenditure type used to build default accounting flexfield.

ExternalDocumentLineReference

string

Internal document reference number from Oracle Fusion Receivables. Used for XML invoices.

FinalDischargeLocationCode

string

Final discharge location code.

FinalDischargeLocationId

long

Final discharge location identifier.

FinalMatchFlag

boolean

Final match indicator for distribution line matched to purchase order.

GlobalAttribute1

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute10

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute11

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute12

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute13

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute14

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute15

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute16

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute17

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute18

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute19

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute2

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute20

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute3

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute4

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute5

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute6

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute7

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute8

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttribute9

string

Global Descriptive Flexfield: segment of the global descriptive flexfield.

GlobalAttributeCategory

string

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

IncludedInTaxableLineFlag

boolean

Indicates whether the amount in the tax line is included or not in the taxable line.

IncomeTaxRegion

string

Reporting region for distribution line for 1099 supplier.

InventoryItemId

long

Inventory item identifier.

InvoiceLineId

long

Invoice line identifier.

Keys

  • Primary Key

InvoicedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Quantity invoiced against purchase order shipment.

ItemDescription

string

Inventory item description.

LineGroupNumber

int

Value to identify each item line to which you want to prorate.

LineNumber

int

Invoice line number.

LineTypeLookupCode

string

Type of invoice line such as item, freight, tax, or miscellaneous.

Manufacturer

string

Name of the manufacturer.

MatchOption

string

The value of the Invoice Match option on the PO shipment.

ModelNumber

string

Model information.

OrgId

long

Indicates the identifier of the business unit associated to the row.

PODistributionId

long

Purchase order distribution line identifier used for PO matching.

PODistributionNumber

int

Purchase order distribution line number used for PO matching.

POHeaderId

long

Purchase order header identifier used for PO matching.

POLineId

long

Purchase order line identifier used for PO matching.

POLineLocationId

long

Purchase order line location identifier used for PO matching.

POLineNumber

decimal

Purchase order line number used for PO matching.

PONumber

string

Purchase order number used for PO matching.

POReleaseId

long

Blanket purchase order release identifier used for PO matching.

POShipmentNumber

decimal

Purchase order shipment number used for PO matching.

PaAdditionFlag

boolean

Indicates whether project related invoice distributions have been transferred into Oracle Fusion Projects with values of Y or N.

PaCcArInvoiceId

long

Identifier of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.

PaCcArInvoiceLineNumber

int

Line number of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.

PaCcProcessedCode

string

Indicates the processing status of this invoice line by Oracle Fusion Projects in the receiver operating unit.

PaQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Project item quantity used to build accounting flexfield for project related distribution line.

PackingSlip

string

Packing slip identifier.

PjcExpenditureTypeName

string

Project expenditure type name.

PjcOrganizationName

string

Project organization name.

PjcProjectName

string

Project name.

PjcProjectNumber

string

Project number.

PjcTaskNumber

string

Project task number.

PriceCorrectInvoiceLineNumber

int

Invoice line subject to the price correction.

PriceCorrectInvoiceNumber

string

Number of the invoice that this price correction invoice is correcting.

PriceCorrectionFlag

boolean

Indicates whether line produces price correction.

PrimaryIntendedUse

string

Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level.

ProductCategory

string

Tax Driver: Product category.

ProductFiscClassification

string

Tax Driver: Product fiscal classification.

ProductTable

string

Product source table name.

ProductType

string

Tax Driver: Type of product. Possible values are: Goods or Service. This value populates from the Inventory item attributes. Otherwise, the value is entered by the user.

ProjectBillableFlag

boolean

Indicates whether a project related item is available to be billed to customers.

ProjectCapitalizableFlag

boolean

Indicates whether a project related item is eligible for capitalization.

ProjectContextCategory

string

Segment used to identify the descriptive flexfield application context for project related standardized code collection.

ProjectContractId

decimal

Contract Identified. Used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

ProjectContractLineId

decimal

Tracks contract line information. Used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

ProjectExpenditureItemDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date on which a project related transaction is incurred.

ProjectExpenditureTypeId

decimal

Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.

ProjectFundingAllocationId

decimal

Specifies the name of the project funding override.

ProjectId

long

Identifier for project used to build default accounting flexfield.

ProjectOrganizationId

decimal

Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.

ProjectProjectId

decimal

Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions.

ProjectReservedAttribute1

string

Reserved for future project related functionality.

ProjectReservedAttribute10

string

Reserved for future project related functionality.

ProjectReservedAttribute2

string

Reserved for future project related functionality.

ProjectReservedAttribute3

string

Reserved for future project related functionality.

ProjectReservedAttribute4

string

Reserved for future project related functionality.

ProjectReservedAttribute5

string

Reserved for future project related functionality.

ProjectReservedAttribute6

string

Reserved for future project related functionality.

ProjectReservedAttribute7

string

Reserved for future project related functionality.

ProjectReservedAttribute8

string

Reserved for future project related functionality.

ProjectReservedAttribute9

string

Reserved for future project related functionality.

ProjectTaskId

decimal

Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.

ProjectUserDefineAttribute1

string

Reserved for user-defined project information.

ProjectUserDefineAttribute10

string

Reserved for user-defined project information.

ProjectUserDefineAttribute2

string

Reserved for user-defined project information.

ProjectUserDefineAttribute3

string

Reserved for user-defined project information.

ProjectUserDefineAttribute4

string

Reserved for user-defined project information.

ProjectUserDefineAttribute5

string

Reserved for user-defined project information.

ProjectUserDefineAttribute6

string

Reserved for user-defined project information.

ProjectUserDefineAttribute7

string

Reserved for user-defined project information.

ProjectUserDefineAttribute8

string

Reserved for user-defined project information.

ProjectUserDefineAttribute9

string

Reserved for user-defined project information.

ProjectWorkTypeId

decimal

Identifier for project related classification of the worked performed.

ProrateAcrossFlag

boolean

Prorate indicator for this line to be prorated across all lines with the same LineGroupNumber.

PurchasingCategory

string

Item category concatenated segments.

PurchasingCategoryId

long

Item category unique identifier.

RcvTransactionId

long

Receipt identifier used for receipt matching.

ReceiptLineNumber

string

The receipt line number used to match to an invoice.

ReceiptNumber

string

The receipt number used to match to an invoice.

Reference1

string

A reference to a record in another application.

Reference2

string

A reference to a record in another application.

ReferenceKey1

string

Primary key information that uniquely identifies a record in other products view.

ReferenceKey2

string

Primary key information that uniquely identifies a record in other products view.

ReferenceKey3

string

Primary key information that uniquely identifies a record in other products view.

ReferenceKey4

string

Primary key information that uniquely identifies a record in other products view.

ReferenceKey5

string

Primary key information that uniquely identifies a record in other products view.

ReleaseNumber

int

Blanket purchase order release number used for PO matching.

RequesterEmployeeNumber

string

The employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.

RequesterFirstName

string

The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.

RequesterId

long

Requester identifier. Valid values from active HR employees.

RequesterLastName

string

The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.

SerialNumber

string

Serial number for item.

ShipFromLocationCode

string

Ship-from location code.

ShipFromLocationId

long

Ship-from location identifier.

ShipToLocationCode

string

Ship to location code.

ShipToLocationId

long

Tax Driver: Ship-to location ID. Value entered by user only if line is not PO matched.

SourceApplicationId

long

Source document application identifier.

SourceEntityCode

string

Source document entity code.

SourceEventClassCode

string

Source document event class code.

SourceLineId

long

Identifier of the lowest level for which tax is calculated.

SourceTrxId

long

Source document transaction identifier.

SourceTrxLevelType

string

Source document transaction level type.

StatisticalAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Amount associated with a distribution line for measuring statistical quantities.

TaskId

long

Identifier for project task used to build default accounting flexfield.

Tax

string

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

TaxClassificationCode

string

Tax classification code.

TaxCode

string

Tax code.

TaxCodeId

long

Tax code identifier for the tax code to be used.

TaxJurisdictionCode

string

Internal ID of the tax jurisdiction.

TaxRate

decimal

The rate specified for a tax status in effect for a period of time.

TaxRateCode

string

Tax rate name associated with tax rate identifier. TaxRateId is unique while a TaxRateCode may have different tax rates based on date ranges.

TaxRateId

long

Internal identifier for tax rate effective on the invoice date.

TaxRegimeCode

string

The set of tax rules that determines the treatment of one or more taxes administered by a tax authority, such as VAT Regime in Argentina.

TaxStatusCode

string

Tax status code with possible values of taxable standard rate, zero rated, exempt, or nontaxable.

TaxableFlag

boolean

A value of Y indicates that the line is taxable.

TrxBusinessCategory

string

Tax Driver: Transactions category assigned by user.

Type1099

string

1099 type.

USSGLTransactionCode

string

USSGL transaction code for creating US Standard General Ledger journal entries for Oracle Fusion Public Sector Payables.

UnitOfMeasLookupCode

string

Unit of Measure for quantity invoiced

UnitPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Unit price for purchase order matched invoice items.

UserDefinedFiscClass

string

Tax Driver: Fiscal classification.

VendorItemNumber

string

Supplier item number.

WarrantyNumber

string

Warranty number.