Salesforce Docs Portal

Oracle Fusion Cloud SCM Connector Objects (Maintenance Schema)

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name Description
Debriefs Maintains detailed records for service events, including technician data, customer accounts, and service outcomes.
DebriefsdebriefsDFF Stores customizable descriptive fields for service debriefs to track additional information.
Debriefslines Tracks service line details such as labor, materials, expenses, and activity durations.
DebriefslineslinesDFF Holds customizable fields for capturing additional attributes on service lines.
DebriefsprojectDetailsDFF Contains customizable fields for detailed project tracking within debriefs.
Finders Lists view finder names along with associated attributes for efficient querying.
FlexFndDffDescriptiveFlexfieldContexts Provides methods for managing descriptive flexfield contexts through REST API endpoints.
FlexFndPvsCharacterIdCharacterValues Manages character-based values for flexfield structures, accessible via REST API.
FlexFndPvsCharacterValues Contains character values for managing flexfield configurations.
FlexFndPvsNumberIdCharacterValues Stores numeric values for flexfield configurations.
InstalledBaseAssets Manages customer-owned and maintainable assets, including lifecycle and operational data.
InstalledBaseAssetsassetDFF Holds descriptive flexfields for adding customizable details about assets.
InstalledBaseAssetscharges Tracks asset-related charges, including billing and renewal pricing information.
InstalledBaseAssetsfixedAssetAssociations Maintains associations between installed base assets and fixed assets, including updates and terminations.
InstalledBaseAssetsmeters Manages details about meters associated with assets, including readings and configurations.
InstalledBaseAssetsnotes Enables management of asset-related notes for documentation and communication.
InstalledBaseAssetspartsListComponents Tracks components of an asset's parts list for maintenance and inventory control.
InstalledBaseAssetsrelationships Handles structural relationships between assets, including hierarchical and linked associations.
StandardLookupsLOV Provides a list of standard lookup codes and their translations for shared reference data.
StockingLocations Creates and manages stocking location records to track inventory across organizations and subinventories.
StockingLocationssiteDedicatedLocations Defines stocking location addresses dedicated to specific customer sites for logistics.
TrunkStocks Tracks trunk stock inventory, including quantities and serial numbers for sub-inventories.

Debriefs

Name Type ReadOnly References FilterOnly Description
AssetId Long False No The unique identifier assigned to the asset involved in the service logistics debrief.
BillToPartySiteId Long False No The unique identifier of the bill-to party site, specifying where the customer’s bill is directed.
BUOrgId Long False No The unique identifier of the business unit that is responsible for creating and managing the sales order.
CustomerAccountId Long False No The unique identifier of the customer account associated with the debrief record, used for tracking customer-related transactions.
DebriefHeaderId [KEY] Long False No The unique identifier of the debrief header record, linking to the detailed service or repair activities.
DebriefNumber String False No A unique identifier for the debrief header record, typically assigned sequentially.
DebriefStatusCode String False No An abbreviation identifying the current status of the debrief header, which can be one of several predefined statuses from the 'ORA_RCL_DEBRIEF_STATUS' lookup.
FreezePrice String False No Indicates whether the price is fixed (frozen) when creating the sales order. This option ensures the price does not change after the debrief is processed.
ObjectVersionNumber Int False No A number used for optimistic locking to prevent simultaneous updates to the same record by different sessions. It is incremented every time the record is updated.
ParentEntityCode String False No An abbreviation that identifies the parent entity type for the debrief, such as a work order or service request.
ParentEntityId Long False No The unique identifier of the parent entity (such work order or service request) related to the debrief header.
ParentEntityName String False No The name of the parent entity associated with the debrief, such as a specific work order or service request.
PartyId Long False No The unique identifier of the customer party (from the HZ_PARTIES table) associated with the service logistics debrief record.
ProductItemId Long False No The unique identifier of the product (from the EGP_SYSTEM_ITEMS table) associated with the service logistics debrief record.
ProductSerialNumber String False No The serial number of the product involved in the debrief, used for identifying individual product instances.
TechnicianPartyId Long False No The unique identifier of the technician resource (from the HZ_PARTIES table) associated with the debrief record.
ProductItemNumber String False No The product number that uniquely identifies the item involved in the service logistics debrief.
BUName String False No The name of the business unit where the sales order for the debrief is created.
TechnicianPartyName String False No The name of the technician assigned to the service task associated with the debrief.
CustomerName String False No The name of the customer involved in the service request or debrief.
CustomerAccountNumber String False No The account number associated with the customer for billing and transaction tracking.
AssetNumber String False No The unique asset number that identifies the asset involved in the service logistics process.
ParentEntityCodeMeaning String False No The detailed meaning of the parent entity code, referring to the entity type such as work order or service request.
ParentEntityNumber String False No The identification number of the parent document associated with the service logistics debrief record.
CostOrganizationName String False No The name of the cost organization managing the maintenance and service tasks for the debrief.
CostOrganizationCode String False No The abbreviation or code identifying the maintenance organization handling the debrief.
CostOrganizationId Long False No The unique identifier of the maintenance organization responsible for processing the debrief.
WorkOrderSubTypeMeaning String False No The description of the work order subtype used for categorizing debrief-related work orders.
WorkOrderSubTypeCode String False No An abbreviation identifying the work order subtype related to the service or maintenance task for the debrief.
ProductItemDescription String False No The description of the product involved in the debrief, detailing the item or service being worked on.
BillToAddress String False No The billing address associated with the debrief, indicating where the invoice will be sent.
PurchaseOrder String False No The purchase order number associated with the service request for the debrief header.
ServiceRequestId Long False No The unique identifier of the service request that initiated the debrief.
ServiceRequestNumber String False No The number associated with the service request, used for tracking and referencing the request in the system.
DebriefStatus String False No The status of the debrief, indicating whether the service task has been completed, is in progress, or other statuses.
CreationDate Datetime False No The date and time when the debrief record was created in the system.
CreatedBy String False No The user who created the debrief record, typically the technician or system administrator.
LastUpdateDate Datetime False No The date and time when the debrief record was last updated or modified.
LastUpdatedBy String False No The user who last updated the debrief record, typically a technician or manager.
LastUpdateLogin String False No The login identifier of the user who last updated the debrief record.
RepriceFlag Bool False No Indicates whether the debrief should trigger a repricing process. If true, the system will initiate repricing for the debrief.
CurrencyCode String False No The currency code used for repricing the debrief, such as USD or EUR.
TechnicianPartyNumber String False No The technician’s unique party number in the debriefing system, used for identifying the technician.
TechnicianEmailAddress String False No The email address of the technician assigned to the debrief, used for communication purposes.
OrderId Decimal False No The unique order ID related to the debriefing process, used for tracking.
OrderNumber String False No The order number associated with the debrief, used for referencing the specific transaction.
CreateChargesFlag Bool False No Indicates whether charges created for maintenance work orders should be included in the debrief transaction.
Quantity Decimal False No The quantity of items or units involved in the debrief process.
ReceivedQuantity Decimal False No The quantity of items that have been received or processed in the debrief.
ShipToPartySiteId Long False No The unique identifier for the ship-to party site where the debrief service was performed.
ShipToAddress String False No The shipping address associated with the debrief, where items or services are delivered.
Finder String False No A generic search term used for locating debrief records in the system.

