GPBR_LAYOUT_IDGPBR_ROW_SEQUENCEDefault Value: 0
Default Value: 0
D=Detail
H=Header
T=Trail
Default Value: H
Default Value: GPBR_LAYOUT_ROW.DESCR50
Default Value: 1
Prompt Table:
QRY_NAME_VW
Set Control Field: QRYNAME
GPBR_LAYOUT_ROW(SQL Table) |
Index Back |
|---|---|
Layout row definitionsLayout row definitions for brazilian file reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_LAYOUT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Layout identificator. |
| 2 | GPBR_ROW_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | Row sequence in the layout. |
| 3 | GPBR_ROW_DEP_ON | Number(3,0) | SMALLINT NOT NULL |
Row length given in characters
Default Value: 0 |
| 4 | GPBR_ROW_LENGTH | Number(3,0) | SMALLINT NOT NULL |
Row length given in characters
Default Value: 0 |
| 5 | GPBR_ROW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
RowType
D=Detail H=Header T=Trail Default Value: H |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: GPBR_LAYOUT_ROW.DESCR50 |
| 8 | GPBR_REPR_TIMES | Number(2,0) | SMALLINT NOT NULL |
Number of times a row is reproduced within a layout file.
Default Value: 1 |
| 9 | GPBR_QRY_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Query name
Prompt Table:
QRY_NAME_VW
|