{"id":10161,"date":"2023-06-21T15:46:37","date_gmt":"2023-06-21T06:46:37","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=10161"},"modified":"2023-06-25T10:52:44","modified_gmt":"2023-06-25T01:52:44","slug":"setting-up-account-segments-and-custom-account-segment-tables","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=10161&lang=en","title":{"rendered":"Setting Up Account Segments and Customized Account Segment Tables"},"content":{"rendered":"<p>Views: 15<\/p><div id=\"header\">\n<h1>Setting Up Account Segments and Customized Account Segment Tables<\/h1>\n<div id=\"toc\" class=\"toc2\">\n<div id=\"toctitle\">Table of Contents<\/div>\n<ul class=\"sectlevel1\">\n<li><a href=\"#_proposal_to_simplify_account_segment_and_customized_segment_for_ease_of_understanding_and_efficiency\">1. Proposal to Simplify Account Segment and Customized Segment for Ease of Understanding and Efficiency<\/a><\/li>\n<li><a href=\"#_customized_account_segment_and_customized_account_value\">2. Customized Account Segment and Customized Account Value<\/a>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_overview\">2.1. Overview<\/a><\/li>\n<li><a href=\"#_corresponding_file_is_a_predetermined_account_segment_table\">2.2. Corresponding_File is a predetermined account segment table<\/a><\/li>\n<li><a href=\"#_explaining_corresponding_file_as_defined_in_iso_213782019\">2.3. Explaining Corresponding_File as defined in ISO 21378:2019<\/a><\/li>\n<li><a href=\"#_explaining_corresponding_file_as_a_custom_table\">2.4. Explaining Corresponding_File as a custom table<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_field_values_used_in_iso_213782019_annex_b\">3. Field Values Used in ISO 21378:2019 Annex B<\/a>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_general\">3.1. General<\/a><\/li>\n<li><a href=\"#_the_first_set_of_records_for_account_number_2202\">3.2. The First Set of Records for Account Number 2202<\/a><\/li>\n<li><a href=\"#_the_second_set_of_records_for_account_number_2202\">3.3. The Second Set of Records for Account Number 2202<\/a><\/li>\n<li><a href=\"#_the_third_row_with_account_number_5502\">3.4. The third row with Account Number 5502<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_how_to_setup_bas_customized_acc_segment_and_bas_customized_acc_value\">4. How to setup BAS_Customized_ACC_Segment and BAS_Customized_ACC_Value<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div id=\"content_adoc\">\n<div id=\"preamble\">\n<div class=\"sectionbody\">\n<div class=\"paragraph data-line-7\">\n<p>Nobuyuki SAMBUICHI<\/p>\n<\/div>\n<div class=\"paragraph data-line-9\">\n<p><a href=\"https:\/\/www.iso.org\/committee\/5648297.html\" data-href=\"https:\/\/www.iso.org\/committee\/5648297.html\">ISO\/TC295 Audit data services<\/a>\/SG1 Semantic model Convener<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1 data-line-11\">\n<h2 id=\"_proposal_to_simplify_account_segment_and_customized_segment_for_ease_of_understanding_and_efficiency\">1. Proposal to Simplify Account Segment and Customized Segment for Ease of Understanding and Efficiency<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph data-line-13\">\n<p>I would like to propose a simplification of the account segment and customized segment structure in ISO 21378:2019. As it currently stands, the complex structure tends to create hurdles both in understanding and in practical application. It potentially leads to errors during data entry and could consume more computer power than necessary, both of which adversely impact the user experience and efficiency.<\/p>\n<\/div>\n<div class=\"paragraph data-line-15\">\n<p><strong>Pros of the Current Structure:<\/strong><\/p>\n<\/div>\n<div class=\"olist arabic data-line-17\">\n<ol class=\"arabic\">\n<li class=\"data-line-17\">\n<p><strong>Comprehensive<\/strong>: The existing structure is highly detailed, accounting for a broad range of potential scenarios and use cases.<\/p>\n<\/li>\n<li class=\"data-line-19\">\n<p><strong>Flexible<\/strong>: It caters to both pre-defined and custom account segments, which allows for significant customization to meet specific business needs.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-21\">\n<p><strong>Cons of the Current Structure:<\/strong><\/p>\n<\/div>\n<div class=\"olist arabic data-line-23\">\n<ol class=\"arabic\">\n<li class=\"data-line-23\">\n<p><strong>Complexity<\/strong>: The intricate structure can be challenging to comprehend and implement, especially for users with limited technical knowledge.<\/p>\n<\/li>\n<li class=\"data-line-25\">\n<p><strong>Data Entry Errors<\/strong>: The high level of detail and manual data entry points increase the chances of human error.<\/p>\n<\/li>\n<li class=\"data-line-27\">\n<p><strong>Resource-Intensive<\/strong>: The structure might be resource-intensive, especially for systems with limited computing power.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-29\">\n<p><strong>Recommendations:<\/strong><\/p>\n<\/div>\n<div class=\"olist arabic data-line-31\">\n<ol class=\"arabic\">\n<li class=\"data-line-31\">\n<p><strong>User-Friendly Design<\/strong>: Revise the structure to focus more on user needs. This could involve simplifying table setups, minimizing manual entry points, and creating a more intuitive flow of data between tables.<\/p>\n<\/li>\n<li class=\"data-line-33\">\n<p><strong>Automation<\/strong>: Implementing automation where possible would minimize data entry errors.<\/p>\n<\/li>\n<li class=\"data-line-35\">\n<p><strong>Modular Structure<\/strong>: Implementing a modular structure would allow the system to adapt to varying levels of complexity as per user needs. Simple operations would use a basic set of tables, and additional tables could be added for more complex scenarios.<\/p>\n<\/li>\n<li class=\"data-line-37\">\n<p><strong>Guidelines and Training<\/strong>: Provide clear guidelines and comprehensive training to users, emphasizing best practices for data entry and management. This approach would mitigate the chances of errors and improve understanding.<\/p>\n<\/li>\n<li class=\"data-line-39\">\n<p><strong>Optimization<\/strong>: Review the structure for potential areas of optimization to reduce the load on computing resources.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-41\">\n<p>I firmly believe that simplifying the account segment and customized segment structure would not only streamline the user experience but also improve overall system performance and reliability. I welcome any feedback or further discussion on the recommendations outlined above.<\/p>\n<\/div>\n<div class=\"paragraph data-line-43\">\n<p>The simplest way is just define extra fields for Account-sub Type Code and Account-sub type Value for GL_Details and other tables like followings.<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-46\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<thead>\n<tr>\n<th class=\"tableblock halign-left valign-top\">Journal_ID<\/th>\n<th class=\"tableblock halign-left valign-top\">Other GL_Detail fields<\/th>\n<th class=\"tableblock halign-left valign-top\">Account-sub Type Code<\/th>\n<th class=\"tableblock halign-left valign-top\">Account-sub type Value<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">&#8216;1122&#8217;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">values for fields of &#8216;1122&#8217;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">&#8216;Expense Type&#8217;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">&#8216;Office Supplies&#8217;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">&#8216;1123&#8217;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">values for fields of &#8216;1122&#8217;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">&#8216;Utilities&#8217;<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-54\">\n<p>More complicated usage check section 4.<\/p>\n<\/div>\n<div class=\"paragraph data-line-57\">\n<div class=\"title\">ChatGPT<\/div>\n<p>In simplifying the current system while maintaining its depth and functionality, I propose the following Unified Table Structure:<\/p>\n<\/div>\n<div class=\"paragraph data-line-59\">\n<p><strong>Unified Account Segment Table:<\/strong><\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-61\">\n<colgroup>\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 10%;\">\n<\/colgroup>\n<thead>\n<tr>\n<th class=\"tableblock halign-left valign-top\">GL_Account_Number<\/th>\n<th class=\"tableblock halign-left valign-top\">Account_Segment_Number<\/th>\n<th class=\"tableblock halign-left valign-top\">Account_Segment_Name<\/th>\n<th class=\"tableblock halign-left valign-top\">Corresponding_File<\/th>\n<th class=\"tableblock halign-left valign-top\">Customized_ACC_Segment_Code<\/th>\n<th class=\"tableblock halign-left valign-top\">Account_Segment_Value<\/th>\n<th class=\"tableblock halign-left valign-top\">Segment_Description<\/th>\n<th class=\"tableblock halign-left valign-top\">Hierarchy_Flag<\/th>\n<th class=\"tableblock halign-left valign-top\">Parent_ACC_Value_Code<\/th>\n<th class=\"tableblock halign-left valign-top\">Parent_ACC_Value_Name<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">x2113<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Bob<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Custom_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Custom_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">c08<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Beijing<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">c<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">China<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">ch010101<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Centre hospital<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">NULL<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-68\">\n<p>In the proposed unified table, each row would carry the comprehensive information for each account segment. It incorporates fields from the Account Segment, Customized Account Segment, and Customized Account Segment Value tables in the current model. This new layout will reduce the need for multiple table lookups, resulting in lower computational resource consumption and simplified data entry and retrieval processes.<\/p>\n<\/div>\n<div class=\"paragraph data-line-70\">\n<p>Please note that this is a simplified model and might need to be further expanded or adjusted based on the specific needs of different accounting scenarios. It serves as a stepping stone towards a more simplified and user-friendly structure.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1 data-line-72\">\n<h2 id=\"_customized_account_segment_and_customized_account_value\">2. Customized Account Segment and Customized Account Value<\/h2>\n<div class=\"sectionbody\">\n<div class=\"sect2 data-line-74\">\n<h3 id=\"_overview\">2.1. Overview<\/h3>\n<div class=\"paragraph data-line-76\">\n<p>Figure 1 displays the relationships between the tables.<\/p>\n<\/div>\n<div class=\"paragraph data-line-78\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig1.png\" alt=\"230620Fig1\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-80\">\n<p>Figure 1 &#8211; Relationships between the tables related to the Customized_Account_Segment and the Customized_Account_Value<\/p>\n<\/div>\n<div class=\"paragraph data-line-82\">\n<p>The process of retrieving information is comprised of these steps:<\/p>\n<\/div>\n<div class=\"olist arabic data-line-86\">\n<ol class=\"arabic\">\n<li class=\"data-line-86\">\n<p>The &#8220;GL_Account_Segment&#8221; table utilizes a unique combination of GL_Account_Number and Account_Segment_Number. The GL_Account_Number corresponds to the same value in the &#8220;GL_Details&#8221; table. The Account_Segment_Number matches the X value in the field named Account_Segment_X in the &#8220;GL_Details&#8221; table. Searching the &#8220;GL_Account_Segment&#8221; table with this unique combination yields Corresponding_File and Customized_ACC_Segment_Code.<\/p>\n<\/li>\n<li class=\"data-line-88\">\n<p>If Corresponding_File equals &#8220;BAS_Customized_ACC_Segment&#8221;, then you should use the returned Customized_ACC_Segment_Code to look up in the &#8220;BAS_Customized_ACC_Segment&#8221; table, where it acts as a key to find the associated <strong>Customized_Account_Segment_Name<\/strong>.<\/p>\n<\/li>\n<li class=\"data-line-90\">\n<p>The &#8220;BAS_Customized_ACC_Value&#8221; table uses a unique key made of a combination of Customizad_ACC_Value_Code and Customized_ACC_Segment_Code. The Customizad_ACC_Value_Code matches the value of Account_Segment_X in the &#8220;GL_Details&#8221; table. The Customized_ACC_Segment_Code, fetched from the &#8220;GL_Account_Segment&#8221; table, corresponds to the keys in both &#8220;BAS_Customized_ACC_Segment&#8221; and &#8220;BAS_Customized_ACC_Value&#8221; tables. Searching the &#8220;BAS_Customized_ACC_Value&#8221; table with this unique key returns the <strong>Customizad_ACC_Value_Name<\/strong>. The data associated with Account_Segment_X in the &#8220;GL_Details&#8221; table aligns with the values of <strong>Customized_Account_Segment_Name<\/strong> from the &#8220;BAS_Customized_ACC_Segment&#8221; table and <strong>Customized_Account_Value_Name<\/strong> from the &#8220;BAS_Customized_ACC_Value&#8221; table.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-92\">\n<p>Figure 2 shows an example of a record and the business meaning of each field.<\/p>\n<\/div>\n<div class=\"paragraph data-line-94\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig2.png\" alt=\"230620Fig2\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-96\">\n<p>Figure 2 &#8211; Example of a record in the GL_Details table<\/p>\n<\/div>\n<div class=\"paragraph data-line-98\">\n<p>The GL_Account_Number field refers to an identifier with a corresponding reference field GL_Account_Number in the &#8220;BAS_Chart_Of_Accounts&#8221; table. This allows you to find account information by searching the &#8220;BAS_Chart_Of_Accounts&#8221; table using the unique key GL_Account_Number. We will explain how to derive the meanings of the account segments in the following sections.<\/p>\n<\/div>\n<div class=\"paragraph data-line-100\">\n<p>Table 1 shows the values listed in GL_Account_Segment.<\/p>\n<\/div>\n<div class=\"paragraph data-line-102\">\n<p>Table 1 &#8211; GL_Account_Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-104\">\n<colgroup>\n<col style=\"width: 11.1111%;\">\n<col style=\"width: 33.3333%;\">\n<col style=\"width: 11.1111%;\">\n<col style=\"width: 33.3333%;\">\n<col style=\"width: 11.1112%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Region<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"sect2 data-line-113\">\n<h3 id=\"_corresponding_file_is_a_predetermined_account_segment_table\">2.2. Corresponding_File is a predetermined account segment table<\/h3>\n<div class=\"paragraph data-line-115\">\n<p>Figure 3 shows how to find the meaning of Account_Segment_Employee in &#8220;GL_Details&#8221; table. \u201cAccount_Segment_Employee\u201d is a predetermined Account Segment.<\/p>\n<\/div>\n<div class=\"paragraph data-line-117\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig3.png\" alt=\"230620Fig3\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-119\">\n<p>Figure 3 &#8211; Retrieving Account_Segment_Employee in GL_Details<\/p>\n<\/div>\n<div class=\"paragraph data-line-121\">\n<p>The &#8220;GL_Account_Segment&#8221; table specifies certain predefined Account Segments that possess an Account_Segment_Number value of 0. These include &#8220;BAS_Employee&#8221;, &#8220;BAS_Project&#8221;, and &#8220;BAS_Bank_Account&#8221;. In our data schema, field names are adapted to reflect this specification, thus we have &#8220;Account_Segment_Employee&#8221;, &#8220;Account_Segment_Project&#8221;, and &#8220;Account_Segment_Bank_Account&#8221; instead of &#8220;Account_Segment_0&#8221;. In this example, we&#8217;ll focus on \u201cAccount_Segment_Employee\u201d.<\/p>\n<\/div>\n<div class=\"paragraph data-line-123\">\n<p>The process of retrieving information consists of these steps:<\/p>\n<\/div>\n<div class=\"olist arabic data-line-125\">\n<ol class=\"arabic\">\n<li class=\"data-line-125\">\n<p>When you search the &#8220;GL_Account_Segment&#8221; table using the GL_Account_Number \u201c1122\u201d (extracted from the &#8220;GL_Details&#8221; table) and Account_Segment_Name \u201cAccount_Segment_Employee\u201d, the search will yield a Corresponding_File labeled \u201cEmployee\u201d.<\/p>\n<\/li>\n<li class=\"data-line-127\">\n<p>The value located under Account_Segment_Employee in the &#8220;GL_Details&#8221; table serves as a unique key for the &#8220;BAS_Employee&#8221; table. So if you search the &#8220;BAS_Employee&#8221; table using this unique key (say \u201cx2113\u201d), the result will be a specific Employee record. For example, Account_Segment_Employee value \u201cx2113\u201d correlates to an employee named \u201cBob\u201d with User_ID \u201cam03\u201d.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-129\">\n<p>Table 2 shows the relationship between tables for the Corresponding_File Employee.<\/p>\n<\/div>\n<div class=\"paragraph data-line-131\">\n<p>Table 2 &#8211; Corresponding_File Employee<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-133\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">property<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">x2133<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Employee Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">x2133<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"sect2 data-line-143\">\n<h3 id=\"_explaining_corresponding_file_as_defined_in_iso_213782019\">2.3. Explaining Corresponding_File as defined in ISO 21378:2019<\/h3>\n<div class=\"paragraph data-line-145\">\n<p>Figure 4 shows how to understand the value of Account_Segment_2 in the &#8220;GL_Details&#8221; table.<\/p>\n<\/div>\n<div class=\"paragraph data-line-147\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig4.png\" alt=\"230620Fig4\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-149\">\n<p>Figure 4 &#8211; Understanding the value of Account_Segment_2 in the GL_Details table<\/p>\n<\/div>\n<div class=\"paragraph data-line-151\">\n<p>To find the meaning of this value, we follow these steps:<\/p>\n<\/div>\n<div class=\"olist arabic data-line-153\">\n<ol class=\"arabic\">\n<li class=\"data-line-153\">\n<p>The field name Account_Segment_2 implies that our Account_Segment_Number is &#8220;2&#8221;. By referring to the &#8220;GL_Account_Segment&#8221; table with a GL_Account_Number &#8220;1122&#8221; and an Account_Segment_Number &#8220;2&#8221;, we identify that the Corresponding_File is &#8220;Customer&#8221;.<\/p>\n<\/li>\n<li class=\"data-line-155\">\n<p>The value of Account_Segment_2 in the &#8220;GL_Details&#8221; table is the key we use to access the &#8220;Customer&#8221; table. Using this key, \u201cch010101\u201d, to search the &#8220;Customer&#8221; table, we uncover the record for a customer named \u201cCentre hospital\u201d with the Customer_Account_Number \u201c71089\u201d.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-157\">\n<p>Table 3 shows how these tables relate to each other for the Corresponding_File Customer.<\/p>\n<\/div>\n<div class=\"paragraph data-line-159\">\n<p>Table 3 &#8211; How the tables relate for Corresponding_File Customer<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-161\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">property<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Customer<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment 2<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">cb010101<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account Segment Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customer Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">cb010101<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"sect2 data-line-171\">\n<h3 id=\"_explaining_corresponding_file_as_a_custom_table\">2.4. Explaining Corresponding_File as a custom table<\/h3>\n<div class=\"paragraph data-line-173\">\n<p>This scenario is not specified in ISO 21378:2019<\/p>\n<\/div>\n<div class=\"paragraph data-line-175\">\n<p>Figure 5 shows how to understand the value of Account_Segment_1 in the GL_Details table.<\/p>\n<\/div>\n<div class=\"paragraph data-line-177\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig5.png\" alt=\"230620Fig5\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-179\">\n<p>Figure 5 &#8211; Understanding the value of Account_Segment_1 in the GL_Details table<\/p>\n<\/div>\n<div class=\"paragraph data-line-181\">\n<p>To find the meaning of this value, we follow these steps:<\/p>\n<\/div>\n<div class=\"olist arabic data-line-183\">\n<ol class=\"arabic\">\n<li class=\"data-line-183\">\n<p>The field name Account_Segment_1 suggests an Account_Segment_Number of &#8220;1&#8221;. Looking up the &#8220;GL_Account_Segment&#8221; table with a GL_Account_Number &#8220;1122&#8221; and Account_Segment_Number &#8220;1&#8221;, we find the Corresponding_File is &#8220;BAS_Customized_ACC_Segment&#8221;. To further lookup in the &#8220;BAS_Customized_ACC_Segment&#8221; table, we use the Customized_ACC_Segment_Code \u201cs05\u201d defined in &#8220;GL_Account_Segment&#8221; table.<\/p>\n<\/li>\n<li class=\"data-line-185\">\n<p>By using the composite primary key, composed of Customized_Account_Value_Code value \u201cc08\u201d (which is the value of Account_Segment_1 in the &#8220;GL_Details&#8221; table) and Customized_ACC_Segment_Code value \u201cs05\u201d, we can search the &#8220;BAS_Customized_ACC_Segment&#8221; table. This will reveal that the value of <strong>Customized_Account_Value_Name<\/strong> is &#8220;Region&#8221;.<\/p>\n<\/li>\n<li class=\"data-line-187\">\n<p>Searching the &#8220;BAS_Customized_ACC_Value&#8221; table with the primary key &#8220;s05&#8221; and Account_Segment_1 value \u201cc08\u201d, we find the <strong>Customized_Account_Value_Name<\/strong> is &#8220;Beijing&#8221;.<\/p>\n<\/li>\n<li class=\"data-line-189\">\n<p>The value of &#8220;1&#8221; for Hierarchy_Flag in the &#8220;BAS_Customized_ACC_Segment&#8221; table indicates a hierarchical structure for the Region. If Parent_ACC_Value_Code in the &#8220;BAS_Customized_ACC_Value&#8221; table is not null, it signifies a Parent_ACC_Value_Code in the same table. Using &#8220;s05&#8221; and Parent_ACC_Value_Code \u201cc\u201d as keys to search the &#8220;BAS_Customized_ACC_Value&#8221; table, we find that the <strong>Customized_Account_Value_Name<\/strong> is &#8220;China&#8221;. This record is the root of the Region hierarchy, as the Parent_ACC_Value_Code for this record is null.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-191\">\n<p>Table 4 shows how these tables relate to each other for the Corresponding_File BAS_Customized_ACC_Segment.<\/p>\n<\/div>\n<div class=\"paragraph data-line-193\">\n<p>Table 4 &#8211; How the tables relate for Corresponding_File BAS_Customized_ACC_Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-195\">\n<colgroup>\n<col style=\"width: 28.5714%;\">\n<col style=\"width: 14.2857%;\">\n<col style=\"width: 14.2857%;\">\n<col style=\"width: 14.2857%;\">\n<col style=\"width: 14.2857%;\">\n<col style=\"width: 14.2858%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"5\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\" colspan=\"2\">\n<p class=\"tableblock\">BAS_Customized_ACC_Value<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1122<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_1<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">c08<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Region<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Region<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Beijing<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">China<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">s05<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Value_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">c08<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Parent_ACC_Value_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">c<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1 data-line-261\">\n<h2 id=\"_field_values_used_in_iso_213782019_annex_b\">3. Field Values Used in ISO 21378:2019 Annex B<\/h2>\n<div class=\"sectionbody\">\n<div class=\"sect2 data-line-263\">\n<h3 id=\"_general\">3.1. General<\/h3>\n<div class=\"paragraph data-line-265\">\n<p>The specific application of extensions, including predefined tables and customized account segments, are not extensively explained when it comes to establishing account segments and customized account segments. This part of the discussion will provide a concrete example of table setup following ISO 21378:2019 Annex B.<\/p>\n<\/div>\n<div class=\"paragraph data-line-267\">\n<p>Annex B of ISO 21378:2019, particularly Table B.1, encompasses rows carrying Account_Segment_X data. This annex also points to crucial tables such as GL_Details, Account Segment, BAS_Customized_ACC_Segment, and BAS_Customized_ACC_Value, that come into play in our discussion.<\/p>\n<\/div>\n<div class=\"paragraph data-line-269\">\n<p>We&#8217;ve modeled Table 5 based on Table B.1 from ISO 21378:2019, with a slight modification. We updated the GL_Account_Number in the second row to 3202, which ensures that each row within the table carries a unique account number.<\/p>\n<\/div>\n<div class=\"paragraph data-line-271\">\n<p>Table 5 \uff0d Account Segment lookup key<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-273\">\n<colgroup>\n<col style=\"width: 33.3333%;\">\n<col style=\"width: 33.3333%;\">\n<col style=\"width: 33.3334%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"2\">\n<p class=\"tableblock\">Account Segment lookup key<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Number = 0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Number &gt; 0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<br \/>\nAccount_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Project<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<br \/>\nAccount_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Bank Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<br \/>\nAccount_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Table in ISO 21378:2019 (e.g. Customer, Supplier, etc.)<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<br \/>\nAccount_Segment_Number<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment *a<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<br \/>\nAccount_Segment_Number<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\" colspan=\"3\">\n<p class=\"tableblock\">*a For account numbers that need to use data from tables not defined in ISO 21378:2019, use &#8220;Customized_ACC_Segment_Code&#8221; value in the &#8220;GL_Account_Segment&#8221; table to get the lookup key to the &#8220;BAS_Customized_ACC_Segment&#8221; table.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-308\">\n<p>NOTE\tIn ISO 21378:2019 Table 96, the description for case 2 of the Corresponding_File field only specifies that the &#8220;BAS_Customized_ACC_Segment&#8221; table holds the basic information for the customized account segment. However, it&#8217;s necessary to check the &#8220;GL_Account_Segment&#8221; table to ensure that the Corresponding_File is indeed &#8220;BAS_Customized_ACC_Segment&#8221;, and that a &#8220;Customized_ACC_Segment_Code&#8221; exists for the corresponding \u201cGL_Account_Number\u201d and \u201cAccount_Segment_Number\u201d.<\/p>\n<\/div>\n<div class=\"paragraph data-line-310\">\n<p>NOTE\tIn ISO 21378:2019, Table 98 identifies reference identifiers in the GL_Details table and their associated reference fields and tables. Table 6 provides an excerpt from ISO 21378:2019 Table 98. As shown in Figure 7, these references should be established via the &#8220;GL_Account_Segment&#8221; table.<\/p>\n<\/div>\n<div class=\"paragraph data-line-312\">\n<p>Table 6 \u2014 Identifiers in GL_Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-314\">\n<colgroup>\n<col style=\"width: 5.5555%;\">\n<col style=\"width: 27.7777%;\">\n<col style=\"width: 11.1111%;\">\n<col style=\"width: 27.7777%;\">\n<col style=\"width: 27.778%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">No.<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Identifier<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Referenced field<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Referenced table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">37<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Employee_ID<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">38<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Project_ID<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">39<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Bank_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-321\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2023\/06\/230620Fig6.png\" alt=\"230620Fig6\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph data-line-323\">\n<p>Figure 7 \uff0d Account Segment bridges to basic information<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2 data-line-325\">\n<h3 id=\"_the_first_set_of_records_for_account_number_2202\">3.2. The First Set of Records for Account Number 2202<\/h3>\n<div class=\"paragraph data-line-327\">\n<p>Let&#8217;s consider the first group of entries for account number 2202. As seen in Table 7, it includes Account_Segment_Employee, Account_Segment_Bank_Account, and Account_Segment_1 with values 31, 102, and 71089 respectively.<\/p>\n<\/div>\n<div class=\"paragraph data-line-329\">\n<p>Table 7 \uff0d GL Detail<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-331\">\n<colgroup>\n<col style=\"width: 7.6923%;\">\n<col style=\"width: 23.0769%;\">\n<col style=\"width: 7.6923%;\">\n<col style=\"width: 23.0769%;\">\n<col style=\"width: 7.6923%;\">\n<col style=\"width: 23.0769%;\">\n<col style=\"width: 7.6924%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">No.<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Property<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Datatype<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Referenced table<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Value<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Code<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Chart_Of_Accounts<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">9<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Journal_Entry_Header_Description<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Text<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Cash received from customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">37<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">31<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">39<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">102<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">40<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-376\">\n<p>By referencing Table 8, we can see that the Corresponding_File for &#8216;Account_Segment_Employee&#8217; is &#8216;BAS_Employee&#8217;, and &#8216;Employee_Code&#8217; 31 can be used to look up the &#8216;BAS_Employee&#8217; table (Table 9).<\/p>\n<\/div>\n<div class=\"paragraph data-line-378\">\n<p>Table 8 \uff0d Account Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-380\">\n<colgroup>\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 35.7142%;\">\n<col style=\"width: 14.2857%;\">\n<col style=\"width: 35.7142%;\">\n<col style=\"width: 7.1431%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customer item<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-387\">\n<p>To understand how to find specific account information, you can use Tables 3 and 4 to look up the relevant data.<\/p>\n<\/div>\n<div class=\"paragraph data-line-389\">\n<p>For example, if you&#8217;re searching for an &#8220;GL_Account_Segment&#8221; titled &#8220;Account_Segment_Employee&#8221; that has a &#8220;GL_Account_Number&#8221; of &#8220;2202&#8221;, you would find that the Corresponding_File is titled &#8220;BAS_Employee&#8221;. The employee code for this record is &#8220;31&#8221;, and this code can be used to find the exact employee record in the &#8220;BAS_Employee&#8221; table, as shown in Table 9.<\/p>\n<\/div>\n<div class=\"paragraph data-line-391\">\n<p>Table 9 \uff0d Corresponding_File Employee<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-393\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"3\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Employee<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Header_Description<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Cash received from customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">31<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Employee<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">31<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-437\">\n<p>Similarly, if you are looking for an &#8220;GL_Account_Segment&#8221; titled &#8220;Account_Segment_Bank_Account&#8221; with a &#8220;GL_Account_Number&#8221; of &#8220;2202&#8221;, the Corresponding_File you&#8217;ll find is titled &#8220;BAS_Bank_Account&#8221;. The bank account number for this record is &#8220;102&#8221;, and this can be used to find the specific bank account in the &#8220;BAS_Bank_Account&#8221; table, as shown in Table 10.<\/p>\n<\/div>\n<div class=\"paragraph data-line-439\">\n<p>Table 10 &#8211; Bank Account Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-441\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">.2+|Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">3+^|Table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Account_Segment<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">|BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|2202<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Cash received from customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|102<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">|<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Account_Segment_Bank_Account<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|BAS_Bank_Account<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-485\">\n<p>Finally, if you&#8217;re searching for &#8220;Account_Segment_1&#8221; &#8211; which indicates that the &#8220;Account_Segment_Number&#8221; is &#8220;1&#8221; &#8211; with a &#8220;GL_Account_Number&#8221; of &#8220;2202&#8221;, you&#8217;ll find that the Corresponding_File is titled &#8220;BAS_Customer&#8221;. The customer account number for this record is &#8220;71089&#8221;, and this can be used to locate the specific customer in the &#8220;BAS_Customer&#8221; table, as shown in Table 11.<\/p>\n<\/div>\n<div class=\"paragraph data-line-487\">\n<p>Table 11 &#8211; Customer Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-489\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">.2+|Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">3+^|Table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Account_Segment<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">|BAS_Customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|2202<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Header_Description<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Cash received from customer<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Account_Segment_1<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|71089<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|BAS_Customer item<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|1<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|BAS_Customer<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">|Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">^|-<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"sect2 data-line-533\">\n<h3 id=\"_the_second_set_of_records_for_account_number_2202\">3.3. The Second Set of Records for Account Number 2202<\/h3>\n<div class=\"paragraph data-line-535\">\n<p>Now let&#8217;s consider the second group of entries for account number 2202. As seen in Table 12, it includes Account Segment Project, Account_Segment_Bank_Account, and Account Segment 2 with values 1801, 101, and 82335 respectively.<\/p>\n<\/div>\n<div class=\"paragraph data-line-537\">\n<p>Table 12 &#8211; Another Example of GL_Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-539\">\n<colgroup>\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 14.2861%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">No.<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Field<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Datatype<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Referenced table<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Value<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Code<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Chart_Of_Accounts<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">9<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Journal Entry Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Text<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2015<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Cash payment to supplier Project 1801<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">38<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Project<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1801<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">39<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">101<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">40<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_2<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-584\">\n<p>By referencing Table 13, we can see that the Corresponding_File for &#8216;Account_Segment_Project&#8217; is &#8216;BAS_Project&#8217;, and &#8216;Project_Code&#8217; 1801 can be used to look up the &#8216;BAS_Project&#8217; table (Table 14).<\/p>\n<\/div>\n<div class=\"paragraph data-line-586\">\n<p>Table 13 &#8211; Another Example of Account Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-588\">\n<colgroup>\n<col style=\"width: 10%;\">\n<col style=\"width: 30%;\">\n<col style=\"width: 10%;\">\n<col style=\"width: 30%;\">\n<col style=\"width: 20%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Supplier item<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Supplier<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-614\">\n<p>Table 14 &#8211; Project Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-616\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"3\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Cash payment to supplier Project 1801<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1801<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Project Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1801<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-660\">\n<p>In the same manner, the Corresponding_File for &#8216;Account_Segment_Bank_Account&#8217; is &#8216;BAS_Bank_Account&#8217;, and &#8216;Bank_Account_Code&#8217; 1801 can be used to look up the &#8216;BAS_Bank_Account&#8217; table (Table 15).<\/p>\n<\/div>\n<div class=\"paragraph data-line-662\">\n<p>Table 15 &#8211; Bank Account Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-664\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"3\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Bank_Account<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Cash payment to supplier Project 1801<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">101<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Bank_Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Bank Account<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Bank Account Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">101<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-708\">\n<p>For Account Segment 2, the Corresponding_File is &#8216;BAS_Supplier&#8217;. &#8216;Supplier_Account_Number&#8217; 82335 can be used to look up the &#8216;Supplier&#8217; table (Table 16).<\/p>\n<\/div>\n<div class=\"paragraph data-line-710\">\n<p>Table 16 &#8211; Supplier Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-712\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"3\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Supplier<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2202<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Cash payment to supplier Project 1801<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment 2<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">82335<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Supplier item<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Supplier<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Supplier Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">82335<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-756\">\n<p>By carefully examining the journal entries and account segments, we can understand how different account details correspond to different tables.<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2 data-line-758\">\n<h3 id=\"_the_third_row_with_account_number_5502\">3.4. The third row with Account Number 5502<\/h3>\n<div class=\"paragraph data-line-759\">\n<p>Table 17 details the journal entries that contain &#8220;Account_Segment_Project&#8221; with the value &#8220;1802&#8221;. This row also has an &#8220;Account_Segment_3&#8221;, indicating that the Account_Segment_Number is \u201c3\u201d with a corresponding value of &#8220;A10032&#8221;.<\/p>\n<\/div>\n<div class=\"paragraph data-line-761\">\n<p>Table 17 &#8211; GL_Details<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-763\">\n<colgroup>\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 7.1428%;\">\n<col style=\"width: 21.4285%;\">\n<col style=\"width: 14.2861%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">No.<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Field<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Datatype<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Referenced table<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Value<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Code<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Chart_Of_Accounts<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">9<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Journal_Entry_Description<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Text<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">\u2014<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Accrued expenses<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">38<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_Project<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">1802<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">40<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Details<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Segment_3<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">REF<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-801\">\n<p>Table 18 &#8211; GL_Account_Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-803\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account_Segment_Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">null<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Vehicle item<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-823\">\n<p>When you search for account segment information using Table 17 and Table 18 with the Account Number \u201c5502\u201d and Account_Segment_Name \u201cAccount Segment Project\u201d, you will find the Corresponding_File is \u201cProject\u201d. You can use Project Code \u201c1802\u201d to find the project details in the Project table as listed in Table 19.<\/p>\n<\/div>\n<div class=\"paragraph data-line-825\">\n<p>Table 19 &#8211; BAS_Project<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-827\">\n<colgroup>\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<col style=\"width: 25%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-center valign-top\" rowspan=\"2\">\n<p class=\"tableblock\">Field name for each table<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\" colspan=\"3\">\n<p class=\"tableblock\">Table<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">BAS_Project<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account Number<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Header Description<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Accrued expenses<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1802<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">0<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Project<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Project Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">1802<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-871\">\n<p>When you search for Account Segment 3 information from Table 17 and Table 18, indicating Account_Segment_Number \u201c3\u201d and Account Number \u201c5502\u201d, you&#8217;ll find that the Corresponding_File is \u201cBAS_Customized_ACC_Segment\u201d with a Customized_ACC_Segment_Code of \u201dA10032\u201d. In this case, you should lookup \u201cBAS_Customized_ACC_Segment\u201d table with key value \u201cA10032\u201d. Table 20 provides information for this Customized_ACC_Segment_Code.<\/p>\n<\/div>\n<div class=\"paragraph data-line-873\">\n<p>Table 20 &#8211; BAS_Customized_ACC_Segment<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch data-line-875\">\n<colgroup>\n<col style=\"width: 20%;\">\n<col style=\"width: 20%;\">\n<col style=\"width: 20%;\">\n<col style=\"width: 20%;\">\n<col style=\"width: 20%;\">\n<\/colgroup>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">property<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Journal Entry Detail<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">GL_Account_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Customized Account Value<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">5502<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Account Segment 3<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">A10032<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Name<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Account Segment Vehicle<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Vehicle<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">Car Buick GLB<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Number<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">3<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Corresponding_File<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">BAS_Customized_ACC_Segment<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Segment_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">v852<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">v852<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">v852<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\">Customized_ACC_Value_Code<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">&#8211;<\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">A10032<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"paragraph data-line-925\">\n<p>By searching the Customized Account Table (as listed in Table 20) for the Name with the Code \u201cA10032\u201d, you will find that the Name corresponds to \u201cCar Buick GLB\u201d.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1 data-line-927\">\n<h2 id=\"_how_to_setup_bas_customized_acc_segment_and_bas_customized_acc_value\">4. How to setup BAS_Customized_ACC_Segment and BAS_Customized_ACC_Value<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph data-line-930\">\n<div class=\"title\">User<\/div>\n<p>GL_Account_Segment has a primary key of combined value of GL_Account_Number and Account_Segment_Number. This means We should have the same Customized_ACC_Segment_Value for the same GL_Account_Number  for different Journal_ID.<br \/>\nSince Journal_ID cannot make any difference on GL_Account_Segment.<\/p>\n<\/div>\n<div class=\"paragraph data-line-934\">\n<div class=\"title\">ChatGPT<\/div>\n<p>Apologies for any confusion earlier, and you&#8217;re correct. The GL_Account_Segment table indeed has a primary key that combines the GL_Account_Number and Account_Segment_Number, meaning the mapping between a specific GL account and its account segments is consistent across different Journal_IDs.<\/p>\n<\/div>\n<div class=\"paragraph data-line-936\">\n<p>So, for a given GL_Account_Number and Account_Segment_Number, the associated Customized_ACC_Segment_Code (and subsequently, the Customized_ACC_Segment_Name) would remain the same across different journal entries, as these are defined at the level of the general ledger account, not the individual journal entry.<\/p>\n<\/div>\n<div class=\"paragraph data-line-938\">\n<p>However, the actual Customized_ACC_Value_Code (and corresponding Customized_ACC_Value_Name) used in a journal line can vary between different Journal_IDs. This allows the system to use different values for the same account segment across different journal entries.<\/p>\n<\/div>\n<div class=\"paragraph data-line-940\">\n<p>For example, if the GL_Account_Number &#8216;1122&#8217; has a custom account segment for &#8216;Expense Type&#8217;, the actual &#8216;Expense Type&#8217; value used in a journal entry (like &#8216;Office Supplies&#8217; or &#8216;Utilities&#8217;) could be different in each Journal_ID, even though the &#8216;Expense Type&#8217; segment itself is consistently associated with GL_Account_Number &#8216;1122&#8217; across all journal entries. This allows different expenses recorded against the same GL account to be categorized differently based on the specifics of each transaction.<\/p>\n<\/div>\n<div class=\"paragraph data-line-942\">\n<p>I hope this clarifies the relationship between these elements. Let me know if you have more questions!<\/p>\n<\/div>\n<div class=\"paragraph data-line-945\">\n<div class=\"title\">User<\/div>\n<p>How to setup GL_Account_Segment to support your soltion?<\/p>\n<\/div>\n<div class=\"paragraph data-line-948\">\n<div class=\"title\">ChatGPT<\/div>\n<p>Setting up the GL_Account_Segment to support this solution involves setting up the account structure and then defining the customized account segments. Here&#8217;s a step-by-step breakdown of how to do this:<\/p>\n<\/div>\n<div class=\"olist arabic data-line-950\">\n<ol class=\"arabic\">\n<li class=\"data-line-950\">\n<p><strong>Create the GL Account:<\/strong> The General Ledger (GL) Account, in this case, &#8216;1122&#8217;, should be created first. This is typically done in the GL_Accounts table, where each GL Account is given a unique identifier (the GL_Account_Number).<\/p>\n<\/li>\n<li class=\"data-line-952\">\n<p><strong>Define Account Segment:<\/strong> In the GL_Account_Segment table, we define the account structure for the GL account &#8216;1122&#8217;. Each row in this table represents one segment of the account structure. We assign a unique Account_Segment_Number to each row and set the GL_Account_Number to &#8216;1122&#8217;. For instance, if we want to associate &#8216;1122&#8217; with the &#8216;Expense Type&#8217; segment, we might create a row with GL_Account_Number = &#8216;1122&#8217;, Account_Segment_Number = &#8216;1&#8217;, and Corresponding_File = &#8216;BAS_Customized_ACC_Segment&#8217;, and Customized_ACC_Segment_Code = &#8216;ET&#8217; (representing &#8216;Expense Type&#8217;).<\/p>\n<\/li>\n<li class=\"data-line-954\">\n<p><strong>Define Customized Account Segment:<\/strong> In the BAS_Customized_ACC_Segment table, we define the &#8216;Expense Type&#8217; segment. We create a row with Customized_ACC_Segment_Code = &#8216;ET&#8217;, Customized_ACC_Segment_Name = &#8216;Expense Type&#8217;, and potentially other properties as needed.<\/p>\n<\/li>\n<li class=\"data-line-956\">\n<p><strong>Define Customized Account Segment Values:<\/strong> In the BAS_Customized_ACC_Value table, we define the specific values that the &#8216;Expense Type&#8217; segment can take. Each row represents a possible value. We might create one row with Customized_ACC_Segment_Code = &#8216;ET&#8217;, Customized_ACC_Value_Code = &#8216;OS&#8217;, and Customized_ACC_Value_Name = &#8216;Office Supplies&#8217;, and another row with Customized_ACC_Segment_Code = &#8216;ET&#8217;, Customized_ACC_Value_Code = &#8216;UT&#8217;, and Customized_ACC_Value_Name = &#8216;Utilities&#8217;.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph data-line-958\">\n<p>Now, when creating a journal entry (in the GL_Details table), we can use different &#8216;Expense Type&#8217; values (like &#8216;Office Supplies&#8217; or &#8216;Utilities&#8217;) for the same GL account &#8216;1122&#8217; across different Journal_IDs. In the GL_Details table, we&#8217;d set GL_Account_Number to &#8216;1122&#8217;, and Account_Segment_1 (matching the Account_Segment_Number we used earlier) to &#8216;OS&#8217; or &#8216;UT&#8217; (or another code we&#8217;ve defined), depending on the specifics of the transaction.<\/p>\n<\/div>\n<div class=\"paragraph data-line-960\">\n<p>This setup allows the system to consistently associate the &#8216;Expense Type&#8217; segment with the GL account &#8216;1122&#8217;, while permitting different &#8216;Expense Type&#8217; values to be used in different journal entries. This can provide greater detail and flexibility when it comes to categorizing transactions.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"footer\">\n<div id=\"footer-text\">\nLast updated 2023-06-21 19:57:12 +0900\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Views: 15 Setting Up Account Segments and Customized Account Segment Tables Table of Contents 1. Proposal to S [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":10160,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,72,73],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/10161"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10161"}],"version-history":[{"count":5,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/10161\/revisions"}],"predecessor-version":[{"id":10210,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/10161\/revisions\/10210"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/10160"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}