Table 18122291 EOS DCF MasterData Arch

Table 18122291 EOS DCF MasterData Arch

Fields

ID (1)

Guid


BatchID (2)

Guid


Line No. (3)

Integer


Generate Records (50)

Boolean


Remove Records (51)

Boolean


Company (100)

Text[10]


PDC Code (101)

Code[16]


Flag C/F/. (102)

Code[1]


Description (103)

Text[80]


Nickname (104)

Code[6]


Address (105)

Text[40]


Post Code (106)

Code[9]


City (107)

Text[40]


County (108)

Code[2]


Country (109)

Code[4]


DCF Bank Code (110)

Code[8]


RBN (111)

Code[4]


Rating (112)

Code[2]


Delay Days (113)

Integer


Commercial Line Code (114)

Code[4]


CC No. (115)

Code[12]


ABI (116)

Code[5]


CAB (117)

Code[5]


Fiscal Code (118)

Code[16]


VAT No. (119)

Code[28]


E-mail (120)

Text[80]


CIN (121)

Code[1]


IBAN Country (122)

Code[2]


Iban Check Digit (123)

Code[2]


BIC (124)

Code[11]


IBAN (125)

Code[34]


Financial Item (126)

Code[6]


Foreign Bank (127)

Text[35]


Branch Foreign Bank (128)

Text[35]


Currency Foreign Bank Details (129)

Code[5]


Routing Code Type Accr. Bank (130)

Code[2]


Routing Code Accredit Bank (131)

Code[11]


BIC Intermediary Bank (132)

Code[11]


Routing Code Type Inter. Bank (133)

Code[2]


Routing Code Inter. Bank (134)

Code[11]


Intermediary Bank (135)

Text[35]


Branch Intermediary Bank (136)

Text[35]


Last Error (200)

Text[2048]

FieldClass: FlowField

CalcFormula: lookup("EOS DCF Error Log"."Error Message" where(BatchID = field(BatchID), Subtype = const(0), "Previous Execution" = const(false), "Record ID" = field(ID)))



EOS Labs -