GL_JSRC_PRD_END(SQL Table) |
Index Back |
|---|---|
Period-End CutoffPeriod-End Cutoff Schedule for Journal Source Security |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_GL_BU_NONVW |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Default Value: OPR_DEF_TBL_FS.LEDGER_GROUP Prompt Table: SP_LGNOKK_NONVW |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: LED_GRP_LED_TBL |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: GL_FISCAL_YR_VW |
| 5 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 7 | GLSEC_SRC_HOLIDAY | Character(1) | VARCHAR2(1) NOT NULL |
Period End Cutoff Holiday Option
N=Next Work Day P=Prev. Work Day S=Same Day Default Value: S |
| 8 | GLSEC_SRC_HOL_CAL | Character(1) | VARCHAR2(1) NOT NULL |
Period End Cutoff Holiday Calendar
Y/N Table Edit Default Value: N |
| 9 | LEDGER_IN_SYNC_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Ledger In Sync Check
Y/N Table Edit Default Value: N |
| 10 | GL_MASS_PND_CUTOFF | Signed Number(4,0) | DECIMAL(3) NOT NULL | Period End Cutoff Mass Update |
| 11 | GL_MASS_UPD_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Mass Update Periods in Period End Cutoff
Y/N Table Edit Default Value: N |
| 12 | GL_CAL_PERIOD | Character(2) | VARCHAR2(2) NOT NULL |
Calendar Period for Journal Source Security
1=Period 1 |
| 13 | END_DATE | Date(10) | DATE | End Date |