Table of Contents

Table Scm_Requisitions

Entity

Entity: Logistics.Procurement.Requisitions

Contains the internal requisitions for products. Requisitions are consolidated by the purchase department into purchase orders. Entity: Scm_Requisitions

Owner Tables Hierarchy

Summary

Name Type Description
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.
Notes nvarchar(254)
Requested_By_Party_Id uniqueidentifier The party, which is requesting the purchase order.
Required_Delivery_Date datetime When not null, specifies the required delivery date for all lines.
Requisition_Id uniqueidentifier PK
Row_Version timestamp
Store_Id uniqueidentifier The store in which the products are needed.

Columns

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

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length 254
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 nvarchar(254) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible no

Requested_By_Party_Id

The party, which is requesting the purchase order.

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 Gen_Parties
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Requested_By_Party_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Required_Delivery_Date

When not null, specifies the required delivery date for all lines.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
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 datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Required_Delivery_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Requisition_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

Requisition_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

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

Store_Id

The store in which the products are needed.

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 Long
User Login no
Visible yes

Store_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Suggest improvement to this page