Fourthshift ERP System Study Notes (2)

 

The following lists the material master file views:

Fs_item

Itmb (main object and Material file) and the unique data of the object and material protected on the off-screen.

Column name	Data Type	Duration	Concise description and valid values
Itemnumber	Varchar	30	Unique generation codes of components, such as work tools, raw materials, configuration, Work Center
Itemdescription	Varchar	70	Zero part number or a description in the Work Center
Itemum	Varchar	4	Number of BITs used in the production process
Itemrevision	Char	2	User-Defined Work Plan version
Makebuycode	Char	1	It means that the product is purchased or produced normally when the product is released. Valid values: B = purchase; M = manufacturing; S = supply materials to external suppliers
Itemtype	Char	1	Indicates that materials are used as materials, and materials are used as materials. Valid values: N = Prong; r = Resource source; t = work tools; X = participation
Itemstatus	Char	1	It indicates that the raw materials are not produced yet, and the raw materials are used for production and use now. It is also removed or discarded step by step. Valid values: A = currently in use; E = work plan; O = discard; P = step by step
Islottraced	Char	1	Whether batch number control is used in the production process of this item Valid value: N = no; Y = yes
Isserialized	Char	1	Indicates whether the system column number is recorded when this item is sent Valid value: N = no; Y = yes
Orderpolicy	Char	1	Where are the plans and orders for handling material supplements? Valid value: 0 = No plan; 1 = subscription point; 2 = subscription upper limit; 3 = subscription; 4 = subscription; 5 = manual Planning
Isinspectionrequired	Char	1	Whether to perform inspection before the materials are received to the existing database Valid value: N = no; Y = yes
Drawingnumber	Varchar	30	User reference section of the document of the standard item design specification
Itemclass1	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass2	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass3	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass4	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass5	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass6	Char	1	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass7	Varchar	6	In order to generate reports, the root user defined value sorts and classifies the object.
Itemclass8	Varchar	6	In order to generate reports, the root user defined value sorts and classifies the object.
Nmfc	Varchar	6	The transportation fee of the state-owned vehicle used for transportation
Fcnmsubcode	Varchar	2	The sub-code of the transportation fee for the transportation of the home machine used for transportation
Itemreference1	Char	2	In order to generate reports, the root user defined value sorts and classifies the object.
Itemreference2	Char	2	In order to generate reports, the root user defined value sorts and classifies the object.
Itemreferenpushed	Char	3	In order to generate reports, the root user defined value sorts and classifies the object.
Itemreference4	Char	3	In order to generate reports, the root user defined value sorts and classifies the object.
Itemshippingweight	Float	8	The amount of weight during the delivery of materials. It is used to calculate the package quantity.
Itemshippingvolume	Float	8	The physical level of the object in the package type. It is used to calculate the volume of the package.
Packagetype	Char	3	The user installs the predefined replacement code for the package used for shipping
Saleableindicator	Char	1	Indicates whether the item is used for the pre-test management module. Valid value: N = no; Y = yes; empty white = No
Piecesperpackage	Float	8	The number of items shown in the Table per bit in the standard item package
Grouppolicycode	Varchar	15	Combine things produced or purchased in a similar way
Familyitemnumber	Varchar	30	Production Planning or main production planning
Itemupc	Varchar	13	Full-ball product code or European product code (EAN)
Familysubgroup	Varchar	6	Small groups in the product family
HTS	Varchar	15	Coordinated customs clearance tax system international material Division
Eccn	Varchar	15	U.S. exit control code generation
Planner	Char	3	Persons responsible for planning production or material use
Buyer	Char	3	Person responsible for purchasing materials
Planningpolicy	Char	1	Class type is required for the child item generated by the root data plan Valid values: D = Sales; F = total installation; M = primary production plan; n = generic; P = Production Plan
Runleadtimedays	Float	8	Number of work days in the production cycle or in the planning period for the vendor to raise the number of work days in the previous period; Number of days allowed for use, however, the number of data increases by the next day.
Fixedleadtimedays	Smallint	2	The number of work days required by the quasi-standby and queuing teams; added to the pre-approval period of the transportation and Inspection Orders
Inspectionleadtimedays	Smallint	2	Number of daily work required for material inspection
Lotsizedays	Smallint	2	The number of work days between the specified period for calculating the total demand of materials; applicable only to the goods booking strategy 3
Lotsizequantity	Float	8	The amount pre-defined for the proposed item quantity; only applicable to the ordering strategy 1 and 4
Safetystockquantity	Float	8	To calculate the MRP, You need to subtract a fixed number from the current quantity. It is only applicable to the pricing of 3, 4 and 5.
Lotsizeminimum	Float	8	Specifies the final operator of the minimum order quantity. It is only applicable to the ordering strategy 2 and 3.
Lotsizemultiplier	Float	8	The specified order quantity must be a fixed character of a certain number of times. It is only applicable to the ordering strategy 2 and 3.
Preferredstockroom	Varchar	6	It is used as an optimal database location for business tasks with missing province values
Preferredbin	Varchar	12	Business optimization database bit
Forecastconsumptioncode	Char	1	Calculation of total demand for materials by means of combined and pre-test/actual demand and handling surplus pre-test/out demand control Valid values: 0 = pre-test code 0; 1 = pre-test code 1; 2 = pre-test code 2; 3 = pre-test code 3; 4 = pre-test code 4
Forecastperiod	Char	1	Calculates the time frame required by the total amount of materials. It is pre-tested according to the pre-test as required for the time frame, and the pre-test for the non-consumption of the maintenance and protection. Valid values: M = month; W = week
Yieldpercentage	Real	4	The pre-production of the production process, as shown in the percentage of the total production
Decimalprecision	Smallint	2	The number of small numbers of display and print objects stored in the library Valid value: 0 = zero, accurate to the integer; 1 = one; 2 = two; 3 = three; 4 = four; 5 = five digits; 6 = six digits; 7 = seven digits; 8 = eight digits; 9 = nine digits
Demandfencedays	Smallint	2	Number of daily work for incomplete orders of maintenance and customer service providers
Atpcode	Char	1	Whether the number of signatures is managed by the System Valid value: N = no; P = Yes (by batp); Y = yes (connected)
Gatewayworkcenter	Varchar	12	Start Point of Raw Material
Planningfencedays	Smallint	2	MRP cannot reach the number of days for a new plan order
Lastplanneddate	Datetime	0	The latest scheduling MRP task scheduling date
Inventoryaccount	Varchar	20	Updates the primary account number of the total sub-accounts of this item library.
Salesaccount	Varchar	20	Primary Account number used for purchase and purchase by the material and materials sales service or the customer
Costofgoodssoldaccount	Varchar	20	The primary account number used for distributing goods in the current business or customer orders
Setupcost	Float	8	The cost of the quasi-standby and purchased item; only used for the test, not a part of the cost
Itemlocalunitprice	Float	8	The average sales price of materials, which is used for calculation.
Costfamily	Varchar	15	In order to compile reports, the root product is a user-defined code for sorting and classifying the object.
Foreigncostcode	Char	6	The currency that is commonly used when purchasing this item.
Foreigncostamount	Float	8	Determine whether the material library is saved as a foreign currency price
Lastperiodreviewdate	Datetime	0	System day period for the last level section Review
Islottraceitemfifo	Char	1	Batch number displayed for query and material extraction Valid value: N = no, in ascending order of database bits, IC, and batch number; Y = yes, in descending order of database daily
Vatproductcode	Varchar	12	Value-added tax of this item
Materialcostofgoodssoldaccount	Varchar	20	Cost of goods sold and materials into this account number
Laborcostofgoodssoldaccount	Varchar	20	The person who sold the goods is billed as the current account number.
Fixedoverheadcostofgoodssoldaccount	Varchar	20	Pay-as-you-go for the goods sold
Variableoverheadcostofgoodssoldaccount	Varchar	20	The sold items can be changed to the Current Account Number.
Outsidecostofgoodssoldaccount	Varchar	20	Add a pay-as-you-go account number
Itemreference5	Varchar	30	In order to generate reports, the root user defined value sorts and classifies the object.
Productlinekey	Int	4	Provide direct link for the data in another view
Intrastatcommoditykey	Int	4	Provide direct link for the data in another view
Itemrowversion	Timestamp	8	The serial number of the fixed, fixed, modified, and recorded time.
Itemkey	Int	4	The unique primary key to be recorded