Oracle Fusion Cloud SCM Connector Objects (SCMCommon Schema)
| 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 | |
| EndTime | String | False | No | The time when the shift ends, formatted as 'hh | |
| 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 | |
| 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. |