| # |
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 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 3 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
Default Value: 1
|
| 4 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SETID_CNT_VW
|
| 5 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SETID_CNT_PO_VW
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 7 |
RELEASE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Option
P=Create Order
V=Create Voucher
Default Value: P
|
| 8 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_VW1
Set Control Field: SETID
|
| 10 |
INTERVAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Interval Type
A=Annually
D=Daily
M=Monthly
W=Weekly
Default Value: M
|
| 11 |
INTERVAL_COUNTER |
Number(3,0) |
SMALLINT NOT NULL |
Counter of Interval Type
Default Value: 1
Prompt Table:
CNTRCT_INT_CNT
|
| 12 |
DETAIL_COUNTER |
Number(3,0) |
SMALLINT NOT NULL |
Interval Detail Counter
Default Value: 1
Prompt Table:
CNTRCT_INT_DET
|
| 13 |
OCCURRENCES |
Number(3,0) |
SMALLINT NOT NULL |
Occurrences of Contract Rels
Default Value: 1
|
| 14 |
LAST_OCCURRENCE_DT |
Date(10) |
DATE |
PO date of Last Contract Rels
|
| 15 |
CNTRCT_DURATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Duration
D=Day
M=Month
W=Week
Y=Year
Default Value: M
|
| 16 |
DURATION_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Duration Option
F=For
T=Times
U=Until
Default Value: U
|
| 17 |
TIMES |
Number(3,0) |
SMALLINT NOT NULL |
Times
|
| 18 |
START_DT |
Date(10) |
DATE |
Start Date
Default Value: %date
|
| 19 |
UNTIL_DT |
Date(10) |
DATE |
Until Date
|
| 20 |
DAY_INCREMENT |
Number(3,0) |
SMALLINT NOT NULL |
Day Increment
|