Return to Top

DebriefsdebriefsDFF

Name Type ReadOnly References FilterOnly Description
DebriefsDebriefHeaderId [KEY] Long False No The unique identifier of the debrief header in the Debriefs table, used to link the debrief details.
DebriefHeaderId [KEY] Long False No The unique identifier of the debrief header record, which serves as the primary reference for all related debrief activities.
_FLEX_Context String False No The descriptive flexfield context for the debrief header, used to store additional, flexible data related to the debrief record.
_FLEX_Context_DisplayValue String False No The display value of the context segment, providing a human-readable format for the flexfield context.
Finder String False No A generic search term used for locating debrief records in the system. This helps with filtering and searching for debrief information.

Return to Top

Debriefslines

Name Type ReadOnly References FilterOnly Description
DebriefsDebriefHeaderId [KEY] Long False No The unique identifier for the debrief header, linking it to the specific debrief line records.
BillToPartyId Long False No The unique identifier of the bill-to party (HZ_PARTIES) associated with the debrief transaction.
CurrencyCode String False No The currency code used for the expense amount in the debrief line (referenced from FND_CURRENCIES).
DebriefHeaderId Long False No The unique identifier for the debrief header record, linking it to the overall debrief process.
DebriefLineId [KEY] Long False No The unique identifier for each debrief line, used to reference individual entries in the debrief.
ExpenseAmount Decimal False No The amount associated with the expense in the debrief line.
InventoryItemId Long False No The unique identifier for the inventory item (EGP_SYSTEM_ITEMS), which could be a material, labor, or expense item, depending on the billing type.
ItemRevision String False No The revision number associated with the product item being debriefed.
LaborEndDate Datetime False No The date and time when labor activities related to the debrief line were completed.
LaborStartDate Datetime False No The date and time when labor activities related to the debrief line began.
LineStatusCode String False No The status of the debrief line, indicating its current state. Valid statuses are defined in the lookup type ORA_RCL_DEBRIEF_STATUS.
LineType String False No An internal code identifying whether the debrief line is related to material, labor, or expense.
LotNumber String False No The lot number of the item being debriefed, used for tracking inventory batches.
OrderLineId Long False No The unique identifier for the order line related to the debrief (DOO_LINES_ALL).
OrganizationId Long False No The unique identifier of the organization handling the inventory for the debrief.
ParentInstanceId Long False No The unique identifier for the parent instance of an asset associated with the debrief.
Quantity Decimal False No The quantity of the item being debriefed.
ReasonCode String False No This attribute is not currently in use but could serve as a reason for adjustments or corrections in the debrief.
SerialNumber String False No The serial number of the item being debriefed, used for tracking specific units.
ServiceActivityId Long False No The identifier for the service activity associated with the debrief line (RCL_SERVICE_ACTIVITIES_VL).
SourceId String False No The unique identifier for the application from which the debrief line originated.
SourceType String False No The type of application where the debrief line was first entered.
SubinventoryCode String False No The subinventory name used for installation or return of items in the debrief transaction.
UOMCode String False No The unit of measure code used in the debrief transaction, such as 'EA' for each or 'KG' for kilograms.
OrganizationCode String False No The code identifying the inventory organization related to the debrief line.
InventoryItemNumber String False No The unique number identifying the item associated with the debrief line (EGP_SYSTEM_ITEMS).
BillToPartyName String False No The name of the bill-to party or customer associated with the debrief.
UnitOfMeasure String False No The unit of measure used for the item in the debrief line, such as quantity or weight.
ServiceActivityCode String False No The abbreviation that identifies the service activity associated with the debrief (RCL_SERVICE_ACTIVITIES_VL).
ReservationId Long False No The unique identifier for the inventory reservation created for part installation in the debrief process.
CommonInventoryFlag Bool False No Indicates whether the project inventory is considered common inventory during the debrief material process. 'True' allows issuing parts from the common inventory.
PartyId Long False No The unique identifier for the customer party (associated with the debrief).
PartyName String False No The name of the customer associated with the debrief.
CustomerAccountId Long False No The unique identifier of the customer account involved in the debrief transaction.
CustomerAccountNumber String False No The account number of the customer associated with the debrief.
BillToPartySiteId Long False No The unique identifier of the bill-to party site where the debrief is directed.
BillToAddress String False No The billing address of the customer associated with the debrief.
ServiceActivity String False No A general description of the service activity associated with the debrief line.
ServiceActivityDescription String False No A detailed description of the service activity for the debrief line.
LineCategoryCode String False No The category code assigned to the debrief line.
ZeroChargeFlag Bool False No Indicates whether the debrief line has zero charges. If true, the line is treated as non-billable.
OmInterfaceFlag Bool False No Indicates whether the debrief line has been interfaced with the Oracle Manufacturing system.
InventoryItemDescription String False No A description of the inventory item associated with the debrief line.
LineStatus String False No The current status of the debrief line, such as 'Pending', 'Completed', 'Cancelled'.
ErrorText String False No Text field used for detailing errors encountered during the processing of the debrief line.
LineTypeMeaning String False No A description of the line type, explaining whether it is for material, labor, or expense.
PricingSegmentCode String False No The code for the pricing segment associated with the debrief line.
PricingSegmentExplanation String False No A detailed explanation of the pricing segment applied to the debrief line.
PricingStrategyExplanation String False No A detailed explanation of the pricing strategy applied to the debrief line.
PricingStrategyId Long False No The unique identifier for the pricing strategy applied to the debrief line.
AppliedCurrencyCode String False No The currency code used for applying pricing to the debrief line.
CreationDate Datetime False No The date when the debrief line was created.
CreatedBy String False No The user who created the debrief line record.
LastUpdateDate Datetime False No The date when the debrief line was last updated.
LastUpdatedBy String False No The user who last updated the debrief line record.
LastUpdateLogin String False No The login information of the user who last updated the debrief line.
OriginalOrderLineId Long False No The reference to the original order line for which the debrief correction is created.
OrderNumber String False No The order number associated with the debrief line.
RepairOrderId Long False No The repair order ID related to the debrief line.
RepairOrderNumber String False No The repair order number associated with the debrief line.
BillingTypeCode String False No The billing type code associated with the debrief line.
BillingType String False No A description of the billing type for the debrief line.
UOMClass String False No The class of unit of measure used in the debrief transaction.
PricingSegment String False No The pricing segment associated with the debrief line.
PricingStrategy String False No The pricing strategy applied to the debrief line.
InvoiceId Long False No The invoice ID related to the debrief line.
InvoiceNumber String False No The invoice number related to the debrief line.
RepriceFlag Bool False No A flag indicating whether the debrief line should be repriced after manual adjustments are applied.
StockLocationId Long False No The unique identifier for the inventory stocking location used in the debrief transaction (RCL_STOCK_LOCATIONS).
Finder String False No A generic search term used for locating debrief line records in the system.

Return to Top

DebriefslineslinesDFF

