SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SETID_TBL
AUC_COMPANY_NAMEAUC_COMPANY_VW(SQL View) |
Index Back |
|---|---|
Registered Company view |
| SELECT DISTINCT SETID , AUC_COMPANY_NAME FROM PS_AUC_BIDDER_HDR WHERE EFF_STATUS = 'A' AND APPROVAL_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
| 2 | AUC_COMPANY_NAME |
Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |