PCODESTYPE FILE
REFERENCED BY
HR04.2 HR204 PA532
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCS-TYPE Alpha 2
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.
PCS-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
PCS-ACTIVE-FLAG Alpha 1
Status The Active flag of the credit card
type.
A = Active
I = Inactive
PCS-SETUP-FLAG Alpha 1
Setup Flag N = No
Y = Yes
PCS-DEFN-PROGRAM Alpha 5
Define Program The Data Mart Setup Program field
contains the name of the program that
provides the dimensions, members, and
data selection parameters required by
the data mart.
PCS-COMMENTS Alpha 50 (Lower Case)
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.
PCODESTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCSSET1 TYPE HR04.2 HR204
PA532
PCSSET2 DESCRIPTION KeyChange, Subset HR04.2
TYPE Where (ACTIVE-FLAG = "A" )
And (SETUP-FLAG = "Y" )
PCODESTYPE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pcodes PCODES Delete Cascades
PCS-TYPE -> PCO-TYPE
PCO-CODE
Pcodesdtl PCODESDTL Delete Cascades
PCS-TYPE -> PDD-TYPE
PDD-CODE
|
