Get all revenue contracts
get
/fscmRestApi/resources/11.13.18.05/revenueContracts
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Finds the revenue contracts that match the primary key criteria specified.
Finder Variables:- CustomerContractHeaderId; integer; The unique identifier of the revenue contract header.
- RevenueContractFinder: Finds the revenue contract that matches the specified search parameters.
Finder Variables:- Number; string; The number associated with the revenue contract.
- RevenueContractsFinder: Finds the revenue contracts that match the specified search parameters.
Finder Variables:- AllocationPendingReason; string; The reason that allocation is pending on a revenue contract.
- AllocationStatus; string; The allocation status of the revenue contract.
- BilledAmount; string; The total amount that was billed to a contract.
- Classification; string; The codes used to classify revenue contracts.
- ContractGroupNumber; string; The unique identifier of a contract group.
- Currency; string; The currency of the revenue contract.
- Date; string; The date the revenue contract was created.
- EffectivePeriod; string; The date range used to establish the standalone selling price.
- ExcludeFromAutomaticWriteOff; string; The option that indicates whether the contract's residual balances are excluded from automatic write-off by the Residual Account Balance Write-Off process.
- FreezeDate; string; The date when the revenue contract was frozen.
- IdentificationRule; string; The unique identifier of the revenue contract identification rule.
- NonexemptTransactionPrice; string; The amount of the contract after excluding the exempt performance obligations.
- Reference; string; The reference information for the contract entered by the user.
- RequestId; string; The unique identifier of the request.
- ResidualBalanceAdjustmentStatus; string; The residual balance adjustment status of the revenue contract.
- RevenueRecognisedAmount; string; The total amount of revenue that was recognized for a revenue contract.
- ReviewStatus; string; The status of the revenue contract.
- TransactionPrice; string; The total amount of the contract in the ledger currency.
- PrimaryKey: Finds the revenue contracts that match the primary key criteria specified.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AllocationPendingReason; string; The reason that allocation is pending on a revenue contract. A list of accepted values is defined in the lookup type ORA_ALLOCATION_PENDING_REASON.
- AllocationStatus; string; The allocation status of the revenue contract. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_ALLOCN_STATUS.
- BilledAmount; number; The total amount that was billed to a contract.
- Classification; string; The codes used to classify revenue contracts. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_CLASSIF_CODE.
- ContractGroupNumber; string; The unique identifier of a contract group.
- Currency; string; The currency of the revenue contract.
- Date; string; The date the revenue contract was created.
- EffectivePeriod; string; The date range used to establish the standalone selling price.
- ExcludeFromAutomaticWriteOff; string; The option that indicates whether the contract's residual balances are excluded from automatic write-off by the Residual Account Balance Write-Off process.
- FreezeDate; string; The date when the revenue contract was frozen.
- IdentificationRule; string; The unique identifier of the revenue contract identification rule.
- NonexemptTransactionPrice; number; The amount of the contract after excluding the exempt performance obligations.
- Number; integer; The number associated with the revenue contract.
- Reference; string; The reference information for the contract entered by the user.
- RequestId; integer; The unique identifier of the request.
- ResidualBalanceAdjustmentStatus; string; The residual balance adjustment status of the revenue contract. A list of accepted values is defined in the lookup type ORA_ADJUSTMENT_STATUS.
- RevenueRecognisedAmount; number; The total amount of revenue that was recognized for a revenue contract.
- ReviewStatus; string; The status of the revenue contract. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_REVIEW_STATUS.
- TransactionPrice; number; The total amount of the contract in the ledger currency.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : revenueContracts
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : revenueContracts-item-response
Type:
Show Source
object
-
AllocationPendingReason: string
Read Only:
true
Maximum Length:80
The reason that allocation is pending on a revenue contract. A list of accepted values is defined in the lookup type ORA_ALLOCATION_PENDING_REASON. -
AllocationStatus: string
Read Only:
true
Maximum Length:80
The allocation status of the revenue contract. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_ALLOCN_STATUS. -
BilledAmount: number
The total amount that was billed to a contract.
-
Classification: string
Read Only:
true
Maximum Length:80
The codes used to classify revenue contracts. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_CLASSIF_CODE. -
Comments: string
Maximum Length:
1000
The user-entered comments that are associated with the revenue contract. -
ContractGroupNumber: string
Maximum Length:
320
The unique identifier of a contract group. -
ConversionDate: string
(date)
The date when a conversion rate is used to convert an amount into another currency for a revenue contract. This attribute is required for nonfunctional currency revenue contracts. The value is imported from the source system along with the revenue basis data or populated by default from the contract date of the revenue contract.
-
ConversionRateType: string
Maximum Length:
30
The type of currency conversion rate that is used to automatically populate a specific rate when converting a revenue contract into the ledger currency. Examples include corporate, user-defined, and spot. -
Currency: string
Maximum Length:
15
The currency of the revenue contract. -
CustomerContractHeaderId: integer
(int64)
The unique identifier of the customer contract header.
-
Date: string
(date)
The date the revenue contract was created.
-
EffectivePeriod: string
Read Only:
true
Maximum Length:60
The date range used to establish the standalone selling price. -
ExcludeFromAutomaticWriteOff: string
Read Only:
true
Maximum Length:80
The option that indicates whether the contract's residual balances are excluded from automatic write-off by the Residual Account Balance Write-Off process. -
FreezeDate: string
(date)
The date when the revenue contract was frozen.
-
IdentificationRule: string
Read Only:
true
Maximum Length:100
The unique identifier of the revenue contract identification rule. -
Ledger: string
Title:
Name
Read Only:true
Maximum Length:30
The ledger that is associated with the revenue contract. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
NonexemptTransactionPrice: number
The amount of the contract after excluding the exempt performance obligations.
-
Number: integer
(int64)
The number associated with the revenue contract.
-
performanceObligations: array
Performance Obligations
Title:
Performance Obligations
The performance obligations resource is used to retrieve the performance obligations of a revenue contract. -
Reference: string
Maximum Length:
1000
The reference information for the contract entered by the user. -
RequestId: integer
(int64)
The unique identifier of the request.
-
ResidualBalanceAdjustmentStatus: string
Read Only:
true
Maximum Length:80
The residual balance adjustment status of the revenue contract. A list of accepted values is defined in the lookup type ORA_ADJUSTMENT_STATUS. -
RevenueRecognisedAmount: number
The total amount of revenue that was recognized for a revenue contract.
-
ReviewStatus: string
Read Only:
true
Maximum Length:80
The status of the revenue contract. A list of accepted values is defined in the lookup type ORA_VRM_CONTRACT_REVIEW_STATUS. -
TransactionPrice: number
The total amount of the contract in the ledger currency.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Performance Obligations
Type:
array
Title:
Performance Obligations
The performance obligations resource is used to retrieve the performance obligations of a revenue contract.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : revenueContracts-performanceObligations-item-response
Type:
Show Source
object
-
DevolvePerformanceObligation: string
Maximum Length:
1
Status indicating that the performance obligation is devolved. A performance obligation is devolved when the Devolve performance obligation option is set to Yes in either the performance obligation identification rule or the implied obligation template that was used during the identification of the performance obligation. -
ImpliedObligationTemplateName: string
Read Only:
true
Maximum Length:60
The name of the template used to create the implied performance obligation. -
ImpliedPerformanceObligation: string
Read Only:
true
Maximum Length:80
The status specifying the performance obligation is added using an implied obligation template or using a source document line. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ObligationAmount: number
The transaction price allocated to the performance obligation in the currency of the performance obligation.
-
ObligationBasePricePercentage: number
The base price percentage of the performance obligation.
-
ObligationBilledAmount: number
The total amount that was billed to a performance obligation.
-
ObligationClassification: string
Read Only:
true
Maximum Length:80
The codes used to classify performance obligations. A list of accepted values is defined in the lookup type ORA_VRM_OBLIG_CLASSIF_CODE. -
ObligationComputedResidualSSP: number
The calculated residual estimated extended standalone selling price of the performance obligation in the contract currency.
-
ObligationConversionRate: number
The rate used to convert the performance obligation amount in the entered currency to the ledger currency.
-
ObligationConversionRateDate: string
(date)
The date when a conversion rate is used to convert an amount into another currency for a performance obligation. This attribute is required for nonfunctional currency performance obligations. The value is imported from the source system along with the revenue basis data or populated by default from the contract date of the revenue contract.
-
ObligationConversionRateType: string
Maximum Length:
30
The type of currency conversion rate that is used to automatically populate a specific rate when converting a revenue contract into the ledger currency. Examples include corporate, user-defined, and spot. -
ObligationCreatedBy: string
Read Only:
true
Maximum Length:64
The user who created the performance obligation. -
ObligationCreationDate: string
(date-time)
Read Only:
true
The date on which the performance obligation is created. -
ObligationDiscountAmount: number
The total discount amount of all the underlying promised details of the performance obligation in the contract currency.
-
ObligationDiscountPercentage: number
The discount percentage of the performance obligation.
-
ObligationEnteredCurrency: string
Maximum Length:
15
The currency of the performance obligation. -
ObligationEnteredCurrencyBaseprice: number
The base price of the performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyBilledAmount: number
The amount billed to a performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyComputedResidualSSP: number
The calculated residual estimated extended standalone selling price of the performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyCostAmount: number
The cost amount of the performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyDiscountAmount: number
The total discount amount of all the underlying promised details of the performance obligation in the performance obligation currency.
-
ObligationEnteredCurrencyExtendedSSP: number
The total standalone selling price amount of a performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyListPriceAmount: number
The list price of a performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencySellingAmount: number
The selling amount of the performance obligation in the entered currency of the performance obligation.
-
ObligationEnteredCurrencyUnitSellingPrice: number
The unit selling price of the performance obligation in the entered currency of the performance obligation.
-
ObligationESSRequestId: integer
(int64)
The request ID of the job that created or last updated the performance obligation.
-
ObligationExemptionStatus: string
Read Only:
true
Maximum Length:80
Status indicating that the performance obligation is exempted from allocation. -
ObligationExtendedSSP: number
The total standalone selling price amount of a performance obligation. The value is calculated by multiplying the unit standalone selling price with the quantity of the performance obligation.
-
ObligationFreezeStatus: string
Read Only:
true
Maximum Length:80
The status indicating whether the performance obligation is frozen for the automatic addition of new interfaced lines. -
ObligationFullSatisfactionDate: string
(date)
The date the performance obligation is fully satisfied.
-
ObligationGrossMarginPercentage: number
The gross margin percentage of the performance obligation.
-
ObligationIdentificationRule: string
Read Only:
true
Maximum Length:100
The unique identifier of the performance obligation identification rule. -
ObligationLastUpdatedBy: string
Read Only:
true
Maximum Length:64
The user who last updated the performance obligation. -
ObligationLastUpdatedDate: string
(date-time)
Read Only:
true
The date on which the performance obligation was last updated. -
ObligationLatestRevisionIntent: string
Read Only:
true
Maximum Length:80
The revision intent of the last promised detail revision of the performance obligation. A list of accepted values is defined in the lookup type ORA_VRM_REVISION_INTENT_TYPE. -
ObligationLatestVersionDate: string
(date)
The date of the most recent version of the performance obligation's underlying promised detail.
-
ObligationPricingDimension: integer
(int64)
The key flexfield structure that identifies the pricing category of the performance obligation.
-
ObligationReference: string
Maximum Length:
1000
User entered performance obligation reference. -
ObligationResidualApproach: string
Read Only:
true
Maximum Length:80
The price of goods or services for the line is variable or missing and the standalone selling price for the performance obligation is estimated using the residual approach. Valid values are Y, N, or blank. -
ObligationRevenueRecognized: number
The total amount of revenue that was recognized for a performance obligation.
-
ObligationSellingAmount: number
Total selling amount of all the promised details of the performance obligation in the currency of the performance obligation.
-
ObligationSSPProfile: string
Read Only:
true
Maximum Length:60
The name of the standalone selling price profile for the performance obligation. -
ObligationSSPRepresentationType: string
Read Only:
true
Maximum Length:80
The standalone selling price representation type of the performance obligation. A list of accepted values is defined in the lookup type VRM_FMV_REPRESENTATIONS. -
ObligationTemplateName: string
Read Only:
true
Maximum Length:60
The name of the template used to create the performance obligation template. -
ObligationUnitSSP: number
Read Only:
true
The unit standalone selling price of the performance obligation. -
PerformanceObligationId: integer
(int64)
The unique identifier of the performance obligation.
-
PerformanceObligationNumber: integer
(int64)
The number associated with the performance obligation.
-
performanceObligationSeries: array
Performance Obligation Series
Title:
Performance Obligation Series
The performance obligation series resource is used to retrieve the series of a devolved performance obligation. -
promisedDetails: array
Promised Details
Title:
Promised Details
The promised detail resource is used to retrieve the promised detail lines of a performance obligation. -
SatisfactionMethod: string
Read Only:
true
Maximum Length:80
The method indicating whether the performance obligation is satisfied at a point in time or over time. A list of accepted values is defined in the lookup type ORA_VRM_SATISFACTION_METHOD. -
SatisfactionStatus: string
Read Only:
true
Maximum Length:80
The codes used to indicate satisfaction status of the performance obligation. A list of accepted values is defined in the lookup type ORA_VRM_LINE_SATISFACTN_STATUS.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Performance Obligation Series
Type:
array
Title:
Performance Obligation Series
The performance obligation series resource is used to retrieve the series of a devolved performance obligation.
Show Source
Nested Schema : Promised Details
Type:
array
Title:
Promised Details
The promised detail resource is used to retrieve the promised detail lines of a performance obligation.
Show Source
Nested Schema : revenueContracts-performanceObligations-performanceObligationSeries-item-response
Type:
Show Source
object
-
DevolvedObligationAllocatedAmount: number
The transaction price allocated to the devolved performance obligation record.
-
DevolvedObligationAmount: number
The selling amount of the devolved performance obligation record. The value is calculated as a proportion of the net consideration amount of the devolved performance obligation for each period of the performance satisfaction plan.
-
DevolvedObligationCreatedBy: string
Read Only:
true
Maximum Length:64
The user who created the devolved performance obligation record. -
DevolvedObligationCreatedDate: string
(date-time)
Read Only:
true
The date the devolved performance obligation record is created. -
DevolvedObligationCreatedFrom: string
Maximum Length:
30
The process that created the devolved performance obligation record. -
DevolvedObligationESSRequestId: integer
(int64)
The request ID of the job that created or last updated the devolved performance obligation record.
-
DevolvedObligationInitialPerformanceAmount: number
The initial performance event amount of the devolved performance obligation record.
-
DevolvedObligationInitialPerformanceDate: string
(date)
The date the initial performance event is recorded.
-
DevolvedObligationLastUpdatedBy: string
Read Only:
true
Maximum Length:64
The user who last updated the devolved performance obligation record. -
DevolvedObligationLastUpdatedDate: string
(date-time)
Read Only:
true
The date the devolved performance obligation record was last updated. -
DevolvedObligationLastUpdatedLogin: string
Read Only:
true
Maximum Length:32
The login name associated to the user who last updated the devolved performance obligation record. -
DevolvedObligationRevenueRecognized: number
The total amount of revenue that was recognized for a devolved performance obligation record.
-
DevolvedObligationReversedStatus: string
Maximum Length:
1
The option that indicates whether the devolved performance obligation record is reversed. N indicates not reversed. Y indicates reversed. Not reversed records are the latest records. -
DevolvedObligationSatisfactionDate: string
(date)
The date the devolved performance obligation is satisfied.
-
DevolvedPerfObligDtlId: integer
(int64)
The unique identifier of the detailed devolved performance obligation record.
-
FirstDevolvedObligationRecord: string
Maximum Length:
1
The indicator that specifies whether the record is the first devolved performance obligation record in the ascending order of the satisfaction date. -
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : revenueContracts-performanceObligations-promisedDetails-item-response
Type:
Show Source
object
-
ExtensibleLineAttribute1: string
Read Only:
true
Maximum Length:150
Generic attribute column used in Oracle Subscription Management integration with Revenue Management to associate the charge description to the source document line. -
Item: string
Read Only:
true
Maximum Length:300
The inventory item name. -
ItemGroup: string
Read Only:
true
Maximum Length:60
The name of the item group that consists of items that share common pricing policies. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MemoLine: string
Title:
Memo Line Name
Read Only:true
Maximum Length:50
The name of the memo line when the item is not an inventory item. -
PerformanceSatisfactionPlan: string
Read Only:
true
Maximum Length:30
The name of the performance satisfaction plan of the promised detail line. -
PlanDurationinPeriods: number
Number of periods in the satisfaction plan for the source document line.
-
PlanEndDate: string
(date)
The end date of a performance satisfaction plan.
-
PlanStartDate: string
(date)
The start date of a performance satisfaction plan.
-
PromisedDetailAmount: number
The transaction price allocated to the promised detail in the currency of the promised detail line.
-
PromisedDetailBasePricePercentage: number
Read Only:
true
The base price percentage of the promised detail line. -
PromisedDetailBilledAmount: number
The total amount that was billed to a promised detail line.
-
PromisedDetailClassification: string
Read Only:
true
Maximum Length:80
The codes used to classify promised details. A list of accepted values is defined in the lookup type ORA_VRM_OBLIG_CLASSIF_CODE. -
PromisedDetailCreatedBy: string
Read Only:
true
Maximum Length:64
The user who created the promised detail line. -
PromisedDetailCreationDate: string
(date-time)
Read Only:
true
The date the promised detail line is created. -
PromisedDetailDiscountPercentage: number
Read Only:
true
The discount percentage of the promised detail line. -
PromisedDetailEnteredCurrency: string
Maximum Length:
15
The currency of the promised detail line. -
PromisedDetailEnteredCurrencyBasePrice: number
Read Only:
true
The base price of the promised detail line in the entered currency of the promised detail line. -
PromisedDetailEnteredCurrencyBilledAmount: number
The amount billed to a promised detail line in the entered currency of the promised detail line.
-
PromisedDetailEnteredCurrencyCostAmount: number
Read Only:
true
The cost amount of the promised detail line in the entered currency of the promised detail line. -
PromisedDetailEnteredCurrencyExtendedSSP: number
The total standalone selling price amount of a promised detail line in the entered currency of the promised detail line.
-
PromisedDetailEnteredCurrencyListPriceAmount: number
Read Only:
true
The list price amount of the promised detail line in the entered currency of the promised detail line. -
PromisedDetailEnteredCurrencySellingAmount: number
The selling amount of the promised detail line in the entered currency of the promised detail line.
-
PromisedDetailEnteredCurrencyUnitListPrice: number
Read Only:
true
The unit list price of the promised detail line in the entered currency of the promised detail line. -
PromisedDetailEnteredCurrencyUnitSellingPrice: number
Read Only:
true
The unit selling price of the promised detail line in the entered currency of the promised detail line. -
PromisedDetailExtendedSSPAmount: number
The total standalone selling price amount of the item or memo line of the promised detail line. The value is calculated by multiplying the unit standalone selling price with the quantity of the promised detail line.
-
PromisedDetailGrossMarginPercentage: number
Read Only:
true
The gross margin percentage of the promised detail line. -
PromisedDetailLastUpdateDate: string
(date-time)
Read Only:
true
The date the promised detail line was last updated. -
PromisedDetailLastUpdatedBy: string
Read Only:
true
Maximum Length:64
The user who last updated the promised detail line. -
PromisedDetailLatestVersionDate: string
(date)
The date of the most recent version of the promised detail line.
-
PromisedDetailLineId: integer
(int64)
The unique identifier of the promised detail.
-
PromisedDetailNumber: integer
(int64)
The number associated with the promised detail.
-
PromisedDetailPricingDimension: integer
(int64)
The key flexfield structure identifying the pricing category of the promised detail line.
-
PromisedDetailResidualApproach: string
Read Only:
true
Maximum Length:80
The status that indicates the price of the goods or services for the line is variable or missing, and the standalone selling price for the promised detail is estimated using the residual approach. Valid values are Y, N, or blank. -
PromisedDetailRevenueRecognizedAmount: number
The total amount of revenue that was recognized for a promised detail line.
-
PromisedDetailRevisionIntent: string
Read Only:
true
Maximum Length:80
The revision intent of the promised detail revision. A list of accepted values is defined in the lookup type ORA_VRM_REVISION_INTENT_TYPE. -
PromisedDetailSellingAmount: number
The total selling amount of the promised detail in the currency of the promised detail line.
-
PromisedDetailSSPProfile: string
Read Only:
true
Maximum Length:60
The name of the standalone selling price profile for the promised detail line. -
PromisedDetailSSPType: string
Read Only:
true
Maximum Length:80
The type of standalone selling price of the promised detail. A list of accepted values is defined in the lookup type VRM_FMV_TYPES. -
PromisedDetailUnitSSP: number
Read Only:
true
The unit standalone selling price of the promised detail line. -
PromiseDetailSSPRepresentation: string
Read Only:
true
Maximum Length:80
The standalone selling price representation type of the promised detail line. A list of accepted values is defined in the lookup type VRM_FMV_REPRESENTATIONS. -
Quantity: number
Read Only:
true
The quantity of the item or memo line. -
RecurringAmount: number
Read Only:
true
The selling amount of the line per recurring frequency. -
RecurringFrequency: number
Read Only:
true
The recurring frequency of the promised detail. -
RecurringIndicator: string
Read Only:
true
Maximum Length:80
The recurring status of the promised detail that indicates if the line recurs after the plan satisfaction end date. -
RecurringPattern: string
Read Only:
true
Maximum Length:80
The recurring pattern of the promised detail. A list of accepted values is defined in the lookup type ORA_VRM_RECUR_PATTERN_CODE. -
satisfactionEvents: array
Satisfaction Events
Title:
Satisfaction Events
The satisfaction events resource is used to retrieve the satisfaction events for a promised detail. -
SatisfactionMeasurementModel: string
Read Only:
true
Maximum Length:80
The satisfaction measurement model of the promised detail line. A list of accepted values is defined in the lookup type ORA_VRM_SATIS_MEAS_MODEL. -
sourceDocuments: array
Source Documents
Title:
Source Documents
The source documents resource is used to retrieve source document details associated with a promised detail line. -
TerminationDate: string
(date)
Read Only:
true
The date the service was terminated. The termination date is required to terminate a recurring service or when the contract update is immaterial. -
UnitOfMeasure: string
Read Only:
true
Maximum Length:200
The unit of measure used for the quantity of the item or memo line.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Satisfaction Events
Type:
array
Title:
Satisfaction Events
The satisfaction events resource is used to retrieve the satisfaction events for a promised detail.
Show Source
Nested Schema : Source Documents
Type:
array
Title:
Source Documents
The source documents resource is used to retrieve source document details associated with a promised detail line.
Show Source
Nested Schema : revenueContracts-performanceObligations-promisedDetails-satisfactionEvents-item-response
Type:
Show Source
object
-
DiscardedBy: string
Read Only:
true
Maximum Length:64
The user who discarded the satisfaction event. -
DiscardedDate: string
(date)
The date the satisfaction measurement event was discarded.
-
DiscardedStatus: string
Read Only:
true
Maximum Length:80
The status indicating that the satisfaction event was discarded. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
PeriodRatio: number
The ratio used to distribute the allocated amount to each period of the promised detail line. Used only when the satisfaction measurement model is Period.
-
PeriodStartDate: string
(date)
The start date of the period satisfied. This date is used only when the satisfaction measurement model is Period.
-
PlanEndDate: string
(date)
The end date of a performance satisfaction plan.
-
SatisfactionEventId: integer
(int64)
The unique identifier of the satisfaction event.
-
SatisfactionEventNumber: integer
(int64)
The sequential number of the satisfaction event of the promised detail line.
-
SatisfactionMeasurementDate: string
(date)
The date the satisfaction is measured. This date is used as the accounting date for the revenue accounting entry.
-
SatisfiedPercent: number
The percentage satisfied on the satisfaction measurement date. If the satisfaction measurement model is Percent then the value for this field is entered manually by the user or is provided by the source system. If the satisfaction measurement model is Period then the value for this field is derived from the performance satisfaction plan of the promised detail.
-
SatisfiedQuantity: number
The quantity satisfied on the measurement date. This attribute is used only when the satisfaction measurement model is Quantity.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : revenueContracts-performanceObligations-promisedDetails-sourceDocuments-item-response
Type:
Show Source
object
-
BillToCustomerNumber: string
Maximum Length:
30
The account number of the bill-to customer of the source document. -
BillToCustomerReferenceInSourceSystem: string
Maximum Length:
255
The reference value used to identify the bill-to customer from the originating source system. -
BillToCustomerSiteNumber: string
Maximum Length:
240
The site number of the bill-to customer of the source document. -
BillToCustomerSiteReferenceInSourceSystem: string
Maximum Length:
255
The reference value used to identify the customer's bill-to-site from the originating source system. -
BusinessUnitName: string
Maximum Length:
240
The business unit that owns the source document. -
ConversionDate: string
(date)
The date when a conversion rate is used to convert an amount into another currency for a source document.
-
ConversionRate: number
The rate used to convert the source document in the entered currency to the ledger currency.
-
ConversionRateType: string
Maximum Length:
30
The type of currency conversion rate that is used to automatically populate a specific rate when converting the source document into the ledger currency. Examples include corporate, user-defined, and spot. -
CurrencyCodeOfSourceDocument: string
Maximum Length:
15
The currency code of the source document. -
CustomerPurchaseOrderNumber: string
Maximum Length:
50
The customer purchase order number on the source document. -
DateOfSourceDocument: string
(date)
The date of the source document, such as the booking date for a sales order or the invoice date for an invoice.
-
DocumentId: integer
(int64)
The source document identifier of the document.
-
DocumentNumberOfSourceDocument: string
Maximum Length:
300
The number of the source document. For example, a sales order number or a Receivables invoice number. -
LegalEntityName: string
Maximum Length:
240
The legal entity of the source document. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ShipToCustomerNumber: string
Maximum Length:
30
The account number of the ship-to customer of the source document. -
ShipToCustomerReferenceInSourceSystem: string
Maximum Length:
255
The reference value used to identify the ship-to customer from the originating source system. -
ShipToCustomerSiteReferenceInSourceSystem: string
Maximum Length:
255
The reference value used to identify the customer's ship-to-site from the originating source system. -
sourceDocumentLines: array
Source Document Lines
Title:
Source Document Lines
The source document lines resource is used to retrieve details of source document lines associated with a promised detail line. -
SourceDocumentTypeCode: string
Maximum Length:
30
The source document type code the source data is imported from. -
SourceDocumentUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber4: number
The fourth numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceSystemCode: string
Maximum Length:
120
The source system code the source data is imported from. The source systems are defined in the Manage Trading Community source systems.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Source Document Lines
Type:
array
Title:
Source Document Lines
The source document lines resource is used to retrieve details of source document lines associated with a promised detail line.
Show Source
Nested Schema : revenueContracts-performanceObligations-promisedDetails-sourceDocuments-sourceDocumentLines-item-response
Type:
Show Source
object
-
ActionCodeForAddingNewLineToExistingContract: string
Maximum Length:
30
The code that indicates how a line is added to an existing contract. A list of accepted values is defined in the lookup type ORA_ADD_TO_CONTRACT_ACTION. -
AddToExistingContract: string
Maximum Length:
1
The option that indicates that the source document line must be added to an existing contract. If this attribute is set to Y, then this line is added to an existing contract. -
BasePrice: number
The base price of the item or memo line on the source document line. The base price is the selling price of the related product or service.
-
BillToCustomerNumber: string
Maximum Length:
30
The account number of the bill-to customer of the source document. -
BillToCustomerReferenceInTheSourceSystem: string
Maximum Length:
255
The reference value used to identify the bill-to customer from the originating source system. -
BillToCustomerSiteNumber: string
Maximum Length:
240
The site number of the bill-to customer of the source document. -
BillToCustomerSiteReferenceInTheSourceSystem: string
Maximum Length:
255
The reference value used to identify the customer's bill-to-site from the originating source system. -
ContractRevisionDate: string
(date)
The date the revised terms of the contract become effective.
-
CostAmount: number
The cost amount of the item or memo line on the source document line.
-
CustomerClassificationOfABillToCustomer: string
Maximum Length:
60
The customer classification of a bill-to customer on the source document line. A list of accepted values is defined in the lookup type CUSTOMER_CLASS. -
CustomerPurchaseOrderNumber: string
Maximum Length:
50
The customer purchase order number on the source document. -
DocumentLineId: integer
(int64)
The unique identifier of a source document line.
-
DocumentTypeCodeOfTheParentLine: string
Maximum Length:
30
The source document type code of the parent source document line of the imported source data. -
DocumentTypeCodeOfTheReferenceDocument: string
Maximum Length:
30
The source document type code of the reference document of the imported source data. -
EndDateOfPerformanceSatisfactionPlan: string
(date)
The end date of a performance satisfaction plan.
-
ImmaterialChangeType: string
Maximum Length:
30
The option that indicates that the contract revision on the source document line is of an immaterial nature. A list of accepted values is defined in the lookup type ORA_IMMATERIAL_CHANGE_TYPE. -
IndicatesTheCurrentSourceProductLineIsAVersionLine: string
Maximum Length:
1
The option that indicates whether the current source document line is a version line. Possible values are Y and N. -
ItemInventoryOrganizationCode: string
Maximum Length:
18
The inventory organization code the item belongs to. -
ItemNumber: string
Maximum Length:
300
The number of the inventory item in the source application. -
LineAmount: number
The total selling amount of the item or memo line on the source document line.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ManualReviewRequired: string
Maximum Length:
1
The option that indicates that the contract requires manual review. The contract is marked Pending Review if this attribute is set to Y. -
MemoLineName: string
Maximum Length:
50
The name of the memo line of the source document line when the item is not an inventory item. -
ParentLineSourceSystem: string
Maximum Length:
120
The source system code of the parent or related source document line from which source data is imported. The source systems are defined in Manage Trading Community. -
ParentSourceDocumentLineUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system. -
ParentSourceDocumentLineUniqueIdentifierCharacter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system. -
ParentSourceDocumentLineUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system. -
ParentSourceDocumentLineUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system. -
ParentSourceDocumentLineUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system. -
ParentSourceDocumentLineUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system.
-
ParentSourceDocumentLineUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system.
-
ParentSourceDocumentLineUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system.
-
ParentSourceDocumentLineUniqueIdentifierNumber4: number
The fourth numeric column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system.
-
ParentSourceDocumentLineUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to identify the parent or related line for a new line received from the source system.
-
PerformanceSatisfactionPlanName: string
Maximum Length:
30
The name of the performance satisfaction plan associated with the source document line. -
PlanDuration: number
The number of periods in which the source document line's revenue is recognized.
-
Quantity: number
The quantity of the item or memo line.
-
RecurringAmount: number
The selling amount of the line per recurring frequency.
-
RecurringFrequency: number
The recurring frequency of the promised detail line.
-
RecurringIndicator: string
Maximum Length:
1
The recurring status of the promised detail line that indicates if the line recurs after the plan satisfaction end date. -
RecurringPattern: string
Maximum Length:
30
The recurring pattern of the promised detail line. A list of accepted values is defined in the lookup type ORA_VRM_RECUR_PATTERN_CODE. -
ReferenceSourceDocumentLineUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo. -
ReferenceSourceDocumentLineUniqueIdentifierCharacter2: string
Maximum Length:
30
The second character column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo. -
ReferenceSourceDocumentLineUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo. -
ReferenceSourceDocumentLineUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo. -
ReferenceSourceDocumentLineUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo. -
ReferenceSourceDocumentLineUniqueIdentifierNumber1: number
The first numeric column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo.
-
ReferenceSourceDocumentLineUniqueIdentifierNumber2: number
The second numeric column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo.
-
ReferenceSourceDocumentLineUniqueIdentifierNumber3: number
The third numeric column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo.
-
ReferenceSourceDocumentLineUniqueIdentifierNumber4: number
The fourth numeric column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo.
-
ReferenceSourceDocumentLineUniqueIdentifierNumber5: number
The fifth numeric column of the reference composite key of 10 attributes to identify the original source document line in the source application for a return or credit memo.
-
ReferenceSourceSystem: string
Maximum Length:
120
The source system code of the referred source document line from imported source data. The source systems are defined in the Manage Trading Community source systems. -
RevenueReversalMethodUsedToReverseTheRevenue: string
Maximum Length:
30
The revenue reversal method used to reverse the revenue for the return lines. Possible values are LIFO and PRORATE. -
SatisfactionMeasurementModel: string
Maximum Length:
30
The satisfaction measurement model of the promised detail. A list of accepted values is defined in the lookup type ORA_VRM_SATIS_MEAS_MODEL. -
ShipToCustomerNumber: string
Maximum Length:
30
The account number of the ship-to customer of the source document. -
ShipToCustomerReferenceInTheSourceSystem: string
Maximum Length:
255
The reference value used to identify the ship-to customer from the originating source system. -
ShipToCustomerSiteReferenceInTheSourceSystem: string
Maximum Length:
255
The reference value used to identify the customer's ship-to-site from the originating source system. -
SourceDocumentLineNumber: string
Maximum Length:
30
The line number of the source document. -
SourceDocumentLineUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharacter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber4: number
The fourth numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
sourceDocumentSubLines: array
Source Document Sublines
Title:
Source Document Sublines
The source document sublines resource is used to retrieve details of source document sublines associated with a promised detail line. -
SourceDocumentTypeCode: string
Maximum Length:
30
The source document type code the source data is imported from. -
SourceDocumentUniqueIdentifieCharacter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to uniquely identify a source document. -
SourceDocumentUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber4: number
The fourth numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceDocumentUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to uniquely identify a source document.
-
SourceSystem: string
Maximum Length:
120
The source system code the source data is imported from. The source systems are defined in the Manage Trading Community source systems. -
SpecifiesTheVersionOfTheSourceProductLine: integer
(int32)
The version number of the source document line. For example, the value for the original source document line is 1 and for revisions the version number is 2 or more. Populate the version indicator if the version number is greater than 1.
-
StartDateOfPerformanceSatisfactionPlan: string
(date)
The start date of a performance satisfaction plan.
-
TerminationDate: string
(date)
The date the service was terminated. The termination date is required to terminate a recurring service or when the contract update is immaterial.
-
UnitListPrice: number
The unit list price of the item or memo line on the source document line.
-
UnitOfMeasureCode: string
Maximum Length:
200
The unit of measure code for the inventory item, service item, or memo line on the source document line. -
UnitSellingPrice: number
The unit selling price of the item or memo line.
-
UnitSSP: number
The unit standalone selling price of the item or memo line on the source document line.
-
UseResidualApproach: string
Maximum Length:
1
The option that indicates that the extended standalone selling price for the performance obligation associated with the line is estimated using the residual approach. Valid values are Y, N and blank. Blank is treated as N.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Source Document Sublines
Type:
array
Title:
Source Document Sublines
The source document sublines resource is used to retrieve details of source document sublines associated with a promised detail line.
Show Source
Nested Schema : revenueContracts-performanceObligations-promisedDetails-sourceDocuments-sourceDocumentLines-sourceDocumentSubLines-item-response
Type:
Show Source
object
-
DocumentSubLineId: integer
(int64)
The unique identifier of the source document subline.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
PeriodSatisfactionEeventActionType: string
Maximum Length:
30
The action type that indicates that positive or negative satisfaction events are created from the period satisfaction events effective date. This attribute is required when the subline type code is Period. A list of accepted values is defined in the lookup type ORA_VRM_PERIOD_SUBLINE_ACTION. -
PeriodSatisfactionEventEffectiveDate: string
(date)
The date when the period satisfaction event action is effective. The Create Satisfaction Events process creates satisfaction events from this date if the action is Reinstate. The process reverses satisfaction events from this date if the action is Reverse.
-
SatisfactionMeasurementDate: string
(date)
The date the satisfaction is measured. This date is used as the accounting date for the revenue accounting entry.
-
SatisfiedPercent: number
The percentage satisfied on the satisfaction measurement date. If the satisfaction measurement model is Percent then the value for this field is entered manually by the user or is provided by the source system. If the satisfaction measurement model is Period then the value for this field is derived from the performance satisfaction plan of the promised detail.
-
SatisfiedQuantity: number
The quantity satisfied on the measurement date. This attribute is used only when the satisfaction measurement model is Quantity.
-
SourceDocumentLineUniqueIdentifierCharcter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharcter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharcter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharcter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierCharcter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to uniquely identify a source document line. -
SourceDocumentLineUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber4: integer
(int64)
The fourth numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentLineUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to uniquely identify a source document line.
-
SourceDocumentSubLineUniqueIdentifierCharacter1: string
Maximum Length:
30
The first character column of the composite key of 10 attributes to uniquely identify a source document subline. -
SourceDocumentSubLineUniqueIdentifierCharacter2: string
Maximum Length:
30
The second character column of the composite key of 10 attributes to uniquely identify a source document subline. -
SourceDocumentSubLineUniqueIdentifierCharacter3: string
Maximum Length:
30
The third character column of the composite key of 10 attributes to uniquely identify a source document subline. -
SourceDocumentSubLineUniqueIdentifierCharacter4: string
Maximum Length:
30
The fourth character column of the composite key of 10 attributes to uniquely identify a source document subline. -
SourceDocumentSubLineUniqueIdentifierCharacter5: string
Maximum Length:
30
The fifth character column of the composite key of 10 attributes to uniquely identify a source document subline. -
SourceDocumentSubLineUniqueIdentifierNumber1: number
The first numeric column of the composite key of 10 attributes to uniquely identify a source document subline.
-
SourceDocumentSubLineUniqueIdentifierNumber2: number
The second numeric column of the composite key of 10 attributes to uniquely identify a source document subline.
-
SourceDocumentSubLineUniqueIdentifierNumber3: number
The third numeric column of the composite key of 10 attributes to uniquely identify a source document subline.
-
SourceDocumentSubLineUniqueIdentifierNumber4: number
The fourth numeric column of the composite key of 10 attributes to uniquely identify a source document subline.
-
SourceDocumentSubLineUniqueIdentifierNumber5: number
The fifth numeric column of the composite key of 10 attributes to uniquely identify a source document subline.
-
SourceDocumentTypeCode: string
Maximum Length:
30
The source document type code of the imported source data. -
SourceSystem: string
Maximum Length:
120
The source system code that source data is imported from. The source systems are defined in the Manage Trading Community source systems. -
SubLineTypeCode: string
Maximum Length:
30
The type of document subline. Possible values are DISTRIBUTIONS, ORA_SATIS_EVENT_SMM_PERCENTAGE and ORA_SATIS_EVENT_SMM_QUANTITY.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source