ManPageW AttributeSetInstance

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: Attribute Set Instance

Description : View Attribute Set Instance detail and use

Help :



Tab: Instance

Description : Attribute Set Instance

Help :

Table Name  : M_AttributeSetInstance

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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ID

Attribute Set Product Attribute Set Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. M_AttributeSet_ID

NUMBER(10)

TableDir

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Lot Product Lot Definition The individual Lot of a Product M_Lot_ID

NUMBER(10)

Search

Lot No Lot number (alphanumeric) The Lot Number indicates the specific lot that a product was part of. Lot

NVARCHAR2(40)

String

Guarantee Date Date when guarantee expires Date when the normal guarantee or availability expires GuaranteeDate

DATE

Date

Serial No Product Serial Number The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. SerNo

NVARCHAR2(40)

String


Tab: Shipment, Receipt

Description : Material Shipment and Receipt Lines

Help :

Table Name  : M_InOutLineMA_v

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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Receipt Material Receipt Document The Material Shipment / Receipt M_InOut_ID

NUMBER(10)

Search

Receipt Line Line on Receipt document M_InOutLine_ID

NUMBER(10)

Search

Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. Line

NUMBER(10)

Integer

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Search

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

NUMBER(10)

Search

Movement Quantity Quantity of a product moved. The Movement Quantity indicates the quantity of a product that has been moved. MovementQty

NUMBER

Quantity


Tab: Movement

Description : Material Movement Lines

Help :

Table Name  : M_MovementLineMA_v

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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Inventory Move Movement of Inventory The Inventory Movement uniquely identifies a group of movement lines. M_Movement_ID

NUMBER(10)

Search

Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_MovementLine_ID

NUMBER(10)

Search

Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. Line

NUMBER(10)

Integer

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

TableDir

Locator To Location inventory is moved to The Locator To indicates the location where the inventory is being moved to. M_LocatorTo_ID

NUMBER(10)

Table

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

NUMBER(10)

Search

Movement Quantity Quantity of a product moved. The Movement Quantity indicates the quantity of a product that has been moved. MovementQty

NUMBER

Quantity


Tab: Invoice

Description : AP / AR Invoice Lines

Help :

Table Name  : RV_C_InvoiceLine

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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

Search

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. C_InvoiceLine_ID

NUMBER(10)

Search

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

NUMBER(10)

Search

Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. QtyInvoiced

NUMBER

Quantity

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

Unit Price Actual Price The Actual or Unit Price indicates the Price for a product in source currency. PriceActual

NUMBER

CostsPrices

Lot No Lot number (alphanumeric) The Lot Number indicates the specific lot that a product was part of. Lot

NVARCHAR2(40)

String

Lot Product Lot Definition The individual Lot of a Product M_Lot_ID

NUMBER(10)

TableDir

Serial No Product Serial Number The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. SerNo

NVARCHAR2(40)

String

Contributions

Personal tools