PRCR_UPD_AET

(SQL Table)
Index Back

Procurement Hst Upd Cache Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ALLOW_MC_PO Character(1) VARCHAR2(1) NOT NULL Allow Multicurrency PO
N=No
Y=Yes

Y/N Table Edit

Default Value: N

3 CALC_YEAR Number(4,0) SMALLINT NOT NULL The calculation year for a given data set within the Position tools.
4 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
5 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
6 CUR_PERIOD Number(3,0) SMALLINT NOT NULL Current Period
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 END_DT Date(10) DATE End Date
9 END_PERIOD Signed Number(4,0) DECIMAL(3) NOT NULL End Period
10 END_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL End Year
11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
12 INCLUDE_AP Character(1) VARCHAR2(1) NOT NULL Include AP Data
13 INCLUDE_NO_ITM_LN Character(1) VARCHAR2(1) NOT NULL Include Lines with no Item ID
14 INCLUDE_PO Character(1) VARCHAR2(1) NOT NULL Include PO Data
N=No
Y=Yes
15 INCLUDE_RECV Character(1) VARCHAR2(1) NOT NULL Include Receiver Data
16 MAX_PER Number(3,0) SMALLINT NOT NULL Max Period
17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
18 PRCR_PER_TYPE Character(1) VARCHAR2(1) NOT NULL Period Run Type
R=Relative
S=Specify
19 PRCR_PERIOD Number(3,0) SMALLINT NOT NULL Procurement Period
20 PRCR_VIEW_NAME Character(30) VARCHAR2(30) NOT NULL View By
21 PRCR_YEAR Number(4,0) SMALLINT NOT NULL Procurement Year
22 REL_END_PER Signed Number(4,0) DECIMAL(3) NOT NULL End - Cur Period Minus
23 REL_START_PER Signed Number(4,0) DECIMAL(3) NOT NULL Start - Cur Period Minus
24 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
25 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

26 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
27 RUN_DT Date(10) DATE Run Date
28 START_PERIOD Signed Number(4,0) DECIMAL(3) NOT NULL Start Period
29 START_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Start Year
30 START_DT Date(10) DATE Start Date
31 AE_MSG_NUM Number(5,0) INTEGER NOT NULL Message Number
32 AE_APPL_ABORT Character(1) VARCHAR2(1) NOT NULL AE Application Abort Indicator

Y/N Table Edit

33 AE_CNV_IN_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE input convert field
34 AE_CNV_OUT_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE output converion field
35 AE_RUN_OK Character(1) VARCHAR2(1) NOT NULL AE Run OK Indicator

Y/N Table Edit

36 AE_SPACE Character(1) VARCHAR2(1) NOT NULL Blank field literal
37 AE_SW1 Character(1) VARCHAR2(1) NOT NULL AE Switch
38 AE_N Character(1) VARCHAR2(1) NOT NULL AE_N
39 AE_Y Character(1) VARCHAR2(1) NOT NULL AE_Y
40 SETID Character(5) VARCHAR2(5) NOT NULL SetID
41 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset
42 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
43 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
44 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
45 SQL_STMT_254 Character(254) VARCHAR2(254) NOT NULL An internal work field that contains SQL text that is to be utilized in treasury application p
46 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
47 FROM_CLAUSE Character(254) VARCHAR2(254) NOT NULL From Clause