Inventory Control

Comparison between versions 4.0 and 5.0

New

ICBIN

Fields

Bin Location new

Name:	Bin Location
Type:	String
Domain:	IC Bin Location
Size:	16
Required:	true
Upper:	true

Bin ID new

Name:	Bin ID
Type:	AutoInc
Required:	true

Bin Name new

Name:	Bin Name
Type:	String
Domain:	Short Description
Size:	30

LocationCode new

Name:	LocationCode
Type:	String
Domain:	IC Location Code
Size:	8
Required:	true
Upper:	true

Custom 1 new

Name:	Custom 1
Type:	String
Domain:	IC Bin Custom 1 Text
Size:	30

Custom 2 new

Name:	Custom 2
Type:	String
Domain:	IC Bin Custom 2 Text
Size:	30

Inactive new

Name:	Inactive
Type:	Boolean

Indices

LocationBin new

Name:	LocationBin
Unique:	true
Parts:	LocationCode;Bin Location

BinID new

Name:	BinID
Unique:	true
Parts:	Bin ID

ActiveLocationBin new

Name:	ActiveLocationBin
Unique:	true
Parts:	Inactive;LocationCode;Bin Location

ICDELTA

Fields

Delta ID new

Name:	Delta ID
Type:	AutoInc
Domain:	IC Delta ID
Required:	true

Account File new

Name:	Account File
Type:	String
Domain:	Account File
Size:	8
Required:	true
Upper:	true

Account Code new

Name:	Account Code
Type:	String
Domain:	Account Code
Size:	28
Required:	true
Upper:	true

Change Type new

Name:	Change Type
Type:	String
Domain:	ChangeType
Size:	1
Required:	true
Upper:	true

Change Heat new

Name:	Change Heat
Type:	Byte

Created User Code new

Name:	Created User Code
Type:	String
Domain:	CO User Code
Size:	8
Upper:	true

Created Date new

Name:	Created Date
Type:	Date

Created Time new

Name:	Created Time
Type:	Time

Indices

Delta new

Name:	Delta
Unique:	true
Parts:	Delta ID

File Delta new

Name:	File Delta
Unique:	true
Parts:	Account File;Delta ID

Date Time Delta new

Name:	Date Time Delta
Unique:	true
Parts:	Created Date;Created Time;Delta ID

ICDTFLD

Fields

Delta ID new

Name:	Delta ID
Type:	RowID
Domain:	IC Delta ID
Required:	true

Line No new

Name:	Line No
Type:	Smallint

Name new

Name:	Name
Type:	String
Domain:	Table Field Name
Size:	40
Required:	true

Old Value new

Name:	Old Value
Type:	Variant
Size:	120

New Value new

Name:	New Value
Type:	Variant
Size:	120

Indices

Delta Line new

Name:	Delta Line
Unique:	true
Parts:	Delta ID;Line No

ICMFHEAD

Fields

Batch ID new

Name:	Batch ID
Type:	AutoInc
Domain:	IC Manufacture Batch ID
Required:	true

Created User Code new

Name:	Created User Code
Type:	String
Domain:	CO User Code
Size:	8
Upper:	true

Created Date new

Name:	Created Date
Type:	Date

Created Time new

Name:	Created Time
Type:	Time

Period ID new

Name:	Period ID
Type:	Smallint
Domain:	Period ID
Required:	true

Details new

Name:	Details
Type:	String
Domain:	Description
Size:	60

Transaction Date new

Name:	Transaction Date
Type:	Date

Reference new

Name:	Reference
Type:	String
Domain:	Reference
Size:	20
LeftPad:	true

Product Code new

Name:	Product Code
Type:	String
Domain:	IC Product Code
Size:	28
Upper:	true

UOM Code new

Name:	UOM Code
Type:	String
Domain:	CO UOM Code
Size:	8
Upper:	true

UOM Multiplier new

Name:	UOM Multiplier
Type:	Float
Domain:	Quantity Multiplier
Required:	true

