This table lists all of the available interface components: This section describes the available real-time events associated with the Account Master, business object which includes the RTAMOUT event. This code is not valid for budget entry programs. Values are: L: Subledger and type are required for all transactions. Subject: [jdedwards-l] Data Tables in JDE. Enter a word or string of characters to search for an account. The Refresh Chart of Accounts program can take a long time to run, especially if you revise a substantial number of accounts or have a large chart of accounts. "Understanding the Alternate Chart of Accounts for France" in the JD Edwards EnterpriseOne Applications Localizations for France Implementation Guide. For example, if you wanted to search for an account that contains the words accounts payable, you could enter Accts Pay, Accts, A, P, or A/P. View different levels of detail in other JD Edwards EnterpriseOne inquiry programs. If the object account is six digits, you should use all six digits. Do not enter any data selection for the report. 8 (with separator) characters for the subsidiary account. You define the document types that qualify as adjustment entries in UDC table 09/AA. For flexible account numbers, you can define up to six segments and use a total of 12 characters for the business unit. C: Consolidated business unit or account. Before you can use subledgers, you must decide which subledger types to use. Can anybody please provide me a list of data tables used in Accounts Receivale, Accounts Payable and General Ledger module of JDE E1 8.12. Before you can use the Account Master Word program (P0901WS), you must build the Account - Word Search table (F0901WS). Subledgers do not create additional records in the Account Master table (F0901). Review accounts, delete accounts, and print reports. WIN (winter): Spread according to user-specified percentages. 7: Petty Cash - Corporate, Petty Cash - Branch, and so on. Figure 7-3 Revise Accounts by Business Unit form. Values are: Blank: Non-model business unit or account. The user can create an alternate description for this account by language preference that is stored in the Account Master - Alternate Description (F0901D) table. Posts subledgers in detailed format for every account. This list includes the real-time events for the Account Master business object: D0900170B: GL Account Real Time Event Notification Outbound Data. For example, the Account Master Word program is already set to ignore A, About, and After. To print a report, select Chart of Accounts from the Report menu. Select Organization & Account Setup (G09411), Online Chart of Accounts. You might use the third GL account number as an alternative way of entering account numbers when you enter data. Other reasons why you might use the third GL account number include: Facilitate account recoding during the year. You specify the category code in the processing options. Depending on your organizational structure, you can create more than one model chart of accounts. SUM (summer): Spread according to user-specified percentages. The individual elements must be greater than zero and must not exceed: 12 (with separator) characters for the business unit. If you add an account with the same object and subsidiary as an existing account but with a different description or level of detail, the Refresh Chart of Accounts program retains the first occurrence of the object and subsidiary only for the chart of accounts. You supply the account number and it edits and returns the components and description. To print the Chart of Accounts Report (R0909P), select Chart of Accounts from the Report menu. 0. Before you complete the tasks in this section, you must verify that the model business unit from which you want to copy is accurate. Assign the third GL account number to an account. To assign a subledger posting edit code to multiple accounts that require subledgers, select Account by BU or Account by Obj/Sub from the Row menu on the Work With Accounts form. On the Work With Accounts form, select an account and from the Row menu, select Account by BU. You can assign one or more alternate account numbers to category codes 21, 22, and 23 (UDC 09/21–09/23). This check box allows you to post adjusting entries for journal allocations, reburdening, and so on, to accounts that might otherwise be closed for regular transactions. Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.700 and later: JDE Data Load Fails with Table Errors - Demand generation failed for JDE Data Load Fails with Table Errors - Demand generation failed for COMPTBLE-XXXX.F0901 B: Only allows posting to budget ledger types starting with B or J. L: Subledger and type are required for all transactions. Understanding the Setup Requirements for Automatic Receipts Processing. F0101, F03B11,f04B11 F0901,F0911, etc) in a datasheet view. "F0901 Edit Account Number". All or a range of object accounts to a specific company or across all companies. The translation of account descriptions enables you to see the translated account descriptions only on reports or when you access an inquiry program. If the program finds errors, it: Access the Copy Accounts to Business Units form. This process saves time and ensures consistency throughout your account structure. If you want to report on subledgers, use this code. "Understanding the Alternate Chart of Accounts for Spain" in the JD Edwards EnterpriseOne Applications Localizations for Spain Implementation Guide. Copying the model reproduces any errors in multiple business units. Before you complete the tasks in this section, you must run these integrity reports to verify the integrity of your data before you make any changes: To move a business unit or an account within the structure, drag the business unit or account to the new location and drop it. Access the Revise Accounts by Business Unit form. You add account 1.5005.WEST with a description of Sales - Western Region. The below code gets me very close to the hierarchy but does not quite match...any suggestions? Fields that you can protect are: Enter a number used to summarize and classify accounts in the GL. Specify the mode in which to run the report. Enter a code that controls GL posting and account balance updates in the F0901 table. The Adjustment Entry check box or field appears in these programs: Account Master Search (Return Account ID) (P0901SA). To have old balances correspond with the new account numbers, you must run the Update Business Unit.Object.Subsidiary to Account Balances program. Enter a code from UDC table 00/MC that identifies the classification of the business unit. If an account is deleted, the pertinent information is sent to the third-party, which will take the appropriate action. Subledgers can create additional records in the Account Balances table (F0902), depending on the posting edit code that you assign to the account. Because these subledger types are not validated against any JD Edwards EnterpriseOne tables, you should define them only if you want the system to validate values against a format requirement rather than a specific value. Column . You might want to change the description of the account or include additional information, particularly additional lines for a business unit description. All accounts in which the digit matches are rolled together. 7.2.1.2 Account Inactivation. Validates against the Address Book Master table (F0101). Enter a code that controls GL posting and account balance updates in the Account Master table (F0901).