Job Costing

Comparison between versions 3.6 and 4.0

• New
  • JCINFO
    • Fields
      • Job Code new

        Name:	Job Code
        Type:	String
        Domain:	JC Job Code
        Size:	16
        Required:	true
        Upper:	true

      • Description new

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

      • Line Break new

        Name:	Line Break
        Type:	Boolean

      • Line No new

        Name:	Line No
        Type:	Integer
        Required:	true

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Job Line new

        Name:	Job Line
        Unique:	true
        Parts:	Job Code;Line No

• Modified
  • JCACTUAL
    • Fields
      • New
        • Document Class

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

      • Modified
        • Source Document ID

          Domain:

          Source ID

  • JCBAL
    • Fields
      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

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

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

  • JCCOMP
    • Fields
      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Active Analysis new

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

  • JCCOST
    • Fields
      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Active Analysis new

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

  • JCCTRL
    • Indices
      • User Name modified

        CaseInsensitive:

        true

  • JCDESC
    • Fields
      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • JCESTI
    • Fields
      • New
        • Branch Code

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

        • Department Code

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

        • Sales Group Code

          Name:	Sales Group Code
          Type:	String
          Domain:	AR Sales Group Code
          Size:	8
          Required:	true
          Upper:	true

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

          Name:	UOM Quantity Estimated
          Type:	Float
          Domain:	UOM Quantity

        • Discount Percentage

          Name:	Discount Percentage
          Type:	Float
          Domain:	Discount

        • UOM Unit Sell Price

          Name:	UOM Unit Sell Price
          Type:	Float
          Domain:	FX Sell Price

        • UOM Unit Sell Price Bs

          Name:	UOM Unit Sell Price Bs
          Type:	Float
          Domain:	Sell Price

        • UOM Unit Cost Price

          Name:	UOM Unit Cost Price
          Type:	Float
          Domain:	Cost Price

      • Modified
        • Line ID

          Domain:

          JC Estimate Line ID

        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          JC Estimate Line Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          JC Estimate Line Custom 2 Text

  • JCGROUP
    • Fields
      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

  • JCHEAD
    • Fields
      • New
        • Source Module

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

        • Source ID

          Name:	Source ID
          Type:	RowID
          Domain:	Source ID

        • UOM Code

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

        • Control Total

          Name:	Control Total
          Type:	Float
          Domain:	Amount

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Batch ID

          Domain:

          JC Batch ID

    • Indices
      • Source new

        Name:	Source
        Parts:	Source Module;Source ID

  • JCINV
    • Fields
      • Source Document ID modified

        Domain:

        Source ID

  • JCJOB
    • Fields
      • New
        • Quoted Cost

          Name:	Quoted Cost
          Type:	Float
          Domain:	Amount

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Custom 1

          Domain:

          changed from

          Custom Text

          to

          JC Job Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Custom Text

          to

          JC Job Custom 2 Text

        • Contact ID

          Domain:

          AR Contact ID

    • Indices
      • Period Transferred Job new

        Name:	Period Transferred Job
        Unique:	true
        Parts:	Period Transfer To GL;Job Code

  • JCLINE
    • 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 Transaction Quantity

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

        • Discount Percentage

          Name:	Discount Percentage
          Type:	Float
          Domain:	Discount

        • UOM Unit Sell Price

          Name:	UOM Unit Sell Price
          Type:	Float
          Domain:	FX Sell Price

        • UOM Unit Sell Price Bs

          Name:	UOM Unit Sell Price Bs
          Type:	Float
          Domain:	Sell Price

        • UOM Unit Cost Price

          Name:	UOM Unit Cost Price
          Type:	Float
          Domain:	Cost Price

      • Modified
        • Line ID

          Domain:

          JC Batch Line ID

        • Batch ID

          Domain:

          JC Batch ID

        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          JC Batch Line Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          JC Batch Line Custom 2 Text

  • JCLINK
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • LinkID

          Domain:

          JC Link ID

  • JCMEMO
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Memo ID

          Domain:

          JC 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

  • JCMEMOLN
    • Fields
      • Memo ID modified

        Domain:

        JC Memo ID

  • JCPEND
    • Fields
      • Transaction ID modified

        Domain:

        JC Transaction ID

      • Source Document ID modified

        Domain:

        Source ID

      • Source Line ID modified

        Domain:

        Source Line ID

  • JCTRAN
    • 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 Transaction Quantity

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

        • UOM Approval Invoice Quantity

          Name:	UOM Approval Invoice Quantity
          Type:	Float
          Domain:	UOM Quantity

        • UOM Approval Invoice Cost Price

          Name:	UOM Approval Invoice Cost Price
          Type:	Float
          Domain:	Cost Price

        • UOM Approval Invoice Sell Price

          Name:	UOM Approval Invoice Sell Price
          Type:	Float
          Domain:	FX Sell Price

        • UOM Approval Invoice Sell Price Bs

          Name:	UOM Approval Invoice Sell Price Bs
          Type:	Float
          Domain:	Sell Price

        • Approval Invoice Discount Percentage

          Name:	Approval Invoice Discount Percentage
          Type:	Float
          Domain:	Discount

        • Discount Percentage

          Name:	Discount Percentage
          Type:	Float
          Domain:	Discount

        • UOM Unit Sell Price

          Name:	UOM Unit Sell Price
          Type:	Float
          Domain:	FX Sell Price

        • UOM Unit Sell Price Bs

          Name:	UOM Unit Sell Price Bs
          Type:	Float
          Domain:	Sell Price

        • UOM Unit Cost Price

          Name:	UOM Unit Cost Price
          Type:	Float
          Domain:	Cost Price

        • Transferred To GL

          Name:	Transferred To GL
          Type:	Float
          Domain:	Amount

        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Deleted
        • WIP Transferred To General Ledger
      • Modified
        • Transaction ID

          Domain:

          JC Transaction ID

        • Source ID

          Domain:

          Source ID

        • Source Line ID

          Domain:

          Source Line ID

        • Batch ID

          Domain:

          JC Batch ID

        • Custom 1

          Domain:

          changed from

          Short Custom Text

          to

          JC Transaction Custom 1 Text

        • Custom 2

          Domain:

          changed from

          Short Custom Text

          to

          JC Transaction Custom 2 Text

  • JCWIPGL
    • Fields
      • Transaction ID modified

        Domain:

        JC Transaction ID