PeopleSoft 9.0
Cash Management

Table Name BU_LED_GRP_TBL

Table Description
BU_LED_GRP_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes No
LEDGER_GROUP CHAR(10) Yes Yes
LEDGER CHAR(10) Yes Yes
LEDGER_TYPE CHAR(1) No No
BALANCED_LEDGER 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
CALENDAR_ID CHAR(2) No No
UPD_OPENPER CHAR(1) No No
ASSOCIATED_LED_GRP CHAR(10) No No
DTTM_STAMP_SEC PSDATETIME No No
UPDATE_TIMING CHAR(1) No No
ROUND_ADJ_OPTN CHAR(1) No No
ADB_REPORTING CHAR(1) No No
ADB_STATUTORY_RPT CHAR(1) No No
ADB_FILTER_ACCNTS CHAR(1) No No
CALENDAR_ID_ADB CHAR(2) No No
CURRENCY_BAL_OPTN CHAR(1) No No
BASE_CUR_ADJ_OPTN CHAR(1) No No
JRNL_FOREIGN_OPTN CHAR(1) No No
ALLOW_LEDG_LOAD_SW CHAR(1) No No
ALLOW_WF_UPDATE CHAR(1) No No
BASE_CURRENCY CHAR(3) No No
DEFAULT_LEDGER_GRP CHAR(1) No No
SEPARATE_DRCR CHAR(1) No No
SEPARATE_DRCR_AMT CHAR(1) No No
ALTACCT_OPTN CHAR(1) No No
ACCT_ALT_SUSPENSE CHAR(10) No No
ALT_ACCT_SUSPENSE CHAR(10) No No
UPDATE_CLOSING_SW 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
DOC_TYPE CHAR(8) No No
DOC_TYPE_UNPOST CHAR(8) No No
COMMITMENT_CNTL CHAR(1) No No
KK_REVERSAL_OPTN CHAR(1) No No
KK_ERR_OPTN CHAR(1) No No
KK_INCLUDE_PRE_ENC CHAR(1) No No
KK_ALLOW_INC_SA CHAR(1) No No
POSITION_ACCOUNT CHAR(8) No No
NO_POST_FUTURE_DT CHAR(1) No No
POST_REVERSAL_SW CHAR(1) No No
POST_SUMLED_SW CHAR(1) No No
UNPOST_DOCTYPE_OPT CHAR(1) No No
UNPOST_INTERUNIT CHAR(1) No No
UNPOST_REVERSALS CHAR(1) No No
ENABLE_INC_SLED CHAR(1) No No
ENABLE_INC_LLOAD CHAR(1) No No
DETAIL_LEDGER CHAR(10) No No
Index
Name Type Unique Member
XPKBU_LED_GRP_TBL PK Yes
PS_BU_LED_GRP_TBL AK1 Yes
Member(s) of "XPKBU_LED_GRP_TBL" Index
BUSINESS_UNIT
LEDGER_GROUP
LEDGER
Member(s) of "PS_BU_LED_GRP_TBL" Index
BUSINESS_UNIT
LEDGER_GROUP
LEDGER

Published April 30, 2007