The following data fields are exported by
Kofax AP Agility
and passed to the
PeopleSoft
ERP via the connector.
Header level
BUSINESS_UNIT
VOUCHER_STYLE (REG or ADJ for credit memo and credits)
VCHR_SRC (XLS,XML)
INVOICE_ID
INVOICE_DT (invoice date)
VENDOR_SETID
VENDOR_ID
VNDR_LOC (Vendor site ID)
GROSS_AMT (invoice amount)
DSCNT_AMT (discount amount)
SALETX_AMT
FREIGHT_AMT
TXN_CURRENCY_CD (currency)
DESCR254_MIXED (contains attachment ID - image of the invoice)
IN_PROCESS_FLG (always N)
BUSINESS_UNIT_PO (empty if PO Number is not set)
PO_ID (PO number)
ITEM_LINE number of line items
Line-item level
BUSINESS_UNIT
VOUCHER_LINE_NUM (line number)
BUSINESS_UNIT_PO
PO_ID
LINE_NBR (PO line number)
SCHED_NBR (PO schedule number)
DESCR
MERCHANDISE_AMT
QTY_VCHR (line quantity)
UNIT_OF_MEASURE
UNIT_PRICE
BUSINESS_UNIT_RECV (same as
BUSINESS_UNIT)
RECEIVER_ID (GRDocNoLine)
RECV_LN_NBR (GRDocItemLine)
SHIPTO_ID (plant line)
ULTIMATE_USE_CD
VENDOR_ID
VNDR_LOC
CATEGORY_ID
If GL segments are set on the line-item level then distribution lines are created with the following field data
BUSINESS_UNIT
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
BUSINESS_UNIT_GL
ACCOUNT
ALTACCT
DEPTID
MERCHANDISE_AMT
BUSINESS_UNIT_PO
PO_ID
PO_DIST_LINE_NUM
BUSINESS_UNIT_PC
ACTIVITY_ID
ANALYSIS_TYPE
RESOURCE_TYPE
RESOURCE_CATEGORY
RESOURCE_SUB_CAT
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
CHARTFIELD1
CHARTFIELD2
CHARTFIELD3
PROJECT_ID
Search results
Search tips
The search returns topics that contain terms you enter. If you type more than one term, an OR is assumed, which returns topics where any of the terms are found. Enclose your search terms in quotes for exact-phrase matching.
The search also uses fuzzy matching to account for partial words (such as install and installs). The results appear in order of relevance, based on how many search terms occur per topic. Exact matches are highlighted.
To refine the search, you can use the following operators:
Type + in front of words that must be included in the search or - in front of words to exclude. (Example: user +shortcut –group finds shortcut and user shortcut, but not group or user group.)
Use * as a wildcard for missing characters. The wildcard can be used anywhere in a search term. (Example: inst* finds installation and instructions.)
Type title: at the beginning of the search phrase to look only for topic titles. (Example: title:configuration finds the topic titled “Changing the software configuration.”)
For multi-term searches, you can specify a priority for terms in your search. Follow the term with ^ and a positive number that indicates the weight given that term. A higher number indicates more weight. (Example: shortcut^10 group gives shortcut 10 times the weight as group.)
To use fuzzy searching to account for misspellings, follow the term with ~ and a positive number for the number of corrections to be made. (Example: port~1 matches fort, post, or potr, and other instances where one correction leads to a match.)
Note that operators cannot be used as search terms: + - * : ~ ^ ' "
