BU_AM_BOOK_VW

(SQL View)
 Index Back

AM BU, Book & System Options


SELECT a.Business_Unit , a.Book , a.Acct_Ent_Tmpl_Id , c.Books_In_Synch_Sw , c.CAP_Book , c.Lease_Book , c.Default_Book , c.TRANSLATE_ACCOUNT , c.ALTACCT , b.Type_Add , b.Type_Adjustment , b.Type_Transfer , b.Type_Retire , b.Type_Reinstate , b.Type_Depr , b.Type_Prior_Depr , b.Type_Recategorize , a.Currency_Cd , a.Capitalization_Min , a.Distribution_Sw , a.Business_Unit_GL , a.Ledger_Group , a.Ledger , a.Bud_Ledger_Group , a.Budget_Ledger , a.Book_Type , a.Cal_Depr_PD , A.DEROGATORY_SW , A.BOOK_STATUTORY , A.ROUND_TYPE , A.ROUND_RULE_AM , A.ROUND_PRECISION , A.ROUND_FACTOR , A.TRUNCATE_FLAG , A.RT_TYPE , A.TRANSLATE_GL_SW FROM PS_BUS_UNIT_TBL_AM c , ps_installation_am b , ps_BU_Book_Tbl a WHERE a.business_unit = c.business_unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID
4 BOOKS_IN_SYNCH_SW Character(1) VARCHAR2(1) NOT NULL Keep all books in synch
5 CAP_BOOK Character(10) VARCHAR2(10) NOT NULL Book Used by CAP
6 LEASE_BOOK Character(10) VARCHAR2(10) NOT NULL Book used by Lease
7 DEFAULT_BOOK Character(10) VARCHAR2(10) NOT NULL Default Book
8 TRANSLATE_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Translate Account
9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
10 TYPE_ADD Character(3) VARCHAR2(3) NOT NULL Trans Type - Add
11 TYPE_ADJUSTMENT Character(3) VARCHAR2(3) NOT NULL Trans Type - Adjustment
12 TYPE_TRANSFER Character(3) VARCHAR2(3) NOT NULL Trans Type - Transfer In
13 TYPE_RETIRE Character(3) VARCHAR2(3) NOT NULL Trans Type - Class Retire
14 TYPE_REINSTATE Character(3) VARCHAR2(3) NOT NULL Reinstatement
15 TYPE_DEPR Character(3) VARCHAR2(3) NOT NULL Depreciation
16 TYPE_PRIOR_DEPR Character(3) VARCHAR2(3) NOT NULL Prior Depreciation
17 TYPE_RECATEGORIZE Character(3) VARCHAR2(3) NOT NULL Recategorize
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 CAPITALIZATION_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Capitalization Minimum
20 DISTRIBUTION_SW Character(1) VARCHAR2(1) NOT NULL Distribution Switch
N=No
Y=Yes
21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
22 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
23 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
24 BUD_LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Budget Ledger Group
25 BUDGET_LEDGER Character(10) VARCHAR2(10) NOT NULL Budget Ledger
26 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

27 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar

Prompt Table: CAL_DEFN_TBL

28 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation
29 BOOK_STATUTORY Character(10) VARCHAR2(10) NOT NULL Statutory Book
30 ROUND_TYPE Character(1) VARCHAR2(1) NOT NULL Round Type
C=Currency
G=Generic
31 ROUND_RULE_AM Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
32 ROUND_PRECISION Signed Number(4,0) DECIMAL(3) NOT NULL Rounding Precision
33 ROUND_FACTOR Number(15,7) DECIMAL(14,7) NOT NULL Rounding Factor
34 TRUNCATE_FLAG Character(1) VARCHAR2(1) NOT NULL Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate
35 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.
36 TRANSLATE_GL_SW Character(1) VARCHAR2(1) NOT NULL Translate Gain/Loss