Job Costing

Comparison between versions 3.0 and 3.2

• New
  • JCWIPGL
    • 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

      • Transaction ID new

        Name:	Transaction ID
        Type:	RowID
        Required:	true

      • Transferred To GL new

        Name:	Transferred To GL
        Type:	Float
        Domain:	Amount

    • Indices
      • Transaction Period new

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

      • Job Period new

        Name:	Job Period
        Parts:	Job Code;Period ID

• Modified
  • JCBAL
    • Fields
      • New
        • Opening Work In Progress Cost

          Name:	Opening Work In Progress Cost
          Type:	Float
          Domain:	Amount

        • Movement Work In Progress Cost

          Name:	Movement Work In Progress Cost
          Type:	Float
          Domain:	Amount

        • Opening Work In Progress Recovered

          Name:	Opening Work In Progress Recovered
          Type:	Float
          Domain:	Amount

        • Movement Work In Progress Recovered

          Name:	Movement Work In Progress Recovered
          Type:	Float
          Domain:	Amount

        • Opening Transferred To GL

          Name:	Opening Transferred To GL
          Type:	Float
          Domain:	Amount

        • Movement Transferred To GL

          Name:	Movement Transferred To GL
          Type:	Float
          Domain:	Amount

      • Deleted
        • Opening Work In Progress
        • Movement Work In Progress
    • Indices
      • Period Job new

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

  • JCDESC
    • Fields
      • Line Break new

        Name:	Line Break
        Type:	Boolean

  • JCESTI
    • Fields
      • Line Break new

        Name:	Line Break
        Type:	Boolean

  • JCJOB
    • Fields
      • New
        • Work In Progress Cost

          Name:	Work In Progress Cost
          Type:	Float
          Domain:	Amount

        • Work In Progress Recovered

          Name:	Work In Progress Recovered
          Type:	Float
          Domain:	Amount

        • Period Transfer To GL

          Name:	Period Transfer To GL
          Type:	Smallint
          Domain:	Period ID

        • Transferred To GL

          Name:	Transferred To GL
          Type:	Float
          Domain:	Amount

      • Modified
        • Site Post Code

          Upper:

          true

    • Indices
      • Customer Job new

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

  • JCLINE
    • Fields
      • Fully Invoiced new

        Name:	Fully Invoiced
        Type:	Boolean

      • Line Break new

        Name:	Line Break
        Type:	Boolean

  • JCMEMOLN
    • Fields
      • Line Break new

        Name:	Line Break
        Type:	Boolean

  • JCPEND
    • Fields
      • Cost Centre Code new

        Name:	Cost Centre Code
        Type:	String
        Domain:	JC Cost Centre Code
        Size:	8
        Upper:	true

      • Component Code new

        Name:	Component Code
        Type:	String
        Domain:	JC Component Code
        Size:	8
        Upper:	true

      • Product Code new

        Name:	Product Code
        Type:	String
        Domain:	IC Product Code
        Size:	28
        Upper:	true

      • Location Code new

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

      • Transaction Type new

        Name:	Transaction Type
        Type:	String
        Domain:	JCTranType
        Size:	1
        Required:	true
        Upper:	true

  • JCTRAN
    • Fields
      • Line Break new

        Name:	Line Break
        Type:	Boolean

    • Indices
      • New
        • Period Complete Transaction

          Name:	Period Complete Transaction
          Unique:	true
          Parts:	Period Complete For WIP;Transaction ID

        • Job Period Complete Transaction

          Name:	Job Period Complete Transaction
          Unique:	true
          Parts:	Job Code;Period Complete For WIP;Transaction ID

      • Modified
        • Job Line Period Transaction

          Unique:

          true