GL_JSRC_PRDCOPY(SQL Table) |
Index Back |
|---|---|
Copy Period-End CutoffCopy Period-End Cutoff Schedule for Journal Source Security |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: GL_PERCUT_BU_VW |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: GL_LEDGRP_DVW |
| 6 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: GL_LEDGER_DVW |
| 7 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: GL_FISCALYR_DVW |
| 8 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 9 | BUSINESS_UNIT2 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: GL_JSRC_BU_DVW |
| 10 | BUS_UNIT_GL_FROM | Character(5) | VARCHAR2(5) NOT NULL |
From Business Unit GL
Prompt Table: GL_JSRC_BU_DVW |
| 11 | BUS_UNIT_GL_TO | Character(5) | VARCHAR2(5) NOT NULL |
To Business Unit GL
Prompt Table: GL_JSRC_BU_DVW |
| 12 | LEDGER_GROUP_2 | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: GL_LEDGRP_DVW |
| 13 | FISCAL_YEAR2 | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: GL_FISCAL_YR_VW |
| 14 | LEDGER_2 | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: GL_LEDGER_DVW |
| 15 | GL_PRD_END_COPY | Character(1) | VARCHAR2(1) NOT NULL |
Copy Period End Cutoff
C=All R=By Business Unit Range |
| 16 | GL_MASS_COPY | Character(1) | VARCHAR2(1) NOT NULL |
Period End Cutoff Mass Copy
Y/N Table Edit |
| 17 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |