BU_BOOK_VW5(SQL View) |
Index Back |
|---|---|
Bus. Unit Books w/Dist=Y & Inf |
| SELECT 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 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' |
| # | 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_BU_AM_NONVW |
| 2 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_BOOK_NONVW |
| 3 | ACCT_ENT_TMPL_ID | Character(10) | VARCHAR2(10) NOT NULL | Account Entry Template ID |
| 4 | REQUIRED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Book is Required
Y/N Table Edit Default Value: Y |
| 5 | 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 |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | CAPITALIZATION_MIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Capitalization Minimum |
| 8 | LEASE_CAP_MIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Lease Cap. Minimum |
| 9 | DISTRIBUTION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Switch
N=No Y=Yes Default Value: N |
| 10 | DISPOSAL_DIST_SW | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by Disposal Code
Y/N Table Edit Default Value: N |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 12 | CAL_DEPR_PD | Character(2) | VARCHAR2(2) NOT NULL |
Calendar
Prompt Table: CAL_DEFN_DPR_VW |
| 13 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 14 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 15 | BUD_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Budget Ledger Group |
| 16 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 17 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |