PeopleSoft 9
Account Payables

Table Name BU_LED_GRP_TBL

Table Description
BU_LED_GRP_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
LEDGER_GROUP VARCHAR(10) Yes Yes
LEDGER VARCHAR(10) Yes Yes
LEDGER_TYPE VARCHAR(1) No No
BALANCED_LEDGER VARCHAR(1) No No
JRNL_BALANCE_OPTN VARCHAR(1) No No
JRNL_EDIT_ERR_OPTN VARCHAR(1) No No
JRNL_AMT_ERR_OPTN VARCHAR(1) No No
JRNL_DT_ERR_OPTN VARCHAR(1) No No
JRNL_DT_ERR_OPTN2 VARCHAR(1) No No
CONTROL_TOTAL_OPTN VARCHAR(1) No No
CALENDAR_ID VARCHAR(2) No No
UPD_OPENPER VARCHAR(1) No No
ASSOCIATED_LED_GRP VARCHAR(10) No No
DTTM_STAMP_SEC PSDATETIME No No
UPDATE_TIMING VARCHAR(1) No No
ROUND_ADJ_OPTN VARCHAR(1) No No
ADB_REPORTING VARCHAR(1) No No
ADB_STATUTORY_RPT VARCHAR(1) No No
ADB_FILTER_ACCNTS VARCHAR(1) No No
CALENDAR_ID_ADB VARCHAR(2) No No
CURRENCY_BAL_OPTN VARCHAR(1) No No
BASE_CUR_ADJ_OPTN VARCHAR(1) No No
JRNL_FOREIGN_OPTN VARCHAR(1) No No
ALLOW_LEDG_LOAD_SW VARCHAR(1) No No
ALLOW_WF_UPDATE VARCHAR(1) No No
BASE_CURRENCY VARCHAR(3) No No
DEFAULT_LEDGER_GRP VARCHAR(1) No No
SEPARATE_DRCR VARCHAR(1) No No
SEPARATE_DRCR_AMT VARCHAR(1) No No
ALTACCT_OPTN VARCHAR(1) No No
ACCT_ALT_SUSPENSE VARCHAR(10) No No
ALT_ACCT_SUSPENSE VARCHAR(10) No No
UPDATE_CLOSING_SW VARCHAR(1) No No
JRNL_APPRVL_OPTN VARCHAR(1) No No
BD_JRNL_APPR_OPTN VARCHAR(1) No No
BUSPROCNAME VARCHAR(30) No No
APPR_RULE_SET VARCHAR(30) No No
BUSPROCNAME_BD VARCHAR(30) No No
APPR_RULE_SET_BD VARCHAR(30) No No
DOC_TYPE VARCHAR(8) No No
DOC_TYPE_UNPOST VARCHAR(8) No No
COMMITMENT_CNTL VARCHAR(1) No No
KK_REVERSAL_OPTN VARCHAR(1) No No
KK_ERR_OPTN VARCHAR(1) No No
KK_INCLUDE_PRE_ENC VARCHAR(1) No No
KK_ALLOW_INC_SA VARCHAR(1) No No
POSITION_ACCOUNT VARCHAR(8) No No
NO_POST_FUTURE_DT VARCHAR(1) No No
POST_REVERSAL_SW VARCHAR(1) No No
POST_SUMLED_SW VARCHAR(1) No No
UNPOST_DOCTYPE_OPT VARCHAR(1) No No
UNPOST_INTERUNIT VARCHAR(1) No No
UNPOST_REVERSALS VARCHAR(1) No No
ENABLE_INC_SLED VARCHAR(1) No No
ENABLE_INC_LLOAD VARCHAR(1) No No
DETAIL_LEDGER VARCHAR(10) No No
Index
Name Type Unique Member
PS_BU_LED_GRP_TBL PK Yes
Member(s) of "PS_BU_LED_GRP_TBL" Index
BUSINESS_UNIT
LEDGER_GROUP
LEDGER

Published June 06, 2007