Fields exported by
PeopleSoft
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
|
