PeopleSoft 9.0
Cash Management

Table Name PMT_FORMAT_DEFN

Table Description
PMT_FORMAT_DEFN
Columns
Name Datatype Is PK Is FK
FORMAT_ID CHAR(10) Yes No
FORMAT_DOC_TYPE CHAR(3) No No
FORMAT_NAME CHAR(30) No No
DESCR254 CHAR(254) No No
TRANS_PROGRAM_TYPE CHAR(2) No No
TRANSFORM_PROGRAM CHAR(30) No No
PACKAGEROOT CHAR(30) No No
QUALIFYPATH CHAR(127) No No
APPCLASSID CHAR(30) No No
REPORT_DEFN_ID CHAR(12) No No
TEMPLATE_ID CHAR(30) No No
SOURCE_DOC CHAR(30) No No
TRANSFORM_MSG CHAR(30) No No
CHUNK_CD CHAR(15) No No
MAX_PMT_COUNT INT No No
Index
Name Type Unique Member
PS_PMT_FORMAT_DEFN PK Yes
PS0PMT_FORMAT_DEFN IE1 No
PS1PMT_FORMAT_DEFN IE2 No
Member(s) of "PS_PMT_FORMAT_DEFN" Index
FORMAT_ID
Member(s) of "PS0PMT_FORMAT_DEFN" Index
FORMAT_DOC_TYPE
FORMAT_ID
Member(s) of "PS1PMT_FORMAT_DEFN" Index
FORMAT_NAME
FORMAT_ID

Published April 30, 2007