RECNAMEFIELDNAMEECRECFIELD_VW | |
View: PS_ECRECFIELD_VW |
| Platform | View Text |
|---|---|
| Default | SELECT A.RECNAME , A.FIELDNAME , B.FIELDTYPE , A.FIELDNUM , B.LENGTH , B.DECIMALPOS , C.LONGNAME , C.SHORTNAME , A.SUBRECORD , A.DEFFIELDNAME FROM PSRECFIELD A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAMe AND B.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1 |
| PeopleSoft Field Name | Description |
|---|---|
| RECNAME | Record (Table) Name |
| FIELDNAME | Field Name |
| FIELDTYPE | Field Type |
| FIELDNUM | Field Number |
| LENGTH | Length |
| DECIMALPOS | Decimal Positions |
| LONGNAME | Long Name |
| SHORTNAME | Field Short Name |
| SUBRECORD | Sub Record |
| DEFFIELDNAME | Default Field Name |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |