Table Crm_Default_Sales_Order_Payment_Plans
Entity
Entity: Crm.Sales.DefaultSalesOrderPaymentPlans
Default payment plan for new documents of the specified document type. Entity: Crm_Default_Sales_Order_Payment_Plans
Owner Tables Hierarchy
Summary
Name |
Type |
Description |
Amount_Percent |
decimal(7, 6) |
Percent of the sales order amount to be payed. |
Default_Sales_Order_Payment_Plan_Id |
uniqueidentifier PK |
|
Document_Type_Id |
uniqueidentifier |
|
Due_Date_Form_Method |
nvarchar(3) Allowed: EXP , INV , SLS , SDD , IDD |
Method to determine the payment due date. SLS = Use sales order date, INV = Use invoice date, EXP = Specify the date explicitly, SDD = Sales order due date, IDD = Invoice due date |
Enterprise_Company_Id |
uniqueidentifier |
Enterprise company for which the current default installment template is valid. If enterprise company is not set then the installment template is valid for all enterprise companies. |
Enterprise_Company_Location_Id |
uniqueidentifier |
Enterprise company location (within the chosen enterprise company) for which the current default installment template is valid. If enterprise company location is not set then the installment template is valid for all enterprise company locations. |
Installment_Number |
int |
Consequtive installment number. Used for identifying different payments generated according this payment plan. |
Payment_Account_Id |
uniqueidentifier |
Default payment account for the current installment. NULL means that there is no default account. |
Payment_Term_Days |
int |
Payment term in days, which are to be added to form the payment due date. 0 means that the date determined by Due_Date_Form_Method and Explicit_Payment_Due_Date is taken as due date. |
Payment_Type_Id |
uniqueidentifier |
Default payment type for the current installment. NULL means that there is no default payment type. |
Remainder |
bit |
Indicates wheather this amount is the remainder of the document. Amount = Total amount of the sales order - explicitly specified amounts in the plan (by Amount_Percent). |
Row_Version |
timestamp |
|
Columns
Amount_Percent
Percent of the sales order amount to be payed.
Property |
Value |
Attributes |
IsPercent |
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 |
decimal(7, 6) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Default_Sales_Order_Payment_Plan_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 |
Default_Sales_Order_Payment_Plan_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Document_Type_Id
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 |
yes |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Document_Types |
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_Type_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Method to determine the payment due date. SLS = Use sales order date, INV = Use invoice date, EXP = Specify the date explicitly, SDD = Sales order due date, IDD = Invoice due date
Property |
Value |
Allowed Values |
EXP , INV , SLS , SDD , IDD |
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 |
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(3) |
UI Memo Editor |
no |
UI Width |
Long |
User Login |
no |
Visible |
yes |
Enterprise_Company_Id
Enterprise company for which the current default installment template is valid. If enterprise company is not set then the installment template is valid for all enterprise companies.
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_Enterprise_Companies |
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 |
Enterprise_Company_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Enterprise_Company_Location_Id
Enterprise company location (within the chosen enterprise company) for which the current default installment template is valid. If enterprise company location is not set then the installment template is valid for all enterprise company locations.
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 |
Cm_Company_Locations |
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 |
Enterprise_Company_Location_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Installment_Number
Consequtive installment number. Used for identifying different payments generated according this payment plan.
Property |
Value |
Auto Complete |
no |
Autoincrement |
1 |
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 |
int |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Payment_Account_Id
Default payment account for the current installment. NULL means that there is no default account.
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 |
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_Term_Days
Payment term in days, which are to be added to form the payment due date. 0 means that the date determined by Due_Date_Form_Method and Explicit_Payment_Due_Date is taken as due date.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
0 |
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 |
int |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Payment_Type_Id
Default payment type for the current installment. NULL means that there is no default payment type.
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 |
Cash_Payment_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 |
yes |
Payment_Type_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Remainder
Indicates wheather this amount is the remainder of the document. Amount = Total amount of the sales order - explicitly specified amounts in the plan (by Amount_Percent).
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 |
no |
Type |
bit |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
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 |