This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by KHanson

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
27 26-Nov-2021 10:22 8 KB kparrott to previous
26 26-Nov-2021 10:22 8 KB JMyers to previous | to last
25 26-Nov-2021 10:22 8 KB JAiken to previous | to last
24 26-Nov-2021 10:22 8 KB JMyers to previous | to last
23 26-Nov-2021 10:22 8 KB JEscott to previous | to last
22 26-Nov-2021 10:22 8 KB JEscott to previous | to last
21 26-Nov-2021 10:22 8 KB JEscott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 3 lines
[{TableOfContents}]
!!!DEFINE GENERAL LEDGER SEGMENTS
[{TableOfContents }] <-- only if tabbed form
!!!GENERAL LEDGER SEGMENTS
[{Image src='IDGS.JPG' width='360' align='right' link='attach/IDGS/IDGS.JPG'}]
At line 8 changed one line
Note that if a single-segment distribution is being used, then no hyphens whatsoever should be present in the format.
The system may ‘validate’ each segment of distribution codes defined on the G/L Company (IDGC) form. You may do this by completing the G/L Segments (IDGS) form for all segments you wish to validate.
At line 10 changed one line
The system may ‘validate’ each segment of distribution codes defined on the G/L Company ([IDGC]) form. You may do this by completing the G/L Segments (IDGS) form for all segments you wish to validate.
Once you define these segments, Personality validates the distribution code via the Distribution Editor button for any forms that invoke this Distribution Editor. For example: Department (IDDP), Job (IDJB), Position (IDPS), Assignment (IEAS), Pay Transaction (IPTR), Pay Lines (IPPH), etc. The distribution button invokes the distribution editor to look-up and choose the appropriate segment codes.
At line 12 removed 4 lines
Once you define these segments, Personality validates the distribution code via the Distribution Editor button for any forms that invoke this Distribution Editor.
For example: Department ([IDDP]), Job ([IDJB]), Position ([IDPS]), Assignment ([IEAS]), Pay Transaction ([IPTR]), Pay Lines ([IPPH]), etc. The distribution button invokes the distribution editor to look-up and choose the appropriate segment codes.
At line 13 added one line
‘Define General Ledger Segments’ Usage and Examples
At line 18 changed 2 lines
General Ledger Segments data is stored in the [P2K_CM_GL_SEGMENTS] and the [P2K_CM_GL_SEGMENT_VALUES] table.
General Ledger Segments data is stored in the [P2K_CM_GL_SEGMENTS] and the [P2K_CM_GL_SEGMENTS_VALUES] table.
At line 23 changed 23 lines
----
!!Input (Segments 1 Thru 10) tab
;[Segment | SEGMENT_NUMBER]:This is the sequential order of the segments. Maximum of ten segments may be defined numbered between 1 through 10.
;:i.e. Distribution code: 1234-56-789
;:Segment 1 is digits 1234
;:Segment 2 is digits 56
;:Segment 3 is digits 789
;[Start At | FIELD_START_BYTE]:This is the starting position of the segment. It does not count ‘-’ or ‘.’ as a position
;:i.e. Distribution code: 1234-56-789
;:Segment 1starts at position 1
;:Segment 2 starts at position 5
;:Segment 3 starts at position 7
;[Length | VALUE_LENGTH]:This is the number of characters of the segment.
;:i.e. Distribution code: 1234-56-789
;:Segment 1 starting at position 1 has a length of 4(1234)
;:Segment 2 starting at position 5 has a length of 2(56)
;:Segment 3 starting at position 7 has a length of 3(789)
;[Name | DESCRIPTION]:This field displays the name of the segment highlighted. e.g. Company, Division, Department, Fund,
;[Prompt | FIELD_PROMPT]:When the Distribution Editor button is invoked on various forms (e.g. [IDDP], [IDPS], [IDJB], [IEAS], [IPTR], [IPPH], etc.), this value in this field is used as a side label for the segment to be entered.
[{Image src='IDGS_INPUT.JPG' width='360' align='right' link='attach/IDGS/IDGS_INPUT.JPG'}]
!!INPUT (SEGMENTS 1 THRU 10)
;[Start At | FIELD_START_BYTE]:This is the starting position of the segment. It does not count ‘-’ or ‘.’ as a position i.e. Distribution code: 1234-56-789
Segment 1starts at position 1
Segment 2 starts at position 5
Segment 3 starts at position 7
;[Length | VALUE_LENGTH]:This is the number of characters of the segment. i.e. Distribution code: 1234-56-789
Segment 1 starting at position 1 has a length of 4(1234)
Segment 2 starting at position 5 has a length of 2(56)
Segment 3 starting at position 7 has a length of 3(789)
;[Name | DESCRIPTION]:This field displays the name of the segment highlighted.
e.g. Company, Division, Department, Fund,
;[Prompt | FIELD_PROMPT]:When the Distribution Editor button is invoked on various forms (e.g. IDPP, IDPS, IDJB, IEAS, IPTR, IPPH, etc.), this value in this field is used as a side label for the segment to be entered.
At line 47 changed 3 lines
;:9 for a numeric
;:a for an alpha character
;:x for any alphanumeric character
9 for a numeric
a for an alpha character
x for any alphanumeric character
At line 51 changed one line
;[Must Validate | MUST_VALIDATE]:If the toggle is ON, then the segment, at the distribution level, will be validated against the information defined in the ‘GL Valid Value’ list in the form below.
;[Must Validate | VALIDATION_ONLY]:If the toggle is ON, then the segment, at the distribution level, will be validated against the information defined in the ‘GL Valid Value’ list in the form below.
At line 54 changed 5 lines
;[Description | DESCRIPTION]:If desired, a description of the segment may be entered. This may aid users in determining the values they require. If the Must Validate toggle is turned on, then this description will be shown on the list of values, as well as shown beside the value selected, on the Distribution Editor. If the Must Validate toggle is not on, then this description is not shown on the Distribution Editor.
----
!!Validate tab
;[Description | DESCRIPTION]:If desired, a description of the segment may be entered. This may aid users in determining the values they require.
If the Must Validate toggle is turned on, then this description will be shown on the list of values, as well as shown beside the value selected, on the Distribution Editor. If the Must Validate toggle is not on, then this description is not shown on the Distribution Editor.
!Section He[{Image src='IDGS_VALIDATE.JPG' width='360' align='right' link='attach/IDGS/IDGS_VALIDATE.JPG'}]
!!VALIDATE
At line 64 changed 2 lines
You may set up validation for different combinations within the predefined segments. For example: You have defined your distribution mask as ????-??-??? (Division - Cost Center- Account). You would like to indicate that there are only certain accounts that work with certain cost centers.
Those cost centers are defined by the last three numbers in the cost center segment. Once those three numbers are defined, you will have a selection of accounts defined by the entire account segment.
You may set up validation for different combinations within the predefined segments. For example: You have defined your distribution mask as ????-??-??? (Division - Cost Centre- Account). You would like to indicate that there are only certain accounts that work with certain cost centres.
Those cost centres are defined by the last three numbers in the cost centre segment. Once those three numbers are defined, you will have a selection of accounts defined by the entire account segment.
At line 73 changed 7 lines
;:Unit 11 is digits 123456
;:Unit 12 is digits 56789
;:Unit 13 is digits 345678
;[From | FIELD_START_BYTE]:This is the starting position of the unit. Characters such as ‘-’ or ‘.’ are NOT considered positions. For example, if the original G/L segment is 1234-56-789, then:
;:Unit 11 starts at position 1
;:Unit 12 starts at position 5
;:Unit 13 starts at position 3
Unit 11 is digits 123456
Unit 12 is digits 56789
Unit 13 is digits 345678
;[From | FIELD_START_BYTE]:This is the starting position of the unit. Characters such as ‘-’ or ‘.’ are NOT considered positions.
For example, if the original G/L segment is 1234-56-789, then:
Unit 11 starts at position 1
Unit 12 starts at position 5
Unit 13 starts at position 3
At line 81 changed 3 lines
;:Unit 11 starting at position 1 has a length of 6 (1234-56)
;:Unit 12 starting at position 5 has a length of 5 (56-789)
;:Unit 13 starting at position 3 has a length of 6 (34-56-78)
Unit 11 starting at position 1 has a length of 6 (1234-56)
Unit 12 starting at position 5 has a length of 5 (56-789)
Unit 13 starting at position 3 has a length of 6 (34-56-78)
At line 85 changed one line
;[G/L Valid Value | GL_VALID_VALUE]:The actual valid unit value to be compared to what the user may be entering as a distribution code. For example, if the only valid value for a specific unit is 1235-6?-???, input 12356 in this field.
;[G/L Valid Value | GL_VALID_VALUE]:The actual valid unit value to be compared to what the user may be entering as a distribution code.
For example, if the only valid value for a specific unit is 1235-6?-???, input 12356 in this field.
At line 87 removed 5 lines
----
![Notes|Edit:Internal.IDGS]
[{InsertPage page='Internal.IDGS' default='Click to create a new notes page'}]