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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
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 |
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 |
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 |
The flex field element of the contract line. |
|
|
ContractAllLine_2 |
The sub-line element of the contract. |
|
|
ContractBillLine |
Contract Bill Line |
|
|
ContractCharge |
The charge associated with the contract. |
|
|
ContractCoveredAsset |
The asset covered by the contract. |
|
|
ContractLineTranslation |
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
|
|
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 Term |
|
|
ProjectContractLineInternalAttributes |
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 |
|
|
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. |