Difference between revisions of "Template:Attribute Set Instance (Window ID-358 V1.0.0)"
From iDempiere en
m (Created page with "en:Attribute Set Instance (Window ID-358) ar:Attribute Set Instance (نافذة ID-358) [[bg:Инстанция на комплект атрибути (прозоре...") |
CarlosRuiz (talk | contribs) (Template generated from iDempiere12.20241227) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | = Window: Attribute Set Instance = | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
'''Description:''' View Attribute Set Instance detail and use | '''Description:''' View Attribute Set Instance detail and use | ||
| − | '''Help:''' | + | '''Help:''' |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Tab: Instance == | ||
| + | '''Description:''' Attribute Set Instance | ||
| − | + | '''Help:''' | |
| + | [[Image:Attribute_Set_Instance_-_Instance_-_Window_(iDempiere_1.0.0).png|border]] | ||
| − | + | {| border="1" cellpadding="5" cellspacing="0" align="center" | |
| − | + | |+'''Fields''' | |
| − | + | !style="background:#efefef;" width="100"|Name | |
| − | + | !style="background:#efefef;" width="150"|Description | |
| − | + | !style="background:#efefef;" width="300"|Help | |
| − | {| border="1" cellpadding="5" cellspacing="0" | + | !style="background:#efefef;" width="100"|<small>Technical Data</small> |
| − | + | |-valign="top" | |
| − | + | |Tenant | |
| − | + | |Tenant for this installation. | |
| − | !style="background:#efefef;" | | + | |A Tenant is a company or a legal entity. You cannot share data between Tenants. |
| − | !style="background:#efefef;" | | + | |<small>M_AttributeSetInstance.AD_Client_ID<br>numeric(10)<br>Table Direct</small> |
| − | !style="background:#efefef;" | | + | |-valign="top" |
| − | !style="background:#efefef;" | ||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |-valign="top" | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |A | ||
| − | |AD_Client_ID<br>numeric(10) | ||
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Organization | |Organization | ||
| − | |Organizational entity within | + | |Organizational entity within tenant |
| − | |An organization is a unit of your | + | |An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. |
| − | |AD_Org_ID<br>numeric(10) | + | |<small>M_AttributeSetInstance.AD_Org_ID<br>numeric(10)<br>Table Direct</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Attribute Set Instance | |Attribute Set Instance | ||
| − | |Product Attribute Set Instance | + | |Product Attribute Set Instance |
|The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | |The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | ||
| − | |M_AttributeSetInstance_ID<br>numeric(10) | + | |<small>M_AttributeSetInstance.M_AttributeSetInstance_ID<br>numeric(10)<br>ID</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Attribute Set | |Attribute Set | ||
| − | |Product 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. | |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<br>numeric(10)<br>Table Direct | + | |<small>M_AttributeSetInstance.M_AttributeSet_ID<br>numeric(10)<br>Table Direct</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Description | |Description | ||
| − | |Optional short description of the record | + | |Optional short description of the record |
|A description is limited to 255 characters. | |A description is limited to 255 characters. | ||
| − | |Description<br>character varying( | + | |<small>M_AttributeSetInstance.Description<br>character varying(1023)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Lot | |Lot | ||
| − | + | |Product Lot Definition | |
| − | |Product Lot Definition | ||
|The individual Lot of a Product | |The individual Lot of a Product | ||
| − | |M_Lot_ID<br>numeric(10)<br>Search | + | |<small>M_AttributeSetInstance.M_Lot_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Lot No | |Lot No | ||
| − | |Lot number (alphanumeric) | + | |Lot number (alphanumeric) |
|The Lot Number indicates the specific lot that a product was part of. | |The Lot Number indicates the specific lot that a product was part of. | ||
| − | |Lot<br>character varying(40)<br>String | + | |<small>M_AttributeSetInstance.Lot<br>character varying(40)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Guarantee Date | |Guarantee Date | ||
| − | + | |Date when guarantee expires | |
| − | |Date when guarantee expires | ||
|Date when the normal guarantee or availability expires | |Date when the normal guarantee or availability expires | ||
| − | |GuaranteeDate<br>timestamp without time zone<br>Date | + | |<small>M_AttributeSetInstance.GuaranteeDate<br>timestamp without time zone<br>Date</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Serial No | |Serial No | ||
| − | + | |Product Serial Number | |
| − | |Product Serial Number | ||
|The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | |The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | ||
| − | |SerNo<br>character varying(40)<br>String | + | |<small>M_AttributeSetInstance.SerNo<br>character varying(40)<br>String</small> |
| − | |||
| − | |||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Tab: Shipment, Receipt == | ||
| + | '''Description:''' Material Shipment and Receipt Lines | ||
| + | '''Help:''' | ||
| + | [[Image:Attribute_Set_Instance_-_Shipment,_Receipt_-_Window_(iDempiere_1.0.0).png|border]] | ||
| − | + | {| border="1" cellpadding="5" cellspacing="0" align="center" | |
| − | + | |+'''Fields''' | |
| − | + | !style="background:#efefef;" width="100"|Name | |
| − | {| border="1" cellpadding="5" cellspacing="0" | + | !style="background:#efefef;" width="150"|Description |
| − | + | !style="background:#efefef;" width="300"|Help | |
| − | + | !style="background:#efefef;" width="100"|<small>Technical Data</small> | |
| − | + | |-valign="top" | |
| − | !style="background:#efefef;" | | + | |Tenant |
| − | !style="background:#efefef;" | | + | |Tenant for this installation. |
| − | !style="background:#efefef;" | | + | |A Tenant is a company or a legal entity. You cannot share data between Tenants. |
| − | !style="background:#efefef;" | + | |<small>M_InOutLineMA_v.AD_Client_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | | | ||
| − | |||
| − | |||
| − | |-valign="top" | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |A | ||
| − | |AD_Client_ID<br>numeric(10)<br>Table Direct | ||
| − | |||
| − | |||
| − | |||
| − | |-valign="top" | ||
|Organization | |Organization | ||
| − | + | |Organizational entity within tenant | |
| − | |Organizational entity within | + | |An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. |
| − | |An organization is a unit of your | + | |<small>M_InOutLineMA_v.AD_Org_ID<br>numeric(10)<br>Table Direct</small> |
| − | |AD_Org_ID<br>numeric(10)<br>Table Direct | + | |-valign="top" |
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Attribute Set Instance | |Attribute Set Instance | ||
| − | |Product Attribute Set Instance | + | |Product Attribute Set Instance |
|The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | |The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | ||
| − | |M_AttributeSetInstance_ID<br>numeric(10)<br>Product Attribute | + | |<small>M_InOutLineMA_v.M_AttributeSetInstance_ID<br>numeric(10)<br>Product Attribute</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Receipt | |Receipt | ||
| − | |Material Receipt Document | + | |Material Receipt Document |
|The Material Shipment / Receipt | |The Material Shipment / Receipt | ||
| − | |M_InOut_ID<br>numeric(10)<br>Search | + | |<small>M_InOutLineMA_v.M_InOut_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Receipt Line | |Receipt Line | ||
| − | |Line on Receipt document | + | |Line on Receipt document |
| − | | | + | | |
| − | |M_InOutLine_ID<br>numeric(10)<br>Search | + | |<small>M_InOutLineMA_v.M_InOutLine_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Line No | |Line No | ||
| − | |Unique line for this document | + | |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. | |Indicates the unique line for a document. It will also control the display order of the lines within a document. | ||
| − | |Line<br>numeric(10)<br>Integer | + | |<small>M_InOutLineMA_v.Line<br>numeric(10)<br>Integer</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Locator | |Locator | ||
| − | + | |Warehouse Locator | |
| − | |Warehouse Locator | ||
|The Locator indicates where in a Warehouse a product is located. | |The Locator indicates where in a Warehouse a product is located. | ||
| − | |M_Locator_ID<br>numeric(10)<br>Search | + | |<small>M_InOutLineMA_v.M_Locator_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Product | |Product | ||
| − | |Product, Service, Item | + | |Product, Service, Item |
|Identifies an item which is either purchased or sold in this organization. | |Identifies an item which is either purchased or sold in this organization. | ||
| − | |M_Product_ID<br>numeric(10)<br>Search | + | |<small>M_InOutLineMA_v.M_Product_ID<br>numeric(10)<br>Search</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Movement Quantity | |Movement Quantity | ||
| − | + | |Quantity of a product moved. | |
| − | |Quantity of a product moved. | ||
|The Movement Quantity indicates the quantity of a product that has been moved. | |The Movement Quantity indicates the quantity of a product that has been moved. | ||
| − | |MovementQty<br>numeric<br>Quantity | + | |<small>M_InOutLineMA_v.MovementQty<br>numeric<br>Quantity</small> |
| − | |||
| − | |||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Tab: Movement == | ||
| + | '''Description:''' Material Movement Lines | ||
| − | + | '''Help:''' | |
| + | [[Image:Attribute_Set_Instance_-_Movement_-_Window_(iDempiere_1.0.0).png|border]] | ||
| − | {| border="1" cellpadding="5" cellspacing="0" | + | {| border="1" cellpadding="5" cellspacing="0" align="center" |
| − | + | |+'''Fields''' | |
| − | + | !style="background:#efefef;" width="100"|Name | |
| − | + | !style="background:#efefef;" width="150"|Description | |
| − | !style="background:#efefef;" | | + | !style="background:#efefef;" width="300"|Help |
| − | !style="background:#efefef;" | | + | !style="background:#efefef;" width="100"|<small>Technical Data</small> |
| − | !style="background:#efefef;" | | + | |-valign="top" |
| − | !style="background:#efefef;" | + | |Tenant |
| − | + | |Tenant for this installation. | |
| − | | | + | |A Tenant is a company or a legal entity. You cannot share data between Tenants. |
| − | + | |<small>M_MovementLineMA_v.AD_Client_ID<br>numeric(10)<br>Table Direct</small> | |
| − | + | |-valign="top" | |
| − | |-valign="top" | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |A | ||
| − | |AD_Client_ID<br>numeric(10)<br>Table Direct | ||
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Organization | |Organization | ||
| − | |Organizational entity within | + | |Organizational entity within tenant |
| − | |An organization is a unit of your | + | |An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. |
| − | |AD_Org_ID<br>numeric(10)<br>Table Direct | + | |<small>M_MovementLineMA_v.AD_Org_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Attribute Set Instance | |Attribute Set Instance | ||
| − | + | |Product Attribute Set Instance | |
| − | |Product Attribute Set Instance | ||
|The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | |The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | ||
| − | |M_AttributeSetInstance_ID<br>numeric(10)<br>Product Attribute | + | |<small>M_MovementLineMA_v.M_AttributeSetInstance_ID<br>numeric(10)<br>Product Attribute</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Inventory Move | |Inventory Move | ||
| − | |Movement of Inventory | + | |Movement of Inventory |
|The Inventory Movement uniquely identifies a group of movement lines. | |The Inventory Movement uniquely identifies a group of movement lines. | ||
| − | |M_Movement_ID<br>numeric(10)<br>Search | + | |<small>M_MovementLineMA_v.M_Movement_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Move Line | |Move Line | ||
| − | |Inventory Move document Line | + | |Inventory Move document Line |
|The Movement Line indicates the inventory movement document line (if applicable) for this transaction | |The Movement Line indicates the inventory movement document line (if applicable) for this transaction | ||
| − | |M_MovementLine_ID<br>numeric(10)<br>Search | + | |<small>M_MovementLineMA_v.M_MovementLine_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Line No | |Line No | ||
| − | |Unique line for this document | + | |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. | |Indicates the unique line for a document. It will also control the display order of the lines within a document. | ||
| − | |Line<br>numeric(10)<br>Integer | + | |<small>M_MovementLineMA_v.Line<br>numeric(10)<br>Integer</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Locator | |Locator | ||
| − | |Warehouse Locator | + | |Warehouse Locator |
|The Locator indicates where in a Warehouse a product is located. | |The Locator indicates where in a Warehouse a product is located. | ||
| − | |M_Locator_ID<br>numeric(10)<br>Table Direct | + | |<small>M_MovementLineMA_v.M_Locator_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Locator To | |Locator To | ||
| − | + | |Location inventory is moved to | |
| − | |Location inventory is moved to | ||
|The Locator To indicates the location where the inventory is being moved to. | |The Locator To indicates the location where the inventory is being moved to. | ||
| − | |M_LocatorTo_ID<br>numeric(10)<br>Table | + | |<small>M_MovementLineMA_v.M_LocatorTo_ID<br>numeric(10)<br>Table</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Product | |Product | ||
| − | |Product, Service, Item | + | |Product, Service, Item |
|Identifies an item which is either purchased or sold in this organization. | |Identifies an item which is either purchased or sold in this organization. | ||
| − | |M_Product_ID<br>numeric(10)<br>Search | + | |<small>M_MovementLineMA_v.M_Product_ID<br>numeric(10)<br>Search</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Movement Quantity | |Movement Quantity | ||
| − | + | |Quantity of a product moved. | |
| − | |Quantity of a product moved. | ||
|The Movement Quantity indicates the quantity of a product that has been moved. | |The Movement Quantity indicates the quantity of a product that has been moved. | ||
| − | |MovementQty<br>numeric<br>Quantity | + | |<small>M_MovementLineMA_v.MovementQty<br>numeric<br>Quantity</small> |
| − | |||
| − | |||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Tab: Invoice == | ||
| + | '''Description:''' AP / AR Invoice Lines | ||
| − | + | '''Help:''' | |
| + | [[Image:Attribute_Set_Instance_-_Invoice_-_Window_(iDempiere_1.0.0).png|border]] | ||
| − | {| border="1" cellpadding="5" cellspacing="0" | + | {| border="1" cellpadding="5" cellspacing="0" align="center" |
| − | + | |+'''Fields''' | |
| − | + | !style="background:#efefef;" width="100"|Name | |
| − | + | !style="background:#efefef;" width="150"|Description | |
| − | !style="background:#efefef;" | | + | !style="background:#efefef;" width="300"|Help |
| − | !style="background:#efefef;" | | + | !style="background:#efefef;" width="100"|<small>Technical Data</small> |
| − | !style="background:#efefef;" | | + | |-valign="top" |
| − | !style="background:#efefef;" | + | |Tenant |
| − | + | |Tenant for this installation. | |
| − | | | + | |A Tenant is a company or a legal entity. You cannot share data between Tenants. |
| − | + | |<small>RV_C_InvoiceLine.AD_Client_ID<br>numeric(10)<br>Table Direct</small> | |
| − | + | |-valign="top" | |
| − | |-valign="top" | ||
| − | | | ||
| − | |||
| − | | | ||
| − | |A | ||
| − | |AD_Client_ID<br>numeric(10)<br>Table Direct | ||
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Organization | |Organization | ||
| − | |Organizational entity within | + | |Organizational entity within tenant |
| − | |An organization is a unit of your | + | |An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. |
| − | |AD_Org_ID<br>numeric(10)<br>Table Direct | + | |<small>RV_C_InvoiceLine.AD_Org_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Attribute Set Instance | |Attribute Set Instance | ||
| − | + | |Product Attribute Set Instance | |
| − | |Product Attribute Set Instance | ||
|The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | |The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | ||
| − | |M_AttributeSetInstance_ID<br>numeric(10)<br>Search | + | |<small>RV_C_InvoiceLine.M_AttributeSetInstance_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Invoice | |Invoice | ||
| − | |Invoice Identifier | + | |Invoice Identifier |
|The Invoice Document. | |The Invoice Document. | ||
| − | |C_Invoice_ID<br>numeric(10)<br>Search | + | |<small>RV_C_InvoiceLine.C_Invoice_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Invoice Line | |Invoice Line | ||
| − | |Invoice Detail Line | + | |Invoice Detail Line |
|The Invoice Line uniquely identifies a single line of an Invoice. | |The Invoice Line uniquely identifies a single line of an Invoice. | ||
| − | |C_InvoiceLine_ID<br>numeric(10)<br>Search | + | |<small>RV_C_InvoiceLine.C_InvoiceLine_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Product | |Product | ||
| − | |Product, Service, Item | + | |Product, Service, Item |
|Identifies an item which is either purchased or sold in this organization. | |Identifies an item which is either purchased or sold in this organization. | ||
| − | |M_Product_ID<br>numeric(10)<br>Search | + | |<small>RV_C_InvoiceLine.M_Product_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | | | + | |Quantity Invoiced |
| − | |||
| − | |||
| − | |||
|Invoiced Quantity | |Invoiced Quantity | ||
| − | |||
|The Invoiced Quantity indicates the quantity of a product that have been invoiced. | |The Invoiced Quantity indicates the quantity of a product that have been invoiced. | ||
| − | |QtyInvoiced<br>numeric<br>Quantity | + | |<small>RV_C_InvoiceLine.QtyInvoiced<br>numeric<br>Quantity</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | + | |Business Partner | |
| − | + | |Identifies a Business Partner | |
| − | |||
| − | |||
| − | |Business Partner | ||
| − | |Identifies a Business Partner | ||
|A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | |A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | ||
| − | |C_BPartner_ID<br>numeric(10)<br>Search | + | |<small>RV_C_InvoiceLine.C_BPartner_ID<br>numeric(10)<br>Search</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Unit Price | |Unit Price | ||
| − | + | |Actual Price | |
| − | |Actual Price | ||
|The Actual or Unit Price indicates the Price for a product in source currency. | |The Actual or Unit Price indicates the Price for a product in source currency. | ||
| − | |PriceActual<br>numeric<br>Costs+Prices | + | |<small>RV_C_InvoiceLine.PriceActual<br>numeric<br>Costs+Prices</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Lot No | |Lot No | ||
| − | |Lot number (alphanumeric) | + | |Lot number (alphanumeric) |
|The Lot Number indicates the specific lot that a product was part of. | |The Lot Number indicates the specific lot that a product was part of. | ||
| − | |Lot<br>character varying(40)<br>String | + | |<small>RV_C_InvoiceLine.Lot<br>character varying(40)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Lot | |Lot | ||
| − | + | |Product Lot Definition | |
| − | |Product Lot Definition | ||
|The individual Lot of a Product | |The individual Lot of a Product | ||
| − | |M_Lot_ID<br>numeric(10)<br>Table Direct | + | |<small>RV_C_InvoiceLine.M_Lot_ID<br>numeric(10)<br>Table Direct</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Serial No | |Serial No | ||
| − | |Product Serial Number | + | |Product Serial Number |
|The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | |The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | ||
| − | |SerNo<br>character varying(40)<br>String | + | |<small>RV_C_InvoiceLine.SerNo<br>character varying(40)<br>String</small> |
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 17:52, 27 December 2024
Window: Attribute Set Instance
Description: View Attribute Set Instance detail and use
Help:
Tab: Instance
Description: Attribute Set Instance
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_AttributeSetInstance.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_AttributeSetInstance.AD_Org_ID numeric(10) Table Direct |
| 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.M_AttributeSetInstance_ID numeric(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_AttributeSetInstance.M_AttributeSet_ID numeric(10) Table Direct |
| Description | Optional short description of the record | A description is limited to 255 characters. | M_AttributeSetInstance.Description character varying(1023) String |
| Lot | Product Lot Definition | The individual Lot of a Product | M_AttributeSetInstance.M_Lot_ID numeric(10) Search |
| Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | M_AttributeSetInstance.Lot character varying(40) String |
| Guarantee Date | Date when guarantee expires | Date when the normal guarantee or availability expires | M_AttributeSetInstance.GuaranteeDate timestamp without time zone Date |
| Serial No | Product Serial Number | The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | M_AttributeSetInstance.SerNo character varying(40) String |
Tab: Shipment, Receipt
Description: Material Shipment and Receipt Lines
Help:
File:Attribute Set Instance - Shipment, Receipt - Window (iDempiere 1.0.0).png
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_InOutLineMA_v.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_InOutLineMA_v.AD_Org_ID numeric(10) Table Direct |
| 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_InOutLineMA_v.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Receipt | Material Receipt Document | The Material Shipment / Receipt | M_InOutLineMA_v.M_InOut_ID numeric(10) Search |
| Receipt Line | Line on Receipt document | M_InOutLineMA_v.M_InOutLine_ID numeric(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. | M_InOutLineMA_v.Line numeric(10) Integer |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_InOutLineMA_v.M_Locator_ID numeric(10) Search |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_InOutLineMA_v.M_Product_ID numeric(10) Search |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | M_InOutLineMA_v.MovementQty numeric Quantity |
Tab: Movement
Description: Material Movement Lines
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_MovementLineMA_v.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_MovementLineMA_v.AD_Org_ID numeric(10) Table Direct |
| 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_MovementLineMA_v.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Inventory Move | Movement of Inventory | The Inventory Movement uniquely identifies a group of movement lines. | M_MovementLineMA_v.M_Movement_ID numeric(10) Search |
| Move Line | Inventory Move document Line | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLineMA_v.M_MovementLine_ID numeric(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. | M_MovementLineMA_v.Line numeric(10) Integer |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_MovementLineMA_v.M_Locator_ID numeric(10) Table Direct |
| Locator To | Location inventory is moved to | The Locator To indicates the location where the inventory is being moved to. | M_MovementLineMA_v.M_LocatorTo_ID numeric(10) Table |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_MovementLineMA_v.M_Product_ID numeric(10) Search |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | M_MovementLineMA_v.MovementQty numeric Quantity |
Tab: Invoice
Description: AP / AR Invoice Lines
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | RV_C_InvoiceLine.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | RV_C_InvoiceLine.AD_Org_ID numeric(10) Table Direct |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | RV_C_InvoiceLine.M_AttributeSetInstance_ID numeric(10) Search |
| Invoice | Invoice Identifier | The Invoice Document. | RV_C_InvoiceLine.C_Invoice_ID numeric(10) Search |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | RV_C_InvoiceLine.C_InvoiceLine_ID numeric(10) Search |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | RV_C_InvoiceLine.M_Product_ID numeric(10) Search |
| Quantity Invoiced | Invoiced Quantity | The Invoiced Quantity indicates the quantity of a product that have been invoiced. | RV_C_InvoiceLine.QtyInvoiced numeric Quantity |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | RV_C_InvoiceLine.C_BPartner_ID numeric(10) Search |
| Unit Price | Actual Price | The Actual or Unit Price indicates the Price for a product in source currency. | RV_C_InvoiceLine.PriceActual numeric Costs+Prices |
| Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | RV_C_InvoiceLine.Lot character varying(40) String |
| Lot | Product Lot Definition | The individual Lot of a Product | RV_C_InvoiceLine.M_Lot_ID numeric(10) Table Direct |
| Serial No | Product Serial Number | The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | RV_C_InvoiceLine.SerNo character varying(40) String |
.png){kind=link}