BU_BOOK_VW4(SQL View) |
Index Back |
|---|---|
Business Unit Lease Books |
| 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.LEDGER_GROUP, a.LEDGER, a.BUD_LEDGER_GROUP, a.CAL_DEPR_PD, a.RT_TYPE, a.GROUP_PROC_SW, b.SETID, b.DESCR, b.LC_CNTRY 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 |
| # | 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 | LEASE_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Book used by Lease |
| 3 | ACCT_ENT_TMPL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Account Entry Template ID
Prompt Table: AMAE_TMPLID_TBL |
| 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 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 13 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 14 | BUD_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Budget Ledger Group |
| 15 | CAL_DEPR_PD | Character(2) | VARCHAR2(2) NOT NULL |
Calendar
Prompt Table: CAL_DEFN_DPR_VW |
| 16 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 17 | GROUP_PROC_SW | Character(1) | VARCHAR2(1) NOT NULL | Group Asset Processing |
| 18 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | LC_CNTRY | Character(3) | VARCHAR2(3) NOT NULL | The local country. |