Table Scm_Purchase_Invoices
Entity
Entity: Logistics.Procurement.PurchaseInvoices
Contains purchase invoice headers. Entity: Scm_Purchase_Invoices
Owner Tables Hierarchy
Summary
| Name |
Type |
Description |
| Apply_Date |
date |
Specifies the date on which to create the VAT ledger entry for this purchase invoice. Usually, this date is equal to the document date, except when the document is received too late to be applied on its original document date. |
| Cost_Center_Id |
uniqueidentifier |
Cost center for which the amount from this document will be accounted. |
| Credit_Note_Original_Purchase_Invoice_Id |
uniqueidentifier |
The original invoice, which is debited/credited with this note |
| Credit_Note_Reason |
nvarchar(254) |
Reason for the debit/credit note |
| Deal_Type_Id |
uniqueidentifier |
Deal type for this purchase invoice. If deal type in entered then VAT entry is created for this deal type. |
| Delivery_Terms_Code |
nvarchar(3) Allowed: EXW, FCA, FAS, FOB, CFR, CIF, CPT, CIP, DAP, DAT, DDP, DPU |
Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting |
| Document_Currency_Id |
uniqueidentifier |
The currency of the unit prices and amounts in the document. |
| Document_Id |
uniqueidentifier |
|
| Intrastat_Destination_Region_Id |
uniqueidentifier |
Region, which is the final destination of the goods. Used for Intrastat reporting. When this is non-NULL, it applies to the whole document. |
| Intrastat_Transaction_Nature_Code |
nvarchar(2) Allowed: 11, 12, 13, 14, 19, 21, 22, 23, 29, 60, 70, 80, 91, 99, 30, 41, 42, 51, 52 |
Transaction nature; used for Intrastat reporting |
| Intrastat_Transport_Country_Id |
uniqueidentifier |
Country of origin of the transport company; used for Intrastat reporting |
| Intrastat_Transport_Mode_Code |
nvarchar(1) Allowed: 1, 2, 3, 4, 5, 7, 8, 9 |
Transport mode; used for Intrastat reporting |
| 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. |
| Payment_Account_Id |
uniqueidentifier |
When not NULL, specifies the default payment account for the payment order |
| Payment_Due_Date |
datetime |
Due date for paying the invoice. NULL means to use the default |
| Payment_Type_Id |
uniqueidentifier |
The payment type to be used. NULL is allowed only temporary and should be specified if payment order is to be generated |
| Purchase_Invoice_Id |
uniqueidentifier PK |
|
| Purchase_Order_Id |
uniqueidentifier |
The purchase order that was sent to the supplier and is the base for the invoice. NULL means there is no linked PO and 3 way check won't be performed |
| Purchase_Price_List_Id |
uniqueidentifier |
The price list, which, when non-NULL, is used to automatically load unit prices of the products, when entering the invoice manually. |
| Receiving_Order_Id |
uniqueidentifier |
The receiving order for the goods that were invoiced. The id is used for 2 or 3 way quantity check. NULL means that there is no linked RO and the 2 or 3 way check will not include the RO |
| Row_Version |
timestamp |
|
| Sale_Deal_Type_Id |
uniqueidentifier |
Sale deal type for this purchase invoice. If sale deal type in entered then Sales VAT entry is created for this deal type. |
| Supplier_Id |
uniqueidentifier |
The supplier of the purchase, who is issuing the document. |
| VAT_Cash_Reporting_Mode |
bit |
When True, indicates, that this invoice uses the special 'Cash reporting mode' when creating VAT ledger entries. |
| VAT_Notes |
nvarchar(254) |
Description of the operation that will be entered in the VAT ledgers. |
Columns
Apply_Date
Specifies the date on which to create the VAT ledger entry for this purchase invoice. Usually, this date is equal to the document date, except when the document is received too late to be applied on its original document date.
| 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 |
11 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
date |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Apply_Date - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |
Cost_Center_Id
Cost center for which the amount from this document will be accounted.
| 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 |
10 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Acc_Cost_Centers |
| 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 |
no |
Cost_Center_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Credit_Note_Original_Purchase_Invoice_Id
The original invoice, which is debited/credited with this note
| 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 |
7 |
| 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 |
100 |
| User Login |
no |
| Visible |
yes |
Credit_Note_Original_Purchase_Invoice_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Credit_Note_Reason
Reason for the debit/credit note
| 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 |
254 |
| Order |
8 |
| 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 |
100 |
| User Login |
no |
| Visible |
yes |
Deal_Type_Id
Deal type for this purchase invoice. If deal type in entered then VAT entry is created for this deal type.
| 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 |
9 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
VAT_Deal_Types |
| 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 |
no |
Deal_Type_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Delivery_Terms_Code
Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting
| Property |
Value |
| Allowed Values |
EXW, FCA, FAS, FOB, CFR, CIF, CPT, CIP, DAP, DAT, DDP, DPU |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
3 |
| Order |
17 |
| 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(3) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Document_Currency_Id
The currency of the unit prices and amounts in the document.
| 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 |
3 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Gen_Currencies |
| 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 |
Document_Currency_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
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 |
1 |
| 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 |
yes |
Intrastat_Destination_Region_Id
Region, which is the final destination of the goods. Used for Intrastat reporting. When this is non-NULL, it applies to the whole document.
| 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_Administrative_Regions |
| 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 |
Intrastat_Destination_Region_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Intrastat_Transaction_Nature_Code
Transaction nature; used for Intrastat reporting
| Property |
Value |
| Allowed Values |
11, 12, 13, 14, 19, 21, 22, 23, 29, 60, 70, 80, 91, 99, 30, 41, 42, 51, 52 |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
2 |
| Order |
18 |
| 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(2) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Intrastat_Transport_Country_Id
Country of origin of the transport company; used for Intrastat reporting
| 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 |
20 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Gen_Countries |
| 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 |
Intrastat_Transport_Country_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Intrastat_Transport_Mode_Code
Transport mode; used for Intrastat reporting
| Property |
Value |
| Allowed Values |
1, 2, 3, 4, 5, 7, 8, 9 |
| 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 |
19 |
| 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(1) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
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 |
Payment_Account_Id
When not NULL, specifies the default payment account for the payment order
| 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 |
15 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Cash_Payment_Accounts |
| 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 |
Payment_Account_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Payment_Due_Date
Due date for paying the invoice. NULL means to use the default
| 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 |
14 |
| 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 |
Payment_Due_Date - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
yes |
no |
Payment_Type_Id
The payment type to be used. NULL is allowed only temporary and should be specified if payment order is to be generated
| 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 |
4 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Cash_Payment_Types |
| 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 |
Payment_Type_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Purchase_Invoice_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 |
0 |
| 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_Invoice_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Purchase_Order_Id
The purchase order that was sent to the supplier and is the base for the invoice. NULL means there is no linked PO and 3 way check won't be performed
| 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 |
5 |
| 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 |
100 |
| User Login |
no |
| Visible |
yes |
Purchase_Order_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Purchase_Price_List_Id
The price list, which, when non-NULL, is used to automatically load unit prices of the products, when entering the invoice manually.
| 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 |
16 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Scm_Purchase_Price_Lists |
| 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_Price_List_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Receiving_Order_Id
The receiving order for the goods that were invoiced. The id is used for 2 or 3 way quantity check. NULL means that there is no linked RO and the 2 or 3 way check will not include the RO
| 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 |
6 |
| 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 |
100 |
| User Login |
no |
| Visible |
yes |
Receiving_Order_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
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 |
Sale_Deal_Type_Id
Sale deal type for this purchase invoice. If sale deal type in entered then Sales VAT entry is created for this deal type.
| 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 |
12 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
VAT_Deal_Types |
| 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 |
no |
Sale_Deal_Type_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Supplier_Id
The supplier of the purchase, who is issuing the document.
| 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 |
2 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Scm_Suppliers |
| 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 |
Supplier_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
VAT_Cash_Reporting_Mode
When True, indicates, that this invoice uses the special 'Cash reporting mode' when creating VAT ledger entries.
| 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 |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
bit |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
VAT_Cash_Reporting_Mode - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
VAT_Notes
Description of the operation that will be entered in the VAT ledgers.
| 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 |
13 |
| 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 |
100 |
| User Login |
no |
| Visible |
no |