Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Electronic Funds Transfer Screens
app:eft_screens

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
app:eft_screens [2019/07/29 00:43]
dtucker [EFT Format Maintenance Screen] 		app:eft_screens [2019/07/29 02:02] (current)
Line 159: Line 159:
 ===== EFT File Maintenance Screen ===== ===== EFT File Maintenance Screen =====
  
 +TWBS Electronic Funds Transfer creates a screen through the SAP® Business One User Interface (UI) that provides the ability to modify the details of the record type lines for an EFT file format for EFT processing in SAP® Business One.
  
  
-TWBS Electronic Funds Transfer creates a screen [[#page828|through the SAP® Business One]] User Interface (UI) that provides the ability to modify [[#page828|the details of the record type]] lines for an EFT file format for EFT processing in [[#page828|SAP® Business One.]] 
  
- +  * Click the <color #22b14c>**Copy Format**</color> button or select the <color #00a2e8>**Define New**</color> option from the <color #00a2e8>**EFT Format**</color> field on the **EFT Bank Setup Wizard** step 2 screen to load the **TWBS EFT Format Maintenance** screen.
- +
-Click the **Copy Format** button or select the [[#page828|**Define New** option from the **EFT**]] **Format** field on the [[#page821|EFT Bank Setup Wizard]] [[#page828|step 2 screen to load]] +
- +
- +
- +
-the TWBS EFT Format Maintenance screen.+
  
 {{:app/image842.jpeg?772x422}} {{:app/image842.jpeg?772x422}}
  
-{{:app/image22.jpeg}} **Format Name –** The unique name of the new [[#page828|EFT format.]]+  * <color #00a2e8>**Format Name**</color> - The unique name of the new EFT format.
  
-{{:app/image80.jpeg?771}}+  * <color #00a2e8>**Record Type**</color> **column** - The type of data record for the [[#page828|EFT format field.]]
  
-**Record Type –** The type of data record for the [[#page828|EFT format field.]]+<WRAP center round info 90%> 
 +The <color #00a2e8>Record Type</color> column values available for selection will be dependent on the information entered for the EFT file format on the **EFT Format Maintenance** screen. 
 +</WRAP>
  
-{{:app/image311.jpeg?11x11}}+  * <color #00a2e8>**Description**</color> **column** - The description of the EFT format field. 
 +  * <color #00a2e8>**Source**</color> **column** - The data source of the EFT format field of the new EFT format. 
 +    * <color #00a2e8>**Blank**</color> - The value will consist of blank (empty) spaces.  
 +    * <color #00a2e8>**Constant**</color> - The value will consist of a constant hard-coded value specified in the <color #00a2e8>**Value**</color> column. 
 +    * <color #00a2e8>**Data Field**</color> - The value will be obtained from another database field specified in the <color #00a2e8>**Table**</color> and <color #00a2e8>**Field**</color> columns. 
 +    * <color #00a2e8>**Entry Field**</color> - The value will be entered on the EFT Bank Setup]] [[#page821|Wizard step 3 screen at the time of EFT Bank setup.]] 
 +    * <color #00a2e8>**System Field**</color> - The value will be obtained from the system based on the value specified in the <color #00a2e8>**Data Type**</color> column. 
 +    * <color #00a2e8>**Transferred Field**</color> - The value will be obtained from another record field specified in the <color #00a2e8>**TransferredRecordName**</color> and <color #00a2e8>**TransferredFieldName**</color> columns. 
 +  * **<color #00a2e8>Required</color> column** - Indicates if the EFT format field is required. 
 +    * <color #00a2e8>**Mandatory**</color> - The data record is mandatory. 
 +    * <color #00a2e8>**Optional**</color> - The data record is optional. 
 +    * <color #00a2e8>**Required**</color> - The data record is required. 
 +  * **<color #00a2e8>Data Type</color> column** - The data type of the EFT format field. 
 +    * <color #00a2e8>**Alphanumeric**</color> 
 +    * <color #00a2e8>**Blank**</color> 
 +    * <color #00a2e8>**Transaction Code**</color> 
 +    * <color #00a2e8>**Batch Date**</color> 
 +    * <color #00a2e8>**Immediate Origin Code**</color> 
 +    * <color #00a2e8>**Transaction Trace Number**</color> 
 +    * <color #00a2e8>**Transit Routing Number**</color> 
 +    * <color #00a2e8>**Company Entry Description**</color> 
 +    * <color #00a2e8>**Company Descriptive Date**</color> 
 +    * <color #00a2e8>**Julian Date (NACHA)**</color> 
 +    * <color #00a2e8>**Transaction Amt**</color> 
 +    * <color #00a2e8>**Numeric**</color> 
 +    * <color #00a2e8>**Service Class Code**</color> 
 +    * <color #00a2e8>**Entry Addenda Count**</color> 
 +    * <color #00a2e8>**Batch Entry Hash**</color> 
 +    * <color #00a2e8>**Total Debit Entry Amt**</color> 
 +    * <color #00a2e8>**Trace Number Seq**</color> 
 +    * <color #00a2e8>**Batch Tim**</color> 
 +    * <color #00a2e8>**File ID Modifier**</color> 
 +    * <color #00a2e8>**Total Credit Entry Amt**</color> 
 +    * <color #00a2e8>**Batch Number**</color> 
 +    * <color #00a2e8>**Total Debit Entry Amt**</color> 
 +    * <color #00a2e8>**Total Credit Entry Amt**</color> 
 +    * <color #00a2e8>**Batch Count**</color> 
 +    * <color #00a2e8>**Block Count**</color> 
 +    * <color #00a2e8>**Entry/Addenda Count**</color> 
 +    * <color #00a2e8>**Entry Hash**</color> 
 +    * <color #00a2e8>**Count of Debits**</color> 
 +    * <color #00a2e8>**Count of Credits**</color> 
 +    * <color #00a2e8>**Canadian Batch Number**</color> 
 +    * <color #00a2e8>**Julian Date (Canada)**</color> 
 +    * <color #00a2e8>**Entry Effective Date**</color> 
 +    * <color #00a2e8>**Payment Number**</color> 
 +  * **<color #00a2e8>Length</color> column** - The length in characters of the EFT format field.
  
-**Note –** The Record Type values available [[#page828|for]] selection will be dependant on the [[#page828|information]] entered for the EFT file format on the [[#page828|EFT]] +<WRAP center round info 90%> 
- +All Record Type entries on the **EFT File Maintenance** screen **must** add up to the number of characters specified in the <color #00a2e8>**Max. Length**</color> column of the **EFT Format Maintenance** screen.
-{{:app/image843.jpeg?575x126}} +
- +
-Format Maintenance Screen. +
- +
-{{:app/image844.jpeg?575x39}} +
- +
-**Description –** The description of the EFT format field. +
- +
- +
- +
-**Source –** The data source of the EFT format field of the new EFT format. +
- +
- +
- +
-**Blank –** The value will consist of blank (empty) spaces. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Constant –** The value will consist of a constant hard-coded value specified in the **Value** column. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Data Field –** The value will be obtained from another database field specified in the **Table** and **Field** columns. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-[[#page821|**Entry Field –** The value will be entered on the EFT Bank Setup]] [[#page821|Wizard step 3 screen at the time of EFT Bank setup.]] +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**System Field –** The value will be obtained from the system based on the value specified in the **Data Type** column. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Transferred Field –** The value will be obtained from another record field specified in the **TransferredRecordName** and **TransferredFieldName** columns. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Mandatory –** Indicates if the EFT format field is required. +
- +
- +
- +
-**Mandatory –** The data record is mandatory. +
- +
-{{:app/image38.jpeg}} +
- +
-**Optional –** The data record is optional. +
- +
-{{:app/image38.jpeg}} +
- +
-**Required –** The data record is required. +
- +
-{{:app/image38.jpeg}} +
- +
- **Data Type –** The data type of the EFT format field. +
- +
-**Alphanumeric** +
- +
- +
- +
-**Blank** +
- +
- +
- +
-**Transaction Code** +
- +
- +
- +
-**Batch Date** +
- +
- +
- +
-**Immediate Origin Code** +
- +
- +
- +
-**Transaction Trace Number** +
- +
- +
- +
-**Transit Routing Number** +
- +
- +
- +
-**Company Entry Description** +
- +
- +
- +
-**Company Descriptive Date** +
- +
- +
- +
-**Julian Date (NACHA)** +
- +
- +
- +
-**Transaction Amt** +
- +
- +
- +
-**Numeric** +
- +
- +
- +
-**Service Class Code** +
- +
- +
- +
-**Entry Addenda Count** +
- +
- +
- +
-**Batch Entry Hash** +
- +
- +
- +
- +
- +
-**Total Debit Entry Amt** +
- +
- +
- +
-**Trace Number Seq** +
- +
- +
- +
-**Batch Tim** +
- +
- +
- +
-**File ID Modifier** +
- +
- +
- +
-**Total Credit Entry Amt** +
- +
- +
- +
-**Batch Number** +
- +
- +
- +
-**Total Debit Entry Amt** +
- +
- +
- +
-**Total Credit Entry Amt** +
- +
- +
- +
-**Batch Count** +
- +
- +
- +
-**Block Count** +
- +
- +
- +
-**Entry/Addenda Count** +
- +
- +
- +
-**Entry Hash** +
- +
- +
- +
-**Count of Debits** +
- +
- +
- +
-**Count of Credits** +
- +
- +
- +
-**Canadian Batch Number** +
- +
- +
- +
-**Julian Date (Canada)** +
- +
- +
- +
-**Entry Effective Date** +
- +
- +
- +
-**Payment Number** +
- +
- +
- +
- +
-  * **Length –** The length in characters of the EFT format field. +
- +
-<WRAP center round info> +
-All Record Type entries on the EFT File Maintenance Screen **must** add up to the number of characters specified in the Max. Length column of the EFT Format Maintenance Screen.+
 </WRAP> </WRAP>
  
-  * **StartColumn –** The character position of the **Record Type** where the EFT format field will begin.+  * **<color #00a2e8>StartColumn</color> column** - The character position of the <color #00a2e8>**Record Type**</color> where the EFT format field will begin.
  
-<WRAP center round info> +<WRAP center round info 90%> 
-The StartColumn value will be calculated automatically and may change based upon changes to the Length or Record Type columns.+The StartColumn value will be calculated automatically and may change based upon changes to the <color #00a2e8>**Length**</color> or <color #00a2e8>**Record Type**</color> columns.
 </WRAP> </WRAP>
  
-  * **Value –** The value of the EFT format field. This column is used in conjunction with the **Constant** **Data Source** value.+  * **<color #00a2e8>Value</color> column** – The value of the EFT format field. This column is used in conjunction with the **Constant** **Data Source** value.
  
 {{:app/image845.jpeg?707x37}} {{:app/image845.jpeg?707x37}}
  
-  * **Table** – The table from which the value of the EFT format field will be obtained. This column is used in conjunction with the **Data Field** and **Entry Field** **Data Source** values. +  * **<color #00a2e8>Table</color> column** – The table from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Data Field**</color> and <color #00a2e8>**Entry Field**</color> <color #00a2e8>**Data Source**</color> values. 
- +  * **<color #00a2e8>Field</color> column** – The field of the <color #00a2e8>**Table**</color> from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Data Field**</color> and <color #00a2e8>**Entry Field**</color> <color #00a2e8>**Data Source**</color> values.
- +
- +
- +
- +
-"@TWBS_EFT_VALUES" "U_Value". +
- +
-  * **Field –** The field of the **Table** from which the value of the EFT format field will be obtained. This column is used in conjunction with the **Data Field** and **Entry Field** **Data Source** values.+
  
 {{:app/image846.jpeg?772x46}} {{:app/image846.jpeg?772x46}}
  
-**Note –** If using the **Entry Field Data Source** value, the+<WRAP center round info 90%> 
 +If using the <color #00a2e8>**Entry Field Data Source**</color> value, the <color #00a2e8>**Table**</color> should be specified as <color #ff7f27>**@TWBS_EFT_VALUES**</color> and the Field should be specified as <color #ff7f27>**U_Value**</color>. 
 +</WRAP>
  
-{{:app/image847.jpeg?571x88}}+{{:app/image849.jpeg?772x47}}
  
-  * **Table** should be specified as and the +<WRAP center round info 90%> 
-  * **Field** should be specified as +If using the <color #00a2e8>**Data Field Data Source**</color> value, the <color #00a2e8>**Field**</color> can be either a basic table field or a user defined field. 
- +</WRAP>
-{{:app/image848.jpeg?571x60}}{{:app/image849.jpeg?772x47}} +
- +
-**Note –** If using the **Data Field Data Source** value, the **Field** can be either a basic table field or a user defined field.+
  
-  * **TransferredRecordName –** The **Record Type** of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the **Transferred Field** **Data Source** value.  +  * **<color #00a2e8>TransferredRecordName</color> column** – The <color #00a2e8>**Record Type**</color> of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Transferred Field**</color> <color #00a2e8>**Data Source**</color> value.  
-  * **TransferredFieldName–** The **Description** of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the **Transferred Field** **Data Source** value.+  * **<color #00a2e8>TransferredFieldName</color> column** – The <color #00a2e8>**Description**</color> of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Transferred Field**</color> <color #00a2e8>**Data Source**</color> value.
  
 {{:app/image850.jpeg?772x22}} {{:app/image850.jpeg?772x22}}
  
-  * **FillChar –** The character to be used as a specific filler character for the entirety of the entered **Length** value.+  * **<color #00a2e8>FillChar</color> column** – The character to be used as a specific filler character for the entirety of the entered <color #00a2e8>**Length**</color> value.
  
-  * **Back button –** Returns to the [[#page828|EFT Format Maintenance Screen]] without saving the EFT file format information. +  * **<color #22b14c>Back</color> button** - Returns to the **EFT Format Maintenance** screen without saving the EFT file format information. 
-  * **Save and Continue button –** Saves the EFT file format information.  +  * **<color #22b14c>Save and Continue</color> button** - Saves the EFT file format information.  
-  * **Cancel button –** Cancels the EFT file format creation process and closes the form.+  * **<color #22b14c>Cancel</color> button** - Cancels the EFT file format creation process and closes the form.
  
 {{:app/image44.jpeg?786}} {{:app/image44.jpeg?786}}
app/eft_screens.1564375409.txt.gz · Last modified: 2019/07/29 00:43 by dtucker

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki