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 |