SP_BOOKB5_CLSVW(SQL View) |
Index Back |
|---|---|
Bus. Unit Books w/Dist=Y & Inf |
| SELECT D.OPRCLASS , a.BUSINESS_UNIT , a.BOOK , a.ACCT_ENT_TMPL_ID , a.REQUIRED_SW , a.BOOK_TYPE , a.CURRENCY_CD , a.CAPITALIZATION_MIN , a.LEASE_CAP_MIN , a.DISTRIBUTION_SW , a.DISPOSAL_DIST_SW , a.BUSINESS_UNIT_GL , a.CAL_DEPR_PD , a.LEDGER_GROUP , a.LEDGER , a.BUD_LEDGER_GROUP , b.SETID , b.DESCR FROM PS_BU_BOOK_TBL a , PS_BOOK_DEFN_TBL b , PS_SP_BOOK_CLSVW D WHERE b.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC c WHERE c.SETCNTRLVALUE= a.BUSINESS_UNIT AND c.RECNAME='BOOK_DEFN_TBL') AND a.BOOK = b.BOOK AND a.Distribution_Sw='Y' AND a.infl_adj_sw = 'Y' AND D.SETID = B.SETID AND D.BOOK = B.BOOK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_BOOK_NONVW |
| 4 | ACCT_ENT_TMPL_ID | Character(10) | VARCHAR2(10) NOT NULL | Account Entry Template ID |
| 5 | REQUIRED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Book is Required
Y/N Table Edit Default Value: Y |
| 6 | BOOK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Book Type
A=U.S. AMT Book F=Corporate Book P=Corporate w/Tax Info T=Main Tax Book Default Value: F |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | CAPITALIZATION_MIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Capitalization Minimum |
| 9 | LEASE_CAP_MIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Lease Cap. Minimum |
| 10 | DISTRIBUTION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Switch
N=No Y=Yes Default Value: N |
| 11 | DISPOSAL_DIST_SW | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by Disposal Code
Y/N Table Edit Default Value: N |
| 12 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 13 | CAL_DEPR_PD | Character(2) | VARCHAR2(2) NOT NULL |
Calendar
Prompt Table: CAL_DEFN_DPR_VW |
| 14 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 15 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 16 | BUD_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Budget Ledger Group |
| 17 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |