| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CNTRCT_STYLE |
Character(10) |
VARCHAR2(10) NOT NULL |
Style ID
|
| 2 |
CNTRCT_STYLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Contract Style
|
| 3 |
CNTRCT_STRUCT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Valid Structures for Contract Styles
ADHD=Ad Hoc Document
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
POD=Purchase Order Document
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SED=Sourcing Event Document
SPP=Special Purpose
|
| 4 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 5 |
STYLE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Style Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
CNTRCT_PROC_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
|
| 7 |
ALLOW_ALL_DOCTYPES |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Style Status
Y/N Table Edit
Default Value: Y
|
| 8 |
USE_AGREEMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Agreements on contract
Y/N Table Edit
Default Value: Y
|
| 9 |
USE_PRICE_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Price Adjustments on contract
Y/N Table Edit
Default Value: Y
|
| 10 |
MANUAL_PO_RELEASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Manual PO Release on contract
Y/N Table Edit
Default Value: Y
|
| 11 |
USE_ADV_PRICE_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Advance Price Adj on Contract
Y/N Table Edit
Default Value: Y
|
| 12 |
USE_OPEN_ITEM_REF |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Open Item Reference on contract
Y/N Table Edit
Default Value: Y
|
| 13 |
USE_TAX_REFERENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Tax Reference on contract
Y/N Table Edit
Default Value: Y
|
| 14 |
USE_LOCK_CF |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Lock Chartfields on contract
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 15 |
USE_RETENTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Retention on contract
Y/N Table Edit
Default Value: Y
|
| 16 |
USE_THRESHOLDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Thresholds on contract
Y/N Table Edit
Default Value: Y
|
| 17 |
USE_PO_DEFAULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use PO Defaults on contract
Y/N Table Edit
Default Value: Y
|
| 18 |
USE_MULTICURR_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Muti-currency on contract
Y/N Table Edit
Default Value: Y
|
| 19 |
USE_CONTRACT_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Contract Lines on contract
Y/N Table Edit
Default Value: Y
|
| 20 |
USE_LINE_GROUPINGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Line Groupings on contract
Y/N Table Edit
Default Value: Y
|
| 21 |
USE_MILESTONES |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Milestones on contract
Y/N Table Edit
Default Value: Y
|
| 22 |
USE_CNT_BASE_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Base Price Default on contract
Y/N Table Edit
Default Value: N
|
| 23 |
USE_LINE_MINMAX_Q |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Line Min/Maximum Quantities on contract
Y/N Table Edit
Default Value: Y
|
| 24 |
USE_LINE_MINMAX_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Line Min/Maximum Amounts on contract
Y/N Table Edit
Default Value: Y
|
| 25 |
USE_CNT_BY_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Contract by Category on contract
Y/N Table Edit
Default Value: Y
|
| 26 |
USE_CAT_MINMAX_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Category Min/Maximum Amounts on contract
Y/N Table Edit
Default Value: Y
|