Inventory Control

Comparison between versions 5.0 and 6.0

• New
  • ICADHEAD
    • Fields
      • Batch ID new

        Name:	Batch ID
        Type:	AutoInc
        Domain:	IC Adjustment 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:	30
        LeftPad:	true

      • Comment new

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

      • Store Person Code new

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

      • Location Code new

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

      • 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

      • Status Period Batch new

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

      • Period Batch new

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

      • Location Batch new

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

      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICADLINE
    • Fields
      • Line ID new

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

      • Batch ID new

        Name:	Batch ID
        Type:	RowID
        Domain:	IC Adjustment Batch ID
        Required:	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

      • Serial No new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Line Type new

        Name:	Line Type
        Type:	String
        Domain:	ICLineType
        Size:	1
        Required:	true
        Upper:	true

      • Line Break new

        Name:	Line Break
        Type:	Boolean

      • Line Space new

        Name:	Line Space
        Type:	Boolean

      • Branch Code new

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

      • Department Code new

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

      • GL Account Code new

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

      • Location Code new

        Name:	Location Code
        Type:	String
        Domain:	IC Location Code
        Size:	8
        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

      • Description new

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

      • Custom 1 new

        Name:	Custom 1
        Type:	String
        Domain:	IC Adjustment Line Custom 1 Text
        Size:	30

      • Custom 2 new

        Name:	Custom 2
        Type:	String
        Domain:	IC Adjustment Line Custom 2 Text
        Size:	30

      • 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

  • ICBNCTHD
    • Fields
      • Batch ID new

        Name:	Batch ID
        Type:	AutoInc
        Domain:	IC Bin Count 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

      • Location Code new

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

      • Bin Code new

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

      • Store Person Code new

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

      • Period ID new

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

      • Transaction Date new

        Name:	Transaction Date
        Type:	Date
        Required:	true

      • Details new

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

      • Reference new

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

      • Comment new

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

      • Custom 1 new

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

      • Custom 2 new

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

      • 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
        Required:	true
        Upper:	true

      • Post Status new

        Name:	Post Status
        Type:	String
        Domain:	IC Stocktake Post Status
        Size:	1
        Required:	true
        Upper:	true

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Batch new

        Name:	Batch
        Unique:	true
        Parts:	Batch ID

      • Status Period Batch new

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

      • Period Batch new

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

      • Location Bin Batch new

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

      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICBNCTLN
    • Fields
      • Line ID new

        Name:	Line ID
        Type:	AutoInc
        Domain:	IC Bin Count Line ID
        Required:	true

      • Batch ID new

        Name:	Batch ID
        Type:	RowID
        Domain:	IC Bin Count ID
        Required:	true

      • Product Code new

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

      • Serial No new

        Name:	Serial No
        Type:	String
        Domain:	IC Serial No
        Size:	28
        Upper:	true

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Lot Date new

        Name:	Lot Date
        Type:	Date

      • Expiry Date new

        Name:	Expiry Date
        Type:	Date

      • Quantity Expected new

        Name:	Quantity Expected
        Type:	Float
        Domain:	Quantity

      • 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

      • Quantity Counted new

        Name:	Quantity Counted
        Type:	Float
        Domain:	Quantity

      • UOM Quantity Counted new

        Name:	UOM Quantity Counted
        Type:	Float
        Domain:	UOM Quantity

      • Adjust new

        Name:	Adjust
        Type:	Boolean

      • Line No new

        Name:	Line No
        Type:	Integer
        Required:	true

      • Transaction ID new

        Name:	Transaction ID
        Type:	RowID
        Domain:	IC Transaction ID

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • Batch Line new

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

      • Product Batch Line new

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

      • Product Lot Serial new

        Name:	Product Lot Serial
        Parts:	Product Code;Lot No;Serial No

  • ICBNMVHD
    • Fields
      • Batch ID new

        Name:	Batch ID
        Type:	AutoInc
        Domain:	IC Bin Movement 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

      • Batch Class new

        Name:	Batch Class
        Type:	String
        Domain:	ICBinMovementClass
        Size:	1
        Required:	true
        Upper:	true

      • Location Code new

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

      • Store Person Code new

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

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Period ID new

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

      • Transaction Date new

        Name:	Transaction Date
        Type:	Date
        Required:	true

      • Reference new

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

      • Comment new

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

      • Details new

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

      • Custom 1 new

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

      • Custom 2 new

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

      • 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
        Required:	true
        Upper:	true

      • Post Status new

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

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Batch new

        Name:	Batch
        Unique:	true
        Parts:	Batch ID

      • Status Period Batch new

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

      • Period Batch new

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

      • Location Batch new

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

      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICBNMVLN
    • Fields
      • Line ID new

        Name:	Line ID
        Type:	AutoInc
        Domain:	IC Bin Movement Line ID
        Required:	true

      • Batch ID new

        Name:	Batch ID
        Type:	RowID
        Domain:	IC Bin Movement ID
        Required:	true

      • Product Code new

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

      • Serial No new

        Name:	Serial No
        Type:	String
        Domain:	IC Serial No
        Size:	28
        Upper:	true

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        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

      • UOM Quantity Moved new

        Name:	UOM Quantity Moved
        Type:	Float
        Domain:	UOM Quantity

      • Quantity Moved new

        Name:	Quantity Moved
        Type:	Float
        Domain:	Quantity

      • Line No new

        Name:	Line No
        Type:	Integer
        Required:	true

      • Transaction ID new

        Name:	Transaction ID
        Type:	RowID
        Domain:	IC Transaction ID

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • Batch Line new

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

      • Product Batch Line new

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

  • ICPARTHD
    • Fields
      • Product Code new

        Name:	Product Code
        Type:	String
        Domain:	IC Product Code
        Size:	28
        Required:	true
        Upper:	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

      • Serial No Prefix new

        Name:	Serial No Prefix
        Type:	String
        Domain:	IC Serial Affix
        Size:	4
        Upper:	true

      • Serial No Suffix new

        Name:	Serial No Suffix
        Type:	String
        Domain:	IC Serial Affix
        Size:	4
        Upper:	true

      • Automatic Subcomponent new

        Name:	Automatic Subcomponent
        Type:	Boolean

      • Expiry Unit new

        Name:	Expiry Unit
        Type:	String
        Domain:	ICExpiryUnit
        Size:	1
        Upper:	true

      • Expiry Count new

        Name:	Expiry Count
        Type:	Integer

      • 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

      • Serial No Counter new

        Name:	Serial No Counter
        Type:	Integer

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Product new

        Name:	Product
        Unique:	true
        Parts:	Product Code

  • ICPERS
    • Fields
      • Store Person Code new

        Name:	Store Person Code
        Type:	String
        Domain:	IC Store Person Code
        Size:	8
        Required:	true
        Upper:	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

      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Store Person Name new

        Name:	Store Person Name
        Type:	String
        Domain:	Short Description
        Size:	30

      • Comment new

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

      • Phone No new

        Name:	Phone No
        Type:	String
        Domain:	Contact Phone Number
        Size:	20

      • Phone No 2 new

        Name:	Phone No 2
        Type:	String
        Domain:	Contact Phone Number 2
        Size:	20

      • Phone No 3 new

        Name:	Phone No 3
        Type:	String
        Domain:	Contact Phone Number 3
        Size:	20

      • Email Address new

        Name:	Email Address
        Type:	String
        Domain:	Email Address
        Size:	120

      • Role new

        Name:	Role
        Type:	String
        Domain:	Role
        Size:	35

      • 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

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • StorePerson new

        Name:	StorePerson
        Unique:	true
        Parts:	Store Person Code

      • ActiveStorePerson new

        Name:	ActiveStorePerson
        Unique:	true
        Parts:	Inactive;Store Person Code

  • ICRTHEAD
    • Fields
      • Batch ID new

        Name:	Batch ID
        Type:	AutoInc
        Domain:	IC Receipt 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:	30
        LeftPad:	true

      • Comment new

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

      • Store Person Code new

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

      • Location Code new

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

      • 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

      • Status Period Batch new

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

      • Period Batch new

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

      • Location Batch new

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

      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICRTLINE
    • Fields
      • Line ID new

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

      • Batch ID new

        Name:	Batch ID
        Type:	RowID
        Domain:	IC Receipt Batch ID
        Required:	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

      • Serial No new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Line Type new

        Name:	Line Type
        Type:	String
        Domain:	ICLineType
        Size:	1
        Required:	true
        Upper:	true

      • Line Break new

        Name:	Line Break
        Type:	Boolean

      • Line Space new

        Name:	Line Space
        Type:	Boolean

      • Location Code new

        Name:	Location Code
        Type:	String
        Domain:	IC Location Code
        Size:	8
        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

      • Description new

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

      • Custom 1 new

        Name:	Custom 1
        Type:	String
        Domain:	IC Receipt Line Custom 1 Text
        Size:	30

      • Custom 2 new

        Name:	Custom 2
        Type:	String
        Domain:	IC Receipt Line Custom 2 Text
        Size:	30

      • 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

  • ICTRKDTL
    • Fields
      • Detail ID new

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

      • Transaction ID new

        Name:	Transaction ID
        Type:	RowID
        Domain:	IC Transaction ID

      • Pending new

        Name:	Pending
        Type:	Boolean

      • Tentative Serial No new

        Name:	Tentative Serial No
        Type:	Boolean

      • Tentative Lot No new

        Name:	Tentative Lot No
        Type:	Boolean

      • Product Code new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Serial No new

        Name:	Serial No
        Type:	String
        Domain:	IC Serial No
        Size:	28
        Upper:	true

      • Location Code new

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

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Lot Date new

        Name:	Lot Date
        Type:	Date

      • Expiry Date new

        Name:	Expiry Date
        Type:	Date

      • Fixed Lot new

        Name:	Fixed Lot
        Type:	Boolean

      • Period ID new

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

      • Source Module new

        Name:	Source Module
        Type:	String
        Domain:	Module Code
        Size:	2
        Required:	true
        Upper:	true

      • Source Type new

        Name:	Source Type
        Type:	String
        Domain:	IC Source Type
        Size:	1
        Upper:	true

      • Source ID new

        Name:	Source ID
        Type:	RowID
        Domain:	Source ID

      • Source Line ID new

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

      • Class new

        Name:	Class
        Type:	String
        Domain:	ICPendingDetailType
        Size:	1
        Upper:	true

      • Line No new

        Name:	Line No
        Type:	Smallint

      • Quantity new

        Name:	Quantity
        Type:	Float
        Domain:	Quantity

      • UOM Quantity new

        Name:	UOM Quantity
        Type:	Float
        Domain:	UOM Quantity

      • 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

      • Contra new

        Name:	Contra
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Detail new

        Name:	Detail
        Unique:	true
        Parts:	Detail ID

      • Source new

        Name:	Source
        Parts:	Source Module;Source Type;Source ID;Source Line ID;Line No

      • Transaction new

        Name:	Transaction
        Parts:	Transaction ID;Line No

      • Pending Product Period Transaction new

        Name:	Pending Product Period Transaction
        Parts:	Pending;Product Code;Period ID;Transaction ID

      • Pending Product Location Period Tran new

        Name:	Pending Product Location Period Tran
        Parts:	Pending;Product Code;Location Code;Period ID;Transaction ID

      • Pending Product Lot Serial Period Tran new

        Name:	Pending Product Lot Serial Period Tran
        Parts:	Pending;Product Code;Lot No;Serial No;Period ID;Transaction ID;Line No

  • ICTRKLOT
    • Fields
      • Lot ID new

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

      • Product Code new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Required:	true
        Upper:	true

      • Tentative new

        Name:	Tentative
        Type:	Boolean

      • Lot Date new

        Name:	Lot Date
        Type:	Date
        Required:	true

      • Expiry Date new

        Name:	Expiry Date
        Type:	Date

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Lot new

        Name:	Lot
        Unique:	true
        Parts:	Lot ID

      • Product Lot new

        Name:	Product Lot
        Unique:	true
        Parts:	Product Code;Lot No

  • ICTRKQTY
    • Fields
      • Tracking ID new

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

      • Product Code new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Location Code new

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

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Lot Date new

        Name:	Lot Date
        Type:	Date

      • Expiry Date new

        Name:	Expiry Date
        Type:	Date

      • Bin Picking Priority new

        Name:	Bin Picking Priority
        Type:	Byte

      • Stocktake Variance new

        Name:	Stocktake Variance
        Type:	Float
        Domain:	Quantity

      • Quantity In Stock new

        Name:	Quantity In Stock
        Type:	Float
        Domain:	Quantity

      • Quantity Committed new

        Name:	Quantity Committed
        Type:	Float
        Domain:	Quantity

      • Quantity Transfer In new

        Name:	Quantity Transfer In
        Type:	Float
        Domain:	Quantity

      • Quantity Transfer Out new

        Name:	Quantity Transfer Out
        Type:	Float
        Domain:	Quantity

      • Quantity Returned new

        Name:	Quantity Returned
        Type:	Float
        Domain:	Quantity

      • Quantity Shipped new

        Name:	Quantity Shipped
        Type:	Float
        Domain:	Quantity

      • Quantity Allocated new

        Name:	Quantity Allocated
        Type:	Float
        Domain:	Quantity

      • Available new

        Name:	Available
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Tracking new

        Name:	Tracking
        Unique:	true
        Parts:	Tracking ID

      • Product Location Lot Bin new

        Name:	Product Location Lot Bin
        Unique:	true
        Parts:	Product Code;Location Code;Lot No;Bin Code

      • Product Lot new

        Name:	Product Lot
        Parts:	Product Code;Lot No

      • Location Bin new

        Name:	Location Bin
        Parts:	Location Code;Bin Code

      • Product Location Available Lot new

        Name:	Product Location Available Lot
        Parts:	Product Code;Location Code;Available;Lot No

  • ICTRKSRL
    • Fields
      • Serial ID new

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

      • Product Code new

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

      • Serial No new

        Name:	Serial No
        Type:	String
        Domain:	IC Serial No
        Size:	28
        Required:	true
        Upper:	true

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Tentative new

        Name:	Tentative
        Type:	Boolean

      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Location Code new

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

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Stocktake Variance new

        Name:	Stocktake Variance
        Type:	Tinyint

      • Quantity In Stock new

        Name:	Quantity In Stock
        Type:	Tinyint

      • Quantity Committed new

        Name:	Quantity Committed
        Type:	Tinyint

      • Quantity Transfer In new

        Name:	Quantity Transfer In
        Type:	Tinyint

      • Quantity Transfer Out new

        Name:	Quantity Transfer Out
        Type:	Tinyint

      • Quantity Returned new

        Name:	Quantity Returned
        Type:	Tinyint

      • Quantity Shipped new

        Name:	Quantity Shipped
        Type:	Tinyint

      • Quantity Allocated new

        Name:	Quantity Allocated
        Type:	Tinyint

      • Available new

        Name:	Available
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Serial new

        Name:	Serial
        Unique:	true
        Parts:	Serial ID

      • Product Serial new

        Name:	Product Serial
        Unique:	true
        Parts:	Product Code;Serial No

      • Active Product Location Bin new

        Name:	Active Product Location Bin
        Parts:	Inactive;Product Code;Location Code;Bin Code

      • Available Product Location Lot Serial new

        Name:	Available Product Location Lot Serial
        Unique:	true
        Parts:	Available;Product Code;Location Code;Lot No;Serial No

      • Product Lot Serial new

        Name:	Product Lot Serial
        Unique:	true
        Parts:	Product Code;Lot No;Serial No

  • ICTRKUNS
    • Fields
      • Unspecified ID new

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

      • Product Code new

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

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Location Code new

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

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Stocktake Variance new

        Name:	Stocktake Variance
        Type:	Float
        Domain:	Quantity

      • Quantity In Stock new

        Name:	Quantity In Stock
        Type:	Float
        Domain:	Quantity

      • Quantity Committed new

        Name:	Quantity Committed
        Type:	Float
        Domain:	Quantity

      • Quantity Transfer In new

        Name:	Quantity Transfer In
        Type:	Float
        Domain:	Quantity

      • Quantity Transfer Out new

        Name:	Quantity Transfer Out
        Type:	Float
        Domain:	Quantity

      • Quantity Returned new

        Name:	Quantity Returned
        Type:	Float
        Domain:	Quantity

      • Quantity Shipped new

        Name:	Quantity Shipped
        Type:	Float
        Domain:	Quantity

      • Quantity Allocated new

        Name:	Quantity Allocated
        Type:	Float
        Domain:	Quantity

      • Available new

        Name:	Available
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Unspecified new

        Name:	Unspecified
        Unique:	true
        Parts:	Unspecified ID

      • Product Location Lot Bin new

        Name:	Product Location Lot Bin
        Unique:	true
        Parts:	Product Code;Location Code;Lot No;Bin Code

      • Product Location Available Lot new

        Name:	Product Location Available Lot
        Parts:	Product Code;Location Code;Available;Lot No

