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 |