FIN_MBL_TYPE(SQL Table) |
Index Back |
|---|---|
Mobile Approval Trans/TypesMobile Approval Trans/Types |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Transaction or Type ID | |
| 2 | FIN_MBL_ITEM_NAME | Character(30) | VARCHAR2(30) NOT NULL | Transaction or Type name |
| 3 | FIN_MBL_ITEM_HNDLR | Character(254) | VARCHAR2(254) NOT NULL | Transaction or Type data handler app class |
| 4 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: EOAWPACKAGE_VW |
| 5 | FIN_MBL_IMG_LARGE | Character(254) | VARCHAR2(254) NOT NULL | Large image |
| 6 | FIN_MBL_IMG_MEDIUM | Character(254) | VARCHAR2(254) NOT NULL | Medium size image |
| 7 | FIN_MBL_IMG_SMALL | Character(254) | VARCHAR2(254) NOT NULL | Small image |
| 8 | FIN_MBL_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 9 | FIN_MBL_SHOW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Included/shown indicator
Y/N Table Edit Default Value: N |
| 10 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 11 | HMAP_INCL_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Include in Fluid
Y/N Table Edit Default Value: N |
| 12 | HMAP_MASS_APPR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Approvals
Y/N Table Edit Default Value: N |
| 13 | HMAP_ITEM_GRP_ID | Character(8) | VARCHAR2(8) NOT NULL |
Transaction or Type ID
Prompt Table: HMAP_ITEM_GROUP |
| 14 | EOAW_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Approve
Y/N Table Edit Default Value: Y |
| 15 | EOAW_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Deny
Y/N Table Edit Default Value: N |
| 16 | EOAW_PUSHBACK | Character(1) | VARCHAR2(1) NOT NULL |
Pushback
Y/N Table Edit Default Value: N |
| 17 | EOAW_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold
Y/N Table Edit Default Value: N |
| 18 | EOAW_REQUESTINFO | Character(1) | VARCHAR2(1) NOT NULL |
Request Information
Y/N Table Edit Default Value: N |
| 19 | EOAW_REQCOMM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Require Comments for fluid approval deny action
Y/N Table Edit Default Value: N |
| 20 | EOAW_SHOWTERM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show terminated transactions in fluid approval flag
Y/N Table Edit Default Value: N |