PeopleSoft 9
Asset Management

Table Name BUS_UNIT_TBL_GL

Table Description
BUS_UNIT_TBL_GL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
AS_OF_DATE PSDATE No No
BASE_CURRENCY char(3) No No
ELIMS_ONLY char(1) No No
JRNL_BALANCE_OPTN char(1) No No
JRNL_EDIT_ERR_OPTN char(1) No No
JRNL_AMT_ERR_OPTN char(1) No No
JRNL_DT_ERR_OPTN char(1) No No
JRNL_DT_ERR_OPTN2 char(1) No No
CONTROL_TOTAL_OPTN char(1) No No
CURRENCY_BAL_OPTN char(1) No No
BASE_CUR_ADJ_OPTN char(1) No No
JRNL_FOREIGN_OPTN char(1) No No
ENABLE_UNPOST_DT char(1) No No
JRNL_APPRVL_OPTN char(1) No No
BD_JRNL_APPR_OPTN char(1) No No
BUSPROCNAME char(30) No No
APPR_RULE_SET char(30) No No
BUSPROCNAME_BD char(30) No No
APPR_RULE_SET_BD char(30) No No
TR_RVL_RATE_INDEX char(10) No No
TR_RVL_RT_TYPE char(5) No No
INT_ENTITYCD char(4) No No
EXT_ENTITYCD char(4) No No
PYMNT_METHOD char(3) No No
DOC_SEQ char(1) No No
DOC_TYPE char(8) No No
VAT_NRCVR_PRO_FLG char(1) No No
VAT_NRCVR_ALL_FLG char(1) No No
HOLIDAY_LIST_ID char(10) No No
POST_DATE_OPTN char(1) No No
PROCESS_DATE PSDATE No No
IU_INTER_TMPLT_CD char(5) No No
IU_INTRA_TMPLT_CD char(5) No No
IU_LEGAL_ENT_BU char(5) No No
BUSINESS_UNIT_AP char(5) No No
VENDOR_SETID char(5) No No
VENDOR_ID char(10) No No
LOCATION char(10) No No
BUSINESS_UNIT_BI char(5) No No
CUST_ID char(15) 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
PROJECT_ID char(15) No No
DEPTID char(10) No No
CUST_VNDR_AFFILIAT char(1) No No
LED_GRP_DEFAULT char(10) No No
PHYSICAL_NATURE char(1) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_BUS_UNIT_TBL_GL PK Yes
PSABUS_UNIT_TBL_GL IE1 No
Member(s) of "PS_BUS_UNIT_TBL_GL" Index
BUSINESS_UNIT
Member(s) of "PSABUS_UNIT_TBL_GL" Index
SYNCID

Published December 16, 2006