AUTHORIDTYPE2=User
3=Role
USERID_ROLENAMEPI_FLD_DISP_TYPEFND=Find Asset
LOC=Scan By Location
PHY=Physical Inventory
SCN=Scan Asset
FIELD_NUMFIELDNAMEDefault Value: Y
Default Value: N
PI_SCAN_OPT_FLD(SQL Table) |
Index Back |
|---|---|
AM - Scan OptionsAM Fluid barcode scanning options for controlling field display for scanners. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUTHORIDTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Author ID Type
2=User 3=Role |
| 2 | USERID_ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table |
| 3 | PI_FLD_DISP_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Display Fields
FND=Find Asset LOC=Scan By Location PHY=Physical Inventory SCN=Scan Asset |
| 4 | FIELD_NUM |
Number(3,0) | SMALLINT NOT NULL | Field Num |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | PI_SCAN_SHOW_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Show Field
Default Value: Y |
| 7 | PI_SCAN_ENABLE_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Allow Field Edit
Default Value: N |