|
 | GL00100 | Account Master |
|
This table contains nonfinancial information about account numbers.
Required fields:
Account Number
Account Index
Main Account Segment
Account Type
Account Description
Posting Type
Account Category Number
Active
Typical Balance
Decimal Places
Fixed Or Variable
Balance For Calculation
Display In Lookups
Post Sales In
Post Inventory In
Post Purchasing In
Post Payroll In
Comments:
The following fields are assigned values only for specific account types:
Typical Balance: posting accounts only
Decimal Places: unit accounts only
Fixed Or Variable: allocations only
Balance For Calculation: variable allocations only.
|
| | GL00100F1 | Account Master Filter1 |
|
|
| | GL00100F2 | Account Master Filter2 |
|
|
| | GL00100F3 | Account Master Filter3 |
|
|
| | GL00100F4 | Account Master Filter4 |
|
|
| | GL00102 | Account Category Master |
|
|
| | GL00103 | Fixed Allocation Master |
|
|
| | GL00104 | Variable Allocation Master |
|
|
| GL00105 | Account Index Master |
|
This table stores all Account Index fields for each account number to insure data integrity should an account record be damaged in the Account Master table. For each record in the Account Master table, there is a corresponding record in the Account Index Master table.
Comments:
All non-GL modules instead of the full-sized account number to store the Account Index conserve data space. Should an account record be removed from the Account Master table, a check link can be run on the Account Master table and the Account Index Master table will be used to restore the connection between the Account Number and Account Index fields. This will insure greater data integrity and prevent the loss of account number links in subsidiary modules.
|
| | GL00200 | Budget Master |
|
The easiest method is to create the budget ID in the budget maintenance window (but adding no accounts) then to import to the Budget Summary Master. Accounts with a typical credit balance would import budget figures as negative to show correctly on financial statements.
Note: the Account Summary Master is no longer used for importing Budget data; the summary information is contained in the Budget Summary Master.
|
| | GL00201 | Budget Summary Master |
|
|
|
|
|
| GL10000 | Transaction Work |
|
Physical Name: GL10000
Display Name: Transaction Work
This table contains transaction header information for transactions entered in transaction and clearing entry windows in General Ledger. Line detail is stored in the GL_TRX_LINE_WORK table for transactions and the GL_TRX_Clearing_WORK table for clearing transactions.
Required fields:
Batch Number
Batch Source
Journal Entry
Source Document
Reference
TRX Date
Reversing Date
Balance For Calculation
Posting Status
Transaction Type
Series
Ledger ID
Optional:
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro Triangulation.
Document Date
Comments:
The following fields are assigned values only for specific transaction types:
Reversing Date: reversing transactions only
Balance For Calculation: clearing transactions only
The following fields are used to store transaction information when posting transactions from subsidiary modules to General Ledger:
DTA Control Number
DTA TRX Type
DTA Index
Originating Posted Date
Originating TRX Source
|
| GL10001 | Transaction Amounts Work |
|
Physical Name: GL10001
Display Name: Transaction Amounts Work
This table contains line information for transactions entered in transaction entry windows in General
Ledger.
Required fields:
Batch Number
Journal Entry
Sequence Line
Account Index
Debit Amount
Credit Amount
Optional:
Originating Credit Amount
Originating Debit Amount
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro Triangulation.
|
| | GL10002 | Transaction Clearing Amounts Work |
|
|
| | GL10100 | Quick Journal Work |
|
|
| | GL10101 | Quick Journal Amounts Work |
|
|
| | GL10110 | Account Current Summary Master |
|
|
| | GL10111 | Account Summary History |
|
This table displays period balances by Account Number.'
|
| | GL10300 | General Ledger Tax Work |
|
|
| | GL11000 | GL Distribution Register Temporary |
|
|
| | GL12000 | Budget Transaction Work |
|
|
| | GL12001 | Budget Transaction Amounts Work |
|
|
|
| |
| GL20000 | Year-to-Date Transaction Open |
|
|
| | GL20001 | |
|
|
|
|
| GL30000 | Account Transaction History |
|
|
| | GL30001 | |
|
|
| | GL32000 | Budget Transaction History |
|
|
|
| |
| | GL00100W | |
|
|
| | GL00105W | |
|
|
| | GL10110W | |
|
|
| | GL40000 | General Ledger Setup |
|
|
| | GL40001 | Reporting Ledger Setup |
|
|
| | GL40100 | Quick Journal Setup |
|
|
| | GL40101 | Quick Journal Account Setup |
|
|
| | GL40200 | Segment Description Master |
|
|
| | GL40300 | Posting Numbers Setup |
|
|
| | GL40400 | GL_Reconcile_Module_Accounts_SETP |
|
|
| | GL40401 | |
|
|
| | GL40402 | |
|
|
| | GL50010 | General Ledger Period Header Temporary |
|
|
| | GL50011 | General Ledger Period Temporary |
|
|
| | GL50102 | Audit Trail Code Temporary |
|
|
| | GL50400 | Period Consolidation Activity |
|
|
| | GL50500 | |
|
|
| | GL50501 | |
|
|
| | GL50502 | |
|
|
| | GL50503 | |
|
|
| | GL50504 | |
|
|
| | GL50505 | |
|
|
| | GL50506 | |
|
|
| | GL50507 | |
|
|
| | GL50508 | |
|
|
| | GL70500 | General Ledger Report Options |
|
|
| | GL70501 | General Ledger Report Options Temporary |
|
|
|