ManPageW Demand

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Demand

= BETA FUNCTIONALITY =

Description : Maintain Material Demand

Help : Material Demand can be based on Forecast, Requisitions, Open Orders



Tab: Demand

Description : Material Demand

Help : Material Demand can be based on Forecast, Requisitions, Open Orders

Table Name  : M_Demand

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)

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

Default Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault

CHAR(1)

YesNo

Calendar Accounting Calendar Name The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30. C_Calendar_ID

NUMBER(10)

TableDir

Year Calendar Year The Year uniquely identifies an accounting year for a calendar. C_Year_ID

NUMBER(10)

TableDir

Process Now Processing

CHAR(1)

Button


Tab: Line

Description : Material Demand Line

Help : Demand for a product in a period

Table Name  : M_DemandLine

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

Demand Material Demand Material Demand can be based on Forecast, Requisitions, Open Orders M_Demand_ID

NUMBER(10)

TableDir

Period Period of the Calendar The Period indicates an exclusive range of dates for a calendar. C_Period_ID

NUMBER(10)

TableDir

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

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Quantity Quantity The Quantity indicates the number of a specific product or item for this document. Qty

NUMBER

Quantity

Calculated Quantity Calculated Quantity QtyCalculated

NUMBER

Quantity


Tab: Detail

Description : Material Demand Line Source Detail

Help : Source Link for Material Demand Lines

Table Name  : M_DemandDetail

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

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

Demand Line Material Demand Line Demand for a product in a period M_DemandLine_ID

NUMBER(10)

TableDir

Forecast Line Forecast Line Forecast of Product Qyantity by Period M_ForecastLine_ID

NUMBER(10)

Search

Requisition Line Material Requisition Line M_RequisitionLine_ID

NUMBER(10)

Search

Sales Order Line Sales Order Line The Sales Order Line is a unique identifier for a line in an order. C_OrderLine_ID

NUMBER(10)

Search

Contributions

Personal tools