ACV_NODE_LINE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ACV_NDTPL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node Template ID |
| 2 | ACV_ND_VIEW_NAME |
Character(16) | VARCHAR2(16) NOT NULL | Node View Name |
| 3 | ACV_ZOOM_LEVEL |
Number(2,0) | SMALLINT NOT NULL | Zoom Level |
| 4 | ACV_ND_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 5 | ACV_ND_LINE_SEQ | Number(3,0) | SMALLINT NOT NULL | Line Sequence Number |
| 6 | ACV_NDFLD_TYPE_1 | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
A=Related Actions F=Data Field H=Header L=Label V=Value |
| 7 | ACV_NDFLD_ID_1 | Character(8) | VARCHAR2(8) NOT NULL |
Data Field ID
Prompt Table: %EDITTABLE2 |
| 8 | ACV_ND_STRING_1 | Character(128) | VARCHAR2(128) NOT NULL | String Value |
| 9 | ACV_NDFLD_ALIGN_1 | Character(1) | VARCHAR2(1) NOT NULL |
Field Alignment
L=Left R=Right Default Value: L |
| 10 | ACV_NDFLD_TYPE_2 | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
A=Related Actions F=Data Field H=Header L=Label V=Value |
| 11 | ACV_NDFLD_ID_2 | Character(8) | VARCHAR2(8) NOT NULL |
Data Field ID
Prompt Table: %EDITTABLE2 |
| 12 | ACV_ND_STRING_2 | Character(128) | VARCHAR2(128) NOT NULL | String Value |
| 13 | ACV_NDFLD_ALIGN_2 | Character(1) | VARCHAR2(1) NOT NULL |
Field Alignment
L=Left R=Right Default Value: R |