PeopleSoft 9
Account Payables

Table Name VCHR_DOCSEQ_HDR

Table Description
VCHR_DOCSEQ_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
AP_TRANS_TYPE VARCHAR(1) Yes No
UNPOST_SEQ SMALLINT Yes No
APPL_JRNL_ID VARCHAR(10) Yes No
PYMNT_CNT int Yes No
BUSINESS_UNIT_GL VARCHAR(5) Yes No
PROCESS_INSTANCE decimal(10) Yes No
ACCOUNTING_DT PSDATE No No
DOC_TYPE VARCHAR(8) No Yes
DOC_SEQ_NBR VARCHAR(12) No No
DOC_SEQ_DATE PSDATE No No
DOC_SEQ_STATUS VARCHAR(1) No No
Index
Name Type Unique Member
PS_VCHR_DOCSEQ_HDR PK Yes
Member(s) of "PS_VCHR_DOCSEQ_HDR" Index
BUSINESS_UNIT
VOUCHER_ID
AP_TRANS_TYPE
UNPOST_SEQ
APPL_JRNL_ID
PYMNT_CNT
BUSINESS_UNIT_GL
PROCESS_INSTANCE

Published June 06, 2007