PeopleSoft 9
Account Payables

Table Name AP_PCJOB_STAT

Table Description
AP_PCJOB_STAT
Columns
Name Datatype Is PK Is FK
PRCSJOBNAME VARCHAR(8) Yes No
PRCSJOBSEQ SMALLINT Yes No
PROCESS_INSTANCE DECIMAL(10) No No
RUNDTTM PSDATETIME No No
JOB_STATUS VARCHAR(1) No No
OPRID VARCHAR(30) No No
SERVERNAME VARCHAR(8) No No
PAY_CYCLE VARCHAR(6) No No
PAY_CYCLE_SEQ_NUM INT No No
MESSAGE_TEXT VARCHAR(100) No No
Index
Name Type Unique Member
PS_AP_PCJOB_STAT PK Yes
Member(s) of "PS_AP_PCJOB_STAT" Index
PRCSJOBNAME
PRCSJOBSEQ

Published June 06, 2007