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 |