Table 10301 "ACH US Detail" (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 | ACH US Detail |
| 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 | Data Exch. Entry No. | Integer | — | TableRelation “Data Exch.”.“Entry No.” |
| 2 | Transaction Code | Integer | — | |
| 3 | Payee Transit Routing Number | Text[30] | — | |
| 4 | Payee Bank Account Number | Text[30] | — | |
| 5 | Payment Amount | Decimal | — | |
| 6 | Payee ID/Cross Reference Numbe | Text[30] | — | |
| 7 | Payee Name | Text[100] | — | |
| 8 | Discretionary Data | Text[30] | — | |
| 9 | Addenda Record Indicator | Integer | — | |
| 10 | Trace Number | Text[50] | — | |
| 11 | Record Type | Integer | — | |
| 12 | Federal ID No. | Text[30] | — | |
| 13 | Gateway Operator OFAC Scr.Inc | Text[30] | Gateway Operator Office of Foreign Assets Control Source Indicator caption | |
| 14 | Secondary OFAC Scr.Indicator | Text[30] | Secondary Office of Foreign Assets Control Source Indicator caption | |
| 15 | Origin. DFI ID Qualifier | Text[30] | — | |
| 16 | Receiv. DFI ID Qualifier | Text[30] | — | |
| 17 | IAT Entry Trace Number | Text[50] | — | |
| 18 | Entry Detail Sequence No | Text[50] | — | |
| 19 | Company Address | Text[105] | — | |
| 20 | Company Name | Text[100] | — | |
| 21 | Company City County | Text[65] | — | |
| 22 | Cmpy CntryRegionCode PostCode | Code[35] | Company Country Region Code Post Code caption | |
| 23 | Bank CountryRegion Code | Code[10] | Bank Country Region Code caption | |
| 24 | Destination Bank | Text[100] | — | |
| 25 | Destination Transit Number | Text[30] | — | |
| 26 | Destination Federal ID No. | Text[30] | — | |
| 27 | Destination Address | Text[250] | — | |
| 28 | Destination Bank Country Code | Text[65] | — | |
| 29 | Destination CntryCode PostCode | Code[35] | Destination Country Code Post Code caption | |
| 30 | Payee Small Transit Route No | Text[30] | — | |
| 31 | Addenda Record Type | Integer | — | |
| 32 | Bank Name | Text[100] | — | |
| 33 | Destination City County Code | Code[65] | — | |
| 34 | Data Exch. Line Def Code | Code[20] | — | NotBlank |
| 35 | Filler/Reserved | Text[30] | — | |
| 36 | Bank Transit Routing Number | Text[30] | — | |
| 37 | Origin Bank Branch | Text[20] | — | |
| 38 | Destination Bank Branch | Text[20] | — | |
| 39 | Transaction Type Code | Text[4] | — | |
| 100 | Payment Reference | Code[50] | — | |
| 101 | External Document No. | Code[35] | — | |
| 102 | Document No. | Code[35] | — | |
| 103 | Applies-to Doc. No. | Code[20] | — |
Keys
- Key1: Data Exch. Entry No., Data Exch. Line Def Code (clustered)
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: "ACH US Detail"), 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.