Inventory Control

Comparison between versions 2.7 and 3.0

New

ICMEMO

Fields

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

Memo ID new

Name:	Memo ID
Type:	AutoInc
Required:	true

Memo Date new

Name:	Memo Date
Type:	Date
Required:	true

Memo Time new

Name:	Memo Time
Type:	Time
Required:	true

Subject new

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

Reference new

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

Memo Type new

Name:	Memo Type
Type:	String
Domain:	MemoType
Size:	1
Required:	true
Upper:	true

Action On Date new

Name:	Action On Date
Type:	Date

Action On Time new

Name:	Action On Time
Type:	Time

Target User Code new

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

Category 1 new

Name:	Category 1
Type:	String
Domain:	CO Memo Category 1 Code
Size:	8
Upper:	true

Category 2 new

Name:	Category 2
Type:	String
Domain:	CO Memo Category 2 Code
Size:	8
Upper:	true

Custom 1 new

Name:	Custom 1
Type:	String
Domain:	Short Custom Text
Size:	30

Custom 2 new

Name:	Custom 2
Type:	String
Domain:	Short Custom Text
Size:	30

Inactive new

Name:	Inactive
Type:	Boolean

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

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

Indices

File Code Type Memo new

Name:	File Code Type Memo
Unique:	true
Parts:	Account File;Account Code;Memo Type;Memo ID

Active File Code Type Memo new

Name:	Active File Code Type Memo
Unique:	true
Parts:	Inactive;Account File;Account Code;Memo Type;Memo ID

Memo new

Name:	Memo
Unique:	true
Parts:	Memo ID

Active Type ActionDateTime new

Name:	Active Type ActionDateTime
Parts:	Inactive;Memo Type;Action On Date;Action On Time

File Type Code Memo new

Name:	File Type Code Memo
Unique:	true
Parts:	Account File;Memo Type;Account Code;Memo ID

Active File Type Code Memo new

Name:	Active File Type Code Memo
Unique:	true
Parts:	Inactive;Account File;Memo Type;Account Code;Memo ID

Type File Code Memo new

Name:	Type File Code Memo
Unique:	true
Parts:	Memo Type;Account File;Account Code;Memo ID

Active Type File Code Memo new

Name:	Active Type File Code Memo
Unique:	true
Parts:	Inactive;Memo Type;Account File;Account Code;Memo ID

ICMEMOLN

Fields

Memo ID new

Name:	Memo ID
Type:	RowID
Required:	true

Line No new

Name:	Line No
Type:	Integer
Required:	true

Line Text new

Name:	Line Text
Type:	String
Domain:	Memo Line Text
Size:	78

Indices

Memo Line new

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

Modified

ICBAL

Fields

Budget new

Name:	Budget
Type:	Float
Domain:	Amount

Budget Quantity new

Name:	Budget Quantity
Type:	Float
Domain:	Quantity

ICCOST

Fields

New

Currency Code

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Supplier Cost

Name:	Supplier Cost
Type:	Float
Domain:	FX Cost Price

Additional Cost Bs

Name:	Additional Cost Bs
Type:	Float
Domain:	Cost Price

Supplier Cost Bs

Name:	Supplier Cost Bs
Type:	Float
Domain:	Cost Price

Supplier Cost Date

Name:	Supplier Cost Date
Type:	Date
Required:	true

Supplier Standard Cost

Name:	Supplier Standard Cost
Type:	Float
Domain:	FX Cost Price

Exchange Rate

Name:	Exchange Rate
Type:	Float
Domain:	Exchange Rate
Required:	true

Deleted
- Unit Cost
- Additional Cost

Modified

Lead Time Unit

Domain:

changed from

Character

TimeUnit

ICCTRL
- Fields
  - Name modified
    
    Domain: Control Name

ICGROUP

Fields

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

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

ICLINE

Fields

New

Extended Weight

Name:	Extended Weight
Type:	Float
Domain:	Weight

Extended Volume

Name:	Extended Volume
Type:	Float
Domain:	Volume

Weight

Name:	Weight
Type:	Float
Domain:	Weight

Volume

Name:	Volume
Type:	Float
Domain:	Volume

Modified

Unit Cost Price

Domain:

changed from

Price

Cost Price

Custom 1

Domain:

Short Custom Text

Custom 2

Domain:

Short Custom Text

ICLINK

Fields

New

Category 1

