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 |