Serial No new

Name:	Serial No
Type:	String
Domain:	Serial No
Size:	28

Manufacture ID new

Name:	Manufacture ID
Type:	RowID
Domain:	Source Line ID

Location Code new

Name:	Location Code
Type:	String
Domain:	IC Location Code
Size:	8
Required:	true
Upper:	true

UOM Transaction Quantity new

Name:	UOM Transaction Quantity
Type:	Float
Domain:	UOM Quantity

Transaction Quantity new

Name:	Transaction Quantity
Type:	Float
Domain:	Quantity

UOM Unit Cost price new

Name:	UOM Unit Cost price
Type:	Float
Domain:	Cost Price

Unit Cost price new

Name:	Unit Cost price
Type:	Float
Domain:	Cost Price

Cost Value Exclusive new

Name:	Cost Value Exclusive
Type:	Float
Domain:	Amount

Modified User Code new

Name:	Modified User Code
Type:	String
Domain:	CO User Code
Size:	8
Upper:	true

Modified Date new

Name:	Modified Date
Type:	Date

Modified Time new

Name:	Modified Time
Type:	Time

Print Status new

Name:	Print Status
Type:	String
Domain:	ICPrintStatus
Size:	1
Upper:	true

Post Status new

Name:	Post Status
Type:	String
Domain:	ICPostStatus
Size:	1
Upper:	true

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Batch new

Name:	Batch
Unique:	true
Parts:	Batch ID

StatusPeriodBatch new

Name:	StatusPeriodBatch
Unique:	true
Parts:	Post Status;Period ID;Batch ID

PeriodBatch new

Name:	PeriodBatch
Unique:	true
Parts:	Period ID;Batch ID

ProductBatch new

Name:	ProductBatch
Unique:	true
Parts:	Product Code;Batch ID

LocationBatch new

Name:	LocationBatch
Unique:	true
Parts:	Location Code;Batch ID

ICMFLINE

Fields

Line ID new

Name:	Line ID
Type:	AutoInc
Domain:	IC Manufacture Line ID
Required:	true

Batch ID new

Name:	Batch ID
Type:	RowID
Domain:	IC Manufacture Batch ID
Required:	true

Product Code new

Name:	Product Code
Type:	String
Domain:	IC Product Code
Size:	28
Required:	true
Upper:	true

UOM Code new

Name:	UOM Code
Type:	String
Domain:	CO UOM Code
Size:	8
Upper:	true

UOM Multiplier new

Name:	UOM Multiplier
Type:	Float
Domain:	Quantity Multiplier
Required:	true

Serial No new

Name:	Serial No
Type:	String
Domain:	Serial No
Size:	28

Location Code new

Name:	Location Code
Type:	String
Domain:	IC Location Code
Size:	8
Required:	true
Upper:	true

UOM Transaction Quantity new

Name:	UOM Transaction Quantity
Type:	Float
Domain:	UOM Quantity

Transaction Quantity new

Name:	Transaction Quantity
Type:	Float
Domain:	Quantity

UOM Unit Cost Price new

Name:	UOM Unit Cost Price
Type:	Float
Domain:	Cost Price

Unit Cost Price new

Name:	Unit Cost Price
Type:	Float
Domain:	Cost Price

Cost Value Exclusive new

Name:	Cost Value Exclusive
Type:	Float
Domain:	Amount

Line No new

Name:	Line No
Type:	Integer

Indices

Batch Line new

Name:	Batch Line
Unique:	true
Parts:	Batch ID;Line No

Product new

Name:	Product
Parts:	Product Code

Line new

Name:	Line
Unique:	true
Parts:	Line ID

ICPRODTX

Fields

Product Code new

Name:	Product Code
Type:	String
Domain:	IC Product Code
Size:	28
Required:	true
Upper:	true

Regime Code new

Name:	Regime Code
Type:	String
Domain:	CO Tax Regime Code
Size:	2
Required:	true
Upper:	true

Gst Code new

