EORC_UPDCOND(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
2 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
3 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: EORC_RCM_CMP_V |
4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EORC_CMPREC_V |
5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EORC_RECFLD_V |
6 | FIELDUSEDAS | Character(2) | VARCHAR2(2) NOT NULL |
Field Used As
AO=As Of Date AT=Accounting Date BT=Bill Thru Date CF=Cycle From Date CT=Cycle Through Date ED=Effective Date ET=Exception Accounting Date EV=Event Date FD=From Date FP=From Period FY=Fiscal Year ID=Invoice Date IF=From Invoice Date IT=To Invoice Date OA=Override Accounting Date OP=Request Date Option PF=Process Frequency PR=Period RD=Request Date ST=Bills Added On Or After TD=To Date TP=To Period TT=Transaction Date YF=From Year YT=To Year |
7 | OPTIONALDATE | Character(18) | VARCHAR2(18) NOT NULL |
Optional Date Field
Prompt Table: EORC_RECFLD_V |
8 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Data
Default Value: N |