AP_MTCH_EXP_DTL

(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

Prompt Table: SP_BU_AP_NONVW

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
5 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 MTCH_EXCPTN_TYPE Character(4) VARCHAR2(4) NOT NULL Match Exception Type
DBMO=Debit Memo
EXCP=Exception
9 ASSTN_NAME Character(30) VARCHAR2(30) NOT NULL Association Name
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
12 VCHR_FLDVALUE Character(30) VARCHAR2(30) NOT NULL Voucher
13 PO_FLDVALUE Character(30) VARCHAR2(30) NOT NULL Purchase Order
14 RECV_FLDVALUE Character(30) VARCHAR2(30) NOT NULL Receiver
15 NOTIFY_DATE Date(10) DATE Notification Date
16 CREATION_DT Date(10) DATE Creation Date
17 YEAR_FROM Character(4) VARCHAR2(4) NOT NULL From Year
1=NONE
18 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
19 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
20 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
21 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
22 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
23 INVOICE_DT Date(10) DATE Invoice Date