Lawson Insight Technical Documentation |
|
PACOMPPROF
PACOMPPROF FILE
REFERENCED BY
HS50.3 HS50.4 PA08.1 PA20.1 PA207 PA21.1
PA22.1 PA24.1 PA27.1 PA34.1 PA35.1 PA36.1
PA38.1 PA520 TR21.1 TR22.1 TR26.1 TR500
UPDATED BY
HR04.2 HR04.3 HR04.7 HR04.8 HR80.1 HR80.2
HR80.3 HR80.4 HR80.5 HR80.6 HR80.7 HR80.8
HR80.9 HR81.1 HR81.2 HR81.3 HR81.4 HR81.5
HR81.6 HR81.7 HR81.8 HR81.9 HR82.1 HR82.2
HR82.3 HR82.4 HR82.5 HR82.6 HR82.7 HR82.8
HR82.9 HR83.1 HR83.2 HR83.3 HR83.4 HR83.5
HR83.6 HR83.7 HR83.8 HR83.9 HR84.1 HR84.2
HR84.3 HR84.4 HR84.5 HR84.6 HR84.7 HR84.8
HR84.9 HR85.1 HR85.2 HR85.3 HR85.4 HR85.5
HR85.6 HR85.7 HR85.8 HR86.1 HR86.2 HR86.3
HR86.4 HR86.5 HR86.6 HR86.7 HR86.8 HR86.9
HR87.1 HR87.2 HR87.3 HR87.4 HR87.5 HR87.6
HR87.7 HR87.8 HR87.9 HR88.1 HR88.2 HR88.3
HR88.4 HR88.5 HR88.6 HR88.7 HR89.1 HR89.2
HR89.3 HR89.4 HR89.5 HR89.6 HR89.7 HR89.8
HR89.9 PA07.1 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCM-COMPANY Numeric 4 PA07.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PCM-PROCESS-LEVEL Alpha 5 PA07.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PCM-CODE Alpha 10 PA07.1
Element: Code Code that is valid for the specified
record type.
PCM-TYPE Alpha 2 PA07.1
Element: Type This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
DF = Default
AB = Abilities
KN = Knowledge
OA = Other Attributes
SK = Skills
PCM-PROFIC-LEVEL Alpha 10 PA07.1
Element: Profic Level
PCM-SEQ Numeric 3 HR04.2 HR04.3
Element: Sequence NumbeThis field contains the record sequence HR04.7 HR04.8
number. HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PCM-ACTIVE-FLAG Alpha 1 PA07.1
Element: Status The Active flag of the credit card
type.
A = Active
I = Inactive
PCM-DESCRIPTION Alpha 30 (Lower Case) PA07.1
Element: Description This field displays the description.
PCM-COMMENTS Alpha 50 (Lower Case) PA07.1
Element: Comments This field contains the text you enter
for the comment to be associated with an
asset. You can have multiple lines of
comments for each comment type.
PCM-DATE-STAMP Numeric 8 (yyyymmdd) PA07.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PCM-TIME-STAMP Numeric 6 (hhmmss) PA07.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PCM-USER-ID Alpha 10 (Lower Case) PA07.1
Element: User Contains the user ID of the person who
last changed this record.
PACOMPPROF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCMSET1 COMPANY HR00.1 HR01.1
PROCESS-LEVEL HS50.3 HS50.4
TYPE PA07.1 PA08.1
CODE PA20.1 PA207
PROFIC-LEVEL PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 PBIP.1
PR197
PCMSET2 PROFIC-LEVEL HR04.2 HR04.3
COMPANY HR04.7 HR04.8
PROCESS-LEVEL HR80.1 HR80.2
TYPE HR80.3 HR80.4
CODE HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
...
PCMSET3 CODE KeyChange HR04.2 HR04.3
TYPE HR04.7 HR04.8
COMPANY HR80.1 HR80.2
PROCESS-LEVEL HR80.3 HR80.4
SEQ HR80.5 HR80.6
PROFIC-LEVEL HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
...
PCMSET4 COMPANY KeyChange HR04.2 HR04.3
PROCESS-LEVEL HR04.7 HR04.8
TYPE HR80.1 HR80.2
CODE HR80.3 HR80.4
SEQ HR80.5 HR80.6
PROFIC-LEVEL HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
...
PACOMPPROF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PCM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Hr Codes PCODES Required
When (PCM-TYPE != "DF" )
PCM-TYPE -> PCO-TYPE
PCM-CODE -> PCO-CODE
Process Level PRSYSTEM Required
When (PCM-PROCESS-LEVEL != Spaces )
PCM-COMPANY -> PRS-COMPANY
PCM-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Proficiency PCODES Required
"PF" -> PCO-TYPE
PCM-PROFIC-LEVEL -> PCO-CODE
|