Table 10811 "EFT Export Workset" (US)
US country layer · Microsoft.Bank.ElectronicFundsTransfer
Across versions
- BC23-28not present
- BC29-30present
US country layer · Microsoft.Bank.ElectronicFundsTransfer · BC29-30 · source at ea08af5e · facts from BC29
An object of the US localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | EFT Export Workset |
| 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 | Option | — | OptionCaption: ,Computer Check,Manual Check,Electronic Payment,Electronic Payment-IAT |
| 9 | Transaction Code | Code[10] | — | |
| 10 | Document Type | Option | — | OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund |
| 11 | Posting Date | Date | — | |
| 13 | Account Type | Option | — | OptionCaption: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner |
| 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[50] | — | |
| 27 | Currency Code | Code[10] | — | |
| 31 | Bal. Account No. | Code[20] | — | |
| 32 | Bal. Account Type | Option | — | OptionCaption: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner |
| 33 | Applies-to Doc. Type | Option | — | OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund |
| 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 | — | |
| 58 | Include | Boolean | — | |
| 59 | Pathname | Text[250] | — | |
| 60 | UserSettleDate | Date | User Settle Date caption | |
| 61 | TraceNumber | Code[30] | Trace Number caption | |
| 62 | ProcessOrder | Integer | Process Order caption |
Keys
- Key1: Journal Template Name, Journal Batch Name, Line No., Sequence No. (clustered)
- Key2: Bank Account No.
- Key3: Account Type, Account No., Foreign Exchange Indicator, Foreign Exchange Ref.Indicator, Foreign Exchange Reference
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 Workset"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A US country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.