Inventory Control

Comparison between versions 3.6 and 4.0

• New
  • ICCNTHD
    • Fields
      • Count ID new

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

      • Document ID new

        Name:	Document ID
        Type:	RowID
        Domain:	IC Stocktake ID
        Required:	true

      • Location Code new

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

      • Details new

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

      • Count Status new

        Name:	Count Status
        Type:	String
        Domain:	IC Count Status
        Size:	1
        Required:	true
        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

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Created User Code new

        Name:	Created 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

      • Modified User Code new

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

    • Indices
      • Count new

        Name:	Count
        Unique:	true
        Parts:	Count ID

      • Document Count new

        Name:	Document Count
        Unique:	true
        Parts:	Document ID;Count ID

  • ICCNTLN
    • Fields
      • Count ID new

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

      • DocumentID new

        Name:	DocumentID
        Type:	RowID
        Domain:	IC Stocktake ID
        Required:	true

      • Product Code new

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

      • Quantity Counted new

        Name:	Quantity Counted
        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

      • UOM Quantity Counted new

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

      • Line No new

        Name:	Line No
        Type:	Integer
        Required:	true

    • Indices
      • Count Line new

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

      • Document Product Count Line new

        Name:	Document Product Count Line
        Parts:	DocumentID;Product Code;Count ID;Line No

  • ICLNWORD
    • Fields
      • Word new

        Name:	Word
        Type:	String
        Domain:	Word Text
        Size:	30
        Required:	true

      • Location Code new

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

    • Indices
      • Word new

        Name:	Word
        Parts:	Word

      • Location new

        Name:	Location
        Parts:	Location Code

  • ICSTKHD
    • Fields
      • Document ID new

        Name:	Document ID
        Type:	AutoInc
        Domain:	IC Stocktake ID
        Required:	true

      • Document Class new

        Name:	Document Class
        Type:	String
        Domain:	IC Stocktake Class
        Size:	1
        Required:	true
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Created User Code new

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

      • Location Code new

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

      • Period ID new

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

      • Document Date new

        Name:	Document Date
        Type:	Date

      • Count Type new

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

      • Details new

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

      • Reference new

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

      • 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

      • Post Status new

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

      • Document Type new

        Name:	Document Type
        Type:	String
        Domain:	DocumentType
        Size:	1
        Required:	true
        Upper:	true

    • Indices
      • Document new

        Name:	Document
        Unique:	true
        Parts:	Document ID

      • Type Location Period Document new

        Name:	Type Location Period Document
        Parts:	Document Type;Location Code;Period ID;Document ID

      • Period Document new

        Name:	Period Document
        Parts:	Period ID;Document ID

      • Type Period Document new

        Name:	Type Period Document
        Parts:	Document Type;Period ID;Document ID

  • ICSTKLN
    • Fields
      • Line ID new

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

      • Document ID new

        Name:	Document ID
        Type:	RowID
        Domain:	IC Stocktake ID
        Required:	true

      • Location Code new

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

      • Period ID new

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

      • Product Code new

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

      • Quantity Expected Opening new

        Name:	Quantity Expected Opening
        Type:	Float
        Domain:	Quantity

      • Quantity Expected Movement new

        Name:	Quantity Expected Movement
        Type:	Float
        Domain:	Quantity

      • Quantity Counted new

        Name:	Quantity Counted
        Type:	Float
        Domain:	Quantity

      • Line Status new

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

      • Count Lines new

        Name:	Count Lines
        Type:	Smallint

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • Document Product new

        Name:	Document Product
        Unique:	true
        Parts:	Document ID;Product Code

      • Status Product Period Location new

        Name:	Status Product Period Location
        Parts:	Line Status;Product Code;Period ID;Location Code

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

      • UOM Multiplier new

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

    • Indices
      • Product UOM new

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

      • UOM Product new

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

      • Product Multiplier new

        Name:	Product Multiplier
        Parts:	Product Code;UOM Multiplier

