BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
N=No
Y=Yes
Prompt Table: PSMSGSETDEFN
Prompt Table: PSMSGCATDEFN
Prompt Table: PSMSGSETDEFN
Prompt Table: PSMSGCATDEFN
PI_SCAN_OPT_BU(SQL Table) |
Index Back |
|---|---|
AM - Scan OptionsAM Fluid barcode scanning options (by Business Unit). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | CUSTODIAN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Send To Asset Custodian
N=No Y=Yes |
| 3 | SEND_EMAIL | Character(1) | VARCHAR2(1) NOT NULL | Action Workflow Flag |
| 4 | EMAIL_ADDRESS | Long Character | CLOB NOT NULL | Default Email Address |
| 5 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
| 7 | MESSAGE_SET_NBR2 | Number(5,0) | INTEGER NOT NULL |
Body Message Set
Prompt Table: PSMSGSETDEFN |
| 8 | MESSAGE_NBR02 | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |