The GLDetail table links GLSource records to GLControl records.
The following diagram illustrates the mapping relationship between the three tables. With this example, the lone Division record within GLSource links to all four GLControl records.
Figure 13:GLDetail link relationships
Use the table below to assist in creating GL Detail
records.
|
Field |
Description |
|
GLDPriKey |
This is the table identifier set and maintained internally by the application. |
|
GLCPriKey |
Link this record to a key value for a control record set in the GLControl table (GLCPriKey). |
|
GLSPriKey |
Link this record to a key value for a source record set in GLSource Setup (GLCPriKey). |
|
SegmentNumber |
Enter a number that corresponds to a sequenced section in the general ledger number. |
|
SegmentLength |
Enter the number digits that correspond to the length of the segment. For Divisions, this value cannot exceed the length of the GLCode field value in Division Setup. |