• Modified
  • ICBAL
    • Fields
      • Transferred Value new

        Name:	Transferred Value
        Type:	Float
        Domain:	Amount

      • Transferred To GL new

        Name:	Transferred To GL
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Product Location Period new

        Name:	Product Location Period
        Unique:	true
        Parts:	Product Code;Location Code;Period ID

      • Transferred Period Product Location new

        Name:	Transferred Period Product Location
        Unique:	true
        Parts:	Transferred To GL;Period ID;Product Code;Location Code

  • ICBAR
    • Fields
      • New
        • UOM Code

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

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Bar Code

          Required

          deleted

  • ICCAT1
    • Fields
      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • ActiveCategory new

        Name:	ActiveCategory
        Unique:	true
        Parts:	Inactive;Code

  • ICCAT2
    • Fields
      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • ActiveCategory new

        Name:	ActiveCategory
        Unique:	true
        Parts:	Inactive;Code

  • ICCOST
    • Fields
      • Minimum Order Quantity new

        Name:	Minimum Order Quantity
        Type:	Float
        Domain:	Quantity

      • Supplier Standard Cost Date new

        Name:	Supplier Standard Cost Date
        Type:	Date

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • ICCTRL
    • Indices
      • User Name modified

        CaseInsensitive:

        true

  • ICDESC
    • Fields
      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • ICGROUP
    • Fields
      • Default UOM Code new

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

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • ICLINE
    • Fields
      • New
        • UOM Code

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

        • UOM Multiplier

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

        • UOM Quantity Adjusted

          Name:	UOM Quantity Adjusted
          Type:	Float
          Domain:	UOM Quantity

        • UOM Quantity Dispatched

          Name:	UOM Quantity Dispatched
          Type:	Float
          Domain:	UOM Quantity

        • UOM Quantity Receipted

          Name:	UOM Quantity Receipted
          Type:	Float
          Domain:	UOM Quantity

        • Quantity Adjusted

          Name:	Quantity Adjusted
          Type:	Float
          Domain:	Quantity

        • Quantity Dispatched

          Name:	Quantity Dispatched
          Type:	Float
          Domain:	Quantity

        • Quantity Receipted

          Name:	Quantity Receipted
          Type:	Float
          Domain:	Quantity

      • Deleted
        • Dispatch
        • Receipt
        • Adjustment
      • Modified
        • Line ID

          Domain:

          IC Transfer Line ID

        • Document ID

          Domain:

          IC Transfer ID

        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          IC Transfer Line Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          IC Transfer Line Custom 2 Text

  • ICLINK
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • LinkID

          Domain:

          IC Link ID

  • ICLOCN
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          IC Location Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          IC Location Custom 2 Text

  • ICMEMO
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Memo ID

          Domain:

          IC Memo ID

        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          CO Memo Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          CO Memo Custom 2 Text

  • ICMEMOLN
    • Fields
      • Memo ID modified

        Domain:

        IC Memo ID

  • ICPART
    • Fields
      • 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 new

        Name:	UOM Quantity
        Type:	Float
        Domain:	UOM Quantity

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • UOM Part new

        Name:	UOM Part
        Parts:	UOM Code;Part Code

  • ICPEND
    • Fields
      • New
        • UOM Code

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

        • UOM Quantity

          Name:	UOM Quantity
          Type:	Float
          Domain:	UOM Quantity

      • Modified
        • Source Document ID

          Domain:

          Source ID

        • Source Line ID

          Domain:

          Source Line ID

    • Indices
      • UOM Product new

        Name:	UOM Product
        Parts:	UOM Code;Product Code

  • ICPROD
    • Fields
      • Base UOM Code new

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

      • Sale UOM Code new

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

      • Purchase UOM Code new

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

      • Date of Last Stocktake new

        Name:	Date of Last Stocktake
        Type:	Date

      • Revaluation Period To Date new

        Name:	Revaluation Period To Date
        Type:	Float
        Domain:	Amount

      • Revaluation Year To Date new

        Name:	Revaluation Year To Date
        Type:	Float
        Domain:	Amount

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Active UOM Product new

        Name:	Active UOM Product
        Parts:	Inactive;Base UOM Code;Product Code

      • Active Diminishing Product new

        Name:	Active Diminishing Product
        Parts:	Inactive;Non Diminishing;Product Code

  • ICQTY
    • Fields
      • New
        • Transferred Value

          Name:	Transferred Value
          Type:	Float
          Domain:	Amount

        • Date of Last Stocktake

          Name:	Date of Last Stocktake
          Type:	Date

        • Revaluation Period To Date

          Name:	Revaluation Period To Date
          Type:	Float
          Domain:	Amount

        • Revaluation Year To Date

          Name:	Revaluation Year To Date
          Type:	Float
          Domain:	Amount

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Deleted
        • Transferred To General Ledger
  • ICSELL
    • Fields
      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • ICTFER
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Document ID

          Domain:

          IC Transfer ID

  • ICTRAN
    • Fields
      • New
        • Source Type

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

        • Parent ID

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

        • UOM Code

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

        • UOM Multiplier

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

        • UOM Transaction Quantity

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

        • Transferred Value

          Name:	Transferred Value
          Type:	Float
          Domain:	Amount

        • Transferred To GL

          Name:	Transferred To GL
          Type:	Boolean

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Transaction ID

          Domain:

          IC Transaction ID

        • Source ID

          Domain:

          Source ID

        • Source Line ID

          Domain:

          Source Line ID

    • Indices
      • Transferred Period Transaction new

        Name:	Transferred Period Transaction
        Unique:	true
        Parts:	Transferred To GL;Period ID;Transaction ID

      • Source new

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