Contract

The contract header view object.

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

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 Line

Contains

Sales Credit

Contains

Contract Billing Control

Contains

Contract Bill Plan

Contains

Contract Header Language Translation

Contains

Contract Header Descriptive Flexfield Attributes

Contains

Contract Revenue Plan

Contains

Contract Related Document

Contains

Contract Party

Handled by

Contract Service Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccessLevel

string

The level of the access in the hierarchy.

AccountRuleId

long

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

AccountRuleName

string

The accounting rule used for service revenue recognition.

AdjustmentBasis

string

The adjustment basis for the contract.

AgreedAmount

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

Agreed Amount

AgreementAmountLimit

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

Agreement Amount Limit

AgreementEnabledFlag

boolean

The flag that denotes whether agreement is enabled for the contract.

AllowCurrencyOverrideFlag

boolean

Indicates whether currency can be overridden on a contract.

AllowExternalItemFlag

boolean

The flag that denotes whether external item is allowed on the contract.

AmendmentEffectiveDate

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

The effective date of the amendment.

ApTermsId

long

The terms identifier for accounts payable.

ArInterfaceYn

string

Indicates whether the billing information has been interfaced.

Assignee

string

The assignee of the contract.

AssigneeId

long

The identifier associated with the assignee of the contract.

AssigneeType

string

The assignee type for the contract.

AuthoringPartyCode

string

The code of the authoring party.

AuthoringPartyMeaning

string

The meaning of the authoring party.

AutoSendForSignature

string

Auto Send For Signature Flag

BaseContractYN

string

Indicates if the contract is Base Contract.

BillPlan

Contract Bill Plan

The bill plan of the contract.

BillSequence

long

The sequence in which the bill was generated.

BillToAccount

string

The account to be billed for the contract.

BillToAccountId

long

The unique identifier of the bill-to account.

BillToAccountNumber

string

The account number of the bill-to account.

BillToSiteUseId

long

The identifier of the customer site identifier where the invoices are sent.

BillToSiteUseLocation

string

The user location of the bill-to site.

BillingControl

Contract Billing Control

The billing control element of the contract.

BillingDateMethod

string

Billing Date type for Billing Schedule.

BillingFrequency

string

The frequency in which service billing will occur.

BillingSalesrepId

long

Billing Sales Rep ID

BillingSalesrepName

string

Billing Sales Rep Name

BuyOrSell

string

Indicates the intent of the contract; whether it is a buy or a sell contract.

CancelReason

string

The reason for cancellation of the contract.

CancelledAmount

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

Cancelled Amount

ChrType

string

The code associated with the type of the contract.

CloseReason

string

The reason for closing the contract.

Cognomen

string

The name of the contract.

Comment

string

The comment for the contract.

CommitmentAmount

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

The amount committed for the contract.

ContractClass

string

The class to which the contract belongs.

ContractCreditedAmount

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

Contract Credited Amount

ContractHeaderFlexfieldVA

Contract Header Descriptive Flexfield Attributes

The contract header flex field element.

ContractHeaderTranslation

Contract Header Language Translation

The contract header translation element.

ContractId

long

Contract Unique Id
  • Primary Key

ContractInvoicedAmount

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

Contract Invoiced Amount

ContractLine

Contract Line

The contract line element.

ContractNumber

string

The number of the contract.

ContractNumberModifier

string

The contract number modifier.

ContractOwnerId

long

The unique identifier of the contract owner.

ContractParty

Contract Party

The contract party element.

ContractPuid

string

Contract PUID

ContractTrueValue

decimal

The true value of a contract after considering the terminations.

ContractTypeId

long

The unique identifier of the contract type.

ContractTypeName

string

The type of the contract.

ContributionPercent

decimal

The contribution percent of the contract.

CorpCurrencyCode

string

Corporate Currency Code

CreatedBy

string

The user who created the record.

CreationDate

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

The date when the record was created.

CurcyConvRateType

string

Currency Conversion Rate

Currency

string

The currency of the contract.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

CustomerPONumber

string

The customer PO number.

CustomerPartyId

long

The unique identifier of the customer party.

CustomerPartyName

string

Customer Party Name

CustomerPartySiteId

long

The unique identifier of the customer party site.

CustomerPartySiteName

string

Customer Party Site Name

DateApproved

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

The date when the contract was approved.

DateSigned

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

The date when the contract was signed.

DateTerminated

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

The date when the contract was terminated.

DatetimeCancelled

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

