Table Srv_Service_Orders
Entity
Entity: Applications.Service.ServiceOrders
Service Orders are issued when a new servicing is required. Entity: Srv_Service_Orders
Owner Tables Hierarchy
Summary
Name
Type
Description
Customer_Id
uniqueidentifier
The client, requesting servicing.
Document_Id
uniqueidentifier
Is_Released
bit
Readonly
True if the document is not void and its state is released or greater. Deprecated
Is_Single_Execution
bit
Readonly
Specifies whether the document is a single execution of its order document.
Row_Version
timestamp
Service_Agreement_Id
uniqueidentifier
When not NULL denotes that the order will be bound to the terms in the specified agreement.
Service_Order_Id
uniqueidentifier
PK
Ship_To_Customer_Id
uniqueidentifier
Customer location of the main customer from which the service object is taken.
Store_Id
uniqueidentifier
The store in which to physically store service objects, received for servicing. Need to be specified only when serviced objects are managed through warehouse; otherwise, it is null.
Columns
Customer_Id
The client, requesting servicing.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Crm_Customers
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
100
User Login
no
Visible
yes
Customer_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Document_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
yes
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Gen_Documents
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Document_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Is_Released
True if the document is not void and its state is released or greater. Deprecated
Property
Value
Auto Complete
no
Data Filter
no
Default Value
False
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
yes
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Is_Released - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
yes
Is_Single_Execution
Specifies whether the document is a single execution of its order document.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
False
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
yes
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Is_Single_Execution - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
yes
Row_Version
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Service_Agreement_Id
When not NULL denotes that the order will be bound to the terms in the specified agreement.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Srv_Service_Agreements
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier (Allows NULL)
UI Memo Editor
no
UI Width
100
User Login
no
Visible
yes
Service_Agreement_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Service_Order_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
NewGuid
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
yes (order: 1)
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Service_Order_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Ship_To_Customer_Id
Customer location of the main customer from which the service object is taken.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Crm_Customers
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Ship_To_Customer_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Store_Id
The store in which to physically store service objects, received for servicing. Need to be specified only when serviced objects are managed through warehouse; otherwise, it is null.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Inv_Stores
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Store_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no