Name Type ReadOnly References FilterOnly Description
DebriefsDebriefHeaderId [KEY] Long False No The unique identifier for the debrief header, linking it to the specific debrief lines in the flexfield.
LinesDebriefLineId [KEY] Long False No The unique identifier for the debrief line, which is part of the larger debrief header structure in the flexfield.
DebriefLineId [KEY] Long False No The identifier for the specific debrief line record, used to reference individual entries in the debrief.
_FLEX_Context String False No The context name used for the descriptive flexfield associated with the debrief lines, defining the structure of data entered.
_FLEX_Context_DisplayValue String False No The display value of the flexfield context, offering a user-friendly description of the context used in the debrief lines flexfield.
DebriefHeaderId Long False No The unique identifier for the debrief header record that ties together the debrief lines in the system.
Finder String False No A search term or identifier used to locate debrief lines flexfield records within the system.

Return to Top

DebriefsprojectDetailsDFF

Name Type ReadOnly References FilterOnly Description
DebriefsDebriefHeaderId [KEY] Long False No The unique identifier for the debrief header, which links to the specific project details flexfield record.
DebriefHeaderId [KEY] Long False No The identifier for the debrief header record that associates the project details with the broader debrief structure.
_FLEX_Context String False No The context name used for the descriptive flexfield associated with the debrief project details, defining the specific data structure used.
_FLEX_Context_DisplayValue String False No The display value of the flexfield context, offering a user-friendly description of the context applied to the project details.
Finder String False No A search term or identifier used to locate the project details flexfield records within the system.

Return to Top

Finders

Name Type ReadOnly References FilterOnly Description
ViewName String False No The name of the database view for which the finder is being applied, helping to identify the view related to the search or lookup process.
FinderName String False No The name of the specific finder being used, which is associated with retrieving or searching data based on the view and its attributes.
AttributeFinderColumn String False No The name of the column in the finder that represents the attribute being searched, helping to specify which field to search within the view.
Type String False No The data type of the attribute in the finder column, indicating the kind of data (for example, string, integer) being handled for search purposes.

Return to Top

FlexFndDffDescriptiveFlexfieldContexts

Name Type ReadOnly References FilterOnly Description
ApplicationId [KEY] Long False No The unique identifier of the application associated with the descriptive flexfield context, which helps in linking the context to a specific application within the system.
DescriptiveFlexfieldCode [KEY] String False No The code of the descriptive flexfield, which is used to identify and reference the flexfield in the system for specific data entry or customization.
ContextCode [KEY] String False No The unique code for the context of the descriptive flexfield, defining the specific usage or scenario in which the flexfield is applied.
Name String False No The name of the descriptive flexfield context, typically used to provide a user-friendly identifier or label for the context in the interface.
Description String False No A detailed description of the descriptive flexfield context, explaining its purpose and usage within the application or module.
EnabledFlag String False No A flag indicating whether the descriptive flexfield context is enabled. Typically, a value of 'Y' signifies that it is enabled, and 'N' indicates that it is disabled.
Bind_ApplicationId Long False No The bound application ID, which links the context to a specific application for configuration purposes or flexibility in applying contexts.
Bind_DescriptiveFlexfieldCode String False No The bound descriptive flexfield code, linking this context to the corresponding flexfield, defining the flexible fields available within this context.
Finder String False No The name of the finder, which is used to locate or search for specific records or data associated with this descriptive flexfield context.

Return to Top

FlexFndPvsCharacterIdCharacterValues

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier of the character value in the FlexFndPvsCharacterIdCharacterValues table.
Value String False No The value associated with a specific character in the FlexFndPvsCharacterIdCharacterValues table.
Description String False No A description that provides additional context or meaning for the character value stored in the table.
StartDateActive Date False No The date from which the character value is considered active. If this date has passed, the character value is considered valid for use.
EndDateActive Date False No The date after which the character value is no longer active. After this date, the character value is considered expired.
EnabledFlag String False No Indicates whether the character value is enabled. A value of 'Y' means the character is enabled, and 'N' means it is disabled.
SummaryFlag String False No Indicates whether the character value is a summary type. If 'Y', it’s a summary; otherwise, it's a detailed entry.
ValueSetCode String False No The code associated with the value set, which groups related character values for a particular purpose or context.
Bind_DataSource String False No The data source associated with the character value. This could be the source from which the value is retrieved or validated.
Bind_FinderContext String False No Defines the context in which the value is found, typically used to specify the search or retrieval criteria for the character value.
Bind_FinderDateFlag String False No Indicates whether the finder query should consider dates while retrieving values. This flag helps filter results based on date criteria.
Bind_ValidationDate Date False No The date used for validating the character value, ensuring it is applicable or relevant based on the context.
Finder String False No The name of the finder that can be used to retrieve the character values based on specific criteria.
Flex_vst_bind1 String False No Custom binding parameter 1 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind10 String False No Custom binding parameter 10 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind11 String False No Custom binding parameter 11 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind12 String False No Custom binding parameter 12 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind13 String False No Custom binding parameter 13 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind14 String False No Custom binding parameter 14 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind15 String False No Custom binding parameter 15 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind16 String False No Custom binding parameter 16 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind17 String False No Custom binding parameter 17 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind18 String False No Custom binding parameter 18 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind19 String False No Custom binding parameter 19 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind2 String False No Custom binding parameter 2 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind20 String False No Custom binding parameter 20 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind3 String False No Custom binding parameter 3 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind4 String False No Custom binding parameter 4 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind5 String False No Custom binding parameter 5 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind6 String False No Custom binding parameter 6 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind7 String False No Custom binding parameter 7 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind8 String False No Custom binding parameter 8 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.
Flex_vst_bind9 String False No Custom binding parameter 9 used for additional filtering or processing in the FlexFndPvsCharacterIdCharacterValues context.

Return to Top

FlexFndPvsCharacterValues

Name Type ReadOnly References FilterOnly Description
Value [KEY] String False No The actual value associated with the character in the FlexFndPvsCharacterValues table.
Description String False No A brief description that provides context or meaning for the character value in the FlexFndPvsCharacterValues table.
StartDateActive Date False No The date when the character value became active and available for use.
EndDateActive Date False No The date when the character value becomes inactive and is no longer applicable.
EnabledFlag String False No Indicates whether the character value is enabled or disabled. A value of 'Y' means enabled, 'N' means disabled.
SummaryFlag String False No Indicates whether the character value represents a summary. 'Y' indicates summary, 'N' indicates detailed information.
ValueSetCode String False No The unique code for the value set to which the character value belongs, used to group related values.
Bind_AttrMap String False No Defines the attribute mapping for the character value, which associates it with the underlying data model.
Bind_DataSource String False No Specifies the data source from which the character value is derived or validated.
Bind_DataSourceDiscr String False No An additional discrimination factor used to filter or specify the data source for the character value.
Bind_FinderContext String False No Specifies the context in which the character value is found, used to define the scope or search parameters.
Bind_FinderDateFlag String False No Indicates whether the date needs to be taken into account when finding or filtering character values.
Bind_ValidationDate Date False No Defines the date used for validating the character value, ensuring it is applicable within the required timeframe.
Finder String False No The name of the finder query that can be used to retrieve character values based on specific conditions.
Flex_vst_bind1 String False No Custom binding parameter 1 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind10 String False No Custom binding parameter 10 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind11 String False No Custom binding parameter 11 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind12 String False No Custom binding parameter 12 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind13 String False No Custom binding parameter 13 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind14 String False No Custom binding parameter 14 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind15 String False No Custom binding parameter 15 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind16 String False No Custom binding parameter 16 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind17 String False No Custom binding parameter 17 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind18 String False No Custom binding parameter 18 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind19 String False No Custom binding parameter 19 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind2 String False No Custom binding parameter 2 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind20 String False No Custom binding parameter 20 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind3 String False No Custom binding parameter 3 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind4 String False No Custom binding parameter 4 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind5 String False No Custom binding parameter 5 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind6 String False No Custom binding parameter 6 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind7 String False No Custom binding parameter 7 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind8 String False No Custom binding parameter 8 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.
Flex_vst_bind9 String False No Custom binding parameter 9 for additional filtering or processing in the the FlexFndPvsCharacterValues table context.

Return to Top

FlexFndPvsNumberIdCharacterValues

Name Type ReadOnly References FilterOnly Description
Id [KEY] Decimal False No The unique identifier for each record in the FlexFndPvsNumberIdCharacterValues table. It is used to reference a specific character value entry.
Value String False No The actual numeric value associated with the character in the FlexFndPvsNumberIdCharacterValues table.
Description String False No A textual description providing further details about the character value in the FlexFndPvsNumberIdCharacterValues table.
StartDateActive Date False No The date when the character value in the FlexFndPvsNumberIdCharacterValues table became active and usable.
EndDateActive Date False No The date when the character value in the FlexFndPvsNumberIdCharacterValues table is no longer valid or active.
EnabledFlag String False No Indicates whether the character value is enabled or disabled in the FlexFndPvsNumberIdCharacterValues table. 'Y' means enabled, 'N' means disabled.
SummaryFlag String False No Indicates whether the character value serves as a summary or detail. 'Y' denotes a summary, while 'N' denotes a detailed entry.
ValueSetCode String False No The unique code associated with the value set to which this character value belongs, used for grouping similar values.
Bind_DataSource String False No Specifies the data source from which the character value is derived or validated.
Bind_FinderContext String False No Defines the context in which the character value is retrieved or found. Used to narrow down the search.
Bind_FinderDateFlag String False No Indicates whether the date should be considered when finding or filtering character values.
Bind_ValidationDate Date False No Specifies the date used to validate the character value, ensuring it is still applicable for the given time period.
Finder String False No The name of the query or finder used to retrieve character values based on specified conditions.
Flex_vst_bind1 String False No Custom binding parameter 1 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind10 String False No Custom binding parameter 10 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind11 String False No Custom binding parameter 11 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind12 String False No Custom binding parameter 12 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind13 String False No Custom binding parameter 13 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind14 String False No Custom binding parameter 14 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind15 String False No Custom binding parameter 15 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind16 String False No Custom binding parameter 16 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind17 String False No Custom binding parameter 17 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind18 String False No Custom binding parameter 18 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind19 String False No Custom binding parameter 19 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind2 String False No Custom binding parameter 2 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind20 String False No Custom binding parameter 20 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind3 String False No Custom binding parameter 3 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind4 String False No Custom binding parameter 4 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind5 String False No Custom binding parameter 5 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind6 String False No Custom binding parameter 6 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind7 String False No Custom binding parameter 7 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind8 String False No Custom binding parameter 8 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.
Flex_vst_bind9 String False No Custom binding parameter 9 used for additional processing or filtering of the FlexFndPvsNumberIdCharacterValues table.

Return to Top

InstalledBaseAssets

Name Type ReadOnly References FilterOnly Description
ActiveEndDate Datetime False No The date when the asset becomes inactive. For maintenance assets, the asset’s active end date must be a future date. For customer assets, this date must be in the past and not earlier than the customer’s active start date. When the asset end date is provided, other asset attributes cannot be updated.
AssetId [KEY] Long False No A unique identifier automatically assigned to each asset when created by the application. This value is read-only.
AssetNumber String False No An optional identifier for the asset. If not provided, the application uses the AssetId as the asset number.
BOMExplosionFlag Bool False No Determines whether to create component assets. If true, it creates child items by expanding the bill of materials for the asset. The default value is false.
CompetitorAssetFlag Bool False No Indicates if the asset represents a competitor’s asset. If true, it is a competitor’s asset; otherwise, it is not. The default value is false.
CurrentLocationContextCode String False No Abbreviation that identifies the location context where the asset resides. A valid list of values is defined in the lookup type 'ORA_CSE_CURRENT_LOC_CONTEXT'. This attribute is required when creating the asset.
CurrentLocationId Long False No A unique identifier for the location where the asset is currently placed. This value is required if the CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION' or 'ORA_INTERNAL_LOCATION'.
CustomerAccountId Long False No A unique identifier for the customer account to which the asset is billed.
CustomerAccountSiteId Long False No A unique identifier for the customer account site associated with the asset. This site must be part of the customer account.
CustomerAccountSiteUseId Long False No A unique identifier for the usage of the customer account site associated with the asset. This value must be part of the customer account site.
CustomerAssetEndDate Datetime False No The date and time when the customer asset becomes inactive. Once this value is set, other asset attributes cannot be updated.
CustomerAssetStartDate Datetime False No The date and time when the customer asset becomes active. This value is determined by the shipment date and is read-only.
CustomerBillingPartyId Long False No A unique identifier for the customer party responsible for billing for the asset. This value is read-only.
CustomerBillingPartySiteId Long False No A unique identifier for the billing party site associated with the customer. This value is read-only.
CustomerId Long False No A unique identifier for the customer party that currently owns or uses the asset. This is required for creating a customer asset.
CustomerSiteId Long False No A unique identifier for the customer site where the asset resides. This value is required when the 'CurrentLocationContextCode' is set to 'ORA_CUSTOMER'.
CustomerSitePartyId Long False No A unique identifier for the customer site party where the asset is located.
Description String False No A description of the asset, used to provide details on its features or characteristics.
DfltWoSubTypeCode String False No Abbreviation identifying the work order sub-type. This value is selected from the 'ORA_MNT_WO_SUB_TYPE' lookup and is used when creating work orders for the asset.
DfltWoTypeCode String False No Abbreviation identifying the work order type. This value is selected from the 'ORA_MNT_WO_TYPE' lookup and is used when creating work orders for the asset.
FulfillLineId Long False No A unique identifier for the fulfillment line associated with the asset in the installed base.
InServiceDate Date False No The date when the asset was placed in service by the organization. The in-service date must occur after the installation date.
InstalledDate Date False No The date when the asset was installed. The installed date must occur after the shipment date and before the in-service date.
LocatorId Long False No A unique identifier for the locator where the asset is placed in the installed base.
IotEnabledFlag Bool False No Indicates whether the asset is synchronized with the Internet of Things (IoT) application. If true, the asset will be synchronized. The default value is true.
ItemId Long False No The unique identifier for the item associated with the asset. This is required when 'ItemRequiredFlag' is true. For customer assets, the item must have 'Enable Asset Tracking' set to 'Customer Asset' or 'Full Lifecycle'. For enterprise assets, it must be set to 'Full Lifecycle'.
OperatingOrganizationId Long False No The unique identifier for the organization that operates or creates the asset. This is required for creating an enterprise asset. If not provided, the application uses the item master organization.
ItemRevision String False No The revision number for the item associated with the asset.
LocationOrganizationId Long False No The unique identifier for the organization where the asset is located. This is required when 'CurrentLocationContextCode' is set to 'ORA_WORK CENTER'.
LotNumber String False No The lot number identifying the inventory lot for the item associated with the asset. This is applicable when the item is lot-controlled.
MaintainableFlag Bool False No Indicates whether the asset is eligible for maintenance activities, such as work orders. If true, the asset can be maintained. The default value is true.
NewWoAllowedFlag Bool False No Indicates whether the application can create a work order for the asset. If true, a work order can be created; otherwise, it cannot. The default value is true.
PurchaseDate Date False No The date when the customer purchased the asset. It must occur before the registration date.
Quantity Decimal False No The quantity for the asset, which is required for the item. If the item is serial controlled, the quantity cannot exceed one.
RegistrationDate Date False No The date and time when the customer registered the asset.
SalesOrderId Long False No The unique identifier for the sales order used to order the asset.
SalesOrderLineId Long False No The unique identifier for the line item on the sales order used to order the asset.
SalesOrderLineNumber String False No The unique number identifying the line item on the sales order used to order the asset.
SalesOrderNumber String False No The number identifying the sales order used to order the asset.
SalesOrderSourceSystem String False No The name of the external application from which the sales order originated. If the source system is internal, it identifies an Oracle Fusion application.
SalesOrderSourceSystemType String False No Describes whether the sales order originated from an internal or external application. This is read-only.
SerialNumber String False No A unique serial number for the asset when the item is serial-controlled. The serial number must be created in the inventory if it does not already exist.
ShipmentDate Datetime False No The date when the asset was shipped to the customer. This is optional, and if not provided, the application uses the current date.
SoldByBusinessUnitId Long False No The unique identifier for the business unit that sold the asset. This is optional.
SplitFromAssetId Long False No The unique identifier for the asset from which this asset was split during partial returns.
SubinventoryCode String False No The subinventory code where the asset is stored or located.
UOMCode String False No The unit of measure code for the asset. It must match the unit of measure used for the item.
UpdateContractFlag Bool False No Indicates whether changes to the asset should be communicated to the enterprise contract application. If true, changes are sent to the contract system. The default is true.
WorkCenterId Long False No The unique identifier for the work center where the asset is located.
WorkCenterName String False No The name of the work center where the asset resides.
CustomerSitePartyName String False No The name of the customer site party where the asset is located.
CustomerSiteName String False No The name of the customer site where the asset resides.
CustomerAccountName String False No The name of the customer account to which the asset is billed.
CustomerAccountSiteName String False No The name of the customer account site associated with the asset.
OperatingOrganizationCode String False No The abbreviation for the organization that creates or operates the asset. It is used to create either customer or enterprise assets.
ManageAssetPrivilege String False No Indicates the level of responsibility for managing the asset. C stands for customer asset responsibility, M for enterprise asset responsibility, and MC for super-user responsibility.
ItemNumber String False No The unique item number for the asset. This is required when 'ItemRequiredFlag' is true and must correspond to an item with asset tracking enabled.
CustomerName String False No The name of the customer who owns or uses the asset. This is read-only.
CustomerNumber String False No A unique identifier for the customer associated with the asset. You can provide either 'CustomerId' or 'CustomerNumber'.
ItemRequiredFlag Bool False No Indicates whether an item is required to create the asset. If true, the item is required. The default is false.
Country String False No The country where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'.
City String False No The city where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'.
PostalCode String False No The postal code for the location where the asset resides, required if 'CurrentLocationContextCode' is 'ORA_EXTERNAL_LOCATION'.
State String False No The state where the asset is located if 'CurrentLocationContextCode' is set to 'ORA_EXTERNAL_LOCATION'.
Address1 String False No The first line of the address for the asset’s location, required if 'CurrentLocationContextCode' is 'ORA_EXTERNAL_LOCATION'.
Address2 String False No The second line of the address for the asset’s location, if applicable.
Address3 String False No The third line of the address for the asset’s location, if applicable.
Address4 String False No The fourth line of the address for the asset’s location, if applicable.
Province String False No The province where the asset resides if CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION'.
County String False No The county where the asset is located if CurrentLocationContextCode is set to 'ORA_EXTERNAL_LOCATION'.
CurrentLocationContext String False No The context in which the asset’s current location is identified.
LocatorName String False No The name of the locator where the asset is stored.
CurrentLocationName String False No The name of the current location of the asset.
ContactId Long False No The unique identifier for the asset contact. You can use the contact identifier, number, or name to link a contact to the asset.
ContactName String False No The name of the asset’s contact person. This is the concatenation of the first, middle, and last names, as defined in the customer data model.
ContactNumber String False No The contact number for the asset's person. This can be used to create or update the asset's contact information.
ParentAssetId Long False No The unique identifier for the parent asset to which this asset is related.
StructureActionCode String False No Indicates the action for the asset relationship, such as adding or removing the asset from a parent asset.
WorkCenterCode String False No The code identifying the work center where the asset is located, when 'CurrentLocationContextCode' is 'ORA_WORK CENTER'.
CustomerAccountNumber String False No The number that identifies the customer account to which the asset is billed.
CustomerAccountSiteNumber String False No The unique number identifying the site of the customer account where the asset is located.
SoldByBusinessUnitName String False No The name of the business unit that sold the asset.
LocationOrganizationCode String False No The organization code identifying the location where the asset is stored, used when the 'CurrentLocationContextCode' is set to 'ORA_WORK CENTER'.
CustomerSiteNumber String False No The unique number identifying the customer site where the asset resides.
CustomerSitePartyNumber String False No The unique number identifying the customer site party for the asset.
CustomerAccountSiteUseCode String False No The code identifying the usage of the customer account site for the asset.
ItemCustomerSelfServiceFlag Bool False No Indicates whether the item is available for self-service by the customer.
ItemServiceRequestEnabledCode String False No Indicates whether service requests are enabled for the item associated with the asset.
ItemDescription String False No The description of the item associated with the asset.
ItemLongDescription String False No The detailed description of the item associated with the asset.
SecondaryQuantity Decimal False No The secondary quantity for dual-unit-of-measure items, which overrides the default quantity if required.
SecondaryUOMCode String False No The code for the secondary unit of measure associated with the asset, used for dual-UOM items.
CustomerPartyType String False No Indicates whether the customer is an organization or an individual party.
ReturnSourceOrderNumber String False No The reference number for the return source sales order when processing returns.
ReturnOrderNumber String False No The unique identifier for the return sales order number.
ReturnOrderFulfillLineId Long False No The unique identifier for the return order fulfillment line.
ReturnOrderId Long False No The unique identifier for the return order.
ReturnOrderLineId Long False No The unique identifier for the return order line.
OperatingOrganizationName String False No The name of the organization responsible for operating or managing the asset.
CurrentLocationNameFormatted String False No The formatted name of the asset’s current location.
Finder String False No Finder for 'InstalledBaseAssets'.

Return to Top

