| # |
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:
SP_SETID_NONVW
|
| 2 |
CHNG_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Template
Prompt Table:
CHG_TMPLT_CT_VW
|
| 3 |
CNTRCT_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Autonumbering
Y/N Table Edit
Default Value: N
|
| 4 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURR_TXN_VW
|
| 5 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 6 |
MSTR_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Master Contracts
Y/N Table Edit
Default Value: N
|
| 7 |
TOL_AMT_OVER |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Tolerance Over
|
| 8 |
TOL_AMT_UNDER |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Tolerance Under
|
| 9 |
TOL_PCT_OVER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percentage Tolerance Over
|
| 10 |
TOL_PCT_UNDER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percentage Tolerance Under
|
| 11 |
TRACK_CHGS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Track changes on contract
Y/N Table Edit
Default Value: N
|
| 12 |
VERSION_CTRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Version control on contract
Y/N Table Edit
Default Value: N
|
| 13 |
REASON_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Type
Default Value: 34
|
| 14 |
REASON_CD_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason Code
N=None
O=Optional
R=Required
Y/N Table Edit
Default Value: N
|
| 15 |
DFLT_REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Reason Code
Prompt Table:
CNTRCT_CHGRN_VW
|
| 16 |
COMMENT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments Required
Y/N Table Edit
Default Value: N
|
| 17 |
DRAFT_CHGS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Track changes flag
Y/N Table Edit
Default Value: N
|
| 18 |
DISPLAY_GLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow GLN Display
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 19 |
GRP_CTRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Link to Multiple Groups
Y/N Table Edit
Default Value: Y
|
| 20 |
GRP_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Contracts
Y/N Table Edit
|
| 21 |
SP_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Purpose Contracts
Y/N Table Edit
|
| 22 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 23 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW
|
| 24 |
MFG_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
|
| 25 |
DST_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Distributor Contract
Y/N Table Edit
|
| 26 |
CTRL_TYPE_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: Y
|
| 27 |
CTRL_BU_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: Y
|
| 28 |
CTRL_BU_MARKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 29 |
CTRL_TYPE_CDOM |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 30 |
CTRL_CDOM_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 31 |
CTRL_CDOM_MARKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 32 |
CTRL_TYPE_SHIPTO |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 33 |
CTRL_SHIPTO_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 34 |
CTRL_SHIPTO_MARKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 35 |
DESCRONLY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Description-Only Items
Y/N Table Edit
|
| 36 |
PUNCHOUT_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Punchout Items
Y/N Table Edit
|