General Ledger

Comparison between versions 2.7 and 3.0

• New
  • GLBUDBAL
    • Fields
      • Budget Code new

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

      • 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

      • Budget new

        Name:	Budget
        Type:	Float
        Domain:	Amount

      • Branch Code new

        Name:	Branch Code
        Type:	String
        Domain:	CO Branch Code
        Size:	4
        Required:	true
        Upper:	true

      • Department Code new

        Name:	Department Code
        Type:	String
        Domain:	CO Department Code
        Size:	4
        Required:	true
        Upper:	true

    • Indices
      • Budget Account Period Branch Department new

        Name:	Budget Account Period Branch Department
        Unique:	true
        Parts:	Budget Code;Account Code;Period ID;Branch Code;Department Code

      • Account Period Budget new

        Name:	Account Period Budget
        Parts:	Account Code;Period ID;Budget Code

  • GLBUDGET
    • Fields
      • Budget Code new

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

      • Budget Name new

        Name:	Budget Name
        Type:	String
        Domain:	Name
        Size:	35

      • Inactive new

        Name:	Inactive
        Type:	Boolean

    • Indices
      • Budget new

        Name:	Budget
        Unique:	true
        Parts:	Budget Code

      • Active Budget new

        Name:	Active Budget
        Unique:	true
        Parts:	Inactive;Budget Code

  • GLMEMO
    • 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

  • GLMEMOLN
    • 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

  • GLWORD
    • Fields
      • Word new

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

      • Account Code new

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

    • Indices
      • Word new

        Name:	Word
        Parts:	Word

      • Account new

        Name:	Account
        Parts:	Account Code

• Modified
  • GLACCT
    • Fields
      • New
        • Analysis Code

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

        • Replicate AR

          Name:	Replicate AR
          Type:	Boolean

        • Replicate AP

          Name:	Replicate AP
          Type:	Boolean

        • Replicate CB

          Name:	Replicate CB
          Type:	Boolean

        • GST Code

          Name:	GST Code
          Type:	String
          Domain:	CO Gst Code
          Size:	1
          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

      • Deleted
        • Budget
      • Modified
        • Account Name

          Domain:

          Description

        • Friendly Account Code

          Domain:

          Friendly Account Code

        • External Account Code
          • New

            Domain:	GL External Account Code
            Upper:	true

          • Modified

            Size:

            changed from

            10

            to

            20

        • Account Type

          Domain:

          changed from

          Character

          to

          GLAccountType

        • Account Class

          Domain:

          changed from

          Character

          to

          GLAccountClass

        • Heading Style

          Domain:

          changed from

          Character

          to

          GLHeadingStyle

        • Total Style

          Domain:

          changed from

          Character

          to

          GLTotalStyle

    • Indices
      • Analysis new

        Name:	Analysis
        Parts:	Account Code

  • GLCTRL
    • Fields
      • Name modified

        Domain:

        Control Name

  • GLHEAD
    • 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
        • Batch Class

          Domain:

          changed from

          Character

          to

          GLBatchClass

        • Post Status

          Domain:

          changed from

          Character

          to

          GLPostStatus

        • Details
          • New

            Domain:

            Description

          • Modified

            Size:

            changed from

            30

            to

            60

  • GLLINE
    • Fields
      • Reference modified

        Size:

        changed from

        12

        to

        20

      • Comment modified

        Domain:

        Description

  • GLLINK
    • 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

          12

          to

          20

        • File Path

          Size:

          changed from

          250

          to

          255

    • Indices
      • Active Code Line new

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

  • GLTRAN
    • Fields
      • Reference modified

        Size:

        changed from

        12

        to

        20

      • Comment modified

        Domain:

        Description