Table of Contents

Table Scm_Purchase_Control_Documents

Note

OBSOLETE! Do not use!

Entity

Entity: Logistics.Procurement.PurchaseControlDocuments

The main document for purchase control data. The purchase control is used to tally all orders and execuctions in the purchasing module. Entity: Scm_Purchase_Control_Documents (Introduced in version 18.2) (Obsoleted in version 22.1.6.73)

Owner Tables Hierarchy

Summary

Name Type Description
Document_Id uniqueidentifier
Purchase_Control_Document_Id uniqueidentifier PK
Purchase_Invoice_Id uniqueidentifier The purchase invoice, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.
Purchase_Order_Id uniqueidentifier The purchase order, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.
Purchase_Requisition_Id uniqueidentifier The purchase requisition, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.
Receiving_Order_Id uniqueidentifier The receiving order, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.

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

Purchase_Control_Document_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

Purchase_Control_Document_Id - Supported Filters

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

Purchase_Invoice_Id

The purchase invoice, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.

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 Scm_Purchase_Invoices
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

Purchase_Invoice_Id - Supported Filters

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

Purchase_Order_Id

The purchase order, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.

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 Scm_Purchase_Orders
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

Purchase_Order_Id - Supported Filters

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

Purchase_Requisition_Id

The purchase requisition, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.

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 Scm_Requisitions
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

Purchase_Requisition_Id - Supported Filters

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

Receiving_Order_Id

The receiving order, when it is the same for all lines. NULL when it is null for the lines or the lines have different values.

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 Scm_Receiving_Orders
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

Receiving_Order_Id - Supported Filters

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