RUN_GLS1210(SQL Table) |
Index Back |
---|---|
Closing sets Validation |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
4 | CLOSING_RULE_SET | Character(20) | VARCHAR2(20) NOT NULL |
Commitment Control Closing Rule Set
Prompt Table: KK_CLOSE_SET |
5 | AS_OF_DATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %date |
6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
7 | KK_ROLL_FWD_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Roll Fwd Calc - Spending Auth
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |
8 | KK_RULE_OVRLAP_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Closing rules overlap
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |
9 | KK_NO_CHILDBD_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Flag used in Budget Closing Set validation request.
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |
10 | KK_NO_PARENTBD_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Flag used in Budget Closing Set validation request.
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |
11 | KK_BP_XFER_SET_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Bud Period not in Transfer Set
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |
12 | KK_ENTRY_EVENT_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Entry Event not Defined
E=Fail the Validation I=Ignore W=Report as a Warning Default Value: E |