Oracle Fusion Cloud SCM Connector Objects (SCMCommon 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
B2bApplicationPartners	Provides details of cross-referenced entities, such as customers or suppliers, involved in B2B message processing in Oracle Fusion applications.
B2bApplicationPartnersdocuments	Retrieves documents associated with application partners for B2B message processing, linking Oracle Fusion applications and trading partners.
B2bMessageTransactions	Manages B2B messages exchanged between Oracle Fusion applications and trading partners using the Collaboration Messaging Framework.
B2bMessageTransactionsdeliveryAttempts	Tracks reprocessed messages that failed or encountered errors during delivery attempts in the Collaboration Messaging Framework.
B2bMessageTransactionsreceiptConfirmations	Captures confirmation messages from trading partners indicating successful receipt of outbound business documents.
B2bTradingPartners	Details external entities, such as customers and suppliers, involved in B2B message exchanges within Oracle Fusion applications.
B2bTradingPartnersb2bServiceProviders	Provides information about external service providers that facilitate message processing for trading partners.
B2bTradingPartnersconfirmationCodes	Maps status codes between trading partners and Oracle's Collaboration Messaging Framework for message processing.
B2bTradingPartnersdeliveryMethods	Specifies communication methods between the Collaboration Messaging Framework and trading partners for message exchange.
B2bTradingPartnersdocuments	Manages documents exchanged with trading partners for B2B message processing.
B2bTradingPartnersdocumentsmessageProcessingRules	Defines message processing rules applied to documents exchanged with trading partners.
B2bTradingPartnersinboundCollaborationMessages	Details inbound messages received from trading partners by the Collaboration Messaging Framework.
B2bTradingPartnersinboundCollaborationMessagesdomainValueMaps	Manages domain value mappings for inbound messages to ensure proper processing and integration.
B2bTradingPartnersinboundCollaborationMessagesmessageProcessingRules	Lists rules applied during processing of inbound messages from trading partners.
B2bTradingPartnersoutboundCollaborationMessages	Provides details of outbound messages sent to trading partners from the Collaboration Messaging Framework.
B2bTradingPartnersoutboundCollaborationMessagesdomainValueMaps	Manages domain value mappings for outbound message processing.
B2bTradingPartnersoutboundCollaborationMessagesmessageProcessingRules	Defines processing rules for outbound messages sent to trading partners.
Carriers	Manages carrier entities used for shipping, including shipping methods, contacts, and tracking rules.
Carrierscontacts	Stores contact information associated with carriers.
CarriersDFF	Maintains descriptive flexfields for carrier entities to support custom attributes.
CarriersinboundTrackingRules	Defines tracking rules for shipments managed by carriers, including web service configurations.
CarriersinboundTrackingRulesorganizationAssociations	Links tracking rules to inventory organizations authorized to use them.
CarriersinboundTrackingRulesparameters	Stores unique parameters required by carrier web services for shipment tracking.
CarriersshippingMethods	Defines shipping methods, including transport modes and service levels, offered by carriers.
CarriersshippingMethodsDFF	Maintains descriptive flexfields for shipping methods to allow custom configurations.
CarriersshippingMethodsorganizationAssociations	Associates shipping methods with inventory organizations authorized to use them.
Finders	Lists available finders and their attributes for querying views in Oracle Fusion applications.
FlexFndDffDescriptiveFlexfieldContexts	Provides API endpoints to retrieve or query descriptive flexfield contexts.
FlexFndPvsCharacterIdCharacterValues	Retrieves character-based values associated with flexfield segments for specific business objects.
FlexFndPvsCharacterValues	Manages character-based values for flexfield segments.
FlexFndPvsNumberIdCharacterValues	Manages numeric values associated with flexfield segments for specific business objects.
InventoryOrganizations	Manages subsets of organizations for logistics, manufacturing, or asset management purposes.
InventoryOrganizationsinvOrgParameters	Handles default values for transactions within specific inventory organizations.
InventoryOrganizationsinvOrgParametersorganizationParameterDFF	Maintains descriptive flexfields for inventory organization parameters.
InventoryOrganizationsplantParameters	Manages default parameters for plant-specific manufacturing or maintenance organizations.
ItemUnitOfMeasureConversions	Provides unit conversion details for items to facilitate accurate transaction reporting.
PackagingStrings	Manages packaging configurations associated with items for transaction processing.
ScheduleExceptions	Defines global schedule changes, such as holidays, applicable to assigned schedules.
Schedules	Manages schedules defining working and non-working times for various business objects.
SchedulesscheduleExceptionAssociations	Links schedule exceptions to specific schedules for broader applicability.
SchedulesscheduleWorkdayPatterns	Assigns workday patterns to schedules for consistent application.
Shifts	Defines shifts representing working and non-working times within schedules.
ShiftsshiftDetails	Breaks down shifts into detailed time segments for precise schedule management.
StandardLookupsLOV	Provides lists of standard lookup codes and their translated meanings for reference.
UnitOfMeasureClasses	Organizes units of measure into classes for streamlined management.
UnitOfMeasureClassesDFF	Maintains descriptive flexfields for unit of measure classes to allow additional attributes.
UnitOfMeasureClassesinterclassConversions	Provides interclass conversion rates for items, enabling accurate measurements between different unit of measure classes in Oracle SCM.
UnitsOfMeasure	Defines and manages the units of measure that can be used in transactions across applications, ensuring consistency and compatibility.
UnitsOfMeasureDFF	Manages descriptive flexfields for units of measure, enabling customization and extension of unit-specific details.
UnitsOfMeasureintraclassConversions	Manages intraclass conversion rates between units of measure and their base unit within the same class, providing more granular control over conversions.
WorkdayPatterns	Defines workday patterns by detailing shifts and active days, forming the foundation for scheduling and time management.
WorkdayPatternsworkdayPatternShifts	Lists shifts assigned to specific workday patterns, supporting detailed scheduling configurations.

B2bApplicationPartners

Name	Type	ReadOnly	FilterOnly	Description
ApplicationPartnerStatus	String	False	No	Indicates the current status of the application partner, such as active, inactive, or pending.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with the application partner.
DvmGroup	String	False	No	Specifies the Data Value Map (DVM) group used for partner data transformation.
PartnerKeyType	String	False	No	Defines the type of key used to uniquely identify the partner, such as Data Universal Numbering System (DUNS) or custom identifier.
ProcessingActionCode	String	False	No	Represents the action code that dictates how transactions with this partner should be processed.
ServiceProviderId	Long	False	No	Unique identifier for the service provider linked to this application partner.
ApplicationPartnerId [KEY]	Long	False	No	Primary key that uniquely identifies the application partner record.
ServiceProviderName	String	False	No	The name of the service provider facilitating business-to-business (B2B) transactions for this partner.
TradingPartner	String	False	No	The name or alias of the trading partner in the business relationship.
TradingPartnerIdType	String	False	No	Specifies the classification of the TradingPartnerId, such as DUNS, Tax ID, or internal ID.
PartnerId	String	False	No	An identifier representing the partner in external integrations or internal systems.
PartnerIdType	String	False	No	Categorizes the PartnerId, distinguishing between different identifier types such as email, ID, or company code.
Finder	String	False	No	A system-defined query or lookup used to retrieve partner records based on specific criteria.

Return to Top

B2bApplicationPartnersdocuments

Name	Type	ReadOnly	FilterOnly	Description
B2bApplicationPartnersApplicationPartnerId [KEY]	Long	False	No	Unique identifier linking the document to a specific application partner.
ApplicationPartnerDocumentStatus	String	False	No	Indicates the current status of the application partner document. Valid values include Enabled, Disabled, and Hold for inbound documents. The default value is Disabled.
DocumentId	Long	False	No	Unique identifier for the collaboration document. This attribute serves as a foreign key reference to the collaboration document.
ApplicationPartnerDocumentId [KEY]	Long	False	No	Primary key that uniquely identifies an application partner document. This value is system-generated when a new document record is created.
StatusDate	Datetime	False	No	Timestamp indicating when the application partner document was created or last updated.
PrimaryRecipientFlag	Bool	False	No	Flag that specifies whether this document is intended for the primary recipient.
DocumentName	String	False	No	The name assigned to the collaboration document.
SenderRole	String	False	No	Specifies the role of the sender in the document exchange, such as Supplier or Buyer.
Direction	String	False	No	Indicates whether the document is inbound or outbound in relation to the system.
ServiceProviderId	Long	False	No	Unique identifier for the service provider associated with the document. This serves as a foreign key reference.
DocumentDescription	String	False	No	Detailed description of the collaboration document's purpose and content.
ApplicationPartnerId	Long	False	No	Unique identifier for the application partner associated with this document.
Finder	String	False	No	A system-defined query or lookup used to retrieve document records based on specific criteria.

Return to Top

B2bMessageTransactions

Name	Type	ReadOnly	FilterOnly	Description
MessageLogId [KEY]	Long	False	No	Unique identifier for the message log entry, used for tracking transactions.
MessageGUID	String	False	No	Globally unique identifier (GUID) assigned to the message for reference across systems.
ServiceProviderId	Long	False	No	Unique identifier for the service provider handling the message transaction.
ServiceProviderName	String	False	No	Name of the service provider responsible for processing the transaction.
Status	String	False	No	Current processing status of the message, such as Pending, Processed, or Failed.
StatusDate	Datetime	False	No	Timestamp indicating when the status of the message was last updated.
TestFlag	Bool	False	No	Indicates whether this transaction is part of a test scenario (True/False).
Error	String	False	No	Details of any error encountered during message processing.
ErrorType	String	False	No	Categorization of the error, such as Validation Error, Transmission Failure, or Processing Error.
MessageName	String	False	No	Descriptive name of the message being processed in the transaction.
MessageId	Long	False	No	Unique identifier assigned to the message within the system.
ProcessingDuration	String	False	No	Time taken for processing the message from initiation to completion.
RetryCount	Int	False	No	Number of retry attempts made for processing the message in case of failures.
SenderMessageId	String	False	No	Identifier of the message as assigned by the sender system.
DocumentOperationId	Long	False	No	Unique identifier for the document operation associated with the message transaction.
ExternalPartnerId	Long	False	No	Unique identifier for the external trading partner involved in the transaction.
TradingPartnerId	String	False	No	Identifier for the trading partner in the business exchange.
TradingPartnerIdType	String	False	No	Specifies the type of TradingPartnerId, such as Data Universal Numbering System (DUNS), Tax ID, or internal system ID.
PartnerMessageName	String	False	No	Name of the message as recognized by the external trading partner.
PartnerMessageId	Long	False	No	Unique identifier assigned to the message by the partner system.
PartnerKeyType	String	False	No	Classification of the partner key used for identification, such as Electronic Data Interchange (EDI) or Custom Key.
CorrelationId	String	False	No	Identifier used to correlate related messages and track transactions across systems.
ProcessingCode	String	False	No	Code that defines how the message should be processed within the system.
ProcessingDetail	String	False	No	Additional details on how the message was processed, including specific rules applied.
SentAttachments	Long	False	No	Number of attachments sent along with the message.
TotalAttachments	Long	False	No	Total number of attachments associated with the message.
SentAttachmentsList	String	False	No	Comma-separated list of attachment names or IDs sent with the message.
DocumentId	Long	False	No	Unique identifier for the document associated with this message transaction.
Direction	String	False	No	Indicates whether the message is inbound (received) or outbound (sent).
DocumentName	String	False	No	Name of the document linked to the message transaction.
MessageLogStatus	String	False	No	Status of the message log entry, such as Completed, Error, or In Progress.
KeyContext	String	False	No	Contextual key information used for linking the message to related records.
PublicationId	String	False	No	Identifier for the publication associated with this message, if applicable.
PrimaryRecipientFlag	Bool	False	No	Indicates whether the recipient of this message is the primary recipient (True/False).
ConfirmationStatus	String	False	No	Indicates whether confirmation of message receipt has been received, such as Confirmed or Pending.
InputDocument	String	False	No	Raw input document content associated with the message transaction.
OutputDocument	String	False	No	Processed output document generated from the message transaction.
AltDelMethodTypeFlag	Bool	False	No	Flag indicating whether an alternative delivery method was used for message transmission.
ErrorDescription	String	False	No	Detailed description of any errors encountered during processing.
LineCount	Long	False	No	Total number of lines in the document associated with this transaction.
SublineCount	Long	False	No	Total number of sublines within the document, if applicable.
DocumentDescription	String	False	No	Description of the document, including purpose and content details.
ChangeOrder	String	False	No	Indicates whether the document is a change order and tracks change history if applicable.
RepositoryFileId	String	False	No	Identifier for the file stored in the document repository related to this transaction.
FlowId	Long	False	No	Unique identifier for the workflow or process flow managing this transaction.
InstanceCount	Int	False	No	Number of instances of this message transaction recorded in the system.
PayloadRetrievalReqd	String	False	No	Indicates if payload retrieval is required for processing, such as Yes or No.
Finder	String	False	No	A system-defined query or lookup used to retrieve transaction records based on specific criteria.

Return to Top

B2bMessageTransactionsdeliveryAttempts

Name	Type	ReadOnly	FilterOnly	Description
B2bMessageTransactionsMessageLogId [KEY]	Long	False	No	Unique identifier linking this delivery attempt to a specific message transaction log entry.
MessageLogDetailId [KEY]	Long	False	No	Unique identifier for the detailed log entry of this delivery attempt.
MessageLogId	Long	False	No	Identifier referencing the main message log associated with this delivery attempt.
MessageGUID	String	False	No	Globally unique identifier (GUID) assigned to the message, ensuring uniqueness across systems.
ProcessingStartTime	Datetime	False	No	Timestamp indicating when the processing of this delivery attempt started.
RetryCount	Int	False	No	Number of times the message delivery has been retried due to failures.
Status	String	False	No	Current status of this delivery attempt, such as Pending, Successful, or Failed.
Error	String	False	No	Details of any error encountered during this delivery attempt.
ErrorType	String	False	No	Categorization of the error, such as Connection Failure, Timeout, or Invalid Response.
ScheduledProcessName	String	False	No	Name of the scheduled process responsible for handling the delivery attempt.
ScheduledProcessId	Long	False	No	Unique identifier for the scheduled process that executed this delivery attempt.
Finder	String	False	No	A system-defined query or lookup used to retrieve delivery attempt records based on specific criteria.

Return to Top

B2bMessageTransactionsreceiptConfirmations

Name	Type	ReadOnly	FilterOnly	Description
B2bMessageTransactionsMessageLogId [KEY]	Long	False	No	Unique identifier linking this receipt confirmation to a specific message transaction log entry.
MessageLogId [KEY]	Long	False	No	Identifier referencing the main message log associated with this receipt confirmation.
MessageGUID	String	False	No	Globally unique identifier (GUID) assigned to the message, ensuring uniqueness across systems.
SenderMessageId	String	False	No	Identifier of the message as assigned by the sender, used for tracking and correlation.
StatusDate	Datetime	False	No	Timestamp indicating when the receipt confirmation status was last updated.
ProcessingCode	String	False	No	Code defining how the receipt confirmation should be processed within the system.
ProcessingDetail	String	False	No	Additional details about the processing of the receipt confirmation, including any relevant status or actions taken.
Finder	String	False	No	A system-defined query or lookup used to retrieve receipt confirmation records based on specific criteria.

Return to Top

B2bTradingPartners

Name	Type	ReadOnly	FilterOnly	Description
TradingPartnerId [KEY]	Long	False	No	Unique identifier for the trading partner, automatically generated when a new trading partner record is created. This serves as the primary key.
TradingPartner	String	False	No	The name assigned to the trading partner, ensuring uniqueness within the system.
TradingPartnerIdType	String	False	No	Specifies the classification of the TradingPartnerId, such as Data Universal Numbering System (DUNS), Tax ID, or internal system ID.
ManualEntryIndicator	String	False	No	Indicates whether the trading partner record was manually entered via the user interface. 'Y' represents a manual entry.
ServiceProviderId	Long	False	No	Unique identifier referencing the service provider associated with the trading partner.
ServiceProviderName	String	False	No	The name of the service provider facilitating communication with this trading partner.
FromPartnerIdTag	String	False	No	Protocol header tag used to identify the sender of the message in business-to-business (B2B) transactions.
FromPartnerIdTypeTag	String	False	No	Protocol header tag used to classify the identifier type of the message sender.
ToPartnerIdTag	String	False	No	Protocol header tag used to specify the recipient of the message in B2B transactions.
ToPartnerIdTypeTag	String	False	No	Protocol header tag used to define the identifier type of the message recipient.
ExternalMessageTypeTag	String	False	No	Tag used in outbound message headers to specify the type of trading partner.
ExternalMessageVersionTag	String	False	No	Tag used in outbound message headers to indicate the version of the trading partner system.
ExternalMessageStandardTag	String	False	No	Tag used in outbound message headers to specify the standard used by the trading partner.
ObnId	String	False	No	Unique identifier for the Oracle Business Network (OBN) associated with this trading partner.
LastUpdateDate	Datetime	False	No	Timestamp indicating the last time this trading partner record was updated.
CreationDate	Datetime	False	No	Timestamp indicating when the trading partner record was initially created.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for communication.
Finder	String	False	No	A system-defined query or lookup used to retrieve trading partner records based on specific criteria.

Return to Top

B2bTradingPartnersb2bServiceProviders

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this service provider entry to a specific trading partner record.
ServiceProviderId [KEY]	Long	False	No	Unique identifier for the service provider facilitating business-to-business (B2B) transactions for the trading partner.
ServiceProviderName	String	False	No	The name of the service provider associated with the trading partner.
PartnerId	String	False	No	Identifier assigned to the trading partner within the service provider’s system.
PartnerIdType	String	False	No	Specifies the classification of the PartnerId, such as Data Universal Numbering System (DUNS), Tax ID, or custom identifier.
CreationDate	Datetime	False	No	Timestamp indicating when this trading partner-service provider relationship was created.
LastUpdateDate	Datetime	False	No	Timestamp indicating the last time this relationship record was updated.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for communication.
Finder	String	False	No	A system-defined query or lookup used to retrieve service provider records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with the service provider.

Return to Top

B2bTradingPartnersconfirmationCodes

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this confirmation code entry to a specific trading partner record.
ConfStatusXrefId [KEY]	Long	False	No	Unique identifier for the confirmation code, automatically generated when a new confirmation code record is created. This serves as the primary key.
PartnerStatus	String	False	No	Indicates the status of the confirmation process for the trading partner, such as Accepted, Rejected, or Pending.
CollaborationStatus	String	False	No	Specifies the status of the collaboration message exchanged with the trading partner.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the confirmation code record was last updated.
CreationDate	Datetime	False	No	Timestamp indicating when the confirmation code record was initially created.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for confirmation handling.
Finder	String	False	No	A system-defined query or lookup used to retrieve confirmation code records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this confirmation code record.

Return to Top

B2bTradingPartnersdeliveryMethods

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this delivery method entry to a specific trading partner record.
DeliveryMethodId [KEY]	Long	False	No	Unique identifier for the delivery method, automatically generated when a new delivery method record is created. This serves as the primary key.
DeliveryMethodName	String	False	No	Descriptive name of the delivery method used for exchanging messages with the trading partner. This attribute is required.
DeliveryMethodType	String	False	No	Specifies the type of delivery method. Valid values include 'One-Way Web Service' or 'Request-Response Web Service'.
Service	String	False	No	Identifies the external service associated with the delivery method for message exchange.
B2bRoutingFlag	Bool	False	No	Indicates whether messages to the service provider are routed through the internal business-to-business (B2B) gateway. 'True' means routing is enabled; 'False' means messages bypass the gateway (default: False).
SecurityPolicy	String	False	No	Specifies the security policy applied to the delivery method, ensuring secure message transmission.
UcmExportDocumentAccount	String	False	No	Specifies the storage location from which files are picked for outbound processing.
RecipientEmailId	String	False	No	Email address to which outbound messages are sent when using email-based delivery methods.
AttachXmlFlag	Bool	False	No	Indicates whether the transformed payload is attached to the email. 'True' means it is attached; 'False' means it is not (default: False).
ServiceUri	String	False	No	Specifies the service endpoint URL stored in the topology manager for message delivery.
CsfkeyUser	String	False	No	Username stored in the credential store framework (CSF) for authentication in secure message transmissions.
CsfkeyPassword	String	False	No	Password stored in the credential store framework (CSF) for authentication in secure message transmissions.
ServiceMeaning	String	False	No	Descriptive meaning of the external service used in the delivery method.
CreationDate	Datetime	False	No	Timestamp indicating when the delivery method record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the delivery method record was last updated.
FileName	String	False	No	Identifies the file being delivered using SFTP-based delivery methods.
RemoteDir	String	False	No	Specifies the remote directory where outbound messages are delivered when using the Secure File Transfer Protocol (SFTP).
SftpHost	String	False	No	Specifies the host name used for outbound message delivery via SFTP.
SftpPort	String	False	No	Specifies the port used for outbound message delivery via SFTP.
FileExtension	String	False	No	Specifies the file extension for the B2B message file. If not specified, the default value is '.ZIP'.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for message delivery.
Finder	String	False	No	A system-defined query or lookup used to retrieve delivery method records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this delivery method.

Return to Top

B2bTradingPartnersdocuments

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this document entry to a specific trading partner record.
DocumentId	Long	False	No	Unique identifier for the collaboration document. This serves as a foreign key reference to the document record.
DocumentName	String	False	No	Name of the document associated with the trading partner.
TradingPartnerDocumentId [KEY]	Long	False	No	Unique identifier for the trading partner document. This serves as a foreign key reference to the trading partner document record.
TradingPartnerDocumentStatus	String	False	No	Indicates the current status of the trading partner document, such as Active, Inactive, or Pending.
ServiceRequestId	Long	False	No	Unique identifier for the service request related to the document setup, automatically generated when a request is made to a service provider.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for document management.
Finder	String	False	No	A system-defined query or lookup used to retrieve document records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this document.

Return to Top

B2bTradingPartnersdocumentsmessageProcessingRules

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this message processing rule entry to a specific trading partner record.
DocumentsTradingPartnerDocumentId [KEY]	Long	False	No	Unique identifier linking this message processing rule to a specific trading partner document.
NodeId [KEY]	Long	False	No	Unique identifier for the message processing rule, automatically generated when a new rule is created. This serves as the primary key.
Name	String	False	No	Descriptive name of the message processing rule used in document processing.
MessageNodeXpath	String	False	No	Specifies the XPath expression used to locate and process the external message node.
DefaultValue	String	False	No	Default value assigned to the node identified in the XPath when no other value is provided.
ValueRequiredFlag	Bool	False	No	Indicates whether a value is mandatory for this field. 'True' means a value is required; 'False' means it is optional.
IncludeInOutputFlag	Bool	False	No	Indicates whether the field should be included in the output message. 'True' means it is included; 'False' means it is excluded (default: False).
LastUpdateDate	Datetime	False	No	Timestamp indicating when this message processing rule record was last updated.
CreationDate	Datetime	False	No	Timestamp indicating when this message processing rule record was initially created.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for message processing.
Finder	String	False	No	A system-defined query or lookup used to retrieve message processing rule records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this message processing rule.

Return to Top

B2bTradingPartnersinboundCollaborationMessages

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this inbound collaboration message to a specific trading partner record.
PartnerMessageId [KEY]	Long	False	No	Unique identifier for the inbound collaboration message, automatically generated when a new record is created. This serves as the primary key.
PartnerMessageName	String	False	No	Descriptive name of the inbound collaboration message associated with the trading partner.
PartnerMessageStatus	String	False	No	Current status of the inbound collaboration message. Valid values include Inactive, Active, or Loopback (default: Inactive).
PartnerMessageStatusDate	Datetime	False	No	Timestamp indicating when the inbound collaboration message status was last updated.
AcknowledgementCode	String	False	No	Indicates whether application processing feedback should be sent for inbound messages.
ProcessingAction	String	False	No	Defines the processing action for inbound and outbound messages transmitted through Simple Object Access Protocol (SOAP) headers.
ApplicationPartnerCodeXpath	String	False	No	XPath expression used to store and reference the application partner code.
ObjectKey1Xpath	String	False	No	XPath expression identifying the first key field in the inbound message payload.
ObjectKey2Xpath	String	False	No	XPath expression identifying the second key field in the inbound message payload.
ObjectKey3Xpath	String	False	No	XPath expression identifying the third key field in the inbound message payload.
ObjectKey4Xpath	String	False	No	XPath expression identifying the fourth key field in the inbound message payload.
ObjectKey5Xpath	String	False	No	XPath expression identifying the fifth key field in the inbound message payload.
ObjectKey6Xpath	String	False	No	XPath expression identifying the sixth key field in the inbound message payload.
MessageId	Long	False	No	Unique identifier for the collaboration message, serving as a foreign key reference.
MessageName	String	False	No	Descriptive name of the collaboration message linked to the inbound transaction.
DocumentId	Long	False	No	Unique identifier for the collaboration document, serving as a foreign key reference.
DocumentName	String	False	No	Name of the collaboration document associated with the inbound message.
PartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier for the partner message customization, automatically generated upon record creation (read-only).
RetentionDuration	Int	False	No	Specifies the duration for which the inbound collaboration message should be retained.
RetentionDurationType	String	False	No	Defines the type of retention duration, such as Days, Weeks, or Months.
OverrideStatus	String	False	No	Indicates the override status of the inbound collaboration message. Valid values include Inactive, Active, or Loopback (default: Inactive).
OverrideStatusDate	Datetime	False	No	Timestamp indicating when the override status was last updated.
LastUpdateDate	Datetime	False	No	Timestamp indicating the most recent user update to the inbound collaboration message for the trading partner.
CreationDate	Datetime	False	No	Timestamp indicating when the inbound collaboration message was configured for the trading partner.
UserDefinedFlag	Bool	False	No	Indicates whether this inbound collaboration message configuration was user-defined.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for inbound message processing.
Finder	String	False	No	A system-defined query or lookup used to retrieve inbound collaboration message records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this inbound collaboration message.

Return to Top

B2bTradingPartnersinboundCollaborationMessagesdomainValueMaps

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this domain value map entry to a specific trading partner record.
InboundcollaborationmessagesPartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier linking this domain value map to a customized partner message in the inbound collaboration process.
InboundcollaborationmessagesPartnerMessageId [KEY]	Long	False	No	Unique identifier linking this domain value map to a specific inbound collaboration message.
MessageDvmId [KEY]	Long	False	No	Unique identifier for the domain value map (DVM) associated with the inbound collaboration message.
DvmName	String	False	No	Name of the domain value map used to translate values between external and internal message formats.
MessageId	Long	False	No	Unique identifier for the collaboration message, serving as a foreign key reference.
MessageName	String	False	No	Descriptive name of the collaboration message associated with this domain value map.
CreationDate	Datetime	False	No	Timestamp indicating when this domain value map record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating the most recent update to this domain value map record.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for domain value mapping.
Finder	String	False	No	A system-defined query or lookup used to retrieve domain value map records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this domain value map entry.

Return to Top

B2bTradingPartnersinboundCollaborationMessagesmessageProcessingRules

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this message processing rule entry to a specific trading partner record.
InboundcollaborationmessagesPartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier linking this message processing rule to a customized partner message in the inbound collaboration process.
InboundcollaborationmessagesPartnerMessageId [KEY]	Long	False	No	Unique identifier linking this message processing rule to a specific inbound collaboration message.
NodeId [KEY]	Long	False	No	Unique identifier for the message processing rule, automatically generated when a new rule is created. This serves as the primary key.
Name	String	False	No	Descriptive name of the message processing rule used in document processing.
MessageNodeXpath	String	False	No	Specifies the XPath expression used to locate and process the external message node.
DefaultValue	String	False	No	Default value assigned to the node identified in the XPath when no other value is provided.
ValueRequiredFlag	Bool	False	No	Indicates whether a value is mandatory for this field. 'True' means a value is required; 'False' means it is optional.
IncludeInOutputFlag	Bool	False	No	Indicates whether the field should be included in the output message. 'True' means it is included; 'False' means it is excluded (default: False).
LastUpdateDate	Datetime	False	No	Timestamp indicating when this message processing rule record was last updated.
CreationDate	Datetime	False	No	Timestamp indicating when this message processing rule record was initially created.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for message processing.
Finder	String	False	No	A system-defined query or lookup used to retrieve message processing rule records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this message processing rule.

Return to Top

B2bTradingPartnersoutboundCollaborationMessages

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this outbound collaboration message to a specific trading partner record.
PartnerMessageId [KEY]	Long	False	No	Unique identifier for the trading partner message, serving as a foreign key reference to the trading partner message record.
PartnerMessageName	String	False	No	Descriptive name of the outbound collaboration message associated with the trading partner.
PartnerMessageStatus	String	False	No	Current status of the outbound collaboration message, such as Pending, Sent, or Failed.
PartnerMessageStatusDate	Datetime	False	No	Timestamp indicating when the status of the outbound collaboration message was last updated.
ProcessingAction	String	False	No	Defines the processing action for the outbound message transmitted through Simple Object Access Protocol (SOAP) headers.
MessageId	Long	False	No	Unique identifier for the collaboration message, serving as a foreign key reference.
MessageName	String	False	No	Descriptive name of the collaboration message associated with the outbound transaction.
ServiceProviderId	Long	False	No	Unique identifier for the service provider handling this outbound collaboration message.
DocumentId	Long	False	No	Unique identifier for the collaboration document, serving as a foreign key reference.
DocumentName	String	False	No	Name of the document associated with the outbound collaboration message.
DeliveryMethodId	Long	False	No	Unique identifier for the delivery method used for sending the outbound collaboration message.
DeliveryMethodName	String	False	No	Descriptive name of the delivery method used to send the outbound message.
AlternateDeliveryMethodId	Long	False	No	Unique identifier for the alternate delivery method, generated when an alternate delivery method record is created.
AlternateDeliveryMethodName	String	False	No	Descriptive name of the alternate delivery method, used if the primary method fails.
PartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier for the trading partner message customization, serving as a foreign key reference.
RetentionDuration	Int	False	No	Specifies how long the outbound collaboration message should be retained before deletion.
RetentionDurationType	String	False	No	Defines the retention duration type, such as Days, Weeks, or Months.
OverrideStatus	String	False	No	Indicates whether the outbound collaboration message has been overridden. Values include Inactive, Active, or Loopback (default: Inactive).
OverrideStatusDate	Datetime	False	No	Timestamp indicating when the override status was last updated.
CreationDate	Datetime	False	No	Timestamp indicating when the outbound collaboration message was created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the outbound collaboration message record was last updated.
AttachmentProcessingMethod	String	False	No	Defines how attachments are handled in the outbound message. Valid values include 'In Message,' 'In Payload,' and 'MIME Part'.
UserDefinedFlag	Bool	False	No	Indicates whether this outbound collaboration message configuration was user-defined.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for outbound message processing.
Finder	String	False	No	A system-defined query or lookup used to retrieve outbound collaboration message records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this outbound collaboration message.

Return to Top

B2bTradingPartnersoutboundCollaborationMessagesdomainValueMaps

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this domain value map entry to a specific trading partner record.
OutboundcollaborationmessagesPartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier linking this domain value map to a customized partner message in the outbound collaboration process.
OutboundcollaborationmessagesPartnerMessageId [KEY]	Long	False	No	Unique identifier linking this domain value map to a specific outbound collaboration message.
MessageDvmId [KEY]	Long	False	No	Unique identifier for the domain value map (DVM) associated with the outbound collaboration message.
DvmName	String	False	No	Name of the domain value map used to translate values between external and internal message formats.
MessageId	Long	False	No	Unique identifier for the collaboration message, serving as a foreign key reference.
MessageName	String	False	No	Descriptive name of the collaboration message associated with this domain value map.
CreationDate	Datetime	False	No	Timestamp indicating when this domain value map record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating the most recent update to this domain value map record.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for domain value mapping.
Finder	String	False	No	A system-defined query or lookup used to retrieve domain value map records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this domain value map entry.

Return to Top

B2bTradingPartnersoutboundCollaborationMessagesmessageProcessingRules

Name	Type	ReadOnly	FilterOnly	Description
B2bTradingPartnersTradingPartnerId [KEY]	Long	False	No	Unique identifier linking this message processing rule entry to a specific trading partner record.
OutboundcollaborationmessagesPartnerMessageCustomizationId [KEY]	Long	False	No	Unique identifier linking this message processing rule to a customized partner message in the outbound collaboration process.
OutboundcollaborationmessagesPartnerMessageId [KEY]	Long	False	No	Unique identifier linking this message processing rule to a specific outbound collaboration message.
NodeId [KEY]	Long	False	No	Unique identifier for the message processing rule, automatically generated when a new rule is created. This serves as the primary key.
Name	String	False	No	Descriptive name of the message processing rule used for outbound document processing.
MessageNodeXpath	String	False	No	Specifies the XPath expression used to locate and process the external message node.
DefaultValue	String	False	No	Default value assigned to the node identified in the XPath when no other value is provided.
ValueRequiredFlag	Bool	False	No	Indicates whether a value is mandatory for this field. 'True' means a value is required; 'False' means it is optional.
IncludeInOutputFlag	Bool	False	No	Indicates whether the field should be included in the output message. 'True' means it is included; 'False' means it is excluded (default: False).
LastUpdateDate	Datetime	False	No	Timestamp indicating when this message processing rule record was last updated.
CreationDate	Datetime	False	No	Timestamp indicating when this message processing rule record was initially created.
BindServiceProviderId	Long	False	No	Unique identifier for the service provider bound to this trading partner for message processing.
Finder	String	False	No	A system-defined query or lookup used to retrieve message processing rule records associated with trading partners.
TradingPartnerId	Long	False	No	Unique identifier for the trading partner associated with this message processing rule.

Return to Top

Carriers

Name	Type	ReadOnly	FilterOnly	Description
CarrierId [KEY]	Long	False	No	Unique identifier for the carrier, automatically generated when a new carrier record is created.
CarrierName	String	False	No	The name of the carrier, which must be unique. This attribute is required.
ActiveFlag	Bool	False	No	Indicates whether the carrier is active. 'True' means the carrier is active; 'False' means the carrier is inactive (default: True).
ManifestingEnabledFlag	Bool	False	No	Specifies whether manifesting is enabled for this carrier. 'True' means a manifest is required; 'False' means a manifest is not required (default: False).
CreationDate	Datetime	False	No	Timestamp indicating when the carrier record was initially created.
CreatedBy	String	False	No	Username or system entity that created the carrier record.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the carrier record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the carrier record.
Finder	String	False	No	A system-defined query or lookup used to retrieve carrier records based on specific criteria.

Return to Top

Carrierscontacts

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this contact to a specific carrier record.
RelationshipRecordId [KEY]	Long	False	No	Unique identifier for the relationship record between the carrier and the contact.
LastName	String	False	No	Last name of the contact person at the carrier. This attribute is required.
FirstName	String	False	No	First name of the contact person at the carrier.
JobTitle	String	False	No	Job title of the contact person at the carrier.
PhoneNumber	String	False	No	Phone number of the contact person at the carrier.
EmailAddress	String	False	No	Email address of the contact person at the carrier.
CreatedBy	String	False	No	Username or system entity that created the carrier contact record.
CreationDate	Datetime	False	No	Timestamp indicating when the carrier contact record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the carrier contact record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the carrier contact record.
ActiveFlag	String	False	No	Indicates whether the contact record is active. 'True' means active; 'False' means inactive.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this contact record.
CarrierName	String	False	No	Name of the carrier associated with this contact record.
Finder	String	False	No	A system-defined query or lookup used to retrieve carrier contact records based on specific criteria.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersDFF

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this descriptive flexfield (DFF) entry to a specific carrier record.
CarrierId [KEY]	Long	False	No	Unique identifier for the carrier, automatically generated when a new carrier record is created. This serves as the primary key.
_FLEX_ValidationDate	Date	False	No	Date when the DFF data was validated for the carrier.
_FLEX_Context	String	False	No	Context name for the DFF used in defining additional attributes for shipping methods.
_FLEX_NumOfSegments	Int	False	No	Total number of segments defined in the DFF for the carrier.
_FLEX_NumOfVisibleSegments	Int	False	No	Total number of visible segments in the DFF for the carrier.
ActiveFlag	String	False	No	Indicates whether the DFF entry for the carrier is active. 'True' means active; 'False' means inactive.
CarrierName	String	False	No	Name of the carrier associated with this DFF entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve carrier records with DFF data.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersinboundTrackingRules

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this inbound tracking rule to a specific carrier record.
TrackingRuleId [KEY]	Long	False	No	Unique identifier for the tracking rule, automatically generated when a new tracking rule is created.
TrackingRuleName	String	False	No	Descriptive name of the tracking rule. This attribute is required.
BaseURL	String	False	No	The carrier's published URL used for tracking shipments in transit. This attribute is required.
RequestMethodCode	String	False	No	The HTTP request method required to retrieve tracking details. Accepted values include 'G' for GET and 'P' for POST. This attribute is required.
RequestMethod	String	False	No	Specifies the request method for retrieving shipment tracking information from the carrier.
ActiveFlag	Bool	False	No	Indicates whether the tracking rule is active. 'True' means the rule is active; 'False' means it is inactive (default: True).
CreatedBy	String	False	No	Username or system entity that created the tracking rule record.
CreationDate	Datetime	False	No	Timestamp indicating when the tracking rule record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the tracking rule record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the tracking rule record.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this tracking rule.
CarrierName	String	False	No	Name of the carrier associated with this tracking rule.
Finder	String	False	No	A system-defined query or lookup used to retrieve carrier tracking rule records based on specific criteria.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersinboundTrackingRulesorganizationAssociations

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this organization association to a specific carrier record.
InboundtrackingrulesTrackingRuleId [KEY]	Long	False	No	Unique identifier linking this organization association to a specific inbound tracking rule.
OrganizationCarrierTrackingId [KEY]	Long	False	No	Unique identifier for the organization-specific carrier tracking configuration.
OrganizationId	Long	False	No	Unique identifier for the inventory organization assigned to a carrier shipping method. Either this attribute or OrganizationCode is required.
OrganizationCode	String	False	No	Short abbreviation or code uniquely identifying the inventory organization. Either this attribute or OrganizationId is required.
OrganizationName	String	False	No	Full name of the inventory organization associated with this tracking rule.
CreatedBy	String	False	No	Username or system entity that created the organization association record.
CreationDate	Datetime	False	No	Timestamp indicating when the organization association record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the organization association record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the organization association record.
ActiveFlag	String	False	No	Indicates whether this organization association is active. 'True' means active; 'False' means inactive.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this organization tracking rule.
CarrierName	String	False	No	Name of the carrier associated with this organization tracking rule.
Finder	String	False	No	A system-defined query or lookup used to retrieve organization association records for carrier tracking rules.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersinboundTrackingRulesparameters

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this tracking rule parameter entry to a specific carrier record.
InboundtrackingrulesTrackingRuleId [KEY]	Long	False	No	Unique identifier linking this tracking rule parameter entry to a specific inbound tracking rule.
ParameterId [KEY]	Long	False	No	Unique identifier for the tracking rule parameter, automatically generated when a new parameter is created.
Sequence	Int	False	No	Specifies the order of precedence for each parameter in the tracking rule for a carrier. This attribute is required.
ParameterName	String	False	No	Descriptive name of the tracking rule parameter, which can either have a constant value or be derived from the transaction.
ConstantValue	String	False	No	Specifies the fixed value for the tracking rule parameter when it is set as a constant.
LookupParameterCode	String	False	No	Defines the transaction attribute required by the carrier's tracking URL when the parameter value is supplied dynamically. Example: 'Tracking Number'.
LookupParameter	String	False	No	Specifies the attribute used to map the parameter value from the transaction data.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this tracking rule parameter record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this tracking rule parameter record.
CreatedBy	String	False	No	Username or system entity that created this tracking rule parameter record.
CreationDate	Datetime	False	No	Timestamp indicating when this tracking rule parameter record was initially created.
ActiveFlag	String	False	No	Indicates whether this tracking rule parameter is active. 'True' means active; 'False' means inactive.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this tracking rule parameter.
CarrierName	String	False	No	Name of the carrier associated with this tracking rule parameter.
Finder	String	False	No	A system-defined query or lookup used to retrieve tracking rule parameter records based on specific criteria.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersshippingMethods

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this shipping method entry to a specific carrier record.
OrganizationCarrierServiceId [KEY]	Long	False	No	Unique identifier for the shipping service provided by the carrier within an organization.
ShipMethodCode	String	False	No	Code representing the shipping method used by the carrier.
ServiceLevelCode	String	False	No	Indicates the priority level of transportation, affecting delivery speed. Valid values include Next Day, Overnight, Express, or Door to Door.
ServiceLevel	String	False	No	Descriptive label for the service level of the shipping method.
ModeOfTransportCode	String	False	No	Indicates the method of transportation used for shipment delivery. Valid values include Rail, Air, or Road.
ModeOfTransport	String	False	No	Descriptive label for the mode of transport associated with the shipping method.
ActiveFlag	Bool	False	No	Indicates whether the shipping method is active. 'True' means the shipping method is active; 'False' means it is inactive (default: True).
CreatedBy	String	False	No	Username or system entity that created this shipping method record.
CreationDate	Datetime	False	No	Timestamp indicating when this shipping method record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this shipping method record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this shipping method record.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this shipping method.
CarrierName	String	False	No	Name of the carrier associated with this shipping method.
Finder	String	False	No	A system-defined query or lookup used to retrieve shipping method records based on specific criteria.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersshippingMethodsDFF

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this descriptive flexfield (DFF) entry to a specific carrier record.
ShippingmethodsOrganizationCarrierServiceId [KEY]	Long	False	No	Unique identifier linking this DFF entry to a specific shipping method within an organization.
OrgCarrierServiceId [KEY]	Long	False	No	Unique identifier for the organization-specific carrier service associated with this shipping method.
TestMdm1	String	False	No	Custom metadata field for testing or additional carrier-related information.
TestMdm2	String	False	No	Additional custom metadata field for testing or extended shipping method attributes.
_FLEX_Context	String	False	No	Descriptive flexfield (DFF) context name, defining the purpose of the additional attributes for shipping methods.
_FLEX_Context_DisplayValue	String	False	No	Display value representing the context assigned to the descriptive flexfield (DFF).
ActiveFlag	String	False	No	Indicates whether this DFF entry for the shipping method is active. 'True' means active; 'False' means inactive.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this DFF entry.
CarrierName	String	False	No	Name of the carrier associated with this DFF entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve shipping method records with DFF data.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

CarriersshippingMethodsorganizationAssociations

Name	Type	ReadOnly	FilterOnly	Description
CarriersCarrierId [KEY]	Long	False	No	Unique identifier linking this organization association to a specific carrier record.
ShippingmethodsOrganizationCarrierServiceId [KEY]	Long	False	No	Unique identifier linking this organization association to a specific shipping method within an organization.
OrganizationCarrierServiceId [KEY]	Long	False	No	Unique identifier for the organization-specific carrier service associated with this shipping method.
OrganizationId	Long	False	No	Unique identifier for the inventory organization assigned to a carrier shipping method. Either this attribute or OrganizationCode is required.
OrganizationCode	String	False	No	Short abbreviation or code uniquely identifying the inventory organization. Either this attribute or OrganizationId is required.
OrganizationName	String	False	No	Full name of the inventory organization associated with this shipping method.
CreatedBy	String	False	No	Username or system entity that created this organization association record.
CreationDate	Datetime	False	No	Timestamp indicating when the organization association record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the organization association record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the organization association record.
ActiveFlag	String	False	No	Indicates whether this organization association is active. 'True' means active; 'False' means inactive.
CarrierId	Long	False	No	Unique identifier for the carrier associated with this organization shipping method.
CarrierName	String	False	No	Name of the carrier associated with this organization shipping method.
Finder	String	False	No	A system-defined query or lookup used to retrieve organization association records for shipping methods.
ManifestingEnabledFlag	String	False	No	Indicates whether manifesting is enabled for this carrier. 'True' means manifesting is required; 'False' means it is not.

Return to Top

Finders

Name	Type	ReadOnly	FilterOnly	Description
ViewName	String	False	No	Specifies the name of the database view for which a finder needs to be identified.
FinderName	String	False	No	The name of the finder, used to retrieve specific records from the view.
AttributeFinderColumn	String	False	No	The attribute within the finder that is used for filtering or searching records.
Type	String	False	No	Data type of the finder attribute, such as String, Integer, or Date.

Return to Top

FlexFndDffDescriptiveFlexfieldContexts

Name	Type	ReadOnly	FilterOnly	Description
ApplicationId [KEY]	Long	False	No	Unique identifier for the application associated with this descriptive flexfield (DFF) context.
DescriptiveFlexfieldCode [KEY]	String	False	No	Code representing the DFF associated with this context.
ContextCode [KEY]	String	False	No	Unique code identifying the specific context within the DFF.
Name	String	False	No	Descriptive name of the DFF context.
Description	String	False	No	Detailed description of the DFF context and its purpose.
EnabledFlag	String	False	No	Indicates whether the DFF context is enabled. 'True' means enabled; 'False' means disabled.
Bind_ApplicationId	Long	False	No	Binding reference to the application associated with this DFF context.
Bind_DescriptiveFlexfieldCode	String	False	No	Binding reference to the DFF code for this context.
Finder	String	False	No	A system-defined query or lookup used to retrieve DFF context records.

Return to Top

FlexFndPvsCharacterIdCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	Unique identifier for the character value entry within the descriptive flexfield (DFF) value set.
Value	String	False	No	The specific value assigned to this character value entry within the value set.
Description	String	False	No	Detailed description of the character value entry and its intended use.
StartDateActive	Date	False	No	The date when this character value becomes active and available for use.
EndDateActive	Date	False	No	The date when this character value is no longer active or valid.
EnabledFlag	String	False	No	Indicates whether this character value is enabled. 'True' means enabled; 'False' means disabled.
SummaryFlag	String	False	No	Indicates whether this character value is a summary value within the value set.
ValueSetCode	String	False	No	Code identifying the value set that contains this character value.
Bind_DataSource	String	False	No	Reference to the data source associated with this character value entry.
Bind_FinderContext	String	False	No	Specifies the finder context used to retrieve relevant data for this character value.
Bind_FinderDateFlag	String	False	No	Flag indicating whether date-based validation is required for this character value.
Bind_ValidationDate	Date	False	No	Specifies the date used for validation of this character value entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve character value records.
Flex_vst_bind1	String	False	No	Custom flexfield binding attribute 1 for additional metadata or lookup references.
Flex_vst_bind10	String	False	No	Custom flexfield binding attribute 10 for user-defined system attributes.
Flex_vst_bind11	String	False	No	Custom flexfield binding attribute 11 for additional validation parameters.
Flex_vst_bind12	String	False	No	Custom flexfield binding attribute 12 for extended business rules.
Flex_vst_bind13	String	False	No	Custom flexfield binding attribute 13 for additional metadata extensions.
Flex_vst_bind14	String	False	No	Custom flexfield binding attribute 14 for lookup and processing needs.
Flex_vst_bind15	String	False	No	Custom flexfield binding attribute 15 for business process enhancements.
Flex_vst_bind16	String	False	No	Custom flexfield binding attribute 16 for reporting and query extensions.
Flex_vst_bind17	String	False	No	Custom flexfield binding attribute 17 for customized data filtering.
Flex_vst_bind18	String	False	No	Custom flexfield binding attribute 18 for system-wide lookup logic.
Flex_vst_bind19	String	False	No	Custom flexfield binding attribute 19 for additional control over validation rules.
Flex_vst_bind2	String	False	No	Custom flexfield binding attribute 2 for extended lookup or processing logic.
Flex_vst_bind20	String	False	No	Custom flexfield binding attribute 20 for extended transaction logic.
Flex_vst_bind3	String	False	No	Custom flexfield binding attribute 3 for additional processing parameters.
Flex_vst_bind4	String	False	No	Custom flexfield binding attribute 4 for extended metadata.
Flex_vst_bind5	String	False	No	Custom flexfield binding attribute 5 for specialized lookup needs.
Flex_vst_bind6	String	False	No	Custom flexfield binding attribute 6 for business rule application.
Flex_vst_bind7	String	False	No	Custom flexfield binding attribute 7 for additional validation checks.
Flex_vst_bind8	String	False	No	Custom flexfield binding attribute 8 for extended system configurations.
Flex_vst_bind9	String	False	No	Custom flexfield binding attribute 9 for extended transactional data.

Return to Top

FlexFndPvsCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Value [KEY]	String	False	No	The specific value assigned to this character value entry within the value set.
Description	String	False	No	Detailed description of the character value entry and its intended use.
StartDateActive	Date	False	No	The date when this character value becomes active and available for use.
EndDateActive	Date	False	No	The date when this character value is no longer active or valid.
EnabledFlag	String	False	No	Indicates whether this character value is enabled. 'True' means enabled; 'False' means disabled.
SummaryFlag	String	False	No	Indicates whether this character value is a summary value within the value set.
ValueSetCode	String	False	No	Code identifying the value set that contains this character value.
Bind_AttrMap	String	False	No	Mapping reference for the attributes associated with this character value.
Bind_DataSource	String	False	No	Reference to the data source associated with this character value entry.
Bind_DataSourceDiscr	String	False	No	Distinguishing attribute used to differentiate between multiple data sources.
Bind_FinderContext	String	False	No	Specifies the finder context used to retrieve relevant data for this character value.
Bind_FinderDateFlag	String	False	No	Flag indicating whether date-based validation is required for this character value.
Bind_ValidationDate	Date	False	No	Specifies the date used for validation of this character value entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve character value records.
Flex_vst_bind1	String	False	No	Custom flexfield binding attribute 1 for additional metadata or lookup references.
Flex_vst_bind10	String	False	No	Custom flexfield binding attribute 10 for user-defined system attributes.
Flex_vst_bind11	String	False	No	Custom flexfield binding attribute 11 for additional validation parameters.
Flex_vst_bind12	String	False	No	Custom flexfield binding attribute 12 for extended business rules.
Flex_vst_bind13	String	False	No	Custom flexfield binding attribute 13 for additional metadata extensions.
Flex_vst_bind14	String	False	No	Custom flexfield binding attribute 14 for lookup and processing needs.
Flex_vst_bind15	String	False	No	Custom flexfield binding attribute 15 for business process enhancements.
Flex_vst_bind16	String	False	No	Custom flexfield binding attribute 16 for reporting and query extensions.
Flex_vst_bind17	String	False	No	Custom flexfield binding attribute 17 for customized data filtering.
Flex_vst_bind18	String	False	No	Custom flexfield binding attribute 18 for system-wide lookup logic.
Flex_vst_bind19	String	False	No	Custom flexfield binding attribute 19 for additional control over validation rules.
Flex_vst_bind2	String	False	No	Custom flexfield binding attribute 2 for extended lookup or processing logic.
Flex_vst_bind20	String	False	No	Custom flexfield binding attribute 20 for extended transaction logic.
Flex_vst_bind3	String	False	No	Custom flexfield binding attribute 3 for additional processing parameters.
Flex_vst_bind4	String	False	No	Custom flexfield binding attribute 4 for extended metadata.
Flex_vst_bind5	String	False	No	Custom flexfield binding attribute 5 for specialized lookup needs.
Flex_vst_bind6	String	False	No	Custom flexfield binding attribute 6 for business rule application.
Flex_vst_bind7	String	False	No	Custom flexfield binding attribute 7 for additional validation checks.
Flex_vst_bind8	String	False	No	Custom flexfield binding attribute 8 for extended system configurations.
Flex_vst_bind9	String	False	No	Custom flexfield binding attribute 9 for extended transactional data.

Return to Top

FlexFndPvsNumberIdCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	Decimal	False	No	Unique identifier for the number-based character value entry within the descriptive flexfield (DFF) value set.
Value	String	False	No	The specific value assigned to this number-based character value entry within the value set.
Description	String	False	No	Detailed description of the number-based character value entry and its intended use.
StartDateActive	Date	False	No	The date when this number-based character value becomes active and available for use.
EndDateActive	Date	False	No	The date when this number-based character value is no longer active or valid.
EnabledFlag	String	False	No	Indicates whether this number-based character value is enabled. 'True' means enabled; 'False' means disabled.
SummaryFlag	String	False	No	Indicates whether this number-based character value is a summary value within the value set.
ValueSetCode	String	False	No	Code identifying the value set that contains this number-based character value.
Bind_DataSource	String	False	No	Reference to the data source associated with this number-based character value entry.
Bind_FinderContext	String	False	No	Specifies the finder context used to retrieve relevant data for this number-based character value.
Bind_FinderDateFlag	String	False	No	Flag indicating whether date-based validation is required for this number-based character value.
Bind_ValidationDate	Date	False	No	Specifies the date used for validation of this number-based character value entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve number-based character value records.
Flex_vst_bind1	String	False	No	Custom flexfield binding attribute 1 for additional metadata or lookup references.
Flex_vst_bind10	String	False	No	Custom flexfield binding attribute 10 for user-defined system attributes.
Flex_vst_bind11	String	False	No	Custom flexfield binding attribute 11 for additional validation parameters.
Flex_vst_bind12	String	False	No	Custom flexfield binding attribute 12 for extended business rules.
Flex_vst_bind13	String	False	No	Custom flexfield binding attribute 13 for additional metadata extensions.
Flex_vst_bind14	String	False	No	Custom flexfield binding attribute 14 for lookup and processing needs.
Flex_vst_bind15	String	False	No	Custom flexfield binding attribute 15 for business process enhancements.
Flex_vst_bind16	String	False	No	Custom flexfield binding attribute 16 for reporting and query extensions.
Flex_vst_bind17	String	False	No	Custom flexfield binding attribute 17 for customized data filtering.
Flex_vst_bind18	String	False	No	Custom flexfield binding attribute 18 for system-wide lookup logic.
Flex_vst_bind19	String	False	No	Custom flexfield binding attribute 19 for additional control over validation rules.
Flex_vst_bind2	String	False	No	Custom flexfield binding attribute 2 for extended lookup or processing logic.
Flex_vst_bind20	String	False	No	Custom flexfield binding attribute 20 for extended transaction logic.
Flex_vst_bind3	String	False	No	Custom flexfield binding attribute 3 for additional processing parameters.
Flex_vst_bind4	String	False	No	Custom flexfield binding attribute 4 for extended metadata.
Flex_vst_bind5	String	False	No	Custom flexfield binding attribute 5 for specialized lookup needs.
Flex_vst_bind6	String	False	No	Custom flexfield binding attribute 6 for business rule application.
Flex_vst_bind7	String	False	No	Custom flexfield binding attribute 7 for additional validation checks.
Flex_vst_bind8	String	False	No	Custom flexfield binding attribute 8 for extended system configurations.
Flex_vst_bind9	String	False	No	Custom flexfield binding attribute 9 for extended transactional data.

Return to Top

InventoryOrganizations

Name	Type	ReadOnly	FilterOnly	Description
OrganizationId [KEY]	Long	False	No	Unique identifier for the inventory organization.
OrganizationCode	String	False	No	Short code uniquely identifying the inventory organization.
OrganizationName	String	False	No	Full name of the inventory organization.
ManagementBusinessUnitId	Long	False	No	Unique identifier for the business unit managing this inventory organization.
ManagementBusinessUnitName	String	False	No	Name of the business unit responsible for managing this inventory organization.
LegalEntityId	Long	False	No	Unique identifier for the legal entity associated with this inventory organization.
LegalEntityName	String	False	No	Name of the legal entity associated with this inventory organization.
ProfitCenterBusinessUnitId	Long	False	No	Unique identifier for the profit center business unit associated with this inventory organization.
ProfitCenterBusinessUnitName	String	False	No	Name of the profit center business unit associated with this inventory organization.
Status	String	False	No	Current status of the inventory organization (for example, Active, Inactive).
LocationId	Long	False	No	Unique identifier for the location associated with this inventory organization.
LocationCode	String	False	No	Short code representing the location associated with this inventory organization.
InventoryFlag	Bool	False	No	Indicates whether the organization is enabled for inventory management. 'True' means enabled; 'False' means disabled.
ManufacturingPlantFlag	Bool	False	No	Indicates whether the organization is designated as a manufacturing plant. 'True' means enabled; 'False' means disabled.
ContractManufacturingFlag	Bool	False	No	Indicates whether the organization operates as a contract manufacturing facility. 'True' means enabled; 'False' means disabled.
MaintenanceEnabledFlag	Bool	False	No	Indicates whether the organization is enabled for maintenance activities. 'True' means enabled; 'False' means disabled.
MasterOrganizationId	Long	False	No	Unique identifier for the master organization governing this inventory organization.
MasterOrganizationCode	String	False	No	Short code representing the master organization governing this inventory organization.
MasterOrganizationName	String	False	No	Name of the master organization governing this inventory organization.
IntegratedSystemType	String	False	No	Specifies the type of integrated system associated with this inventory organization.
ItemGroupingCode	String	False	No	Code used for grouping items within this inventory organization.
ItemDefinitionOrganizationId	Long	False	No	Unique identifier for the item definition organization associated with this inventory organization.
ItemDefinitionOrganizationCode	String	False	No	Short code representing the item definition organization.
ItemDefinitionOrganizationName	String	False	No	Name of the item definition organization associated with this inventory organization.
ManufacturingParametersExistFlag	Bool	False	No	Indicates whether manufacturing parameters are configured for this inventory organization. 'True' means they exist; 'False' means they do not.
CreatedBy	String	False	No	Username or system entity that created this inventory organization record.
CreationDate	Datetime	False	No	Timestamp indicating when the inventory organization record was initially created.
LastUpdatedBy	String	False	No	Username or system entity that last modified the inventory organization record.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the inventory organization record was last updated.
FixedAssetCorporateBookTypeCode	String	False	No	Specifies the corporate book type code for fixed assets associated with this inventory organization.
Finder	String	False	No	A system-defined query or lookup used to retrieve inventory organization records based on specific criteria.

Return to Top

InventoryOrganizationsinvOrgParameters

Name	Type	ReadOnly	FilterOnly	Description
InventoryOrganizationsOrganizationId [KEY]	Long	False	No	Unique identifier linking this inventory organization parameter entry to a specific inventory organization.
OrganizationId [KEY]	Long	False	No	Unique identifier for the organization, automatically generated when a new organization record is created. This serves as the primary key.
Timezone	String	False	No	Specifies the time zone used by the organization for its operations.
MasterOrganizationId	Long	False	No	Unique identifier for the parent or master organization overseeing this inventory organization.
ScheduleId	Long	False	No	Unique identifier for the work day calendar assigned to the organization.
DefaultPickingRuleId	Long	False	No	Unique identifier for the default picking rule applied when selecting material for picking.
DefaultLocatorOrderValue	Decimal	False	No	Specifies the default picking order assigned to each locator when creating a work order.
DefaultSubinventoryOrderValue	Decimal	False	No	Specifies the default picking order assigned to each subinventory when creating a work order.
NegativeInvReceiptFlag	Bool	False	No	Indicates whether the organization allows negative inventory balances. 'True' means allowed; 'False' means not allowed (default: True).
StockLocatorControl	String	False	No	Defines the default locator control for subinventories, such as Predefined, Dynamic, or None.
SourceType	String	False	No	Specifies the source type used when replenishing an item, such as Organization or Supplier.
SourceOrganizationId	Long	False	No	Unique identifier for the replenishment organization if the source type is Organization.
SourceOrganizationCode	String	False	No	Short code representing the replenishment organization if the source type is Organization.
SourceOrganizationName	String	False	No	Name of the replenishment organization if the source type is Organization.
SourceSubinventory	String	False	No	Specifies the replenishment subinventory if the source type is Organization.
SerialNumberType	String	False	No	Defines the control level ensuring each serial number is unique when created.
AutoSerialAlphaPrefix	String	False	No	Specifies the alphanumeric prefix added when generating serial numbers.
StartAutoSerialNumber	String	False	No	Defines the starting number for auto-generated serial numbers.
AutoLotAlphaPrefix	String	False	No	Specifies the alphanumeric prefix added when generating lot numbers.
LotNumberUniqueness	String	False	No	Defines the control level ensuring each lot number is unique.
LotNumberGeneration	String	False	No	Specifies the control method for generating lot numbers.
LotNumberZeroPaddingFlag	Bool	False	No	Indicates whether lot numbers should be padded with zeros. 'True' means enabled; 'False' means disabled (default: False).
LotNumberLength	Int	False	No	Specifies the total length of the lot number.
StartingRevision	String	False	No	Defines the default starting revision assigned to new items.
PackingUnitPrefix	String	False	No	Specifies the prefix added when creating the packing unit string.
PackingUnitSuffix	String	False	No	Specifies the suffix added when creating the packing unit string.
PackingUnitStartingNumber	Decimal	False	No	Defines the smallest number used when generating packing unit numbers.
PackingUnitTotalLength	Decimal	False	No	Specifies the total length of the packing unit string.
GS1128Flag	Bool	False	No	Indicates whether GS1-128 barcode standards are enabled. 'True' means enabled; 'False' means disabled (default: False).
SerialNumberGeneration	String	False	No	Specifies the control level applied when generating serial numbers.
PickConfirmationRequiredFlag	Bool	False	No	Indicates whether manual pick confirmation is required. 'True' means required; 'False' means not required (default: False).
OverpickTransferOrdersFlag	Bool	False	No	Indicates whether overpicking is allowed for movement requests. 'True' means allowed; 'False' means not allowed (default: False).
DistributedOrganizationFlag	Bool	False	No	Indicates whether the organization provides logistics services like warehousing. 'True' means enabled; 'False' means disabled (default: False).
AllowDifferentLotStatus	Decimal	False	No	Determines whether a lot’s status can change when transferring materials.
ChildLotControlPrefix	String	False	No	Defines the prefix for child lot numbers when generating child lots.
ChildLotControlTotalLength	Decimal	False	No	Specifies the total length of the child lot number.
ChildLotControlFormatValidationFlag	Bool	False	No	Indicates whether the child lot number format should be validated. 'True' means validated; 'False' means not validated (default: False).
ChildLotControlZeroPaddingFlag	Bool	False	No	Indicates whether child lot numbers should be padded with zeros. 'True' means enabled; 'False' means disabled (default: False).
CopyLotAttributeFlag	Bool	False	No	Indicates whether a child lot inherits attributes from the parent lot. 'True' means inherited; 'False' means not inherited (default: False).
AutomaticallyCreateLotUOMConversion	Decimal	False	No	Determines whether lot-based unit of measure (UOM) conversion is enabled.
ParentChildGeneration	String	False	No	Specifies the control level for generating child lot numbers.
AutomaticallyDeleteAllocationsFlag	Bool	False	No	Indicates whether pick allocations are automatically canceled if a movement request is canceled. 'True' means enabled; 'False' means disabled (default: False).
EnforceLocatorAliasUniquenessFlag	Bool	False	No	Currently not used.
PreFillPickedQuantityFlag	Bool	False	No	Indicates whether picked quantities should be pre-filled during pick confirmation. 'True' means enabled; 'False' means disabled (default: False).
CapturePickingExceptionsFlag	Bool	False	No	Indicates whether picking exceptions should be captured. 'True' means enabled; 'False' means disabled (default: True).
PickQuantityDefaultReasonId	Long	False	No	Specifies the default reason applied to picking quantity exceptions.
AllowNegativeOnhandTransactionsFlag	Bool	False	No	Indicates whether negative on-hand inventory transactions are allowed. 'True' means allowed; 'False' means not allowed (default: False).
UseOriginalReceiptDateFlag	Bool	False	No	Indicates whether the original receipt date should be used for inventory transactions. 'True' means enabled; 'False' means disabled (default: False).
RoundReorderQuantityFlag	Bool	False	No	Indicates whether reorder quantities should be rounded to optimize planning. 'True' means enabled; 'False' means disabled (default: False).
PickSlipBatchSize	Int	False	No	Defines the number of movement request lines processed together when allocating material.
ReplenishmentMovementRequestGrouping	Int	False	No	Specifies the grouping threshold for replenishment movement requests.
FillKillMoveOrderFlag	Bool	False	No	Indicates whether partially picked replenishment movement request lines should be canceled. 'True' means enabled; 'False' means disabled (default: False).
ManufacturingPlantFlag	Bool	False	No	Indicates whether the organization is designated as a manufacturing plant. 'True' means enabled; 'False' means disabled (default: False).
ContractManufacturingFlag	Bool	False	No	Indicates whether the organization is a contract manufacturing plant. 'True' means enabled; 'False' means disabled (default: False).
SupplierId	Long	False	No	Unique identifier for the supplier if this is a contract manufacturing organization.
SupplierSiteId	Long	False	No	Unique identifier for the supplier site if this is a contract manufacturing organization.
MaintenanceEnabledFlag	Bool	False	No	Indicates whether maintenance activities are supported. 'True' means enabled; 'False' means disabled (default: False).
SystemSelectsSerialNumberFlag	Bool	False	No	Indicates whether the system auto-generates serial numbers. 'True' means system-selected; 'False' means user-selected (default: False).
PurchasingByRevisionFlag	Bool	False	No	Indicates whether item revisions must be included in purchase orders. 'True' means required; 'False' means optional (default: False).
FillKillTransferOrdersFlag	Bool	False	No	Indicates whether remaining quantities on transfer orders should be automatically canceled. 'True' means enabled; 'False' means disabled (default: False).
ItemGroupingCode	String	False	No	Specifies how items are assigned to the organization.
ItemDefinitionOrganizationId	Long	False	No	Unique identifier for the item definition organization.
TrackByProjectFlag	Bool	False	No	Indicates whether inventory transactions should capture project details. 'True' means enabled; 'False' means disabled (default: False).
TrackByCountryOfOriginFlag	Bool	False	No	Indicates whether tracking by country of origin is enabled. 'True' means enabled; 'False' means disabled (default: False).
InternalCustomerFlag	Bool	False	No	Indicates whether the organization serves as an internal customer. 'True' means enabled; 'False' means disabled (default: False).
InternalCustomerName	String	False	No	Name of the internal customer associated with this inventory organization.
InternalCustomerId	Long	False	No	Unique identifier for the internal customer.
InternalCustomerAccountNumber	String	False	No	Account number associated with the internal customer.
ScheduleName	String	False	No	Name of the work day calendar for the organization.
UseCurrentItemCostFlag	Bool	False	No	Indicates whether the warehouse will default to using the current item cost in the Create Miscellaneous Transaction task. 'True' means enabled; 'False' means disabled (default: False).
OverpickForSpecialHandlingFlag	Bool	False	No	Indicates whether the warehouse allows overpicking to accommodate material movements requiring special handling. 'True' means enabled; 'False' means disabled (default: False).
CreatedBy	String	False	No	Username or system entity that created this inventory organization parameter record.
CreationDate	Datetime	False	No	Timestamp indicating when the inventory organization parameter record was initially created.
LastUpdatedBy	String	False	No	Username or system entity that last modified the inventory organization parameter record.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the inventory organization parameter record was last updated.
AcceptSubstituteItemsFlag	Bool	False	No	Indicates whether the warehouse accepts substitute items in place of ordered items. 'True' means enabled; 'False' means disabled (default: False).
IntegrateWmsWithManufacturingAndMaintenanceFlag	Bool	False	No	Indicates whether the plant is integrated into the warehouse management system (WMS) for manufacturing or maintenance. 'True' means enabled; 'False' means disabled (default: False).
FillKillSalesOrderFlag	Bool	False	No	Indicates whether remaining quantities on backordered sales order lines are automatically canceled during pick release, pick confirm, or ship confirm. 'True' means enabled; 'False' means disabled (default: False).
Finder	String	False	No	A system-defined query or lookup used to retrieve inventory organization parameter records.
Status	String	False	No	Current status of the inventory organization parameters.

Return to Top

InventoryOrganizationsinvOrgParametersorganizationParameterDFF

Name	Type	ReadOnly	FilterOnly	Description
InventoryOrganizationsOrganizationId [KEY]	Long	False	No	Unique identifier linking this descriptive flexfield (DFF) entry to a specific inventory organization parameter.
InvorgparametersOrganizationId [KEY]	Long	False	No	Unique identifier linking this DFF entry to an inventory organization parameter.
OrganizationId [KEY]	Long	False	No	Unique identifier for the item or inventory organization, automatically generated when a new organization is created. This serves as the primary key.
TestSsn	String	False	No	Custom attribute field used for testing or additional inventory organization-related metadata.
TestSsn2	String	False	No	Additional custom attribute field for testing or extended inventory organization attributes.
_FLEX_Context	String	False	No	Descriptive flexfield (DFF) context name, defining the purpose of the additional attributes for inventory organizations.
_FLEX_Context_DisplayValue	String	False	No	Display value representing the context assigned to the DFF.
Finder	String	False	No	A system-defined query or lookup used to retrieve inventory organization parameter records with DFF data.
Status	String	False	No	Current status of the inventory organization parameter DFF entry.

Return to Top

InventoryOrganizationsplantParameters

Name	Type	ReadOnly	FilterOnly	Description
InventoryOrganizationsOrganizationId [KEY]	Long	False	No	Unique identifier linking this plant parameter entry to a specific inventory organization.
OrganizationId [KEY]	Long	False	No	Unique identifier for the inventory organization, automatically generated upon creation.
ManufacturingCalendarId	Long	False	No	Unique identifier for the manufacturing calendar referenced by the organization. This attribute is required.
DefaultSupplySubinventory	String	False	No	Subinventory used for backflushing operations when no default values are defined.
DefaultSupplyLocator	Long	False	No	Locator used for backflushing operations when no default values are defined. Dependent on DefaultSupplySubinventory.
DefaultCompletionSubinventory	String	False	No	Subinventory used to store completed products if no default subinventory is defined.
DefaultCompletionLocator	Long	False	No	Locator used to store completed products if no default locator is defined. Dependent on DefaultCompletionSubinventory.
StartingOperationSequence	Long	False	No	Default sequence number for the first operation in a new work definition.
OperationSequenceIncrement	Long	False	No	Increment value applied to each new operation added in a work definition.
PhantomOperationInherit	String	False	No	Specifies whether phantom work definitions should charge components, resources, and overhead at the parent work item level.
WorkOrderPrefix	String	False	No	Alphanumeric prefix added to work order names when creating new work orders.
WorkOrderStartingNumber	Long	False	No	Starting numeric value used for generating work order numbers at the plant.
DefaultOvercompletionTolerance	Decimal	False	No	Percentage of assemblies allowed to be overcompleted per job or schedule.
DefaultTransactionMode	String	False	No	Specifies whether the system defaults transaction quantities to required quantities during material or resource transactions.
DefaultTransactionQuantity	String	False	No	Determines default transaction behavior for material and resource transactions within a work order.
QuantityChangeBackflush	String	False	No	Specifies whether quantity changes are allowed during backflushing operations.
DefaultWorkOrderTravelerTemplate	String	False	No	Layout template used when printing work order travelers.
DefaultLabelTemplate	String	False	No	Layout template used when printing labels for manufacturing or work orders.
IncludeComponentYieldFlag	Bool	False	No	Indicates whether decimal quantity rounding is applied. 'True' means no rounding; 'False' means rounding is applied (default: False).
AutoAssociateSerialNumberWorkOrderImportFlag	Bool	False	No	Indicates whether serial numbers are automatically created and associated with jobs. 'True' means enabled; 'False' means disabled (default: True).
BackflushLotSelection	String	False	No	Determines lot selection method during backflushing. Valid values: Manual, FIFO (First In First Out), or FEFO (First Expiration First Out).
StartStopCaptureLevel	String	False	No	Defines how time is captured during operations in the work order. Valid values: Operation Serial or Item Serial.
PurchaseRequisitionCreationTime	String	False	No	Specifies the threshold for creating purchase requisitions for work orders involving supplier operations and outside processing.
MaterialReportingLevel	String	False	No	Determines when material reporting icons appear in the dispatch list.
ForecastHorizon	Int	False	No	Defines the maximum number of days the Maintenance Forecast scheduled process calculates. Must be a positive integer (default: 30 days).
GenerateWorkOrdersHorizon	Int	False	No	Defines the maximum number of days the Generate Work Order scheduled process calculates (default: 7 days).
DefaultPickSlipGroupingRule	Long	False	No	Specifies the default grouping rule for pick slips in manufacturing work orders.
PrintPickSlipsFlag	Bool	False	No	Indicates whether pick slips are printed. 'True' means enabled; 'False' means disabled (default: False).
IncludePullComponentsFlag	Bool	False	No	Indicates whether pull supply type components should be included in picking. 'True' means enabled; 'False' means disabled (default: False).
IssuePushComponentsFlag	Bool	False	No	Indicates whether push components should be issued directly to work orders. 'True' means enabled; 'False' means disabled (default: False).
PrintLabelExternallyFlag	Bool	False	No	Indicates whether labels should be printed using an external system. 'True' means enabled; 'False' means disabled (default: False).
AllowDirectPurchasesForWorkOrdersFlag	Bool	False	No	Indicates whether work orders can access self-service procurement. 'True' means enabled; 'False' means disabled (default: False).
EnableProcessManufacturingFlag	Bool	False	No	Indicates whether the plant supports process manufacturing. 'True' means enabled; 'False' means disabled (default: False).
DefaultWorkMethod	String	False	No	Specifies the default manufacturing method for work definitions. Valid values: Discrete or Process.
ManufacturingCalendarName	String	False	No	Name of the manufacturing calendar referenced by the organization.
EnableIotFlag	Bool	False	No	Indicates whether the plant is synchronized with Oracle Internet of Things Cloud Service. 'True' means enabled; 'False' means disabled (default: False).
ManuallyIssueAssemblyToReworkWorkOrderFlag	Bool	False	No	Indicates whether assemblies must be manually issued for rework. 'True' means enabled; 'False' means disabled (default: False).
AllowNegativeIssueWithoutSerialNumberEntryFlag	Bool	False	No	Indicates whether serial number entry is required when removing parts from a procured finished good. 'True' means not required; 'False' means required (default: False).
AllowReservationsOnWorkOrdersFlag	Bool	False	No	Indicates whether work orders allow reservations on specified materials. 'True' means enabled; 'False' means disabled (default: False).
MaximumSchedulingDurationInMonths	Int	False	No	Defines the maximum allowed scheduling duration in months. Minimum: 3 months, Maximum: 48 months (default: 12 months).
CreatedBy	String	False	No	Username or system entity that created this plant parameter record.
CreationDate	Datetime	False	No	Timestamp indicating when the plant parameter record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when the plant parameter record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified the plant parameter record.
DefaultLotNumberBehavior	String	False	No	Specifies the defaulting method for lot number population in finished products. Valid values: No Default, Work Order Number (default: No Default).
RestrictLotsDuringReturnsFlag	Bool	False	No	Indicates whether returned lots must be restricted to previously transacted lots. 'True' means restricted; 'False' means not restricted (default: False).
DefaultUndercompletionTolerance	Decimal	False	No	Percentage of assemblies allowed to be undercompleted per job or schedule.
InspectionPlanType	String	False	No	Specifies the default inspection plan for the maintenance facility.
DefaultIncludeInPlanningForBulkSupplyTypeFlag	Bool	False	No	Indicates whether bulk supply-type operation items are included in planning by default. 'True' means included; 'False' means not included (default: True).
DefaultIncludeInPlanningForSupplierSupplyTypeFlag	Bool	False	No	Indicates whether supplier supply-type operation items are included in planning by default. 'True' means included; 'False' means not included (default: True).
EnableRoboticsFlag	Bool	False	No	Indicates whether the plant uses robotic resources. 'True' means enabled; 'False' means disabled (default: False).
DefaultMaterialReviewBoardSubinventory	String	False	No	Specifies the default subinventory for defective or unserviceable components during maintenance.
DefaultMaterialReviewBoardLocator	Long	False	No	Specifies the default locator for defective or unserviceable components during maintenance.
Finder	String	False	No	A system-defined query or lookup used to retrieve plant parameter records.
Status	String	False	No	Current status of the plant parameter entry.

Return to Top

ItemUnitOfMeasureConversions

Name	Type	ReadOnly	FilterOnly	Description
ItemUOMConversionId	Long	False	No	Unique identifier for the unit of measure (UOM) conversion entry for an inventory item.
InventoryItemId	Long	False	No	Unique identifier for the inventory item associated with this unit of measure conversion.
InventoryItemNumber	String	False	No	Item number associated with the inventory item for which this UOM conversion is defined.
PrimaryUOMCode	String	False	No	Code representing the primary unit of measure assigned to the inventory item.
PrimaryUOMId	Long	False	No	Unique identifier for the primary unit of measure assigned to the inventory item.
PrimaryUOMName	String	False	No	Name of the primary unit of measure assigned to the inventory item.
TransactionUOMCode	String	False	No	Code representing the transaction unit of measure to which the conversion applies.
TransactionUOMId	Long	False	No	Unique identifier for the transaction unit of measure to which the conversion applies.
TransactionUOMName	String	False	No	Name of the transaction unit of measure to which the conversion applies.
ConversionRate	Decimal	False	No	Conversion factor defining how the transaction unit of measure relates to the primary unit of measure.
CreatedBy	String	False	No	Username or system entity that created this unit of measure conversion record.
CreationDate	Datetime	False	No	Timestamp indicating when this unit of measure conversion record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this unit of measure conversion record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this unit of measure conversion record.

Return to Top

PackagingStrings

Name	Type	ReadOnly	FilterOnly	Description
PackagingStringId [KEY]	Long	False	No	Unique identifier for the packaging string entry.
PackagingString	String	False	No	Formatted packaging string composed of unit of measure (UOM) elements and multipliers. Display order is determined by the SCM Common: Display Order of Packaging String Units profile option.
UOMCode1	String	False	No	Unique code for the first unit in the packaging string. This is always the base unit (for example, Each in EA 10/BX 25/CS).
UOMName1	String	False	No	Name of the first unit in the packaging string. This is always the base unit (for example, Each in EA 10/BX 25/CS).
UOMCode2	String	False	No	Unique code for the second unit in the packaging string. This is a multiple of the base unit (for example, Box in EA 10/BX 25/CS).
UOMName2	String	False	No	Name of the second unit in the packaging string. This is a multiple of the base unit (for example, Box in EA 10/BX 25/CS).
UOMMultiplier2	Long	False	No	Multiplier between the base unit and the second unit (for example, 10 Each per Box in EA 10/BX 25/CS).
UOMCode3	String	False	No	Unique code for the third unit in the packaging string. This is a multiple of the second unit (for example, Case in EA 10/BX 25/CS).
UOMName3	String	False	No	Name of the third unit in the packaging string. This is a multiple of the second unit (for example, Case in EA 10/BX 25/CS).
UOMMultiplier3	Long	False	No	Multiplier between the second and third unit (for example, 25 Boxes per Case in EA 10/BX 25/CS).
UOMCode4	String	False	No	Unique code for the fourth unit in the packaging string. This is a multiple of the third unit.
UOMName4	String	False	No	Name of the fourth unit in the packaging string. This is a multiple of the third unit.
UOMMultiplier4	Long	False	No	Multiplier between the third and fourth unit, indicating how many third units are in the fourth unit.
UOMCode5	String	False	No	Unique code for the fifth unit in the packaging string. This is a multiple of the fourth unit.
UOMName5	String	False	No	Name of the fifth unit in the packaging string. This is a multiple of the fourth unit.
UOMMultiplier5	Long	False	No	Multiplier between the fourth and fifth unit, indicating how many fourth units are in the fifth unit.
UOMCode6	String	False	No	Unique code for the sixth unit in the packaging string. This is a multiple of the fifth unit.
UOMName6	String	False	No	Name of the sixth unit in the packaging string. This is a multiple of the fifth unit.
UOMMultiplier6	Long	False	No	Multiplier between the fifth and sixth unit, indicating how many fifth units are in the sixth unit.
UOMCode7	String	False	No	Unique code for the seventh unit in the packaging string. This is a multiple of the sixth unit.
UOMName7	String	False	No	Name of the seventh unit in the packaging string. This is a multiple of the sixth unit.
UOMMultiplier7	Long	False	No	Multiplier between the sixth and seventh unit, indicating how many sixth units are in the seventh unit.
UOMCode8	String	False	No	Unique code for the eighth unit in the packaging string. This is a multiple of the seventh unit.
UOMName8	String	False	No	Name of the eighth unit in the packaging string. This is a multiple of the seventh unit.
UOMMultiplier8	Long	False	No	Multiplier between the seventh and eighth unit, indicating how many seventh units are in the eighth unit.
UOMCode9	String	False	No	Unique code for the ninth unit in the packaging string. This is a multiple of the eighth unit.
UOMName9	String	False	No	Name of the ninth unit in the packaging string. This is a multiple of the eighth unit.
UOMMultiplier9	Long	False	No	Multiplier between the eighth and ninth unit, indicating how many eighth units are in the ninth unit.
UOMCode10	String	False	No	Unique code for the tenth unit in the packaging string. This is a multiple of the ninth unit.
UOMName10	String	False	No	Name of the tenth unit in the packaging string. This is a multiple of the ninth unit.
UOMMultiplier10	Long	False	No	Multiplier between the ninth and tenth unit, indicating how many ninth units are in the tenth unit.
CreatedBy	String	False	No	Username or system entity that created this packaging string record.
CreationDate	Datetime	False	No	Timestamp indicating when this packaging string record was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this packaging string record was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this packaging string record.
Finder	String	False	No	A system-defined query or lookup used to retrieve packaging string records.
UomCode	String	False	No	Code representing the unit of measure associated with this packaging string.

Return to Top

ScheduleExceptions

Name	Type	ReadOnly	FilterOnly	Description
ExceptionId [KEY]	Long	False	No	Unique identifier for the schedule exception entry.
Name	String	False	No	The name assigned to the schedule exception when it is created. This attribute is required.
Description	String	False	No	A brief description of the schedule exception, providing additional details on its purpose.
ShortCode	String	False	No	An abbreviated identifier displayed for the schedule exception.
ExceptionStartDate	String	False	No	The date when the schedule begins applying this exception.
ExceptionEndDate	String	False	No	The date when the schedule stops applying this exception.
PeriodTypeCode	String	False	No	Code representing the type of period the exception applies to, such as Off Period or Work Period.
CategoryCode	String	False	No	Code representing the category of the exception, such as Holiday or Training.
AllDayFlag	Bool	False	No	Indicates whether the exception applies to the entire day. 'True' means it applies for the full day; 'False' means it applies to specific hours within the day. Default is 'False'.
CreatedBy	String	False	No	Username or system entity that created this schedule exception entry.
CreationDate	Datetime	False	No	Timestamp indicating when this schedule exception entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this schedule exception entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this schedule exception entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve schedule exception records.

Return to Top

Schedules

Name	Type	ReadOnly	FilterOnly	Description
ScheduleId [KEY]	Long	False	No	Unique identifier for the schedule entry.
ScheduleTypeCode	String	False	No	Specifies the type of schedule being created. Valid values include Time, Duration, and Elapsed. This attribute is required.
Name	String	False	No	The name assigned to the schedule when it is created. This attribute is required.
Description	String	False	No	A brief description of the schedule, providing additional details on its purpose.
EffectiveFromDate	Date	False	No	The start date when the work schedule modeling, including working and non-working time, becomes effective. This attribute is required.
EffectiveToDate	Date	False	No	The end date when the work schedule modeling, including working and non-working time, is no longer effective. This attribute is required.
CategoryCode	String	False	No	Code representing the category of the schedule, such as Pager, UK SSP, or Work.
DeletedFlag	Bool	False	No	Indicates whether the schedule is active. 'True' means active and usable; 'False' means inactive (default: True).
QuarterlyTypeCode	String	False	No	Defines the quarterly model used for the schedule, such as 13 periods or variations of 4-4-5 week structures.
NumberOfAssignments	Int	False	No	Specifies the number of business objects linked to this schedule. If greater than zero, updates to the schedule may be restricted.
FirstDayOfWorkWeekCode	String	False	No	Defines the first day of the workweek for this schedule. Valid values: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, and SATURDAY (default: MONDAY).
FirstDayOfWorkWeek	String	False	No	Specifies the first day of the workweek for this schedule.
CreatedBy	String	False	No	Username or system entity that created this schedule entry.
CreationDate	Datetime	False	No	Timestamp indicating when this schedule entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this schedule entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this schedule entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve schedule records.

Return to Top

SchedulesscheduleExceptionAssociations

Name	Type	ReadOnly	FilterOnly	Description
SchedulesScheduleId [KEY]	Long	False	No	Unique identifier linking this exception association entry to a specific schedule.
ScheduleExceptionId	Long	False	No	Unique identifier for the schedule exception being assigned. This is a required input.
ScheduleExceptionAssociationId [KEY]	Long	False	No	Unique identifier for the schedule exception association entry.
ScheduleId	Long	False	No	Unique identifier for the parent schedule to which the exception is assigned. This is a required input.
ScheduleExceptionName	String	False	No	The name of the schedule exception that is associated with the schedule.
CreatedBy	String	False	No	Username or system entity that created this schedule exception association entry.
CreationDate	Datetime	False	No	Timestamp indicating when this schedule exception association entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this schedule exception association entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this schedule exception association entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve schedule exception association records.
ScheduleTypeCode	String	False	No	Defines the type of schedule linked to this schedule exception association.

Return to Top

SchedulesscheduleWorkdayPatterns

Name	Type	ReadOnly	FilterOnly	Description
SchedulesScheduleId [KEY]	Long	False	No	Unique identifier linking this workday pattern entry to a specific schedule.
SchedulePatternId [KEY]	Long	False	No	Unique identifier for the schedule workday pattern entry.
PatternSequenceNumber	Long	False	No	Defines the sequence order in which patterns are applied within the schedule.
PatternId	Long	False	No	Unique identifier for the associated workday pattern within the schedule. This is a required input.
PatternName	String	False	No	The name of the workday pattern assigned to the schedule.
CreatedBy	String	False	No	Username or system entity that created this schedule workday pattern entry.
CreationDate	Datetime	False	No	Timestamp indicating when this schedule workday pattern entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this schedule workday pattern entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this schedule workday pattern entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve schedule workday pattern records.
ScheduleId	Long	False	No	Unique identifier for the parent schedule to which this workday pattern is assigned.
ScheduleTypeCode	String	False	No	Defines the type of schedule linked to this workday pattern association.

Return to Top

Shifts

Name	Type	ReadOnly	FilterOnly	Description
ShiftId [KEY]	Long	False	No	Unique identifier for the shift entry.
Name	String	False	No	The name assigned to the shift when it is created. This attribute is required.
Description	String	False	No	A brief description of the shift, providing additional details on its purpose.
Code	String	False	No	A short code or abbreviation used to identify the shift.
StartTime	String	False	No	The time when the shift starts, formatted as 'hh:mm AM/PM'.
EndTime	String	False	No	The time when the shift ends, formatted as 'hh:mm AM/PM'.
Duration	Decimal	False	No	The total duration of the shift based on its start and end times.
DurationUnit	String	False	No	The unit of time associated with the shift duration (for example, hours, minutes).
CategoryCode	String	False	No	Code representing the shift category, such as Working from Home or Office.
PeriodTypeCode	String	False	No	Code indicating the type of period for the shift, such as Work Period or Off Period.
ShiftTypeCode	String	False	No	Defines the type of shift being created. Valid values: Time, Duration, and Elapsed. This attribute is required.
ShiftDetailTypeCode	String	False	No	Specifies the type of Time shift being created. Valid values: Flexible, Punch, or None. This attribute is required for Time shifts.
CreatedBy	String	False	No	Username or system entity that created this shift entry.
CreationDate	Datetime	False	No	Timestamp indicating when this shift entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this shift entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this shift entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve shift records.

Return to Top

ShiftsshiftDetails

Name	Type	ReadOnly	FilterOnly	Description
ShiftsShiftId [KEY]	Long	False	No	Unique identifier linking this shift detail entry to a specific shift.
ShiftDetailsId [KEY]	Long	False	No	Unique identifier for the shift detail entry.
Name	String	False	No	The name assigned to the shift detail.
Day	Long	False	No	Indicates the day of the shift detail, applicable for shifts longer than 24 hours.
StartTime	String	False	No	The time when the shift detail starts, formatted as 'hh:mm AM/PM'.
Duration	Decimal	False	No	Total duration of the shift detail based on its start time and length.
DurationUnit	String	False	No	Unit of time associated with the shift detail duration (for example, hours, minutes).
MinimumBreakMinutes	Long	False	No	Minimum number of minutes allowed for a break within this shift detail.
MaximumBreakMinutes	Long	False	No	Maximum number of minutes allowed for a break within this shift detail.
CoreWorkFlag	Bool	False	No	Indicates whether the shift detail represents core working time. 'True' means core working time; 'False' means not core working time (default: False).
CreatedBy	String	False	No	Username or system entity that created this shift detail entry.
CreationDate	Datetime	False	No	Timestamp indicating when this shift detail entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this shift detail entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this shift detail entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve shift detail records.
ShiftId	Long	False	No	Unique identifier linking this shift detail entry to its parent shift.

Return to Top

StandardLookupsLOV

Name	Type	ReadOnly	FilterOnly	Description
LookupType [KEY]	String	False	No	The category or type of lookup being referenced.
LookupCode [KEY]	String	False	No	A unique code representing a specific lookup value within the lookup type.
Meaning	String	False	No	The display name or label associated with the lookup code.
Description	String	False	No	A brief description providing additional details about the lookup code.
Tag	String	False	No	A classification or tag associated with the lookup entry.
ActiveDate	Date	False	No	The date when the lookup value becomes active and available for use.
Bind_ParentLookupCode	String	False	No	A reference to the parent lookup code if this lookup is part of a hierarchical structure.
Bind_ParentSetidDetermType	String	False	No	Defines the method used to determine the parent set ID.
Bind_ParentSetidDetermValue	String	False	No	Specifies the value used to determine the parent set ID.
Bind_RelationshipId	Long	False	No	Unique identifier linking this lookup to a related entity.
BindActiveDate	Date	False	No	The date when the binding lookup value becomes active.
BindLookupCode	String	False	No	A reference lookup code used for binding relationships.
BindLookupType	String	False	No	A reference lookup type used for binding relationships.
BindTag	String	False	No	A classification or tag associated with the binding lookup entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve lookup values.
NewLookupCode1	String	False	No	A newly defined lookup code for use in updates or expansions.
NewLookupCode2	String	False	No	A second newly defined lookup code for system updates or expansions.
NewLookupCode3	String	False	No	A third newly defined lookup code for system updates or expansions.
NewLookupCode4	String	False	No	A fourth newly defined lookup code for system updates or expansions.
NewLookupCode5	String	False	No	A fifth newly defined lookup code for system updates or expansions.

Return to Top

UnitOfMeasureClasses

Name	Type	ReadOnly	FilterOnly	Description
ClassCode	String	False	No	A unique user-defined code that identifies the unit of measure class. This attribute is required.
ClassId [KEY]	String	False	No	Unique identifier for the unit of measure class.
ClassName	String	False	No	The name assigned to the unit of measure class. This value must be unique and is required.
ClassDescription	String	False	No	A brief description providing additional details about the unit of measure class.
EndDate	Date	False	No	The date when this unit of measure class stops allowing the creation of new units within it.
BaseUnitOfMeasure	String	False	No	The name of the base unit of measure assigned to this class.
BaseUOMCode	String	False	No	A short code that uniquely identifies the base unit of measure for this class.
BaseUOMDescription	String	False	No	A brief description of the base unit of measure for this class.
LastUpdatedBy	String	False	No	Username or system entity that last modified this unit of measure class entry.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this unit of measure class entry was last updated.
CreatedBy	String	False	No	Username or system entity that created this unit of measure class entry.
CreationDate	Datetime	False	No	Timestamp indicating when this unit of measure class entry was initially created.
Finder	String	False	No	A system-defined query or lookup used to retrieve unit of measure class records.

Return to Top

UnitOfMeasureClassesDFF

Name	Type	ReadOnly	FilterOnly	Description
UnitOfMeasureClassesClassId [KEY]	String	False	No	Unique identifier linking this entry to a specific unit of measure class.
UomClass [KEY]	String	False	No	Unique identifier for the unit of measure class. This is a primary key generated by the application upon class creation. It maps to the ClassId parameter in the root resource.
_FLEX_ValidationDate	Date	False	No	Date when the descriptive flexfield (DFF) validation was last performed for the unit of measure class.
_FLEX_Context	String	False	No	DFF context name associated with the unit of measure class.
_FLEX_NumOfSegments	Int	False	No	Number of segments defined within the DFF for the unit of measure class.
_FLEX_NumOfVisibleSegments	Int	False	No	Number of visible segments within the DFF for the unit of measure class.
ClassCode	String	False	No	Unique user-defined code that identifies the unit of measure class.
ClassId	String	False	No	Unique identifier for the unit of measure class.
Finder	String	False	No	A system-defined query or lookup used to retrieve unit of measure class records.

Return to Top

UnitOfMeasureClassesinterclassConversions

Name	Type	ReadOnly	FilterOnly	Description
UnitOfMeasureClassesClassId [KEY]	String	False	No	Unique identifier linking this interclass conversion entry to a specific unit of measure class.
InterclassConversionId [KEY]	Long	False	No	Unique identifier for the interclass conversion record.
InventoryItemId	Long	False	No	Unique identifier for the inventory item associated with this interclass conversion. Either this attribute or ItemNumber is required.
FromUOMClassId	String	False	No	Unique identifier for the originating unit of measure class in the conversion process. For a specific inventory item, interclass conversions always occur between two classes. This attribute is not required when creating new interclass conversions.
FromUOMCode	String	False	No	User-defined short code identifying the base unit of measure for the originating unit of measure class. This attribute is not required when creating new interclass conversions.
ToUOMClassId	String	False	No	Unique identifier for the target unit of measure class in the conversion process. Either this attribute or ToUOMCode is required when creating new interclass conversions.
ToUOMCode	String	False	No	User-defined short code identifying the base unit of measure for the target unit of measure class. Either this attribute or ToUOMClassId is required when creating new interclass conversions.
InterclassConversion	Decimal	False	No	Conversion rate between the FromUOMClass and the ToUOMClass for the specified inventory item. This attribute is required.
InterclassConversionEndDate	Date	False	No	The date when the interclass conversion is no longer valid or available.
ItemNumber	String	False	No	Unique alphanumeric identifier for the inventory item associated with this interclass conversion. Either this attribute or InventoryItemId is required.
CreatedBy	String	False	No	Username or system entity that created this interclass conversion entry.
CreationDate	Datetime	False	No	Timestamp indicating when this interclass conversion entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this interclass conversion entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this interclass conversion entry.
ClassCode	String	False	No	User-defined code representing the unit of measure class involved in the interclass conversion.
ClassId	String	False	No	Unique identifier for the unit of measure class involved in the interclass conversion.
Finder	String	False	No	A system-defined query or lookup used to retrieve interclass conversion records.

Return to Top

UnitsOfMeasure

Name	Type	ReadOnly	FilterOnly	Description
UOMId [KEY]	Long	False	No	Unique identifier for the unit of measure. This value is system-generated when a unit is created.
UOMCode	String	False	No	User-defined short code that uniquely identifies the unit of measure. This attribute is required.
UOMClass	String	False	No	Class that categorizes the unit of measure. Either this attribute or UOMClassName is required when creating a new unit. This value corresponds to the ClassId of the unitOfMeasureClasses instance.
UOMClassCode	String	False	No	The unique code representing the unit of measure class.
UOMClassName	String	False	No	Name of the class that categorizes the unit of measure. Either this attribute or UOMClass is required when creating a new unit.
UOM	String	False	No	The name of the unit of measure. This attribute is required.
Description	String	False	No	A brief description of the unit of measure.
UOMReciprocalDescription	String	False	No	Explains how the unit of measure is processed when used in a reciprocal calculation. For example, 'Per Month' describes the reciprocal for a service measured in 'Month'.
UOMPluralDescription	String	False	No	The plural form of the unit of measure. For example, 'Feet' is the plural for 'Foot'.
BaseUnitFlag	Bool	False	No	Indicates whether this unit is the base unit of its class. 'True' means it is the base unit (typically the smallest unit in the class); 'False' means it is not. All conversions within a class occur through the base unit. Default is 'False'.
DisableDate	Date	False	No	The date when the unit of measure becomes inactive and is no longer used.
StandardConversion	Decimal	False	No	Conversion rate between this unit of measure and the base unit of its class. This attribute is required.
StandardConversionEndDate	Date	False	No	The date when the standard conversion for this unit of measure is no longer valid.
GlobalAttributeCategory	String	False	No	Specifies additional attributes for global extensions related to the unit of measure.
OkeiCode	String	False	No	The international OKEI code assigned to the unit of measure, used for global standardization.
DerivedUnitParentCode	String	False	No	The code of the parent unit if this unit is derived from another unit.
CreatedBy	String	False	No	Username or system entity that created this unit of measure entry.
CreationDate	Datetime	False	No	Timestamp indicating when this unit of measure entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this unit of measure entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this unit of measure entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve unit of measure records.

Return to Top

UnitsOfMeasureDFF

Name	Type	ReadOnly	FilterOnly	Description
UnitsOfMeasureUOMId [KEY]	Long	False	No	Unique identifier linking this descriptive flexfield (DFF) entry to a specific unit of measure.
UnitOfMeasureId [KEY]	Long	False	No	Unique identifier for the unit of measure. This value is system-generated when a unit is created. Maps to the UOMId parameter in the root resource.
_FLEX_ValidationDate	Date	False	No	The date when the DFF validation was last performed for the unit of measure.
_FLEX_Context	String	False	No	DFF context name associated with the unit of measure.
_FLEX_NumOfSegments	Int	False	No	Number of segments defined within the DFF for the unit of measure.
_FLEX_NumOfVisibleSegments	Int	False	No	Number of visible segments within the DFF for the unit of measure.
DisableDate	Date	False	No	The date when the unit of measure is disabled and no longer available for use.
Finder	String	False	No	A system-defined query or lookup used to retrieve unit of measure DFF records.
UOM	String	False	No	The name of the unit of measure.
UOMClass	String	False	No	The unit of measure class that categorizes the unit of measure.
UOMClassCode	String	False	No	Unique code representing the unit of measure class.
UOMCode	String	False	No	User-defined short code that uniquely identifies the unit of measure.
UOMId	Long	False	No	Unique identifier for the unit of measure.

Return to Top

UnitsOfMeasureintraclassConversions

Name	Type	ReadOnly	FilterOnly	Description
UnitsOfMeasureUOMId [KEY]	Long	False	No	Unique identifier linking this intraclass conversion entry to a specific unit of measure.
InventoryItemId	Long	False	No	Unique identifier for the inventory item associated with this intraclass conversion. This attribute is required.
ConversionId [KEY]	Long	False	No	Unique identifier for the intraclass conversion record.
IntraclassConversion	Decimal	False	No	Conversion rate between this unit of measure and the base unit of its class for the specified inventory item. This attribute is required.
IntraclassConversionEndDate	Date	False	No	The date when the intraclass conversion for this unit of measure is no longer valid.
ItemNumber	String	False	No	The unique alphanumeric identifier for the inventory item associated with this intraclass conversion.
CreatedBy	String	False	No	Username or system entity that created this intraclass conversion entry.
CreationDate	Datetime	False	No	Timestamp indicating when this intraclass conversion entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this intraclass conversion entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this intraclass conversion entry.
DisableDate	Date	False	No	The date when the unit of measure is disabled and no longer available for use.
Finder	String	False	No	A system-defined query or lookup used to retrieve intraclass conversion records.
UOM	String	False	No	The name of the unit of measure.
UOMClass	String	False	No	The unit of measure class that categorizes the unit of measure.
UOMClassCode	String	False	No	Unique code representing the unit of measure class.
UOMCode	String	False	No	User-defined short code that uniquely identifies the unit of measure.
UOMId	Long	False	No	Unique identifier for the unit of measure.

Return to Top

WorkdayPatterns

Name	Type	ReadOnly	FilterOnly	Description
PatternId [KEY]	Long	False	No	Unique identifier for the workday pattern.
Name	String	False	No	The name assigned to the workday pattern when it is created. This attribute is required.
Description	String	False	No	A brief description of the workday pattern, providing additional context.
PatternTypeCode	String	False	No	Code representing the type of pattern being created. Valid values include Time, Duration, and Elapsed. This attribute is required.
LengthInDays	Long	False	No	Specifies the number of days in the workday pattern before it repeats. Determines how the assigned shifts fill within this cycle. This attribute is required.
CreatedBy	String	False	No	Username or system entity that created this workday pattern entry.
CreationDate	Datetime	False	No	Timestamp indicating when this workday pattern entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this workday pattern entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this workday pattern entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve workday pattern records.

Return to Top

WorkdayPatternsworkdayPatternShifts

Name	Type	ReadOnly	FilterOnly	Description
WorkdayPatternsPatternId [KEY]	Long	False	No	Unique identifier linking this shift entry to a specific workday pattern.
PatternDetailId [KEY]	Long	False	No	Unique identifier for the specific shift detail within the workday pattern.
SequenceNumber	Long	False	No	Order number of the assigned shift within the Duration pattern. This is not currently used for Time or Elapsed patterns.
StartDay	Long	False	No	The day within the pattern when this shift begins.
EndDay	Long	False	No	The day within the pattern when this shift ends.
ShiftId	Long	False	No	Unique identifier for the shift assigned to the pattern. This attribute is required.
ShiftName	String	False	No	The name of the shift associated with the workday pattern.
CreatedBy	String	False	No	Username or system entity that created this workday pattern shift entry.
CreationDate	Datetime	False	No	Timestamp indicating when this workday pattern shift entry was initially created.
LastUpdateDate	Datetime	False	No	Timestamp indicating when this workday pattern shift entry was last updated.
LastUpdatedBy	String	False	No	Username or system entity that last modified this workday pattern shift entry.
Finder	String	False	No	A system-defined query or lookup used to retrieve workday pattern shift records.
PatternId	Long	False	No	Unique identifier for the workday pattern associated with this shift.

Return to Top