Name:	Gst Code
Type:	String
Domain:	CO Gst Code
Size:	4
Required:	true
Upper:	true

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Regime Product new

Name:	Regime Product
Unique:	true
Parts:	Regime Code;Product Code

Product Regime new

Name:	Product Regime
Unique:	true
Parts:	Product Code;Regime Code

Modified

ICBAL

Fields

New

Inwards Quantity

Name:	Inwards Quantity
Type:	Float
Domain:	Quantity

Inwards Value

Name:	Inwards Value
Type:	Float
Domain:	Amount

Outwards Quantity

Name:	Outwards Quantity
Type:	Float
Domain:	Quantity

Outwards Value

Name:	Outwards Value
Type:	Float
Domain:	Amount

Deleted
- Movement Quantity
- Movement Value

ICCOST

Fields

Supplier Standard Discount new

Name:	Supplier Standard Discount
Type:	Float
Domain:	Discount

Supplier Discount new

Name:	Supplier Discount
Type:	Float
Domain:	Discount

ICCTRL

Fields

New

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Type

Type:

changed from

Integer

Word

ICDESC

Fields

Line Space new

Name:	Line Space
Type:	Boolean

ICGROUP

Fields

GL Cost Of Sales Account Code new

Name:	GL Cost Of Sales Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Stock Purchases Account Code new

Name:	GL Stock Purchases Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Stock Adjustments Account Code new

Name:	GL Stock Adjustments Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Stock Revaluation Account Code new

Name:	GL Stock Revaluation Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Expense Recovery Account Code new

Name:	GL Expense Recovery Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

ICLINE

Fields

GL Account Code new

Name:	GL Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

ICLNWORD

Fields

Count new

Name:	Count
Type:	Word

Indices

Word modified

New

Unique:

true

Modified

Parts:

changed from

Word

Word;Location Code

ICMEMOLN

Fields

Line Space new

Name:	Line Space
Type:	Boolean

ICPROD

Fields

New

Has Regime Overrides

Name:	Has Regime Overrides
Type:	Boolean

Expense Code

Name:	Expense Code
Type:	String
Domain:	AP Expense Code
Size:	8
Upper:	true

Edit Revision

Name:	Edit Revision
Type:	Integer
Domain:	Record Revision

Quantity Returned

Name:	Quantity Returned
Type:	Float
Domain:	Quantity

Quantity Transfer In

Name:	Quantity Transfer In
Type:	Float
Domain:	Quantity

Quantity Transfer Out

Name:	Quantity Transfer Out
Type:	Float
Domain:	Quantity

Quantity In Production

Name:	Quantity In Production
Type:	Float
Domain:	Quantity

Modified

Gst Code

Size:

changed from

Duty

Domain:

changed from

Percent 1

Duty Rate

ICQTY

Fields

New

Non Diminishing

Name:	Non Diminishing
Type:	Boolean

Edit Revision

Name:	Edit Revision
Type:	Integer
Domain:	Record Revision

Quantity Returned

Name:	Quantity Returned
Type:	Float
Domain:	Quantity

Quantity Transfer In

Name:	Quantity Transfer In
Type:	Float
Domain:	Quantity

Quantity Transfer Out

Name:	Quantity Transfer Out
Type:	Float
Domain:	Quantity

Quantity In Production

Name:	Quantity In Production
Type:	Float
Domain:	Quantity

Deleted
- Quantity In Transit

Modified

Bin Location

Upper:

true

ICTRAN

Fields

New

GL Account Code

Name:	GL Account Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

Modified

Gst Code

Size:

changed from

Indices

Period Date Transaction new

Name:	Period Date Transaction
Unique:	true
Parts:	Period ID;Transaction Date;Transaction ID

ICUOM

Fields

Comment new

Name:	Comment
Type:	String
Domain:	Comment
Size:	30

ICWORD

Fields

Count new

Name:	Count
Type:	Word

Indices

Word modified

New

Unique:

true

Modified

Parts:

changed from

Word

Word;Product Code