• Modified
  • ICBIN
    • Fields
      • New
        • Bin Code

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

        • Picking Priority

          Name:	Picking Priority
          Type:	Byte

        • Picking Sequence

          Name:	Picking Sequence
          Type:	Smallint

        • Date Of Last Count

          Name:	Date Of Last Count
          Type:	Date

        • Active Bin Count ID

          Name:	Active Bin Count ID
          Type:	RowID
          Domain:	IC Bin Count ID

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Deleted
        • Bin Location
      • Modified
        • Bin ID

          Domain:

          IC Bin ID

    • Indices
      • LocationBin modified

        Parts:

        changed from

        LocationCode;Bin Location

        to

        LocationCode;Bin Code

      • ActiveLocationBin modified

        Parts:

        changed from

        Inactive;LocationCode;Bin Location

        to

        Inactive;LocationCode;Bin Code

  • ICCAT1
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • ICCAT2
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • ICCNTHD
    • Fields
      • Store Person Code new

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

    • Indices
      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICCNTLN
    • Fields
      • Line ID new

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

      • Serial No new

        Name:	Serial No
        Type:	String
        Domain:	IC Serial No
        Size:	28
        Upper:	true

      • Lot No new

        Name:	Lot No
        Type:	String
        Domain:	IC Lot No
        Size:	28
        Upper:	true

      • Lot Date new

        Name:	Lot Date
        Type:	Date

      • Expiry Date new

        Name:	Expiry Date
        Type:	Date

      • Bin Code new

        Name:	Bin Code
        Type:	String
        Domain:	IC Bin Code
        Size:	16
        Upper:	true

      • Counted new

        Name:	Counted
        Type:	Boolean

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • ProductLotSerial new

        Name:	ProductLotSerial
        Parts:	Product Code;Lot No;Serial No

  • ICCOST
    • Fields
      • Cost ID new

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

    • Indices
      • Cost new

        Name:	Cost
        Unique:	true
        Parts:	Cost ID

  • ICGROUP
    • Fields
      • GL Stock Write Offs Account Code new

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

  • ICLINE
    • Fields
      • New
        • Lot No

          Name:	Lot No
          Type:	String
          Domain:	IC Lot No
          Size:	28
          Upper:	true

        • Line Type

          Name:	Line Type
          Type:	String
          Domain:	ICLineType
          Size:	1
          Upper:	true

        • Line Break

          Name:	Line Break
          Type:	Boolean

        • Line Space

          Name:	Line Space
          Type:	Boolean

        • Description

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

      • Modified
        • Product Code

          Required

          deleted

    • Indices
      • Product new

        Name:	Product
        Parts:	Product Code

  • ICLINK
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

      • Link Type modified

        Required:

        true

    • Indices
      • New
        • Code Link

          Name:	Code Link
          Parts:	Product Code;LinkID

        • Active Code Link

          Name:	Active Code Link
          Parts:	Inactive;Product Code;LinkID

      • Deleted
        • Code Line
        • Active Code Line
  • ICLOCN
    • Fields
      • New
        • Bin Tracked

          Name:	Bin Tracked
          Type:	Boolean

        • Count Type

          Name:	Count Type
          Type:	String
          Domain:	IC Count Type
          Size:	1
          Required:	true
          Upper:	true

      • Modified
        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Department Code

          Size:

          changed from

          4

          to

          8

        • Default Delivery Code

          Domain:

          changed from

          AR Delivery Code

          to

          CO Delivery Code

        • Location Name

          Size:

          changed from

          40

          to

          60

    • Indices
      • Bin Tracked Location new

        Name:	Bin Tracked Location
        Unique:	true
        Parts:	Bin Tracked;Location Code

      • Count Location new

        Name:	Count Location
        Unique:	true
        Parts:	Count Type;Location Code

  • ICMEMO
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

  • ICMFHEAD
    • Fields
      • New
        • Comment

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

        • Lot No

          Name:	Lot No
          Type:	String
          Domain:	IC Lot No
          Size:	28
          Upper:	true

        • Expiry Date

          Name:	Expiry Date
          Type:	Date

        • Bin Code

          Name:	Bin Code
          Type:	String
          Domain:	IC Bin Code
          Size:	16
          Upper:	true

        • Store Person Code

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

      • Modified
        • Reference

          Size:

          changed from

          20

          to

          30

    • Indices
      • Store Person new

        Name:	Store Person
        Parts:	Store Person Code

  • ICMFLINE
    • Fields
      • New
        • Lot No

          Name:	Lot No
          Type:	String
          Domain:	IC Lot No
          Size:	28
          Upper:	true

        • Part Type

          Name:	Part Type
          Type:	String
          Domain:	ICPartType
          Size:	1
          Required:	true
          Upper:	true

        • Line Break

          Name:	Line Break
          Type:	Boolean

        • Line Space

          Name:	Line Space
          Type:	Boolean

        • Description

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

        • Custom 1

          Name:	Custom 1
          Type:	String
          Domain:	IC Manufacture Line Custom 1 Text
          Size:	30

        • Custom 2

          Name:	Custom 2
          Type:	String
          Domain:	IC Manufacture Line Custom 2 Text
          Size:	30

      • Modified
        • Product Code

          Required

          deleted

        • UOM Multiplier

          Required

          deleted

        • Location Code

          Required

          deleted

  • ICPART
    • Fields
      • New
        • Part ID

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

        • Part Type

          Name:	Part Type
          Type:	String
          Domain:	ICPartType
          Size:	1
          Required:	true
          Upper:	true

        • Line Break

          Name:	Line Break
          Type:	Boolean

        • Line Space

          Name:	Line Space
          Type:	Boolean

        • Description

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

      • Modified
        • Part Code

          Required

          deleted

    • Indices
      • Part new

        Name:	Part
        Unique:	true
        Parts:	Part ID

  • ICPEND
    • Fields
      • Source Type new

        Name:	Source Type
        Type:	String
        Domain:	IC Source Type
        Size:	1
        Required:	true
        Upper:	true

      • UOM Multiplier new

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

    • Indices
      • New
        • Source

          Name:	Source
          Unique:	true
          Parts:	Source Module;Source Type;Source Document ID;Source Line ID;Class;Location Code;Contra

        • Location Product Period Document Line

          Name:	Location Product Period Document Line
          Parts:	Location Code;Product Code;Period ID;Source Document ID;Source Line ID

      • Deleted
        • Source Document Line Class
  • ICPROD
    • Fields
      • Image Type new

        Name:	Image Type
        Type:	String
        Domain:	ImageType
        Size:	1
        Required:	true
        Upper:	true

      • Serial Tracked new

        Name:	Serial Tracked
        Type:	String
        Domain:	ICSerialTracked
        Size:	1
        Required:	true
        Upper:	true

      • Serial No Length new

        Name:	Serial No Length
        Type:	Byte

      • Lot Tracked new

        Name:	Lot Tracked
        Type:	Boolean

      • Lot No Length new

        Name:	Lot No Length
        Type:	Byte

      • Expiry Date Tracked new

        Name:	Expiry Date Tracked
        Type:	Boolean

      • Supply Single Lot new

        Name:	Supply Single Lot
        Type:	Boolean

      • Generate Lot Nos new

        Name:	Generate Lot Nos
        Type:	String
        Domain:	ICGenerateLotNos
        Size:	1
        Required:	true
        Upper:	true

      • Minimum Expiry Unit new

        Name:	Minimum Expiry Unit
        Type:	String
        Domain:	ICExpiryUnit
        Size:	1
        Required:	true
        Upper:	true

      • Minimum Expiry Count new

        Name:	Minimum Expiry Count
        Type:	Smallint

      • Retain Years Tracking new

        Name:	Retain Years Tracking
        Type:	Smallint

  • ICQTY
    • Fields
      • New
        • Quantity ID

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

        • Bin Code

          Name:	Bin Code
          Type:	String
          Domain:	IC Bin Code
          Size:	16
          Upper:	true

      • Deleted
        • Bin Location
      • Modified
        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Department Code

          Size:

          changed from

          4

          to

          8

    • Indices
      • Quantity new

        Name:	Quantity
        Unique:	true
        Parts:	Quantity ID

  • ICSELL
    • Fields
      • Sell ID new

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

    • Indices
      • Sell new

        Name:	Sell
        Unique:	true
        Parts:	Sell ID

  • ICSTKHD
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

  • ICSTKLN
    • Fields
      • Expected TransactionID new

        Name:	Expected TransactionID
        Type:	RowID
        Domain:	IC Transaction ID
        Required:	true

  • ICTFER
    • Fields
      • New
        • Source Store Person Code

          Name:	Source Store Person Code
          Type:	String
          Domain:	IC Store Person Code
          Size:	8
          Required:	true
          Upper:	true

        • Destination Store Person Code

          Name:	Destination Store Person Code
          Type:	String
          Domain:	IC Store Person Code
          Size:	8
          Required:	true
          Upper:	true

      • Modified
        • Reference

          Size:

          changed from

          20

          to

          30

    • Indices
      • Source Store Person new

        Name:	Source Store Person
        Parts:	Source Store Person Code

      • Destination Store Person new

        Name:	Destination Store Person
        Parts:	Destination Store Person Code

  • ICTRAN
    • Fields
      • New
        • GLAccountOverridden

          Name:	GLAccountOverridden
          Type:	Boolean

      • Modified
        • Reference

          Size:

          changed from

          20

          to

          30

        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Department Code

          Size:

          changed from

          4

          to

          8

        • Order No

          Size:

          changed from

          20

          to

          30

    • Indices
      • Source modified

        Parts:

        changed from

        Source Module;Source Type;Source ID

        to

        Source Module;Source Type;Source ID;Source Line ID