You are here: Reference Guide > Table Structures > Inventory > IN_Assembly

IN_Assembly

Purpose    

Stores the header record for each assembly form, including form status, current history number and selling price details.

Path         

Inventory Assembly

Name

Type

Linked To/Supplied

INAssemblyID

Text (20)

 

LastSavedDateTime

Date/Time

 

InventoryID

Text (20)

IN_Main.InventoryID

AssemblyNo

Text (20)

 

AssemblyInitDate

Date/Time

 

AssemblyLastDate

Date/Time

 

QtyRequired

Number (Float)

 

AssemblyType

Number (Integer)

Assembly = 0;Disassembly = 1

Status

Number (Integer)

Unactivated =0;Assembled =1;Closed =2

CurrentHistoryNo

Number (Integer)

 

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

PartNo

Text (50)

 

Description

Text (200)

 

AssemblyTotal

Number (Float)

 

UpdateSell

Yes/No

0 = No; 1 = Yes

SellPriceMode

Number (Integer)

0 = Percentage;1 = Actual;2 = None

SellPriceAmount

Number (Float)

 

NewPrice

Number (Float)

 

CalcSell

Number (Float)

 

Copyright © 2012 Jiwa Financials. All rights reserved.