| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 3 |
AUC_BUY_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Buy Event Authorization
Y/N Table Edit
Default Value: N
|
| 4 |
AUC_SELL_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Sell Events Authorization
Y/N Table Edit
Default Value: N
|
| 5 |
AUC_RFI_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
RFI Authorization
Y/N Table Edit
Default Value: N
|
| 6 |
AUC_COMP_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Auction Authorization
Y/N Table Edit
Default Value: N
|
| 7 |
AUC_RFX_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
RFx Authorization
Y/N Table Edit
Default Value: N
|
| 8 |
AUC_FORMAT_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Event Format
F=Sell
I=Request For Information
R=Buy
|
| 9 |
AUC_TYPE_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Type Default
E=Auction
S=RFx
|
| 10 |
AUC_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Authorization
Y/N Table Edit
Default Value: N
|
| 11 |
AUC_CANCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Authorization
Y/N Table Edit
Default Value: N
|
| 12 |
AUC_AWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Authorization
Y/N Table Edit
Default Value: N
|
| 13 |
AUC_COPY_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition
Y/N Table Edit
Default Value: N
|
| 14 |
AUC_COPY_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order
Y/N Table Edit
Default Value: N
|
| 15 |
AUC_COPY_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract
Y/N Table Edit
Default Value: N
|
| 16 |
AUC_COPY_EBOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Engineering BOM
Y/N Table Edit
Default Value: N
|
| 17 |
AUC_COPY_MBOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing BOM
Y/N Table Edit
Default Value: N
|
| 18 |
AUC_COPY_PLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Order
Y/N Table Edit
Default Value: N
|
| 19 |
AUC_AWD_ADDTL_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Award more than requested qty
Y/N Table Edit
Default Value: N
|
| 20 |
AUC_EVENT_CONST |
Character(1) |
VARCHAR2(1) NOT NULL |
Event
Y/N Table Edit
Default Value: N
|
| 21 |
AUC_BU_CONST |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
Y/N Table Edit
Default Value: N
|
| 22 |
AUC_GLOBAL_CONST |
Character(1) |
VARCHAR2(1) NOT NULL |
Global
Y/N Table Edit
Default Value: N
|
| 23 |
AUC_PO_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order
Y/N Table Edit
Default Value: N
|
| 24 |
AUC_GENCONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
General Contract
Y/N Table Edit
Default Value: N
|
| 25 |
AUC_SINGRELPOCONT |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Release PO Contract
Y/N Table Edit
Default Value: N
|
| 26 |
AUC_PO_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Contract
Y/N Table Edit
Default Value: N
|
| 27 |
AUC_REC_VCHRCNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Recurring Voucher Contract
Y/N Table Edit
Default Value: N
|