InstalledBaseAssetsassetDFF

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table, used in the descriptive flexfield (DFF) resource. This attribute is read-only.
AssetId [KEY] Long False No The unique identifier of the asset. This value is used in the descriptive flexfield resource for the asset and is read-only.
AssetCriticality String False No Defines the criticality level of the asset. This attribute provides information on how important the asset is to business operations, often used to prioritize maintenance or response efforts.
InstallationDate Date False No The date when the asset was installed. This value represents the asset's installation date in the descriptive flexfield resource.
_FLEX_Context String False No The context name of the descriptive flexfield for the asset. This context defines the group of segments available for the asset's descriptive flexfield.
_FLEX_Context_DisplayValue String False No The display value of the descriptive flexfield context for the asset. This is the user-friendly version of the context name shown in the UI.
Finder String False No This attribute allows users to search and filter asset records based on descriptive flexfield values.

Return to Top

InstalledBaseAssetscharges

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used in the InstalledBaseAssetscharges table and is read-only.
AssetChargeId [KEY] Long False No The unique identifier for the asset charge. This value is automatically generated by the application when the asset charge is created and is read-only.
AssetId Long False No The unique identifier of the asset to which the charge is associated. The asset referenced determines the value for this attribute, and it is read-only.
ChargeComponentsRollupFlag Bool False No Indicates whether the charge component represents an aggregated value from a rollup charge. If true, the charge component is a rollup; if false, it is not. The default value is false.
ChargeDefinitionCode String False No The abbreviation that uniquely identifies the pricing charge definition. This attribute is required to define the asset charge.
ChargesRollupFlag Bool False No Indicates whether the pricing charge is a rollup charge. If true, the charge is a rollup; if false, it is not. The default value is false.
CurrencyCode String False No The abbreviation for the currency used by the pricing charge. This attribute is required to define the charge for asset pricing.
PriceElementCode String False No The abbreviation that identifies the pricing element associated with the charge. This attribute is required to define the asset charge.
PriceElementUsageCode String False No Indicates whether the unit price in the pricing element is the list price or the net price. This attribute helps distinguish between the two pricing methods.
PricePeriodicityCode String False No The abbreviation for the recurring time period used to price the charge, such as monthly or yearly. This helps define the periodicity of the asset charge.
PricedQuantityUOMCode String False No The abbreviation for the unit of measure used for the quantity being priced. This attribute is required to define the charge for asset pricing.
PrimaryFlag Bool False No Indicates whether the charge is the primary charge for the asset. If true, the charge is considered primary; if false, it is secondary. The default value is false.
TaxIncludedFlag Bool False No Indicates whether the asset price includes taxes. If true, taxes are included in the price; if false, they are not. The default value is false.
UnitPrice Decimal False No The unit price of the asset, representing the current price or the price at which the asset was sold. This is used for pricing the asset.
Finder String False No The finder allows users to search for and filter asset charge records based on specific criteria.

Return to Top

InstalledBaseAssetsfixedAssetAssociations

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used to associate the asset with a fixed asset in the InstalledBaseAssetsfixedAssetAssociations table.
ActiveEndDate Datetime False No The date and time when the association between the installed base asset and the fixed asset becomes inactive. This marks the end of the relationship between the two assets.
ActiveStartDate Datetime False No The date and time when the association between the installed base asset and the fixed asset becomes active. This marks the beginning of the relationship between the two assets.
AutoTerminationFlag String False No Indicates whether the association will be automatically terminated. If true, the association is automatically deactivated; if false, it is not. The flag is set conditionally during asset updates based on certain criteria.
FixedAssetId Long False No The unique identifier for the fixed asset in the table. This attribute establishes the link between an installed base asset and a fixed asset.
TerminationReasonCode String False No The message code for the reason behind the auto-termination of the association, provided when the 'AutoTerminationFlag' is set to true. This code is conditionally displayed in the user interface and explains why the association was terminated.
FixedAssetNumber String False No The unique identifier for the fixed asset, usually an asset number assigned to the fixed asset.
AssetId Long False No The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used in the InstalledBaseAssetsfixedAssetAssociations table to associate the fixed asset with an installed base asset.
Finder String False No The finder used to search for and retrieve the asset associations based on specific criteria.

Return to Top

InstalledBaseAssetsmeters

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This attribute links the asset with its associated meters for tracking consumption or usage.
MeterUsageCode String False No A code that identifies the usage type of the meter. This attribute categorizes the meter based on its specific application or function for the asset.
MeterObjectId Long False No The unique identifier for the meter object in the system. It is used to reference the specific meter associated with the asset.
MeterId Long False No A unique identifier for the meter itself. This value is used to track the meter and its readings.
AssetNumber String False No The number assigned to the asset. This is used to identify the asset and is usually linked with the asset's primary identification in the system.
ActiveEndDate Datetime False No The date and time when the meter association with the asset becomes inactive. This attribute is used to mark the end of the meter's active usage period.
ActiveStartDate Datetime False No The date and time when the meter association with the asset becomes active. This attribute indicates when the meter starts tracking the asset's usage.
LastReadingValue String False No The value recorded during the last reading of the meter. This represents the latest measurement or usage tracked by the meter.
LastReadingDate Datetime False No The date and time when the last meter reading was taken. This attribute helps track when the most recent data was recorded.
LastReadingComments String False No Any comments associated with the last meter reading. This can be used for additional information regarding the reading or the meter's condition at the time.
DisplayedReading String False No The reading shown on the meter for display purposes. This may be a rounded or simplified version of the actual reading value.
LifeToDateReading Decimal False No The total reading accumulated by the meter since its installation or reset. This reflects the overall usage tracked by the meter.
WorkOrderId Long False No The unique identifier of the work order associated with the meter. This links the meter readings to any maintenance or service activities performed on the asset.
WorkOrderNumber String False No The work order number associated with the meter. This is used to reference a specific work order for the asset's maintenance or servicing.
MeterTypeCode String False No A code that identifies the type of meter being used. This attribute is part of the setup and helps categorize meters for asset tracking.
MeterType String False No The type of meter used for tracking the asset's usage, such as energy, water, or gas. This helps identify the purpose of the meter.
MeterDefinitionId [KEY] Long False No The unique identifier for the meter definition. This refers to the setup or template that defines the characteristics of the meter.
MeterName String False No The name assigned to the meter. This name is used to uniquely identify the meter and distinguish it from others in the system.
MeterDescription String False No A description of the meter. This attribute provides more detailed information about the meter's function and purpose.
MeterCode String False No A code used to uniquely identify the meter. This code is part of the setup and allows the meter to be referenced in the system.
ReadingDirection String False No The direction in which the meter readings are taken, such as forward or reverse. This attribute helps define how the meter tracks usage over time.
ReadingDirectionMeaning String False No A description of the meaning of the reading direction. It explains the context of the reading direction (for example, increase or decrease in the tracked value).
ReadingTypeCode String False No A code identifying the type of reading, such as initial, regular, or final. This allows the system to categorize readings.
ReadingType String False No The type of reading taken by the meter, such as usage reading or diagnostic reading. This helps classify the meter's data.
UOMCode String False No The unit of measure (UOM) code associated with the meter's readings, such as kilowatt-hours (kWh) or gallons. This ensures consistent tracking of the meter's data.
UnitOfMeasure String False No The full name of the unit of measure (UOM) used for the meter readings. This provides more detailed information about the UOM.
RolloverResetValue Decimal False No The value at which the meter's reading resets due to rollover. This happens when the meter reaches a specific limit and starts counting from a predefined starting point.
RolloverMaximumValue Decimal False No The maximum value the meter can reach before it resets or rolls over. This helps track how the meter handles large or continuous readings.
RolloverAllowedFlag Bool False No Indicates whether rollover is allowed for the meter. If true, the meter can reset once it reaches its maximum value. If false, the meter does not allow rollover.
ResetAllowedFlag Bool False No Indicates whether resetting the meter is allowed. If true, the meter can be manually reset to start counting from zero. If false, resetting is not permitted.
ResetValue Decimal False No The value to which the meter reading is reset. This is used to manually set the meter back to a starting value, typically when maintenance is performed.
DailyUtilizationRate Decimal False No The daily usage rate for the asset, as measured by the meter. This reflects the asset's average daily consumption or usage.
AllowInMaintProgramFlag Bool False No Indicates whether the meter is included in maintenance programs. If true, the meter is part of a scheduled maintenance plan; if false, it is excluded.
RecordAtWoComplCode String False No The code used to record the meter reading when the work order is completed. This helps track meter data during the completion of service or maintenance tasks.
RecordAtWoComplMeaning String False No The description of the meaning behind the work order completion code. This provides context for the actions taken during the work order's completion.
UtilizationRateComputedAt Decimal False No The calculated utilization rate at the time of meter reading. This value represents how much of the asset’s capacity has been used up at a given point in time.
CalculatedUtilizationRate Decimal False No The computed rate of utilization based on the meter readings and asset usage over time.
AssetId Long False No The unique identifier for the asset associated with the meter. This attribute links the meter readings to a specific asset.
Finder String False No The finder used to search and retrieve meter data based on specific criteria.

Return to Top

InstalledBaseAssetsnotes

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This attribute links the note to a specific asset in the system.
NoteId [KEY] Long False No The unique identifier for the note. This value is generated when the note is created and used to reference the specific note in the system.
SourceObjectCode String False No The name of the source object that created the note. By default, the system sets this value to 'CSE_ASSET' during note creation. This attribute is read-only.
SourceObjectId String False No The unique identifier for the source object associated with the note. It is set to the asset identifier during note creation and is read-only.
PartyName String False No The name of the party associated with the note. This could refer to a customer, user, or other entity in the system.
NoteTxt String False No The content or actual text of the note. This contains the detailed information or message entered when creating the note.
NoteTypeCode String False No An abbreviation that uniquely identifies the type of note, such as 'INTERNAL', 'EXTERNAL', or 'PRIVATE'. The system automatically sets this during creation, and this attribute is read-only.
VisibilityCode String False No Indicates the visibility level of the note. It can be 'INTERNAL', 'EXTERNAL', or 'PRIVATE'. A private note can only be viewed by the creator, while others can have broader access depending on the visibility setting.
CreatorPartyId Long False No The unique identifier for the user who created the note. This value is automatically set by the system and is read-only.
CreatedBy String False No The user who created the note. This attribute is read-only and is automatically populated by the system.
CreationDate Datetime False No The date and time when the note was created. This is automatically set during the creation process and is read-only.
LastUpdateDate Datetime False No The date and time when the note was last updated. This attribute is automatically set by the system whenever changes are made to the note.
PartyId Long False No The unique identifier for the party associated with the note, often representing the customer or user. This attribute is used to link the note to a specific party.
CorpCurrencyCode String False No The currency code used by the party who created the note. This attribute is read-only and is not currently in use.
CurcyConvRateType String False No The currency conversion rate type associated with the party who created the note. This attribute is read-only and is not currently in use.
CurrencyCode String False No The currency code for the party who created the note. This attribute is read-only and is not currently in use.
ContactRelationshipId Long False No The unique identifier for the customer contact associated with the note. This attribute is read-only and not currently in use.
ParentNoteId Long False No The unique identifier for the parent note. If the note is a reply or follow-up, this attribute links it to the original note.
LastUpdatedBy String False No The user who last updated the note. This value is automatically populated by the system whenever the note is modified.
LastUpdateLogin String False No The login credentials of the user who last updated the note. This attribute provides an audit trail for changes made to the note.
EmailAddress String False No The email address of the user who created the note. This value is used for contact purposes or notifications.
FormattedAddress String False No The formatted address of the user who created the note. This value is presented in a standard address format for easier reference.
FormattedPhoneNumber String False No The formatted phone number of the user who created the note. This value is used for contact purposes.
UpdateFlag Bool False No A flag indicating whether the note can be updated. If true, the note is eligible for updates; if false, updates are not allowed.
DeleteFlag Bool False No A flag indicating whether the note can be deleted. If true, the note is eligible for deletion; if false, deletion is not allowed.
NoteNumber String False No A unique number assigned to the note for reference. This value is automatically generated by the system during creation and is read-only.
NoteTitle String False No The title or subject of the note. This is an optional field that the user can enter to summarize the note's content.
AssetId Long False No The unique identifier for the asset associated with the note. This value links the note to a specific asset record in the system.
Finder String False No The finder associated with the note. It is used for searching and retrieving specific notes based on criteria in the system.

Return to Top

InstalledBaseAssetspartsListComponents

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This value links the parts list component to a specific asset.
ItemOrganizationId Long False No The unique identifier for the organization to which the part list item is assigned. This is a required attribute to ensure proper inventory management and organization of parts.
AssetId Long False No The unique identifier for the asset that the part list component is associated with. This attribute links the part to a specific asset in the system.
ComponentQuantity Decimal False No The quantity of each part in the part list that is required for the asset. This specifies how many units of the part are needed to complete the asset configuration.
ItemId Long False No The unique identifier for the item that is part of the asset's part list. This value represents a specific item in the inventory that is associated with the asset.
ListComponentId [KEY] Long False No The unique identifier for the part list item. This is used to reference a specific component in the asset's part list, ensuring that the right parts are assigned to the asset.
ItemNumber String False No The number that uniquely identifies the item within the part list for the asset. This number helps in identifying specific components and ensures that the correct item is referenced in the part list.
SecondaryQuantity Decimal False No The secondary quantity of the product referenced by the asset. This is used when dual unit of measure (UOM) is configured, allowing for additional measurement or conversion of the product quantity.
SecondaryUOMCode String False No The unit of measure code for the secondary quantity of the part. This field is used to track and convert quantities if the item uses a secondary UOM. It must match the UOM set up for the item.
Finder String False No The finder associated with the parts list component. This is used for searching and retrieving specific part list items based on criteria in the system.

Return to Top

InstalledBaseAssetsrelationships

Name Type ReadOnly References FilterOnly Description
InstalledBaseAssetsAssetId [KEY] Long False No The unique identifier for the asset in the InstalledBaseAssets table. This value links the asset to its relationships with other assets.
RelationshipId [KEY] Long False No The unique identifier for the asset relationship. This value is generated by the system when a relationship between assets is created, and is read-only.
AssetId Long False No The unique identifier for the child asset in the relationship structure. This is a required attribute for defining the relationship between the parent and child assets.
SerialNumber String False No The serial number of the child asset in the relationship. This helps uniquely identify the asset, especially when dealing with serialized inventory.
ItemNumber String False No The item number associated with the child asset in the relationship. This attribute provides additional identification for the asset item in the system.
AssetNumber String False No The unique number that identifies the child asset in the asset relationship structure. This is a read-only attribute that is automatically set by the system.
LogicalObjectId Long False No The logical object ID associated with the asset relationship. This ID is used internally to manage the asset relationship data structure.
Finder String False No The finder associated with the asset relationships. This is used to search and retrieve specific asset relationships based on the criteria set in the system.

