Oracle Fusion Cloud SCM Connector Objects (Maintenance Schema)

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.

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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