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 |