FIELDNAMEPYMNT_PRNT_VW5(SQL View) |
Index Back |
|---|---|
Payment Sort Fields Definition |
| select a.fieldname, b.length, a.fieldnum, b.fieldtype from psrecfield a, PSDBFIELD b where a.recname = 'PYMNT_FLDS_VWS' AND b.fieldname = a.fieldname |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | PRINT_LENGTH | Number(5,0) | INTEGER NOT NULL | Print Length |
| 3 | FIELD_SEQUENCE | Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 4 | PRINT_FIELD_TYPE | Number(2,0) | SMALLINT NOT NULL | Print Field Type |