Table 18122292 EOS DCF Receiv/Payable Arch

Table 18122292 EOS DCF Receiv/Payable Arch

Fields

ID (1)

Guid

BatchID (2)

Guid

Line No. (3)

Integer

Generate Records (50)

Boolean

Remove Records (51)

Boolean

Payment Type (100)

Code[2]

Amount (101)

Decimal

Currency Code (102)

Code[5]

Exchange Rate (103)

Decimal

Countervalue (104)

Decimal

Document Type (105)

Code[2]

Sequence Type (106)

Code[5]

Rating/Deliverability (107)

Code[2]

Due Date (108)

Date

Currency Date (109)

Date

Bank (110)

Code[8]

RBN (111)

Code[4]

Blocked (112)

Code[1]

Financial Item (113)

Code[6]

Chart Of Accounts (114)

Code[16]

Description (115)

Text[40]

ABI (116)

Code[5]

CAB (117)

Code[5]

Origin (118)

Code[2]

Company Section (119)

Code[6]

Management Change (120)

Decimal

Source Document No. (121)

Code[12]

C/G Key (122)

Code[26]

Company (123)

Text[10]

CC No. (124)

Code[12]

CIN (125)

Code[1]

Payment Chart Of Accounts (126)

Code[16]

IBAN Country (127)

Code[2]

Iban Check Digit (128)

Code[2]

Source Document Date (129)

Date

Notes (130)

Text[80]

BIC (131)

Code[11]

IBAN (132)

Code[34]

Code Type (133)

Code[1]

Reference Code (134)

Code[16]

Compliance Status (135)

Code[1]

Compliance Bank (136)

Code[8]

Compliance RBN (137)

Code[4]

Foreign Bank (138)

Text[35]

Branch Foreign Bank (139)

Text[35]

Proxy Code (140)

Code[35]

CIG (142)

Code[15]

CUP (143)

Code[15]

CIGwithPrefix (147)

Code[20]

CUPwithPrefix (148)

Code[20]

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)))

Source Table (201)

Integer

Source Entry No. (202)

Integer


EOS Labs -