AP_VCHR_HDR_SUM

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
4 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
5 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
6 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
7 RATE_MULT_TOL Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
8 RATE_DIV_TOL Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
9 MERCH_AMT_VCHR_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amt base
10 MERCH_AMT_VCHRR_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Merch Amount Voucher base-Recv
11 MERCH_AMT_RECVAPPL Signed Number(28,3) DECIMAL(26,3) NOT NULL Receiver line ship merchandise amt applied to voucher line in PO currency
12 MERCH_AMT_RECV Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount Received
13 MERCH_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount
14 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
15 MERCH_AMT_EXTND Signed Number(28,3) DECIMAL(26,3) NOT NULL Extened Merchandise Amount
16 MERCH_AMT_EXTND_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended Merchandise Amt base
17 MERCH_AMT_EXTND_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt Extended PO
18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance