TableExtension 167 Job

TableExtension 18059832 EOS TableExt18059832

Fields

EOS Calc. Recog. Sales Amount (18059830)

Decimal

FieldClass: FlowField

CalcFormula: sum(KVSPSAJobPSPLine."EOS095 Recognized Sales Amount" where("Job No." = field("No.")))

EOS Calc. Recog. Costs Amount (18059831)

Decimal

FieldClass: FlowField

CalcFormula: sum(KVSPSAJobPSPLine."EOS095 Recognized Costs Amount" where("Job No." = field("No.")))

EOS Calc. Rcg. Sls. G/L Amnt. (18059832)

Decimal

FieldClass: FlowField

CalcFormula: sum(KVSPSAJobPSPLine."EOS095 Recog. Sales G/L Amount" where("Job No." = field("No.")))

EOS Calc. Rcg. Cst. G/L Amnt. (18059833)

Decimal

FieldClass: FlowField

CalcFormula: sum(KVSPSAJobPSPLine."EOS095 Recog. Costs G/L Amount" where("Job No." = field("No.")))

EOS Total WIP Cost G/L Amount (18059834)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), "Job Complete" = const(false), Type = filter("Accrued Costs" | "Applied Costs" | "Recognized Costs"), "EOS Simulation" = const(false)))

EOS Total WIP Sales G/L Amount (18059835)

Decimal

FieldClass: FlowField

CalcFormula: sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), "Job Complete" = const(false), Type = filter("Accrued Sales" | "Applied Sales" | "Recognized Sales"), "EOS Simulation" = const(false)))

EOS Applied Costs G/L Amount (18059836)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reverse = const(false), "Job Complete" = const(false), Type = filter("Applied Costs"), "EOS Simulation" = const(false)))

EOS Applied Sales G/L Amount (18059837)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reverse = const(false), "Job Complete" = const(false), Type = filter("Applied Sales"), "EOS Simulation" = const(false)))

EOS Recog. Costs G/L Amount (18059838)

Decimal

FieldClass: FlowField

CalcFormula: sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), Type = filter("Recognized Costs"), "EOS Simulation" = const(false)))

EOS Recog. Sales G/L Amount (18059839)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), Type = filter("Recognized Sales"), "EOS Simulation" = const(false)))

EOS Rcg. Costs Sim. G/L Amount (18060450)

Decimal

FieldClass: FlowField

CalcFormula: sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), Type = filter("Recognized Costs"), "EOS Simulation" = const(true)))

EOS Rcg. Sales Sim. G/L Amount (18060451)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), Type = filter("Recognized Sales"), "EOS Simulation" = const(true)))

EOS Tot. WIP Sim. Ct. G/L Amt. (18060452)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), "Job Complete" = const(false), Type = filter("Accrued Costs" | "Applied Costs" | "Recognized Costs"), "EOS Simulation" = const(true)))

EOS WIP G/L Posting Date (18060454)

Date

FieldClass: FlowField

CalcFormula: min("Job WIP G/L Entry"."WIP Posting Date" where(Reversed = const(false), "Job No." = field("No."), "EOS Simulation" = const(false)))

EOS WIP Sim. G/L Posting Date (18060455)

Date

FieldClass: FlowField

CalcFormula: min("Job WIP G/L Entry"."WIP Posting Date" where(Reversed = const(false), "Job No." = field("No."), "EOS Simulation" = const(true)))

EOS Tot. WIP Sim. Sls. G/L Am. (18060456)

Decimal

FieldClass: FlowField

CalcFormula: sum("Job WIP G/L Entry"."WIP Entry Amount" where("Job No." = field("No."), Reversed = const(false), "Job Complete" = const(false), Type = filter("Accrued Sales" | "Applied Sales" | "Recognized Sales"), "EOS Simulation" = const(true)))

Methods

EOSCalcRecognizedProfitPercentage

procedure EOSCalcRecognizedProfitPercentage(): Decimal

Parameters / Return Value

  • Returns Decimal

EOSCalcRecognizedProfitAmount

procedure EOSCalcRecognizedProfitAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

EOSCalcRecognProfitGLPercentage

procedure EOSCalcRecognProfitGLPercentage(): Decimal

Parameters / Return Value

  • Returns Decimal

EOSCalcRecognizedProfitGLAmount

procedure EOSCalcRecognizedProfitGLAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

EOS Labs -