Table 10810 "EFT Export" (CA)

CA country layer · Microsoft.Bank.ElectronicFundsTransfer · BC29-30 · source at ea08af5e · facts from BC29

An object of the CA localization, not part of W1.

Properties

Property	Value
Caption	EFT Export
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Journal Template Name	Code[10]	—
2	Journal Batch Name	Code[10]	—
3	Line No.	Integer	—
4	Sequence No.	Integer	—
5	Bank Account No.	Code[20]	—
6	Settle Date	Date	—
7	Posting Date Option	Option	—	OptionCaption: Change Posting Date To Match,Skip Lines Which Do Not Match
8	Bank Payment Type	Enum “Bank Payment Type”	—	enum Enum 272 “Bank Payment Type”
9	Transaction Code	Code[10]	—
10	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
11	Posting Date	Date	—
13	Account Type	Enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
14	Account No.	Code[20]	—
15	Payment Reference	Code[50]	—
16	External Document No.	Code[35]	—
21	Applies-to ID	Code[50]	—
23	Document No.	Code[20]	—
25	Description	Text[100]	—
27	Currency Code	Code[10]	—
31	Bal. Account No.	Code[20]	—
32	Bal. Account Type	Enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
33	Applies-to Doc. Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
34	Applies-to Doc. No.	Code[20]	—
35	Check Exported	Boolean	—	not editable
36	Check Printed	Boolean	—	not editable
37	Exported to Payment File	Boolean	—	not editable
38	Amount (LCY)	Decimal	—
40	Foreign Exchange Reference	Code[20]	—
41	Foreign Exchange Indicator	Option	—	OptionCaption: ,FV,VF,FF
42	Foreign Exchange Ref.Indicator	Option	—	OptionCaption: ,1,2,3
43	Country/Region Code	Code[10]	—
47	Source Code	Code[10]	—
48	Company Entry Description	Text[10]	—
49	Transaction Type Code	Option	—	OptionCaption: ANN,BUS,DEP,LOA,MIS,MOR,PEN,RLS,SAL,TAX
50	Payment Related Information 1	Text[80]	—
51	Payment Related Information 2	Text[52]	—
52	Gateway Operator OFAC Scr.Inc	Option	—	OptionCaption: ,0,1
53	Secondary OFAC Scr.Indicator	Option	—	OptionCaption: ,0,1
54	Origin. DFI ID Qualifier	Option	—	OptionCaption: ,01,02,03
55	Receiv. DFI ID Qualifier	Option	—	OptionCaption: ,01,02,03
56	Document Date	Date	—
57	Transmitted	Boolean	—

Keys

Key1: Journal Template Name, Journal Batch Name, Line No., Sequence No. (clustered)
Key2: Bank Account No.

Triggers

OnDelete

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "EFT Export"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A CA country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.