PeopleSoft 9
Account Payables

Table Name DOC_TYPE_TBL

Table Description
DOC_TYPE_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
DOC_TYPE VARCHAR(8) Yes No
DESCR VARCHAR(30) No No
JRNL_CODE VARCHAR(8) No Yes
JRNL_TYPE VARCHAR(2) No Yes
SEQ_RANGE_ID VARCHAR(2) No No
SEQ_TYPE VARCHAR(1) No No
IN_USE_FLAG VARCHAR(1) No No
Index
Name Type Unique Member
PS_DOC_TYPE_TBL PK Yes
PS0DOC_TYPE_TBL IE4 No
Member(s) of "PS_DOC_TYPE_TBL" Index
SETID
DOC_TYPE
Member(s) of "PS0DOC_TYPE_TBL" Index
JRNL_CODE
SETID
DOC_TYPE
DESCR

Published June 06, 2007