Data collection file layouts - data feeds

The following section includes the layout descriptions for the database files.

Accounts Payable

File Layout

• If import will be automated via Scheduler:

  • File name should begin with “AP_KHALL” (same file name each time file is run/saved)
  • File should be placed in folder accessible to the Scheduler. If system is in KH EPM Cloud, then the Cloud Integration Service must be installed.

• If import will be run manually file name should be “AP_YYMMDD”. Example: AP_150301. (Each file should have a unique file name)

  Field	Description	Field Type	Length
  Project ID Number	Project ID	Text	50
  GLAccount	GL Account Number	Numeric	NA
  GL Post Date	Date invoice is posted to the GL	MM/DD/YYYY	15
  Invoice Number	Invoice Number	Text	50
  Dollar Amount	Dollar Amount	Numeric	NA
  Invoice Date	Invoice Date	MM/DD/YYYY	15
  Vendor Code	Vendor Number	Text	30
  Vendor Name	Vendor Name	Text	250
  Purchase Order Number	PO Number	Text	50
  Item Description (optional)	Item\Line Number Description	Text	250
  Check Number (optional)	Check Number	Text	30
  Check Date (optional)	Check Date (MM/DD/YYYY)	MM/DD/YYYY	15

Sample File Layout – Accounts Payable

GL Capital Transaction Detail / Journal Entry Detail

File Layout

• If import will be automated via Scheduler:

  • File name should begin with “JE_KHALL” (same file name each time file is run/saved)
  • File should be placed in folder accessible to the Scheduler. If system is in KH EPM Cloud, then the Cloud Integration Service must be installed.

• If import will be run manually file name should be “JE_YYMMDD”. Example: JE_150301. (Each file should have a unique file name)

  Field	Description	Field Type	Length
  Project ID Number	Project ID	Text	50
  GLAccount	GL Account Number	Numeric	NA
  GL Post Date	Date invoice is posted to the GL	MM/DD/YYYY	15
  Journal Entry Number	Journal Entry Number	Text	50
  Dollar Amount	Dollar Amount	Numeric	NA
  Journal Entry Date	Journal Entry Date	MM/DD/YYYY	15
  Journal Entry Line Description (optional)	Journal Entry Line Description	Text	250
  Line Number (optional)	Line Number	Text	30

Sample File Layout – GL Capital Transaction / Journal Entry Detail

Purchase Order Number

File Layout

• If import will be automated via Scheduler:

  • File name should begin with “PONumber_KHALL” (same file name each time file is run/saved)
  • File should be placed in folder accessible to the Scheduler. If system is in KH EPM Cloud, then the Cloud Integration Service must be installed.

• If import will be run manually file name should be “PONumber_YYMMDD”. Example: PONumber_150301. (Each file should have a unique file name)

  NOTE: The Purchase Order Number Import to Capital Tracking is optional and only applicable if using the Axiom Capital Tracking purchase request features.

  Field	Description	Field Type	Length
  Project ID Number	Project ID	Text	50
  Purchase Request ID Number	Purchase Request ID	Text	50
  Purchase Order Number	PO Number	Text	50

Sample File Layout – Accounts Payable

Purchase Orders

File Layout

• If import will be automated via Scheduler:

  • File name should begin with “PO_KHALL” (same file name each time file is run/saved)
  • File should be placed in folder accessible to the Scheduler. If system is in KH EPM Cloud, then the Cloud Integration Service must be installed.

• If import will be run manually file name should be “PO_YYMMDD”. Example: PO_150301. (Each file should have a unique file name)

  NOTE: The Purchase Order Import to Capital Tracking is optional and only applicable if using the Axiom Capital Tracking purchase request features.

  Field	Description	Field Type	Length
  Project ID Number	Project ID	Text	50
  GLAccount	GL Account Number	Numeric	NA
  Purchase Order Number	PO Number	Text	50
  Dollar Amount	Dollar Amount	Numeric	NA
  Purchase Order Date	PO Date	MM/DD/YYYY	15
  Vendor Code	Vendor Number	Text	30
  Vendor Name	Vendor Name	Text	250
  Purchase Request Number (optional)	Purchase Request Number	Text	50
  PO Description	PO Description	Text	250

Sample File Layout – Purchase Orders