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 |