SourceDocumentLines
Returns the source document lines imported into Oracle Revenue Management, including item, pricing, and satisfaction plan details.
Columns
| Name | Type | SupportedFinders | Description |
| LineNumber | String | SourceDocLinesFinderByDocNumber | The line number of the source document line. |
| DocumentLineId [KEY] | Long | PrimaryKey | The identifier of the source document line. |
| ItemNumber | String | SourceDocLinesFinderByDocNumber | The item or service associated with the source document line. |
| UnitOfMeasure | String | SourceDocLinesFinderByDocNumber | Unit of measure of the item or service associated with the source document line. |
| PricePeriodicity | String | SourceDocLinesFinderByDocNumber | The price periodicity of the service or subscription on the source document line. |
| SatisfactionMeasurementModel | String | SourceDocLinesFinderByDocNumber | The satisfaction measurement model of the source document line. |
| PlanStartDate | Date | SourceDocLinesFinderByDocNumber | The start date of the performance satisfaction plan of the source document line. |
| PlanEndDate | Date | SourceDocLinesFinderByDocNumber | The end date of the performance satisfaction plan of the source document line. |
| SourceDocumentLineUniqueIdentifierNumberOne | Decimal | SourceDocLinesFinderByIdentifiers | The first numeric column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierNumberTwo | Decimal | SourceDocLinesFinderByIdentifiers | The second numeric column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierNumberThree | Decimal | SourceDocLinesFinderByIdentifiers | The third numeric column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierNumberFour | Decimal | SourceDocLinesFinderByIdentifiers | The fourth numeric column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierNumberFive | Decimal | SourceDocLinesFinderByIdentifiers | The fifth numeric column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierCharacterOne | String | SourceDocLinesFinderByIdentifiers | The first character column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierCharacterTwo | String | SourceDocLinesFinderByIdentifiers | The second character column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierCharacterThree | String | SourceDocLinesFinderByIdentifiers | The third character column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierCharacterFour | String | SourceDocLinesFinderByIdentifiers | The fourth character column of the composite key that uniquely identifies a source document line. |
| SourceDocumentLineUniqueIdentifierCharacterFive | String | SourceDocLinesFinderByIdentifiers | The fifth character column of the composite key that uniquely identifies a source document line. |
| SourceDocumentTypeCode | String | The code representing the source document type associated with the source document line. | |
| SourceSystem | String | SourceDocLinesFinderByIdentifiers | The source system of the source document line. |
| DataTransformationStatus | String | The processing status of the source document line. | |
| SourceDocumentNumber | String | SourceDocLinesFinderByDocNumber | The source document number of the source document line. |
| SourceDocumentTypeId | Long | SourceDocLinesFinderByIdentifiers | The identifier of the source document type associated with the source document line. |
| ServiceDuration | Decimal | Duration of the service or subscription in terms of price periodicity. | |
| LineAmount | Decimal | The extended line amount of the source document line. | |
| VersionOfSourceProductLine | Int | The version number of the source document line. | |
| ActionCodeForAddingNewLineToExistingContract | String | Indicates if the source document line should be added to the existing performance obligation or create a new performance obligation. | |
| AddToExistingContract | String | Indicates if the source document line can be added to an existing customer contract after the contract is frozen. Valid values are Y and N. | |
| ImmaterialChangeType | String | The immaterial change type of the source document line. | |
| ParentSourceDocumentLineUniqueIdentifierCharacterOne | String | The first character column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierCharacterTwo | String | The second character column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierCharacterThree | String | The third character column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierCharacterFour | String | The fourth character column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierCharacterFive | String | The fifth character column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierNumberOne | Decimal | The first numeric column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierNumberTwo | Decimal | The second numeric column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierNumberThree | Decimal | The third numeric column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierNumberFour | Decimal | The fourth numeric column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ParentSourceDocumentLineUniqueIdentifierNumberFive | Decimal | The fifth numeric column of the composite key that uniquely identifies the parent document line for a new line received from the source system. | |
| ContractModificationDate | Date | The date when the contract is modified. | |
| TerminationDate | Date | The date when the service or subscription is terminated. | |
| ParentLineSourceSystem | String | The source system of the parent source document line. | |
| DocumentTypeCodeOfTheParentLine | String | The source document type code of the parent line from which the source data is imported. | |
| UnitSSP | Decimal | Unit standalone selling price of the item or service associated with the source document line. | |
| DocumentTypeIdOfTheParentLine | Long | The source document type identifier of the parent line from which the source data is imported. | |
| Currency | String | SourceDocLinesFinderByDocNumber | The three-letter ISO code associated with a currency of the source document. |
| CustomerPurchaseOrderNumber | String | SourceDocLinesFinderByDocNumber | The customer purchase order number of the source document. |
| HeaderSourceDocumentTypeCode | String | SourceDocLinesFinderByDocNumber | The source document type code of the source document. |
| HeaderSourceDocumentTypeId | Long | SourceDocLinesFinderByDocNumber | The source document type identifier of the source document. |
| Quantity | Decimal | The quantity of the item or service on the source document line. | |
| BusinessUnit | String | SourceDocLinesFinderByDocNumber | The business unit associated with the source document. |
| LegalEntity | String | SourceDocLinesFinderByDocNumber | The legal entity associated with the source document. |
| Finder | String | A named finder reference used to filter or locate specific source document lines when querying. |