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. |