PeopleSoft 9
Account Payables

Table Name VCHR_CC_XREF

Table Description
VCHR_CC_XREF
Columns
Name Datatype Is PK Is FK
EMPLID VARCHAR(11) Yes No
CREDIT_CARD_VENDOR VARCHAR(5) Yes No
CRDMEM_ACCT_NBR VARCHAR(44) Yes No
TRANS_NBR VARCHAR(24) Yes No
SEQUENCENO int Yes No
TRANS_DT PSDATE Yes No
LINE_NBR int Yes No
DTTM_STAMP PSDATETIME Yes No
BUSINESS_UNIT VARCHAR(5) No Yes
VOUCHER_ID VARCHAR(8) No Yes
VOUCHER_LINE_NUM int No Yes
Index
Name Type Unique Member
PS_VCHR_CC_XREF PK Yes
PSAVCHR_CC_XREF IE1 No
Member(s) of "PS_VCHR_CC_XREF" Index
EMPLID
CREDIT_CARD_VENDOR
CRDMEM_ACCT_NBR
TRANS_NBR
SEQUENCENO
TRANS_DT
LINE_NBR
DTTM_STAMP
Member(s) of "PSAVCHR_CC_XREF" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007