PeopleSoft 9
Account Payables

Table Name AP_VCHR_HDR_SUM

Table Description
AP_VCHR_HDR_SUM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
VOUCHER_ID VARCHAR(8) Yes No
MATCH_CNTRL_ID VARCHAR(10) No No
VCHR_SRC VARCHAR(4) No No
VOUCHER_STYLE VARCHAR(4) No No
OFAC_STATUS VARCHAR(1) No No
RATE_MULT_TOL DECIMAL(15,8) No No
RATE_DIV_TOL DECIMAL(15,8) No No
MERCH_AMT_VCHR_B DECIMAL(26,3) No No
MERCH_AMT_VCHRR_B DECIMAL(26,3) No No
MERCH_AMT_RECVAPPL DECIMAL(26,3) No No
MERCH_AMT_RECV DECIMAL(26,3) No No
MERCH_AMT_PO DECIMAL(26,3) No No
MERCH_AMT_VCHR DECIMAL(26,3) No No
MERCH_AMT_EXTND DECIMAL(26,3) No No
MERCH_AMT_EXTND_B DECIMAL(26,3) No No
MERCH_AMT_EXTND_PO DECIMAL(26,3) No No
PROCESS_INSTANCE DECIMAL(10) No No
Index
Name Type Unique Member
PS_AP_VCHR_HDR_SUM PK Yes
Member(s) of "PS_AP_VCHR_HDR_SUM" Index
BUSINESS_UNIT
VOUCHER_ID

Published June 06, 2007