PeopleSoft 9
Account Payables

Table Name VCHR_BATCH_RUN

Table Description
VCHR_BATCH_RUN
Columns
Name Datatype Is PK Is FK
OPRID VARCHAR(30) Yes No
RUN_CNTL_ID VARCHAR(30) Yes No
REQUEST_ID VARCHAR(10) Yes No
REQUEST_DT PSDATE No No
PROCESS_INSTANCE decimal(10) No No
VCHR_PROC_OPTION VARCHAR(1) No No
VCHR_BATCH_INT_OPT VARCHAR(1) No No
DESCR VARCHAR(30) No No
PROCESS_FREQUENCY VARCHAR(1) No No
VCHR_EDIT_SOURCE VARCHAR(1) No No
NEW_SRC_SELECT_FLG VARCHAR(1) No No
RCY_SRC_SELECT_FLG VARCHAR(1) No No
FROM_DT PSDATE No No
TO_DT PSDATE No No
VCHR_BLD_CNT_OPT VARCHAR(1) No No
VED_RUN_STATUS VARCHAR(1) No No
DYN_UPDATE_FLG VARCHAR(1) No No
AUTO_ASSIGN_INV VARCHAR(1) No No
AUTO_ASSIGN_INV_DT VARCHAR(1) No No
WHERE_CLAUSE VARCHAR(254) No No
WHERE_CLAUSE2 VARCHAR(254) No No
WHERE_CLAUSE3 VARCHAR(254) No No
WHERE_CLAUSE4 VARCHAR(254) No No
WHERE_CLAUSE5 VARCHAR(254) No No
WHERE_CLAUSE6 VARCHAR(254) No No
URL VARCHAR(254) No No
Index
Name Type Unique Member
PS_VCHR_BATCH_RUN PK Yes
Member(s) of "PS_VCHR_BATCH_RUN" Index
OPRID
RUN_CNTL_ID
REQUEST_ID

Published June 06, 2007