Name:	Category 1
Type:	String
Domain:	CO Link Category 1 Code
Size:	8
Upper:	true

Category 2

Name:	Category 2
Type:	String
Domain:	CO Link Category 2 Code
Size:	8
Upper:	true

Link Type

Name:	Link Type
Type:	String
Domain:	COLinkType
Size:	1
Upper:	true

Inactive

Name:	Inactive
Type:	Boolean

Modified

Reference

Size:

changed from

File Path

Size:

changed from

250

255

Indices

Active Code Line new

Name:	Active Code Line
Unique:	true
Parts:	Inactive;Product Code;Line No

ICLOCN

Fields

New

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Location Name

Domain:

Name

Custom 1

Domain:

Short Custom Text

Custom 2

Domain:

Short Custom Text

ICPEND

Fields

Class modified

Domain:

changed from

Character

ICPendingStockMotion

ICPROD

Fields

New

Sell Currency Code 1

Name:	Sell Currency Code 1
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 2

Name:	Sell Currency Code 2
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 3

Name:	Sell Currency Code 3
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 4

Name:	Sell Currency Code 4
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 5

Name:	Sell Currency Code 5
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 6

Name:	Sell Currency Code 6
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 7

Name:	Sell Currency Code 7
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 8

Name:	Sell Currency Code 8
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Sell Currency Code 9

Name:	Sell Currency Code 9
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	true

Quantity Committed

Name:	Quantity Committed
Type:	Float
Domain:	Quantity

Date Of Last Usage

Name:	Date Of Last Usage
Type:	Date

Quantity Shipped

Name:	Quantity Shipped
Type:	Float
Domain:	Quantity

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Details

Domain:

Description

Alternate Code

Domain:

IC Alternate Code

Gst Code

Domain:

changed from

Character

CO Gst Code

Weight

Domain:

changed from

Quantity

Weight

Volume

Domain:

changed from

Quantity

Volume

Component Mode

Domain:

changed from

Character

ICComponentMode

Standard Cost

Domain:

changed from

Price

Cost Price

Latest Cost

Domain:

changed from

Price

Cost Price

Average Cost

Domain:

changed from

Price

Cost Price

Selling Price 1

Domain:

changed from

Price

FX Sell Price

Selling Price 2

Domain:

changed from

Price

FX Sell Price

Selling Price 3

Domain:

changed from

Price

FX Sell Price

Selling Price 4

Domain:

changed from

Price

FX Sell Price

Selling Price 5

Domain:

changed from

Price

FX Sell Price

Selling Price 6

Domain:

changed from

Price

FX Sell Price

Selling Price 7

Domain:

changed from

Price

FX Sell Price

Selling Price 8

Domain:

changed from

Price

FX Sell Price

Selling Price 9

Domain:

changed from

Price

FX Sell Price

Image Path

Domain:	changed from	Short File Path	to	File Path
Size:	changed from	60	to	255

Indices

Sales Group new

Name:	Sales Group
Parts:	Sales Group Code

ICQTY

Fields

New

Quantity Shipped

Name:	Quantity Shipped
Type:	Float
Domain:	Quantity

Quantity Committed

Name:	Quantity Committed
Type:	Float
Domain:	Quantity

Date Of Last Usage

Name:	Date Of Last Usage
Type:	Date

Modified

Bin Location

Domain:

IC Bin Location

ICSELL

Fields

New

Currency Code

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Modified

Price

Domain:

changed from

Price

FX Sell Price

ICTFER

Fields

New

Total Weight

Name:	Total Weight
Type:	Float
Domain:	Weight

Total Volume

Name:	Total Volume
Type:	Float
Domain:	Volume

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Document Type

Domain:

changed from

Character

DocumentType

Document Class

Domain:

changed from

Character

ICTransferType

Post Status

Domain:

changed from

Character

ICTransferPostStatus

Receipt Status

Domain:

changed from

Character

ICTransferPostStatus

Reference

Size:

changed from

ICTRAN

Fields

New

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Transaction Type

Domain:

changed from

Character

ICTranType

Reference

Size:

changed from

Unit Cost Price

Domain:

changed from

Price

Cost Price

Unit Selling Price

Domain:

changed from

Price

Sell Price

Sell Price Basis

Domain:

changed from

Character

SellPriceBasis

Gst Code

Domain:

changed from

Character

CO Gst Code

ICWORD
- Fields
  - Word modified
    
    Domain: Word Text