 |
Lawson Insight Technical Documentation |
|
PACOMPPROF FILE
REFERENCED BY
HS50.3 HS50.4 PA08.1 PA207 TR22.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 PA07.1
HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCM-COMPANY Numeric 4 PA07.1
Company The company number represents an
established company and is entered on
all function codes.
PCM-PROCESS-LEVEL Alpha 5 PA07.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PCM-CODE Alpha 10 PA07.1
Code
PCM-TYPE Alpha 2 PA07.1
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
Profic Level
PCM-SEQ Numeric 3 HR04.2 HR04.3
Sequence Number This 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
Status The Active flag of the credit card
type.
A = Active
I = Inactive
PCM-DESCRIPTION Alpha 30 (Lower Case) PA07.1
Description This field displays the description.
PCM-COMMENTS Alpha 50 (Lower Case) PA07.1
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
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
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
User ID Name 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 PA207 TR22.1
PROFIC-LEVEL TR500 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
|