PeopleSoft 9
Account Payables

Table Name VCHR_BATCH_PARM

Table Description
VCHR_BATCH_PARM
Columns
Name Datatype Is PK Is FK
OPRID VARCHAR(30) Yes Yes
RUN_CNTL_ID VARCHAR(30) Yes Yes
REQUEST_ID VARCHAR(10) Yes Yes
PROCESS_INSTANCE decimal(10) Yes No
BUSINESS_UNIT VARCHAR(5) Yes No
CNTRCT_SETID VARCHAR(5) Yes No
CNTRCT_ID VARCHAR(25) Yes No
ORIGIN_SETID VARCHAR(5) Yes No
ORIGIN VARCHAR(3) Yes No
GRP_AP_ID VARCHAR(10) Yes No
VENDOR_SETID VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes No
VOUCHER_ID VARCHAR(8) Yes No
Index
Name Type Unique Member
PS_VCHR_BATCH_PARM PK Yes
Member(s) of "PS_VCHR_BATCH_PARM" Index
OPRID
RUN_CNTL_ID
REQUEST_ID
PROCESS_INSTANCE
BUSINESS_UNIT
CNTRCT_SETID
CNTRCT_ID
ORIGIN_SETID
ORIGIN
GRP_AP_ID
VENDOR_SETID
VENDOR_ID
VOUCHER_ID

Published June 06, 2007