The date and time when the contract was cancelled.

Description

string

The free text description of the record.

DiscountPercent

decimal

The discount in percentage of the contract applied to the bill rate.

DocumentSubType

string

Document Sub Type

EnableElectronicSignFlag

boolean

Flag to enable electronic signature

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.

EsignTemplateId

string

Esignature Template Id

EstimatedAmount

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

The estimated amount of the contract.

ExemptCertificateNumber

string

The exempted certificate number.

ExemptReasonCode

string

The code associated with the exemption reason.

ExemptionReasonMeaning

string

The meaning of the exemption reason.

ExternalKey

string

Used to identify external records that were imported.

ExternalSource

string

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

FOB

string

The Free on Board (FOB) of the contract.

FreightTerms

string

The freight terms associated with the contract.

GenerateBillingSchedule

string

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

GeneratedInvoiceStatus

string

Generated Invoice Status

HoldReasonCode

string

The code identifying the hold reason.

HoldReasonCodeSetId

long

The unique identifier of the hold reason code set.

HoldReasonMeaning

string

Hold Reason Meaning

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.

IgnoreQAWarningsFlag

boolean

Indicator to ignore contract validation warnings.

InvConvRateDate

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

The date when the invoice conversion rate was set up.

InvConvRateDateType

string

The type of the invoice conversion rate date.

InvConvRateDateTypeName

string

Inventory Conversion Rate Date Type Name

InvConvRateType

string

The type of the invoice conversion rate.

InvConvRateTypeName

string

Inventory Conversion Rate Type Name

InvConversionRate

decimal

The currency conversion rate applied to the invoice.

InvOrganizationId

long

The unique identifier of the item master organization.

InvTrxTypeId

long

The unique identifier of the invoice transaction type.

InvTrxTypeName

string

Invoice Transaction Type Name

InvoiceRuleId

long

The unique identifier of the invoice rule used for service billing.

InvoiceRuleName

string

The invoice rule used for service billing.

ItemSourceCode

string

The code identifying the item source.

LastUpdateDate

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

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

LedgerCurrency

string

The currency used in the ledger.

LegalEntityId

long

The unique identifier of the legal entity.

LegalEntityName

string

The name of the legal entity.

MajorVersion

long

The major version of the record.

NegotiationCommChannel

string

The communication channel used in the negotiation process

NegotiationContractLayoutTemplate

string

The Contract Layout Template of the contract

NegotiationCustomerAcceptance

string

The flag which indicates if customer acceptance is required for contract activation

NegotiationEnableNotification

string

The flag to enable and disable reminder notifications

NegotiationInternalApproval

string

The internal approval criteria for contract activation

NegotiationLanguage

string

The language used in the negotiation process

NegotiationTermsLayoutTemplate

string

The terms layout template of the contract

NetInvoiceFlag

boolean

Indicates whether the invoice is a net invoice.

NonStandardClauseCount

short

Nonstandard Clause Count

OrderNumber

string

The number of the order that created the contract.

OrderSource

string

The source of the order that created the contract.

OrgId

long

The unique identifier of the business unit.

OrgName

string

The name of the business unit.

OrigSystemId

long

The unique identifier of the original system.

OrigSystemReference

string

The identifier for the record from the original system.

OrigSystemSourceCode

string

The code identifying the original system source.

OutputTaxClassificationCode

string

The code identifying the output tax classification.

OutputTaxSetId

long

The unique identifier of the output tax set.

OverallRiskCode

string

The code identifying the overall risk.

OwningOrgId

long

The unique identifier of the owning organization.

OwningOrgName

string

The name of the owning organization.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PartyObjectType

string

The type of the party object.

PaymentTermId

long

The unique identifier of the customer payment terms used for service billing.

PaymentTermName

string

The customer payment terms used for service billing.

PeriodStartMeaning

string

Indicates whether service is priced from when it was bought or from calendar month start.

PeriodStartUsed

string

The code that Indicates whether service is priced from when it was bought or from calendar month start.

PeriodTypeMeaning

string

Indicates whether service is priced by fixed days for every month or by actual days of the month.

PeriodTypeUsed

string

The code Indicates whether service is priced by fixed days for every month or by actual days of the month.

PersonId

long

The unique identifier of the person.

PriceApplicationRule

string

Price Application Rule

PriceList

string

The price list.

PriceListName

string

The name of the price list.

PricingCalendarId

long

The unique identifier of the pricing calendar.

PricingCalendarName

string

