AVN_NODE_LINE(SQL Table) |
Index Back |
---|---|
Node Line |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Node Template ID | |
2 | Character(16) | VARCHAR2(16) NOT NULL | Node View Name | |
3 | Number(2,0) | SMALLINT NOT NULL | Zoom Level | |
4 | 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 |