Oracle Fusion Cloud SCM Connector Objects (SCMCommon Schema)
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.
| 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |