A register table is a table of contents for its corresponding ledger table or tables. One record exists for each posting process. The register table corresponds closer to the posting routine instead of the application area.
For example, the table that contains the list of entries that are made to the Cust. Ledger Entry table is the G/L Register table because the customer ledger entries are posted from General Journal by using the general ledger posting procedures. The register table is related to its corresponding ledger table or tables.
Register table names
Register tables are named according to the posting function followed by the word register. Therefore, the register table that is updated by the general ledger posting function is named G/L Register. Users can't change the register table.
Primary key and other standard fields
The primary key of a register table is an integer field named No. The primary key is always automatically incremented by one by the posting routine that controls the register. Other standard fields for the register table include:
From Entry No. and To Entry No. - Integer fields that are related to the corresponding ledger table.
Creation Date - Field that specifies the date when the transaction was posted.
User ID - Field that specifies which user has posted the transaction.
Source Code - Field that indicates the source of the transaction.
Journal Batch Name - Field that indicates the journal from which the transaction was posted.
Typically, register tables don't have description fields.
Associated pages
A list page is used to view the records in the register table. The name of the page is the plural of the name of the register table. Therefore, the page that is used to display records from the G/L Register table is named G/L Registers. The list page contains action links to other list pages that display the corresponding ledger entries.
red hat certified system administrator rhcsa malaysia
