TAB_NBRBI_TAB_FLDFIELDNUM00=Folder Tab
01=Edit Box
02=Radio Button
03=Push Button
04=Hyperlink
05=Check Box
06=Drop Down List Box
07=Image
B=Both
N=No
Y=Yes
BI_LNFLD_CFG(SQL Table) |
Index Back |
|---|---|
Bill Line Grid Field ConfigBill Line Grid Field Configuration Meta Data Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAB_NBR |
Number(3,0) | SMALLINT NOT NULL | Tab Number |
| 2 | BI_TAB_FLD |
Character(30) | VARCHAR2(30) NOT NULL | Tab Name |
| 3 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 4 | BI_FIELD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Field type
00=Folder Tab 01=Edit Box 02=Radio Button 03=Push Button 04=Hyperlink 05=Check Box 06=Drop Down List Box 07=Image |
| 5 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | BI_ELEMENT_LABEL | Character(80) | VARCHAR2(80) NOT NULL | Page element label. |