1. SOAP Web Services for Sales and Fusion Service
  2. Contract Line

Contract Line

The contract line view object.

QName: {http://xmlns.oracle.com/apps/contracts/coreAuthoring/contractService/}ContractLine

Logical Business Objects

  • CRM : Enterprise Contracts : Contract

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

Contract Service Billing Summary

Contains

Contract Line

Contains

Pricing Terms Sales Agreement

Contains

Sales Credit

Contains

Contract Associated Project

Contains

Contract Billing Control

Contains

Contract Charge

Contains

Internal Contract Line Attributes SDO

Contains

Contract Covered Asset

Contains

Contract Line Language Translation

Contains

Contract Line Descriptive Flexfield Attributes

Contained by

Contract Line

Contained by

Contract

Handled by

Contract Service Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountRuleId

long

The unique identifier of the accounting rule used for service revenue recognition.

AccountRuleMeaning

string

The accounting rule used for service revenue recognition.

AdjustmentAmount

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

The adjustment amount on the contract line.

AdjustmentBasisCode

string

The adjustment basis code on the contract line.

AdjustmentBasisId

long

Adjustment Basis Id

AdjustmentType

string

The adjustment type on the contract line.

AdjustmentTypeCode

string

The adjustment type code on the contract line.

AgreedAmount

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

The agreed amount on the contract line.

AgreedQuantity

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

The agreed quantity on the contract line.

AgreementAmountLimit

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

The agreement amount limit on the contract line.

AgreementPriceLimit

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

The agreement price limit on the contract line.

AgreementPriceOverAllwdYn

string

The flag that denotes whether the agreement price can be overridden on the contract.

AgreementQuantityLimit

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

The agreement quantity limit on the contract line.

AgreementUnitPrice

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

The agreement unit price on the contract line.

AllowCustomAdjustmentsFlag

boolean

The flag that denotes whether custom adjustment is allowed.

AllowPricelistOverrideYn

string

An indicator to denote whether price list can be overridden on the contract.

AllowPromotionsYn

string

The flag that denotes whether promotions are allowed on the contract.

ArInterfaceYn

string

Indicates whether the billing information has been interfaced.

AssociatedProject

Contract Associated Project

The associated project on the contract line.

AtRiskYn

string

Indicates whether the contract is at risk.

AutoApplyStrategyPriceAdjustmentFlag

boolean

Auto Apply Strategy Price Adjustment Flag

BillPlan

string

The name of the bill plan.

BillPlanId

long

The unique identifier of the bill plan.

BillToAccount

string

The bill-to account where invoices are sent.

BillToAccountDescription

string

Bill To Account Description

BillToAccountId

long

The unique identifier of the bill-to account.

BillToAccountNumber

string

The number of the bill-to account where invoices are sent.

BillToAddress

string

The bill-to address where invoices are sent.

BillToSiteUseId

long

The unique identifier of the bill-to site where invoices are sent.

BillToSiteUseLocation

string

The bill-to site location where invoices are sent.

BillingControl

Contract Billing Control

The billing control element of the contract line.

BillingDateMethod

string

Billing Date type for Billing Schedule.

BillingFrequency

string

The code of the frequency in which service billing occurs.

BillingFrequencyMeaning

string

The frequency in which service billing occurs.

CancelledAmount

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

Cancelled Amount

CarrierId

long

The unique identifier of the carrier.

CarrierName

string

The name of the carrier.

CloseReason

string

The reason for closing the contract.

Cognomen

string

The contract line.

Comments

string

The comments for the record.

CommitLevel

string

The commit level for the contract line.

CommitLevelCode

string

The code associated with the commit level.

ContractAllLineDesFlexVA

Contract Line Descriptive Flexfield Attribute

The flex field element of the contract line.

ContractAllLine_2

Contract Line

The sub-line element of the contract.

ContractBillLine

Contract Service Billing Summary

Contract Bill Line

ContractCharge

Contract Charge

The charge associated with the contract.

ContractCoveredAsset

Contract Covered Asset

The asset covered by the contract.

ContractLineTranslation

Contract Line Language Translation

The contract line translation element.

ContractSubscriptionLineRenewalType

string

Contract Renewal Type

CoverageScheduleId

long

Coverage Schedule

CreditedAmount

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

Credited Amount

CustomerPONumber

string

The customer PO number.

DateTerminated

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

The date when the contract was terminated.

DeliveryDate

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

The date when the contract was delivered.

DurationQuantity

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

Duration

EndDate

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

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

EstimatedVariableConsiderationAmount

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

Estimated Variable Consideration Amount

ExemptCertificateNumber

string

The exempted certificate number.

ExemptReason

string

The reason why the contract was exempted.

ExemptReasonCode

string

The code associated with the exemption reason.

ExternalItemKey

string

The external item key.

ExternalItemReference1

string

The unique identifier of the override in the source application. Used to identify overrides created through external web services.

ExternalItemReference2

string

The unique identifier of the override in the source application. Used to identify overrides created through external web services.

ExternalItemReference3

string

The unique identifier of the override in the source application. Used to identify overrides created through external web services.

ExternalItemReference4

string

The unique identifier of the override in the source application. Used to identify overrides created through external web services.

ExternalItemReference5

string

The unique identifier of the override in the source application. Used to identify overrides created through external web services.

ExternalItemSource

string

The source of the external item.

ExternalKey

string

Used to identify external records that were imported.

ExternalSource

string

The source application where the contract line was created. Used to identify records created through external web services.

FOB

string

The FOB of the contract line.

FOBCode

string

The code identifying the FOB of the contract.

FixedPriceServiceYn

string

Indicates whether the contract supports fixed price service.

FloorPrice

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

The floor price of the contract.

FreightTerms

string

The freight terms associated with the contract.

FreightTermsCode

string

The code identifying the freight term.

GenerateBillingSchedule

string

Flag indicating whether billing schedules should be generated automatically or not.

HoldReason

string

The reason signifying why the contract is on hold.

HoldReasonCode

string

The code identifying the hold reason.

HoldReasonCodeSetId

long

The unique identifier of the hold reason code set.

HoldUntilDate

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

The date until which the contract is on hold.

Id

long

The unique identifier of the contract line.

InvTrxTypeId

long

The identifier of the invoice transaction type used for service billing.

InvoiceRuleId

long

The unique identifier of the invoice rule.

InvoiceRuleMeaning

string

The invoice rule used for service billing.

InvoiceText

string

The text for the invoice line that is interfaced for service billing.

InvoicedAmount

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

The amount as per the invoice.

ItemDescription

string

The description of the item.

ItemName

string

The name of the item.

ItemNameTxt

string

The free form name of the item.

ItemQuantity

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

The number of items.

LastRevenueRecogDate

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

The date when the revenue was last recognized.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Last Update Date

LineAmount

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

The amount in the contract line.

LineId

long
Line Id

  • Primary Key

LineNumber

string

The line number.

LinePuid

string

Line PUID

LineStatus

string

The status of the line.

LineSubTotal

decimal

Line SubTotal

LineTypeId

long

The unique identifier of the line type.

LineTypeName

string

The name of the line type.

LineValueAmount

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

The amount at the contract line.

ListPrice

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

The listed price.

MajorVersion

long

The major version of the record.

MinimumReleaseAmount

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

The minimum release amount.

MinimumReleaseQuantity

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

The minimum release quantity.

Object1Id1

long

The unique identifier of the item.

Object1Id2

long

The unique identifier of the item.

OrderId

long

The source system identifier of the order that created the contract line.

OrderLineId

long

The source system line identifier of the order that created the contract line.

OrderLineNumber

string

The source system line number of the order that created the contract line.

OrderNumber

string

The source system number of the order that created the contract line.

OrderSource

string

The source of the order that created the contract line.

OrigSystemReference

string

The identifier for the record from the original system.

OrigSystemSourceCode

string

The code identifying the originating system source.

OutputTaxClassMeaning

string

The output tax classification.

OutputTaxClassificationCode

string

The code identifying the output tax classification.

PaymentSetId

long

The unique identifier of the prepayment receipt.

PaymentTerms

string

The payment term.

PaymentTermsId

long

The unique identifier of the payment term.

PaymentTermsMeaning

string

The customer payment terms used for service billing.

PercentComplete

decimal

The percentage complete.

PriceApplicationRule

string

Price Application Rule

PriceAsOf

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

The date as of which a contract line or asset line is priced.

PriceBook

string

Price Book

PriceBookId

long

Price Book Id

PriceDuringBillingYn

string

Flag indicating whether the pricing should be done during the billing time.

PriceItemQuantity

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

Price Item Quantity

PriceItemUOM

string

Price Item UOM

PriceList

string

The price list.

PriceListId

long

The unique identifier of the price list.

PriceUOM

string

Price UOM

PricingError

string

Pricing Error

PricingTerm

Pricing Terms Sales Agreement

Pricing Term

ProjectContractLineInternalAttributes

Internal Contract Line Attributes SDO

Project Contract Line Internal Attributes

PurchasingCategory

string

The purchasing category.

PurchasingCategoryId

long

The unique identifier of the purchasing category.

RecInvOrgName

string

The name of the receiving inventory organization.

RecvInvOrgId

long

The unique identifier of the receiving inventory organization.

RecvLocationId

long

The unique identifier of the receiving location.

ReturnCreditMethodCode

string

The code of the credit method used to calculate credit.

ReturnCreditMethodMeaning

string

The credit method used to calculate credit.

RevenueAmount

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

The revenue amount.

RevenuePlan

string

The name of the revenue plan.

RevenuePlanId

long

The unique identifier of the revenue plan.

SalesCredit

Sales Credit

Sales Credit

ShipInvOrgId

long

The unique identifier of the ship-to inventory organization.

ShipToAccount

string

The name of the ship-to account.

ShipToAccountId

long

The unique identifier of the ship-to account.

ShipToAccountNumber

string

The account number of the ship-to account.

ShipToOrgLocation

string

The ship-to organization location.

ShipToPartyId

long

The unique identifier of the ship-to party location.

ShipToPartyName

string

Ship To Party Name

ShipToPartySiteId

long

The unique identifier of the ship-to party site location.

ShipToPartySiteLocation

string

Ship To Party Site Location

ShipToSite

string

The ship-to site.

ShipToSiteUseId

long

The unique identifier of the ship-to site.

SourceDocumentId

long

Source Document Id

SourceDocumentLineId

long

Source Document Line Id

SourceDocumentSystemCode

string

Source Application Code

SourceSystemAttributes

{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

The attributes of the source system.

SpecificDays

int

The day and offset for Billing Schedule.

StandaloneSellingPrice

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

Standalone Selling Price

StartDate

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

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

StsCode

string

The code identifying the status.

Supplier

string

The name of the supplier.

SupplierId

long

The unique identifier of the supplier.

SupplierSiteId

long

The unique identifier of the supplier site.

SupplierSiteName

string

The name of the supplier site.

TaxAmount

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

Tax Amount

TaxClassificationMeaning

string

Tax Classification Meaning

TaxError

string

Tax Error

TaxExemptionControl

string

The tax exemption control.

TaxExemptionControlMeaning

string

The meaning of the tax exemption control.

TerminatedAmount

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

Terminated Amount

TrnCode

string

The code identifying the close or the cancel reason.

TrnCodeSetId

long

The unique identifier of the close or cancel set.

UOMCode

string

The code identifying the unit of measure.

UnbilledAmount

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

Unbilled Amount

UnitOfMeasure

string

The unit Of measure.

UnitPrice

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

The unit price.

VendorSiteId

long

The unique identifier of the vendor site.

VersionType

string

Version Type

WareHouse

string

The ware house.