Table 18122281 EOS DCF Batches

Table 18122281 EOS DCF Batches

Fields

BatchID (1)

Guid


Subtype (2)

Enum "EOS DCF API Subtype"


Creation DateTime (10)

DateTime


Status (11)

Enum "EOS DCF Batch Status"


Processing Date (20)

Date


Processing Time (21)

Time


Processing User (22)

Code[50]


Records No. Import (30)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF Import" where(BatchID = field(BatchID)))


Records No. Import Arch (31)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF Import Arch" where(BatchID = field(BatchID)))


Records No. MasterData (32)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF MasterData" where(BatchID = field(BatchID)))


Records No. MasterData Arch (33)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF MasterData Arch" where(BatchID = field(BatchID)))


Records No. Receiv/Payable (34)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF Receiv/Payable" where(BatchID = field(BatchID)))


Records No. Receiv/Payab Arch (35)

Integer

FieldClass: FlowField

CalcFormula: count("EOS DCF Receiv/Payable Arch" where(BatchID = field(BatchID)))


End DateTime (36)

DateTime


Duration (37)

Duration


Last Error (40)

Text[2048]

FieldClass: FlowField

CalcFormula: lookup("EOS DCF Error Log"."Error Message" where("Entry No" = field("Last Error Entry No.")))


Last Error Entry No. (41)

Integer

FieldClass: FlowField

CalcFormula: max("EOS DCF Error Log"."Entry No" where(BatchID = field(BatchID), Subtype = field(Subtype)))


Last Error Batch (42)

Text[2048]

FieldClass: FlowField

CalcFormula: lookup("EOS DCF Error Log"."Error Message" where(BatchID = field(BatchID)))


Methods

InsertNew

procedure InsertNew(pBatchID: Guid; pSubtype: Enum "EOS DCF API Subtype")

Parameters / Return Value

  • pBatchID Guid

  • pSubtype Enum "EOS DCF API Subtype"



EOS Labs -