PeopleSoft 9.0
Cash 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
XPKBUS_UNIT_TBL_GL PK Yes
PS_BUS_UNIT_TBL_GL AK1 Yes
PSABUS_UNIT_TBL_GL IE1 No
Member(s) of "XPKBUS_UNIT_TBL_GL" Index
BUSINESS_UNIT
Member(s) of "PS_BUS_UNIT_TBL_GL" Index
BUSINESS_UNIT
Member(s) of "PSABUS_UNIT_TBL_GL" Index
SYNCID

Published April 30, 2007