SP_BUBOOK_NONVW(SQL View) |
Index Back |
|---|---|
Business Unit Books w/Dist=Y |
| 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.RT_TYPE , a.LEDGER_GROUP , a.LEDGER , a.BUD_LEDGER_GROUP FROM PS_BU_BOOK_TBL a , PS_SP_BU_AM_NONVW B , ps_Set_Cntrl_Rec d , PS_LED_GRP_TBL E , PS_LED_GRP_LED_TBL F WHERE a.Distribution_Sw = 'Y' AND D.RECNAME = 'LED_GRP_TBL' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND E.SETID = D.SETID AND E.LEDGER_GROUP = A.LEDGER_GROUP AND F.SETID = E.SETID AND F.LEDGER_GROUP = E.LEDGER_GROUP AND ((E.LEDGERS_SYNC = 'Y' AND F.PRIMARY_LEDGER = 'Y' AND (F.LEDGER = A.LEDGER OR A.LEDGER = ' ')) OR (E.LEDGERS_SYNC <> 'Y' AND F.LEDGER = A.LEDGER)) AND B.BUSINESS_UNIT = A.BUSINESS_UNIT |
| # | 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 | 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.
Prompt Table: RT_TYPE_TBL |
| 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 |