Skip to main content

Window: Production (Single Product)

[Created: 27/07/2011 - Updated: 27/07/2011 ]
Description:
Help:

Tab: Production

[Created: 27/07/2011 - Updated: 12/02/2014 ]
Description:
Help:
Tab Level: 0

Table 10: Production - 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_production.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_production.AD_Org_ID numeric(10)
Table Direct
Document TypeDocument type or rulesThe Document Type determines document sequence and processing rulesm_production.C_DocType_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).m_production.DocumentNo character varying(30)
String
NameAlphanumeric identifier of the entityThe 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.m_production.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.m_production.Description character varying(255)
String
Date PromisedDate Order was promisedThe Date Promised indicates the date, if any, that an Order was promised for.m_production.DatePromised timestamp without time zone
Date
Movement DateDate a product was moved in or out of inventoryThe Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.m_production.MovementDate timestamp without time zone
Date
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_production.M_Product_ID numeric(10)
Search
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_production.M_Locator_ID numeric(10)
Locator (WH)
BOM & FormulaBOM & Formulam_production.PP_Product_BOM_ID numeric(10)
Table Direct
Production QuantityQuantity of products to produceThe Production Quantity identifies the number of products to producem_production.ProductionQty numeric
Amount
Create/Update Production linesProcess which will create production lines based on BOM, or recreate with an optional adjusted quantitym_production.CreateFrom character(1)
Button
Records createdm_production.IsCreated character(1)
List
Process Productionm_production.DocAction character(2)
Button
ActiveThe record is active in the systemThere 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.m_production.IsActive character(1)
Yes-No
Sales Order LineSales Order LineThe Sales Order Line is a unique identifier for a line in an order.m_production.C_OrderLine_ID numeric(10)
Table Direct
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonm_production.C_BPartner_ID numeric(10)
Search
Shipment/Receipt LineLine on Shipment or Receipt documentThe Shipment/Receipt Line indicates a unique line in a Shipment/Receipt documentm_production.M_InOutLine_ID numeric(10)
Search
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.m_production.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingm_production.C_Activity_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.m_production.C_Campaign_ID numeric(10)
Table Direct
Trx OrganizationPerforming or initiating organizationThe organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.m_production.AD_OrgTrx_ID numeric(10)
Table
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.m_production.User1_ID numeric(10)
Search
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.m_production.User2_ID numeric(10)
Search
Document StatusThe current status of the documentThe Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action fieldm_production.DocStatus character varying(2)
List
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.m_production.Processed character(1)
Yes-No
PostedPosting statusThe Posted field indicates the status of the Generation of General Ledger Accounting Linesm_production.Posted character(1)
Button

Tab: Production Line

[Created: 27/07/2011 - Updated: 16/03/2021 ]
Description:
Help:
Tab Level: 1

Table 20: Production Line - 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_productionline.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_productionline.AD_Org_ID numeric(10)
Table Direct
ProductionPlan for producing a productThe Production uniquely identifies a Production Planm_productionline.M_Production_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_productionline.Line numeric(10)
Integer
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_productionline.M_Product_ID numeric(10)
Search
End ProductEnd Product of productionm_productionline.IsEndProduct character(1)
Yes-No
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.m_productionline.M_AttributeSetInstance_ID numeric(10)
Product Attribute
ActiveThe record is active in the systemThere 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.m_productionline.IsActive character(1)
Yes-No
Planned QuantityPlanned quantity for this projectThe Planned Quantity indicates the anticipated quantity for this project or project linem_productionline.PlannedQty numeric
Amount
Quantity Usedm_productionline.QtyUsed numeric
Amount
Movement QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_productionline.MovementQty numeric
Quantity
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_productionline.M_Locator_ID numeric(10)
Locator (WH)
DescriptionOptional short description of the recordA description is limited to 255 characters.m_productionline.Description character varying(255)
String

Tab: QC Test

[Created: 27/07/2011 - Updated: 27/07/2011 ]
Description:
Help:
Tab Level: 2

Table 30: QC Test - 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_qualitytestresult.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_qualitytestresult.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_qualitytestresult.M_AttributeSetInstance_ID numeric(10)
Product Attribute
Quality Testm_qualitytestresult.M_QualityTest_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere 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.m_qualitytestresult.IsActive character(1)
Yes-No
ResultResult of the action takenThe Result indicates the result of any action taken on this request.m_qualitytestresult.Result character varying(255)
String
QC Passm_qualitytestresult.IsQCPass character(1)
Yes-No
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.m_qualitytestresult.Processed character(1)
Yes-No

Tab: Attributes

[Created: 20/04/2017 - Updated: 16/03/2021 ]
Description:
Help:
Tab Level: 2

Table 40: Attributes - 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_productionlinema.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_productionlinema.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_productionlinema.M_AttributeSetInstance_ID numeric(10)
Product Attribute
Production LineDocument Line representing a productionThe Production Line indicates the production document line (if applicable) for this transactionm_productionlinema.M_ProductionLine_ID numeric(10)
Search
Movement QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_productionlinema.MovementQty numeric
Quantity
Date Material PolicyTime used for LIFO and FIFO Material PolicyThis field is used to record time used for LIFO and FIFO material policym_productionlinema.DateMaterialPolicy timestamp without time zone
Date
ActiveThe record is active in the systemThere 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.m_productionlinema.IsActive character(1)
Yes-No