 › Manage ERP integrations › Fields exported by PeopleSoft

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