Table 3010541 "DTA Setup" (CH)

CH country layer · Microsoft.Bank.Payment · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	DTA Setup
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	Bank Code	Code[20]	—	NotBlank
2	DTA/EZAG	Option	—	OptionCaption: DTA,EZAG
8	DTA Main Bank	Boolean	—
10	DTA File Folder	Text[250]	—
11	DTA Filename	Text[20]	—
20	DTA Customer ID	Code[10]	—
21	DTA Sender ID	Code[10]	—
22	DTA Sender Clearing	Code[5]	—	TableRelation Bank Directory
23	DTA Debit Acc. No.	Code[24]	—
24	DTA Sender Name	Text[24]	—
25	DTA Sender Name 2	Text[24]	—
26	DTA Sender Address	Text[24]	—
27	DTA Sender City	Text[20]	—
28	DTA Sender Post Code	Code[4]	—
29	DTA Sender IBAN	Code[50]	—
30	EZAG File Folder	Text[250]	—
31	EZAG Filename	Text[20]	—
32	EZAG Debit Account No.	Code[11]	—
33	EZAG Charges Account No.	Code[11]	—
34	Last EZAG Order No.	Code[2]	—	not editable; NotBlank
35	EZAG Media ID	Code[10]	—
38	Bal. Account Type	Option	—	OptionCaption: G/L Account,,,Bank Account
40	Bal. Account No.	Code[20]	—	TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”
41	Credit Limit	Decimal	—
42	DTA Currency Code	Code[10]	—	TableRelation Currency
90	File Format	Option	—	OptionCaption: With CR/LF,Without CR/LF
300	Computer Bureau Name	Text[30]	—
302	Computer Bureau Name 2	Text[30]	—
304	Computer Bureau Address	Text[30]	—
306	Computer Bureau Post Code	Code[20]	—	TableRelation Post Code
308	Computer Bureau City	Text[30]	—
310	Computer Bureau E-Mail	Text[80]	—
312	Computer Bureau Home Page	Text[80]	—
400	DTA Bank Name	Text[30]	—
402	DTA Bank Name 2	Text[30]	—
404	DTA Bank Address	Text[30]	—
405	DTA Bank Address 2	Text[30]	—
406	DTA Bank Post Code	Code[20]	—	TableRelation Post Code
408	DTA Bank City	Text[30]	—
410	DTA Bank E-Mail	Text[80]	—
412	DTA Bank Home Page	Text[80]	—
610	Yellownet E-Mail	Text[80]	—
612	Yellownet Home Page	Text[80]	—
800	Backup Copy	Boolean	—
802	Backup Folder	Text[250]	—
804	Last Backup No.	Code[4]	—
900	EZAG Post Logo	BLOB	—
901	EZAG Bar Code	BLOB	—

Keys

Key1: Bank Code (clustered)

Triggers

OnInsert

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: "DTA Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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