PeopleSoft 9
Asset Management

Table Name BUS_UNIT_TBL_AM

Table Description
BUS_UNIT_TBL_AM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
LOCATION char(10) No No
LAST_ASSET_ID decimal(12) No No
CAP_BOOK char(10) No No
LEASE_BOOK char(10) No No
DEFAULT_BOOK char(10) No No
FEDERAL_BOOK char(10) No No
AMT_BOOK char(10) No No
ACE_BOOK char(10) No No
VAT_BOOK char(10) No No
BOOKS_IN_SYNCH_SW char(1) No No
ALLOW_DUP_TAGS_SW char(1) No No
DEFAULT_TAG_SW char(1) No No
IN_USE_SW char(1) No No
JV_UNIT_SW char(1) No No
JV_PART_PROF_SW char(1) No No
TRF_ACQ_DET_SW char(1) No No
TRF_ATTRIBUTES_SW char(1) No No
TRF_COMMENTS_SW char(1) No No
TRF_LEASE_SW char(1) No No
TRF_LIC_REG_SW char(1) No No
TRF_MAINT_SW char(1) No No
TRF_WARRANTY_SW char(1) No No
TRF_INSURANCE_SW char(1) No No
TRF_INSPECTION_SW char(1) No No
TRF_NON_CAP_COST char(1) No No
ATTRIBUTE_GROUP_SW CHAR(1) No No
ADV_DEPR_SW char(1) No No
JPN_CORP_BOOK char(10) No No
JPN_TAX_BOOK char(10) No No
JPN_COMPOSITE_SW char(1) No No
POSTING_MODE char(1) No No
SERVER_NAME char(8) No No
OPEN_TRANS_ID decimal(10) No No
OP_TRNS_ID_INCR_SW char(1) No No
USE_JPN_LOCAL_TAX char(1) No No
AMAP_UNPOST_SW char(1) No No
SUBSEQ_TXN_TYPE char(1) No No
PARENT_CHILD_FLAG char(1) No No
ALLOW_AUTO_RET_SW char(1) No No
AM_INTFC_PROC char(1) No No
BUSINESS_UNIT_BI char(5) No No
BILL_TYPE_ID char(3) No No
BILL_SOURCE_ID char(10) No No
BILL_BY_ID char(10) No No
TRANSLATE_ACCOUNT char(10) No No
ALTACCT char(10) No No
ADJ_CONV_ADD_SW char(1) No No
REMAP_CF_SW char(1) No No
TREE_NAME char(18) No No
STATISTICS_ACCT char(10) No No
STATISTICS_CODE char(3) No No
RETIRE_AC_SW char(1) No No
TRF_OUT_SW char(1) No No
TRF_IN_SW char(1) No No
OVERRIDE_OTHER_DEF char(1) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
CUSTODIAN char(30) No No
WRHS_LOCATION char(10) No No
EMPLID char(11) No No
DEPTID char(10) No No
PROJECT_ID char(15) No No
TRK_COMP_HIST_SW char(1) No No
Index
Name Type Unique Member
PS_BUS_UNIT_TBL_AM PK Yes
Member(s) of "PS_BUS_UNIT_TBL_AM" Index
BUSINESS_UNIT

Published December 16, 2006