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