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.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes 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. |
|
DefAccrualCodeConcatenated |
string |
Concatenated string for Accrual Account |
|
DefAcctgAccrualCcid |
long |
Accrual Account that is initially debited for deferred expenses |
|
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.
|
|
InvoiceLineRejection |
Invoice line rejection. |
|
|
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. |
|
PjcContractName |
string |
Contract name used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed. |
|
PjcContractNumber |
string |
Contract number used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed. |
|
PjcExpenditureTypeName |
string |
Project expenditure type name. |
|
PjcFundingSourceName |
string |
Name of the source funding the project. |
|
PjcFundingSourceNumber |
string |
Number of the source funding the project. |
|
PjcOrganizationName |
string |
Project organization name. |
|
PjcProjectName |
string |
Project name. |
|
PjcProjectNumber |
string |
Project number. |
|
PjcTaskName |
string |
Name of the task used to build the transaction descriptive flexfield for project-related transaction distributions. |
|
PjcTaskNumber |
string |
Project task number. |
|
PjcWorkType |
string |
Classification of project-related work performed. |
|
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. |