PeopleSoft 9
Account Payables

Table Name LED_GRP_LED_TBL

Table Description
LED_GRP_LED_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
LEDGER_GROUP VARCHAR(10) Yes No
LEDGER VARCHAR(10) Yes No
PRIMARY_LEDGER VARCHAR(1) No No
INHERIT_BASE_CUR VARCHAR(1) No No
BASE_CURRENCY VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
CUR_RT_TYPE_DFLT VARCHAR(5) No No
TRANSL_LEDGER VARCHAR(1) No No
OPEN_ITEM_LEDGER VARCHAR(1) No No
VAT_LEDGER VARCHAR(1) No No
COMMITMENT_CNTL VARCHAR(1) No No
LEDGER_TYPE_KK VARCHAR(1) No No
AFFECT_SPEND_OPTN VARCHAR(1) No No
Index
Name Type Unique Member
PS_LED_GRP_LED_TBL PK Yes
PSALED_GRP_LED_TBL IE1 No
Member(s) of "PS_LED_GRP_LED_TBL" Index
SETID
LEDGER_GROUP
LEDGER
Member(s) of "PSALED_GRP_LED_TBL" Index
SETID
LEDGER_GROUP
LEDGER_TYPE_KK
LEDGER

Published June 06, 2007