Return to Top

StandardLookupsLOV

Name Type ReadOnly References FilterOnly Description
LookupType [KEY] String False No The type of the lookup in the StandardLookupsLOV table, used to categorize different lookup sets.
LookupCode [KEY] String False No The unique code identifying a specific entry within a lookup type in the StandardLookupsLOV table.
Meaning String False No A description or interpretation of the lookup code, providing a clear understanding of its purpose or value.
Description String False No Detailed explanation of the lookup code's significance or usage within the system.
Tag String False No A tag or label associated with the lookup, often used for filtering or categorization purposes.
ActiveDate Date False No The date when the lookup record became active or valid within the system.
Bind_ParentLookupCode String False No The lookup code of the parent lookup, if the current lookup is part of a hierarchical structure.
Bind_ParentSetidDetermType String False No Indicates the method used to determine the parent set ID for the lookup, providing context for how the hierarchy is structured.
Bind_ParentSetidDetermValue String False No The value associated with the parent set ID determination method, providing more details on how the parent lookup is identified.
Bind_RelationshipId Long False No The identifier linking this lookup entry to its related entry, facilitating complex relationships between lookups.
BindActiveDate Date False No The active date of the binding relationship, indicating when the lookup’s relationship became valid.
BindLookupCode String False No The lookup code that defines the binding relationship for the lookup, used to tie entries together.
BindLookupType String False No The type of lookup associated with the binding, indicating the category to which the binding entry belongs.
BindTag String False No The tag associated with the binding, used for organizational or filtering purposes in the lookup structure.
Finder String False No The name of the finder used to retrieve lookup values from the database, providing a method for querying lookups.
NewLookupCode1 String False No A new lookup code for categorizing or referencing a specific entry in the system.
NewLookupCode2 String False No A second new lookup code, providing additional flexibility for categorization.
NewLookupCode3 String False No A third new lookup code, allowing further classification of lookup entries.
NewLookupCode4 String False No A fourth new lookup code, expanding the lookup categorization options.
NewLookupCode5 String False No A fifth new lookup code, offering additional classification possibilities within the lookup structure.

Return to Top

StockingLocations

Name Type ReadOnly References FilterOnly Description
StockLocationId [KEY] Long False No A unique identifier for the stocking location within the system, used to track inventory and storage information.
OrganizationId Long False No A unique identifier for the inventory organization associated with the stocking location. This helps link the stocking location to the organization responsible for managing the inventory.
OrganizationCode String False No An abbreviation representing the inventory organization, used to categorize stocking locations within the organization.
Subinventory String False No The name of the subinventory associated with the stocking location, indicating a subdivision within the inventory organization.
Condition String False No Defines the condition of the stocking location, with possible values of Usable or Defective. This attribute helps categorize the usability of the location for inventory storage.
LocationType String False No Defines the type of location where inventory is stored. Possible values include TECHNICIAN, UNMANNED, MANNED, and SITE_DEDICATED. This categorizes the nature of the location and its intended use.
LocationTypeMeaning String False No Provides a description of the location type, explaining its role such as Technician, Unmanned Warehouse, Manned Warehouse, and Site Dedicated Warehouse.
ConditionMeaning String False No Describes the condition of the stocking location, indicating whether it is usable or defective. This attribute is based on values from the lookup type ORA_RCL_STOCK_LOC_CONDITION.
Finder String False No The name of the finder that retrieves stocking location data from the database, enabling efficient lookup and management of stocking locations.

Return to Top

StockingLocationssiteDedicatedLocations

Name Type ReadOnly References FilterOnly Description
StockingLocationsStockLocationId [KEY] Long False No A unique identifier for the stocking location within the service logistics system. This ID links to the primary record in the stocking locations table.
SiteDedicatedLocId [KEY] Long False No A unique identifier for the site-dedicated location record in the dedicated sites table (RCL_SITE_DEDICATED_LOCATIONS). This attribute is used to track dedicated locations associated with specific sites.
PartySiteId Long False No A unique identifier for the customer site (HZ_PARTY_SITES) linked to the stocking location. This ID is used to associate stocking locations with customer-specific sites for logistical purposes.
StockLocationId Long False No A unique identifier for the specific stocking location record in the service logistics stocking-location table (RCL_STOCK_LOCATION). This attribute helps manage individual stocking locations.
PartySiteNumber String False No A number that uniquely identifies the customer site (HZ_PARTY_SITES) associated with the stocking location. This attribute provides a way to reference the customer site within the stocking locations table.
Finder String False No The name of the finder used to retrieve data from the stocking location's table, enabling efficient lookups and queries related to site-dedicated stocking locations.

Return to Top

TrunkStocks

Name Type ReadOnly References FilterOnly Description
StockLocationId Long False No A unique identifier for the stocking location in the trunk stock system. It helps to identify and track the specific location where inventory is stored.
OrganizationId [KEY] Long False No A unique identifier for the organization associated with the trunk stock. This is used to determine which organization the stock belongs to.
OrganizationCode String False No The code representing the organization that manages or owns the trunk stock. It helps categorize and identify the organization in reports and operations.
Subinventory [KEY] String False No The name or code of the subinventory within the organization where the trunk stock is stored. This field is used to classify stock at a more granular level within the organization.
InventoryItemId [KEY] Long False No A unique identifier for the inventory item in the trunk stock system. This identifier links the trunk stock to the corresponding inventory item.
ItemNumber String False No The item number used to identify the product or material in the trunk stock. This number provides a reference for inventory management.
Revision String False No The revision number of the item in the trunk stock. It is used to track different versions or updates of the item in the inventory.
ItemSerialControl Decimal False No Indicates the serial control applied to the item in the trunk stock. It tracks whether the item is managed by serial number.
UOMCode String False No The unit of measure code that identifies how the trunk stock is measured. This code is used for inventory and transaction processing.
UnitOfMeasure String False No The unit of measure used for the inventory item in the trunk stock. It is a descriptive term that identifies how the item is quantified, such as 'each' or 'box'.
TotalQoh Decimal False No The total quantity on hand (QOH) of the item in the trunk stock. It represents the total amount of the item available for use or sale.
TotalAvailable Decimal False No The total available quantity of the item in the trunk stock. It accounts for items that are not reserved or committed to other transactions.
RecoveredPartDispCode String False No The recovery disposition code for parts in the trunk stock. It categorizes parts based on their condition, such as 'recovered' or 'scrapped'.
SerialNumber [KEY] String False No The serial number of the item in the trunk stock. This number uniquely identifies each instance of the item, particularly useful for items tracked by serial number.
TransactionDate Datetime False No The date and time when the transaction related to the trunk stock occurred. It is used to track the timing of inventory changes.
ItemDescription String False No A description of the item in the trunk stock. It provides detailed information about the item, such as its function or specifications.
Finder String False No The name of the finder function used to search and retrieve specific trunk stock records in the database.

Return to Top