Job Costing

Comparison between versions 2.7 and 3.0

• New
  • JCACTUAL
    • Fields
      • Job Code new

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

      • Period ID new

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

      • Source Module new

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

      • Source Document ID new

        Name:	Source Document ID
        Type:	RowID
        Required:	true

      • Sell Currency Code new

        Name:	Sell Currency Code
        Type:	String
        Domain:	CO Currency Code
        Size:	3
        Required:	true
        Upper:	true

      • Extended Cost new

        Name:	Extended Cost
        Type:	Float
        Domain:	Amount

      • Extended Sell new

        Name:	Extended Sell
        Type:	Float
        Domain:	FX Amount

      • Extended Sell Bs new

        Name:	Extended Sell Bs
        Type:	Float
        Domain:	Amount

    • Indices
      • Source Document Job new

        Name:	Source Document Job
        Unique:	true
        Parts:	Source Module;Source Document ID;Job Code

      • Job Period Source Document new

        Name:	Job Period Source Document
        Parts:	Job Code;Period ID;Source Module;Source Document ID

      • Period Job new

        Name:	Period Job
        Parts:	Period ID;Job Code

  • JCINV
    • Fields
      • Job Code new

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

      • Period ID new

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

      • Source Document ID new

        Name:	Source Document ID
        Type:	RowID
        Required:	true

      • Document Class new

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

      • Post Status new

        Name:	Post Status
        Type:	String
        Domain:	INPostStatus
        Size:	1
        Required:	true
        Upper:	true

      • Customer Code new

        Name:	Customer Code
        Type:	String
        Domain:	AR Customer Code
        Size:	16
        Required:	true
        Upper:	true

      • Sell Currency Code new

        Name:	Sell Currency Code
        Type:	String
        Domain:	CO Currency Code
        Size:	3
        Required:	true
        Upper:	true

      • Extended Cost new

        Name:	Extended Cost
        Type:	Float
        Domain:	Amount

      • Extended Sell new

        Name:	Extended Sell
        Type:	Float
        Domain:	FX Amount

      • Extended Sell Bs new

        Name:	Extended Sell Bs
        Type:	Float
        Domain:	Amount

    • Indices
      • Document Job new

        Name:	Document Job
        Unique:	true
        Parts:	Source Document ID;Job Code

      • Job Period Document new

        Name:	Job Period Document
        Unique:	true
        Parts:	Job Code;Period ID;Source Document ID

      • Status Job Period Document new

        Name:	Status Job Period Document
        Unique:	true
        Parts:	Post Status;Job Code;Period ID;Source Document ID

      • Status Customer Period Job Document new

        Name:	Status Customer Period Job Document
        Unique:	true
        Parts:	Post Status;Customer Code;Period ID;Job Code;Source Document ID

      • Status Period Document new

        Name:	Status Period Document
        Parts:	Post Status;Period ID;Source Document ID

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

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

  • JCPEND
    • Fields
      • Job Code new

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

      • Period ID new

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

      • Source Module new

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

      • Source Document ID new

        Name:	Source Document ID
        Type:	RowID
        Required:	true

      • Source Line ID new

        Name:	Source Line ID
        Type:	RowID
        Required:	true

      • Class new

        Name:	Class
        Type:	String
        Domain:	JCPendingAmount
        Size:	1
        Required:	true
        Upper:	true

      • Transaction ID new

        Name:	Transaction ID
        Type:	RowID

      • Sell Currency Code new

        Name:	Sell Currency Code
        Type:	String
        Domain:	CO Currency Code
        Size:	3
        Required:	true
        Upper:	true

      • Extended Cost new

        Name:	Extended Cost
        Type:	Float
        Domain:	Amount

      • Extended Sell new

        Name:	Extended Sell
        Type:	Float
        Domain:	FX Amount

      • Extended Sell Bs new

        Name:	Extended Sell Bs
        Type:	Float
        Domain:	Amount

    • Indices
      • Source Document Line new

        Name:	Source Document Line
        Unique:	true
        Parts:	Source Module;Source Document ID;Source Line ID

      • Job Class Period Source Document Line new

        Name:	Job Class Period Source Document Line
        Parts:	Job Code;Class;Period ID;Source Module;Source Document ID;Source Line ID

      • Transaction new

        Name:	Transaction
        Parts:	Transaction ID

• Modified
  • JCBAL
    • Fields
      • New
        • Sell Currency Code

          Name:	Sell Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Opening Invoiced Amount Bs

          Name:	Opening Invoiced Amount Bs
          Type:	Float
          Domain:	Amount

        • Movement Invoiced Amount Bs

          Name:	Movement Invoiced Amount Bs
          Type:	Float
          Domain:	Amount

        • Budget

          Name:	Budget
          Type:	Float
          Domain:	Amount

        • Budget Cost

          Name:	Budget Cost
          Type:	Float
          Domain:	Amount

      • Modified
        • Opening Invoiced Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Movement Invoiced Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

  • JCCOMP
    • Fields
      • Analysis Code modified

        Size:

        changed from

        4

        to

        8

  • JCCOST
    • Fields
      • Analysis Code modified

        Size:

        changed from

        4

        to

        8

  • JCCTRL
    • Fields
      • Name modified

        Domain:

        Control Name

  • JCESTI
    • Fields
      • New
        • Line ID

          Name:	Line ID
          Type:	AutoInc
          Required:	true

        • Sell Currency Code

          Name:	Sell Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Rate Type

          Name:	Rate Type
          Type:	String
          Domain:	CO FX Rate Type Code
          Size:	8
          Required:	true
          Upper:	true

        • Exchange Rate

          Name:	Exchange Rate
          Type:	Float
          Domain:	Exchange Rate
          Required:	true

        • Unit Sell Price Bs

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

        • Extended Cost

          Name:	Extended Cost
          Type:	Float
          Domain:	Amount

        • Extended Sell

          Name:	Extended Sell
          Type:	Float
          Domain:	FX Amount

        • Extended Sell Bs

          Name:	Extended Sell Bs
          Type:	Float
          Domain:	Amount

      • Modified
        • Estimate Line Type

          Domain:

          changed from

          Character

          to

          JCTranType

        • Cost Centre Code

          Size:

          changed from

          4

          to

          8

        • Component Code

          Size:

          changed from

          4

          to

          8

        • Unit Cost Price

          Domain:

          changed from

          Price

          to

          Cost Price

        • Unit Sell Price

          Domain:

          changed from

          Price

          to

          FX Sell Price

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

        • Reference

          Size:

          changed from

          12

          to

          20

    • Indices
      • Line new

        Name:	Line
        Unique:	true
        Parts:	Line ID

      • Product new

        Name:	Product
        Parts:	Product Code

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

      • 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

  • JCHEAD
    • Fields
      • New
        • Total Sell Bs

          Name:	Total Sell Bs
          Type:	Float
          Domain:	Amount

        • 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
        • Total Sell
      • Modified
        • Batch Class

          Domain:

          changed from

          Character

          to

          JCBatchClass

        • Details

          Domain:

          Description

        • Component Code

          Size:

          changed from

          4

          to

          8

        • Cost Centre Code

          Size:

          changed from

          4

          to

          8

        • Period ID

          Required:

          true

        • Post Status

          Domain:

          changed from

          Character

          to

          JCPostStatus

        • Print Status

          Domain:

          changed from

          Character

          to

          JCPrintStatus

        • Reference

          Size:

          changed from

          12

          to

          20

        • Transaction Type

          Domain:

          changed from

          Character

          to

          JCTranType

  • JCJOB
    • Fields
      • New
        • Site Country Code

          Name:	Site Country Code
          Type:	String
          Domain:	CO Country Code
          Size:	2
          Upper:	true

        • Site Post Code

          Name:	Site Post Code
          Type:	String
          Domain:	Post Code
          Size:	10

        • Sell Currency Code

          Name:	Sell Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Rate Type

          Name:	Rate Type
          Type:	String
          Domain:	CO FX Rate Type Code
          Size:	8
          Required:	true
          Upper:	true

        • Date Valued

          Name:	Date Valued
          Type:	Date

        • Exchange Rate

          Name:	Exchange Rate
          Type:	Float
          Domain:	Exchange Rate
          Required:	true

        • Fixed Rate

          Name:	Fixed Rate
          Type:	Boolean

        • Estimated Sell Bs

          Name:	Estimated Sell Bs
          Type:	Float
          Domain:	Amount

        • Quoted Sell Bs

          Name:	Quoted Sell Bs
          Type:	Float
          Domain:	Amount

        • Actuals Sell Bs

          Name:	Actuals Sell Bs
          Type:	Float
          Domain:	Amount

        • Pending Actuals Cost

          Name:	Pending Actuals Cost
          Type:	Float
          Domain:	Amount

        • Pending Actuals Sell

          Name:	Pending Actuals Sell
          Type:	Float
          Domain:	FX Amount

        • Pending Actuals Sell Bs

          Name:	Pending Actuals Sell Bs
          Type:	Float
          Domain:	Amount

        • Invoiced Amount Bs

          Name:	Invoiced Amount Bs
          Type:	Float
          Domain:	Amount

        • Pending Invoiced Cost

          Name:	Pending Invoiced Cost
          Type:	Float
          Domain:	Amount

        • Pending Invoiced Sell

          Name:	Pending Invoiced Sell
          Type:	Float
          Domain:	FX Amount

        • Pending Invoiced Sell Bs

          Name:	Pending Invoiced Sell Bs
          Type:	Float
          Domain:	Amount

        • 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
        • Job Name
          • New

            Domain:

            Description

          • Modified

            Size:

            changed from

            35

            to

            60

        • Custom 1

          Domain:

          Custom Text

        • Custom 2

          Domain:

          Custom Text

        • Job Type

          Domain:

          changed from

          Character

          to

          JCJobType

        • Job Status

          Domain:

          changed from

          Character

          to

          JCJobStatus

        • Estimated Sell

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Quoted Sell

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Actuals Sell

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Invoiced Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Sales Person Code

          Required

          deleted

        • Drawing No
          • New

            Domain:

            Short Description

          • Modified

            Size:

            changed from

            24

            to

            30

    • Indices
      • Status Type Customer Job new

        Name:	Status Type Customer Job
        Unique:	true
        Parts:	Job Status;Job Type;Customer Code;Job Code

      • Related Job new

        Name:	Related Job
        Unique:	true
        Parts:	Related Job Code;Job Code

  • JCLINE
    • Fields
      • New
        • Sell Currency Code

          Name:	Sell Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Rate Type

          Name:	Rate Type
          Type:	String
          Domain:	CO FX Rate Type Code
          Size:	8
          Required:	true
          Upper:	true

        • Exchange Rate

          Name:	Exchange Rate
          Type:	Float
          Domain:	Exchange Rate
          Required:	true

        • Unit Sell Price Bs

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

        • Extended Cost

          Name:	Extended Cost
          Type:	Float
          Domain:	Amount

        • Extended Sell

          Name:	Extended Sell
          Type:	Float
          Domain:	FX Amount

        • Extended Sell Bs

          Name:	Extended Sell Bs
          Type:	Float
          Domain:	Amount

      • Modified
        • Transaction Type

          Domain:

          changed from

          Character

          to

          JCTranType

        • Reference

          Size:

          changed from

          12

          to

          20

        • Cost Centre Code

          Size:

          changed from

          4

          to

          8

        • Component Code

          Size:

          changed from

          4

          to

          8

        • Unit Cost Price

          Domain:

          changed from

          Price

          to

          Cost Price

        • Unit Sell Price

          Domain:

          changed from

          Price

          to

          FX Sell Price

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

    • Indices
      • Product new

        Name:	Product
        Parts:	Product Code

  • JCLINK
    • 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;Job Code;Line No

  • JCTRAN
    • Fields
      • New
        • Sell Currency Code

          Name:	Sell Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Rate Type

          Name:	Rate Type
          Type:	String
          Domain:	CO FX Rate Type Code
          Size:	8
          Required:	true
          Upper:	true

        • Exchange Rate

          Name:	Exchange Rate
          Type:	Float
          Domain:	Exchange Rate
          Required:	true

        • Unit Sell Price Bs

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

        • Extended Cost

          Name:	Extended Cost
          Type:	Float
          Domain:	Amount

        • Extended Sell

          Name:	Extended Sell
          Type:	Float
          Domain:	FX Amount

        • Extended Sell Bs

          Name:	Extended Sell Bs
          Type:	Float
          Domain:	Amount

        • Approval Invoice Quantity

          Name:	Approval Invoice Quantity
          Type:	Float
          Domain:	Quantity

        • Approval Invoice Cost Price

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

        • Approval Invoice Sell Price

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

        • Approval Invoice Sell Price Bs

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

        • Approval Invoice Cost

          Name:	Approval Invoice Cost
          Type:	Float
          Domain:	Amount

        • Approval Invoice Sell

          Name:	Approval Invoice Sell
          Type:	Float
          Domain:	FX Amount

        • Approval Invoice Sell Bs

          Name:	Approval Invoice Sell Bs
          Type:	Float
          Domain:	Amount

        • Invoiced Sell Bs

          Name:	Invoiced Sell Bs
          Type:	Float
          Domain:	Amount

        • Pending Invoiced Quantity

          Name:	Pending Invoiced Quantity
          Type:	Float
          Domain:	Quantity

        • Pending Invoiced Cost

          Name:	Pending Invoiced Cost
          Type:	Float
          Domain:	Amount

        • Pending Invoiced Sell

          Name:	Pending Invoiced Sell
          Type:	Float
          Domain:	FX Amount

        • Pending Invoiced Sell Bs

          Name:	Pending Invoiced Sell Bs
          Type:	Float
          Domain:	Amount

        • 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
        • Pending Invoice Quantity
        • Pending Invoice Sell Price
        • Pending Invoice Cost Price
      • Modified
        • Transaction Type

          Domain:

          changed from

          Character

          to

          JCTranType

        • Reference

          Size:

          changed from

          12

          to

          20

        • Cost Centre Code

          Size:

          changed from

          4

          to

          8

        • Component Code

          Size:

          changed from

          4

          to

          8

        • Unit Cost Price

          Domain:

          changed from

          Price

          to

          Cost Price

        • Unit Sell Price

          Domain:

          changed from

          Price

          to

          FX Sell Price

        • Invoiced Sell

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

    • Indices
      • Product new

        Name:	Product
        Parts:	Product Code

  • JCWORD
    • Fields
      • Word modified

        Domain:

        Word Text