ManPageW DistributionList
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Distribution List
Description : Maintain Distribution Lists
Help : Distribution list contain business partners and a distribution quantity or ratio for creating Orders
Tab: Distribution List
Description : Distribution Lists allow to distribute products to a selected list of partners
Help : Distribution list contain business partners and a distribution quantity or ratio for creating Orders
Table Name : M_DistributionList
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Total Ratio | Total of relative weight in a distribution | The total relative weight of an distribution. If the total of all ratios is 100, it is the same as percent. | RatioTotal
NUMBER Number |
Tab: Distribution Line
Description : Distribution List Line with Business Partner and Quantity/Percentage
Help : The distribution can be based on Ratio, fixed quantity or both. If the ratio and quantity is not 0, the quantity is calculated based on the ratio, but with the Quantity as a minimum.
Table Name : M_DistributionListLine
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Distribution List | Distribution Lists allow to distribute products to a selected list of partners | Distribution list contain business partners and a distribution quantity or ratio for creating Orders | M_DistributionList_ID
NUMBER(10) TableDir |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | C_BPartner_Location_ID
NUMBER(10) TableDir |
Ratio | Relative Ratio for Distributions | The relative weight of an distribution. If the total of all ratios is 100, it is the same as percent. | Ratio
NUMBER Number |
Minimum Quantity | Minimum quantity for the business partner | If a minimum quantity is defined, and the quantity is based on the percentage is lower, the minimum quantity is used. | MinQty
NUMBER Quantity |