General Ledger

Comparison between versions 5.0 and 6.0

• New
  • GLACTREC
    • Fields
      • Reconciliation ID new

        Name:	Reconciliation ID
        Type:	AutoInc
        Domain:	GL Reconciliation 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

      • Account Code new

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

      • Period ID new

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

      • Details new

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

      • 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

      • Reconciliation Date new

        Name:	Reconciliation Date
        Type:	Date

      • Reconciliation Amount new

        Name:	Reconciliation Amount
        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

      • Status new

        Name:	Status
        Type:	String
        Domain:	GLReconciliationStatus
        Size:	1
        Upper:	true

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Reconciliation new

        Name:	Reconciliation
        Unique:	true
        Parts:	Reconciliation ID

      • Period Reconciliation new

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

      • Account Period Reconciliation new

        Name:	Account Period Reconciliation
        Unique:	true
        Parts:	Account Code;Period ID;Reconciliation ID

      • Status Period Reconciliation new

        Name:	Status Period Reconciliation
        Unique:	true
        Parts:	Status;Period ID;Reconciliation ID

      • Status Account Period Reconciliation new

        Name:	Status Account Period Reconciliation
        Unique:	true
        Parts:	Status;Account Code;Period ID;Reconciliation ID

• Modified
  • GLBAL
    • Fields
      • Branch Code modified

        Size:

        changed from

        4

        to

        8

      • Department Code modified

        Size:

        changed from

        4

        to

        8

  • GLBUDBAL
    • Fields
      • Branch Code modified

        Size:

        changed from

        4

        to

        8

      • Department Code modified

        Size:

        changed from

        4

        to

        8

  • GLBUDGET
    • Fields
      • Budget Name modified

        Size:

        changed from

        40

        to

        60

  • GLCAT1
    • Fields
      • Description modified

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

  • GLCAT2
    • Fields
      • Description modified

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

  • GLLINE
    • Fields
      • New
        • Line ID

          Name:	Line ID
          Type:	AutoInc
          Domain:	GL Line ID
          Required:	true

        • Source Module

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

        • Source Code

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

      • Modified
        • Narration

          Size:

          changed from

          30

          to

          60

        • Reference

          Size:

          changed from

          20

          to

          30

        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Department Code

          Size:

          changed from

          4

          to

          8

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • Source new

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

  • GLLINK
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

      • Link Type modified

        Required:

        true

    • Indices
      • New
        • Code Link

          Name:	Code Link
          Parts:	GL Account Code;LinkID

        • Active Code Link

          Name:	Active Code Link
          Parts:	Inactive;GL Account Code;LinkID

      • Deleted
        • Code Line
        • Active Code Line
  • GLMEMO
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

  • GLSUB
    • Fields
      • New
        • BranchCode

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

        • Department Code

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

      • Modified
        • Company Name

          Size:

          changed from

          40

          to

          60

  • GLTRAN
    • Fields
      • New
        • Source Code

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

        • Reconciliation ID

          Name:	Reconciliation ID
          Type:	RowID
          Domain:	GL Reconciliation ID

        • Reconciliation Line No

          Name:	Reconciliation Line No
          Type:	Integer

        • Period Reconciled

          Name:	Period Reconciled
          Type:	Smallint
          Domain:	Period ID

      • Modified
        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Department Code

          Size:

          changed from

          4

          to

          8

        • Reference

          Size:

          changed from

          20

          to

          30

        • Narration

          Size:

          changed from

          30

          to

          60

    • Indices
      • Source new

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

      • Reconciled Account Period Transaction new

        Name:	Reconciled Account Period Transaction
        Unique:	true
        Parts:	Period Reconciled;Account Code;Period ID;Transaction ID

      • Reconciliation Line new

        Name:	Reconciliation Line
        Parts:	Reconciliation ID;Reconciliation Line No