SS_FORMAT_SVW(SQL View) |
Index Back |
---|---|
Sourcing Event Format XLAT |
SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'AUC_FORMAT' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
2 | AUC_FORMAT_TXT | Character(30) | VARCHAR2(30) NOT NULL | Event Format |