BUSINESS_UNITPrompt Table: SP_BU_GL_NONVW
LEDGERPrompt Table: BU_LED_TBL
FISCAL_YEARPrompt Table: CNAO_BUYEAR_VW
ACCOUNTING_PERIODCNAO_EXT_ADJ_VW(SQL View) |
Index Back |
|---|---|
CNAO Adjustment Period viewCNAO Data Extract Adjustment Period view |
| SELECT ADJ.BUSINESS_UNIT , LGL.LEDGER , ADJ.FISCAL_YEAR , ADJ.ACCOUNTING_PERIOD , ADJ.BEGIN_DT , ADJ.END_DT FROM PS_CNAO_ADJ_PER_L ADJ , PS_BU_LED_GRP_TBL G , PS_LED_GRP_LED_TBL LGL , PS_SET_CNTRL_REC R WHERE ADJ.BUSINESS_UNIT = G.BUSINESS_UNIT AND ADJ.LEDGER_GROUP = G.LEDGER_GROUP AND G.LEDGER_TYPE = 'D' AND LGL.SETID = R.SETID AND R.RECNAME = 'LED_GRP_LED_TBL' AND R.SETCNTRLVALUE = G.BUSINESS_UNIT AND LGL.LEDGER_GROUP = G.LEDGER_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 2 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: BU_LED_TBL |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: CNAO_BUYEAR_VW |
| 4 | ACCOUNTING_PERIOD |
Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | End Date |