Job Costing

Comparison between versions 4.0 and 5.0

• New
  • JCDELTA
    • Fields
      • Delta ID new

        Name:	Delta ID
        Type:	AutoInc
        Domain:	JC Delta ID
        Required:	true

      • 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

      • Change Type new

        Name:	Change Type
        Type:	String
        Domain:	ChangeType
        Size:	1
        Required:	true
        Upper:	true

      • Change Heat new

        Name:	Change Heat
        Type:	Byte

      • 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

    • Indices
      • Delta new

        Name:	Delta
        Unique:	true
        Parts:	Delta ID

      • File Delta new

        Name:	File Delta
        Unique:	true
        Parts:	Account File;Delta ID

      • Date Time Delta new

        Name:	Date Time Delta
        Unique:	true
        Parts:	Created Date;Created Time;Delta ID

  • JCDTFLD
    • Fields
      • Delta ID new

        Name:	Delta ID
        Type:	RowID
        Domain:	JC Delta ID
        Required:	true

      • Line No new

        Name:	Line No
        Type:	Smallint

      • Name new

        Name:	Name
        Type:	String
        Domain:	Table Field Name
        Size:	40
        Required:	true

      • Old Value new

        Name:	Old Value
        Type:	Variant
        Size:	120

      • New Value new

        Name:	New Value
        Type:	Variant
        Size:	120

    • Indices
      • Delta Line new

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

• Modified
  • JCCTRL
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Type

          Type:

          changed from

          Integer

          to

          Word

  • JCDESC
    • Fields
      • Line Space new

        Name:	Line Space
        Type:	Boolean

  • JCESTI
    • Fields
      • Line Space new

        Name:	Line Space
        Type:	Boolean

  • JCHEAD
    • Fields
      • Branch Code new

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

      • Department Code new

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

      • Location Code new

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

  • JCINFO
    • Fields
      • Line Space new

        Name:	Line Space
        Type:	Boolean

  • JCJOB
    • Fields
      • New
        • Site Latitude

          Name:	Site Latitude
          Type:	Float
          Domain:	GeoCoordinate

        • Site Longitude

          Name:	Site Longitude
          Type:	Float
          Domain:	GeoCoordinate

        • Edit Revision

          Name:	Edit Revision
          Type:	Integer
          Domain:	Record Revision

        • Print Status

          Name:	Print Status
          Type:	String
          Domain:	JCJobPrintStatus
          Size:	1
          Required:	true
          Upper:	true

      • Modified
        • Site Address 1

          Domain:

          changed from

          Address

          to

          Delivery Address 1

        • Site Address 2

          Domain:

          changed from

          Address

          to

          Delivery Address 2

        • Site Address 3

          Domain:

          changed from

          Address

          to

          Delivery Address 3

        • Site Address 4

          Domain:

          changed from

          Address

          to

          Delivery Address 4

        • Site Address 5

          Domain:

          changed from

          Address

          to

          Delivery Address 5

    • Indices
      • Branch new

        Name:	Branch
        Parts:	Branch Code

      • Department new

        Name:	Department
        Parts:	Department Code

  • JCLINE
    • Fields
      • Line Space new

        Name:	Line Space
        Type:	Boolean

  • JCMEMOLN
    • Fields
      • Line Space new

        Name:	Line Space
        Type:	Boolean

  • JCPEND
    • Indices
      • Source Document Line modified

        Parts:

        changed from

        Source Module;Source Document ID;Source Line ID

        to

        Source Module;Source Document ID;Source Line ID;Class

  • JCTRAN
    • Fields
      • New
        • Line Space

          Name:	Line Space
          Type:	Boolean

      • Modified
        • Order No

          Size:

          changed from

          12

          to

          20

    • Indices
      • Period Date Transaction new

        Name:	Period Date Transaction
        Unique:	true
        Parts:	Period ID;Transaction Date;Transaction ID

  • JCWORD
    • Fields
      • Count new

        Name:	Count
        Type:	Word

    • Indices
      • Word modified
        • New

          Unique:

          true

        • Modified

          Parts:

          changed from

          Word

          to

          Word;Job Code