AUC_CNTRCT_SCHD

(SQL View)
 Index Back

Contract Release Schedule


SELECT SETID , CNTRCT_ID , BUSINESS_UNIT_AP , BUSINESS_UNIT_PO , CURRENCY_CD , RELEASE_OPT , RT_TYPE , VNDR_LOC , INTERVAL_TYPE , INTERVAL_COUNTER , DETAIL_COUNTER , OCCURRENCES , LAST_OCCURRENCE_DT , CNTRCT_DURATION , DURATION_OPT , TIMES , START_DT , UNTIL_DT , DAY_INCREMENT FROM PS_CNTRCT_SCHEDULE

# 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 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

Prompt Table: SETID_CNT_VW

4 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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

6 RELEASE_OPT Character(1) VARCHAR2(1) NOT NULL Release Option
P=Create Order
V=Create Voucher

Default Value: P

7 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

8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1
Set Control Field: SETID

9 INTERVAL_TYPE Character(1) VARCHAR2(1) NOT NULL Schedule Interval Type
A=Annually
D=Daily
M=Monthly
W=Weekly

Default Value: M

10 INTERVAL_COUNTER Number(3,0) SMALLINT NOT NULL Counter of Interval Type

Default Value: 1

Prompt Table: CNTRCT_INT_CNT

11 DETAIL_COUNTER Number(3,0) SMALLINT NOT NULL Interval Detail Counter

Default Value: 1

Prompt Table: CNTRCT_INT_DET

12 OCCURRENCES Number(3,0) SMALLINT NOT NULL Occurrences of Contract Rels

Default Value: 1

13 LAST_OCCURRENCE_DT Date(10) DATE PO date of Last Contract Rels
14 CNTRCT_DURATION Character(1) VARCHAR2(1) NOT NULL Contract Duration
D=Day
M=Month
W=Week
Y=Year

Default Value: M

15 DURATION_OPT Character(1) VARCHAR2(1) NOT NULL Duration Option
F=For
T=Times
U=Until

Default Value: U

16 TIMES Number(3,0) SMALLINT NOT NULL Times
17 START_DT Date(10) DATE Start Date

Default Value: %date

18 UNTIL_DT Date(10) DATE Until Date
19 DAY_INCREMENT Number(3,0) SMALLINT NOT NULL Day Increment