| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ST_LEVEL_DISPLAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Storage Level Display
0=No Levels
1=One Level
2=Two Levels
3=Three Levels
4=Four Levels
Default Value: 4
|
| 5 |
CUBIC_CHK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/10/1999 whs - added
Y/N Table Edit
Default Value: N
|
| 6 |
WEIGHT_CHK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/10/1999 whs - added
Y/N Table Edit
Default Value: N
|
| 7 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 8 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 9 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 10 |
LOC_ACCTG_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Accounting Required
Y/N Table Edit
Default Value: N
|
| 11 |
FERC_CD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FERC Reporting
Y/N Table Edit
Default Value: N
|
| 12 |
UOM_CONV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
UOM Conversion Flag
0=Use Entered UOM
1=Convert to Standard UOM
2=Convert to Default Stock UOM
Default Value: INSTALLATION_IN.UOM_CONV_FLAG
|