General Ledger

Comparison between versions 3.2 and 3.5

• GLACCT modified
  • Fields
    • Last History Period new

      Name:	Last History Period
      Type:	Smallint
      Domain:	Period ID

• GLLINK modified
  • Fields
    • New
      • LinkID

        Name:	LinkID
        Type:	AutoInc
        Required:	true

      • Account File

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

      • GL Account Code

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

      • 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
      • Account Code

        Domain:	changed from	GL Account Code	to	Account Code
        Size:	changed from	8	to	28

  • Indices
    • New
      • Link

        Name:	Link
        Unique:	true
        Parts:	LinkID

      • File Code Line

        Name:	File Code Line
        Parts:	Account File;Account Code;Line No

      • Active File Code Line

        Name:	Active File Code Line
        Parts:	Inactive;Account File;Account Code;Line No

      • Category 1

        Name:	Category 1
        Parts:	Category 1

      • Category 2

        Name:	Category 2
        Parts:	Category 2

    • Modified
      • Code Line
        • Deleted
          • Unique
        • Modified

          Parts:

          changed from

          Account Code;Line No

          to

          GL Account Code;Line No

      • Active Code Line
        • Deleted
          • Unique
        • Modified

          Parts:

          changed from

          Inactive;Account Code;Line No

          to

          Inactive;GL Account Code;Line No

• GLMEMO modified
  • Fields
    • GL Account Code new

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

  • Indices
    • Category 1 new

      Name:	Category 1
      Parts:	Category 1

    • Category 2 new

      Name:	Category 2
      Parts:	Category 2

    • GL Account Memo new

      Name:	GL Account Memo
      Parts:	GL Account Code;Memo ID

• GLTRAN modified
  • 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