Skip to main content

Window: Attribute Set Instance

[Created: 12/09/2005 - Updated: 12/09/2005 ]
Description: View Attribute Set Instance detail and use
Help:

Tab: Instance

[Created: 12/09/2005 - Updated: 12/09/2005 ]
Description: Attribute Set Instance
Help:
Tab Level: 0

Table 10: Instance - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 InstanceProduct Attribute Set InstanceThe 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 SetProduct Attribute SetDefine 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
DescriptionOptional short description of the recordA description is limited to 255 characters.m_attributesetinstance.Description character varying(1023)
String
LotProduct Lot DefinitionThe individual Lot of a Productm_attributesetinstance.M_Lot_ID numeric(10)
Search
Lot NoLot number (alphanumeric)The Lot Number indicates the specific lot that a product was part of.m_attributesetinstance.Lot character varying(40)
String
Guarantee DateDate when guarantee expiresDate when the normal guarantee or availability expiresm_attributesetinstance.GuaranteeDate timestamp without time zone
Date
Serial NoProduct Serial NumberThe 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

[Created: 12/09/2005 - Updated: 12/09/2005 ]
Description: Material Shipment and Receipt Lines
Help:
Tab Level: 1

Table 20: Shipment, Receipt - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 InstanceProduct Attribute Set InstanceThe 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
ReceiptMaterial Receipt DocumentThe Material Shipment / Receiptm_inoutlinema_v.M_InOut_ID numeric(10)
Search
Receipt LineLine on Receipt documentm_inoutlinema_v.M_InOutLine_ID numeric(10)
Search
Line NoUnique line for this documentIndicates 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
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_inoutlinema_v.M_Locator_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_inoutlinema_v.M_Product_ID numeric(10)
Search
Movement QuantityQuantity 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

[Created: 12/09/2005 - Updated: 12/09/2005 ]
Description: Material Movement Lines
Help:
Tab Level: 1

Table 30: Movement - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 InstanceProduct Attribute Set InstanceThe 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 MoveMovement of InventoryThe Inventory Movement uniquely identifies a group of movement lines.m_movementlinema_v.M_Movement_ID numeric(10)
Search
Move LineInventory Move document LineThe Movement Line indicates the inventory movement document line (if applicable) for this transactionm_movementlinema_v.M_MovementLine_ID numeric(10)
Search
Line NoUnique line for this documentIndicates 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
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_movementlinema_v.M_Locator_ID numeric(10)
Table Direct
Locator ToLocation inventory is moved toThe Locator To indicates the location where the inventory is being moved to.m_movementlinema_v.M_LocatorTo_ID numeric(10)
Table
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_movementlinema_v.M_Product_ID numeric(10)
Search
Movement QuantityQuantity 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

[Created: 12/09/2005 - Updated: 12/09/2005 ]
Description: AP / AR Invoice Lines
Help:
Tab Level: 1

Table 40: Invoice - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 InstanceProduct Attribute Set InstanceThe 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
InvoiceInvoice IdentifierThe Invoice Document.rv_c_invoiceline.C_Invoice_ID numeric(10)
Search
Invoice LineInvoice Detail LineThe Invoice Line uniquely identifies a single line of an Invoice.rv_c_invoiceline.C_InvoiceLine_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.rv_c_invoiceline.M_Product_ID numeric(10)
Search
Quantity InvoicedInvoiced QuantityThe Invoiced Quantity indicates the quantity of a product that have been invoiced.rv_c_invoiceline.QtyInvoiced numeric
Quantity
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonrv_c_invoiceline.C_BPartner_ID numeric(10)
Search
Unit PriceActual PriceThe Actual or Unit Price indicates the Price for a product in source currency.rv_c_invoiceline.PriceActual numeric
Costs+Prices
Lot NoLot number (alphanumeric)The Lot Number indicates the specific lot that a product was part of.rv_c_invoiceline.Lot character varying(40)
String
LotProduct Lot DefinitionThe individual Lot of a Productrv_c_invoiceline.M_Lot_ID numeric(10)
Table Direct
Serial NoProduct Serial NumberThe 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