The name of the pricing calendar.

PricingEffectivityDate

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

The effective start date of pricing.

PricingPeriodType

string

The type of the pricing period.

PricingSegmentCode

string

The code of the pricing segment used to determine the pricing strategy for the contract.

PricingSegmentExplanation

string

Explanation of why a particular pricing segment was used to determine the pricing strategy for the contract.

PricingStrategyExplanation

string

Explanation of why a particular pricing strategy was used for pricing the contract.

PricingStrategyId

long

The unique identifier of the pricing strategy used to price the contract.

PricingStrategyName

string

Pricing Strategy Name

PrimaryLedgerId

long

The unique identifier of the primary ledger.

PrimaryPartyId

long

The unique identifier of the primary party.

PrimarySalesRepresentative

string

The name of the primary sales rep

PrimarySalesrepId

long

The primary sales rep resource identifier

ProjectEnabledFlag

boolean

Indicates whether the project is enabled.

QuoteAccount

string

The organization name of the quote to contact

QuoteAddress

string

The correspondence address of the quote to contact

QuoteEmail

string

The email address of the quote to contact

QuoteFax

string

The fax of the quote to contact

QuoteOrg

string

The organization name of the quote to contact

QuotePhone

string

The phone number of the quote to contact

QuoteToContact

string

The party name of the quote to contact

QuoteToContactId

long

The party identifier of the quote to contact

QuoteToCopyToEmail

string

The copy to email address for customer communications

RecvInvOrg

string

The receiving inventory organization.

RecvInvOrgId

long

The unique identifier of the receiving inventory organization.

RelatedDocument

Contract Related Document

The related document element.

RenewalType

string

Renewal Type

RevenuePlan

Contract Revenue Plan

The revenue plan element.

RunContractExpertFlag

boolean

Flag to decide whether to run expert after defaulting terms during contract creation or updation

SalesAccountId

long

The unique identifier of the sales account.

SalesAccountName

string

The name of the sales account.

SalesCredit

Sales Credit

The sales credit element.

SegmentExplanationMessageName

string

The explanation message name of the pricing segment used to determine the pricing strategy for the contract.

ServiceEnabledFlag

boolean

Indicates whether service is enabled.

ShipInvOrg

string

The shipping inventory organization.

ShipInvOrgId

long

The unique identifier of the shipping inventory organization.

ShipToAccount

string

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

ShipToSiteUseId

long

The unique identifier of the ship-to site.

ShipToSiteUseLocation

string

The ship-to site use location.

ShortDescription

string

The short description.

SoldToAccount

string

The sold-to account.

SoldToAccountDescription

string

The description of the sold-to account.

SoldToAccountId

long

The unique identifier of the sold-to account.

SoldToAccountNumber

string

The account number of the sold-to account.

SoldToAddress

string

The sold-to address.

SoldToNumber

string

The sold-to number.

SoldToSiteId

long

The unique identifier of the sold-to site.

SourceDocumentId

long

Source Document Id

SourceDocumentSystemCode

string

Source Application Code

SpecificDays

int

The day and offset for Billing Schedule.

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.

StateTransitionFlowName

string

The name of the state transition flow.

StateTransitionFlowState

string

The state transition flow state.

Status

string

The status of the record.

StsCode

string

The code identifying the status.

Subtotal

decimal

The sub total amount of the contract.

Supplier

string

The supplier of the contract.

SupplierId

long

The unique identifier of the supplier.

SupplierSite

string

The supplier site.

SupplierSiteId

long

The unique identifier of the supplier site.

TaxAmount

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

The tax amount.

TaxClassificationMeaning

string

The meaning of the tax classification.

TaxExemptionControl

string

The tax exemption control.

TemplateFlag

boolean

The flag identifying the template.

TerminateCancelSource

string

The source of terminating or canceling the contract.

TermsTemplateId

long

The unique identifier of the terms template.

TermsTemplateName

string

Terms Template Name

TransactionTypeName

string

Transaction type name

TrnCodeSetId

long

The unique identifier of the cancel or the close reason code set.

UnbilledAmount

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

Unbilled Amount

UnderAmendVersionFlag

boolean

Under Amend Version Flag

UnderMigrationFlag

boolean

Under Migration Flag

UserStatusCode

string

The code identifying the user status.

UserStatusMeaning

string

The meaning of the user status.

VersionDescription

string

The description of the version.

VersionType

string

Version Type

WebServiceFlag

boolean

The flag identifying the web service.