REASON_CDSUPOB_ADTRL_RCD(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.REASON_CD ,A.AUC_COMPANY_NAME FROM PS_SUP_OB_ADT_TL_V A WHERE REASON_CD <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REASON_CD |
Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 2 | AUC_COMPANY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |