Standard_Import.xls

The Standard_Import.xls template applies to several document types:

      Advanced Deposits Document (AD)

      Cash Receipt (CR)

      Credit Card Receipts (CCR)

      Disbursement Voucher (DV)

      Distribution of Income and Expense (DI)

      Internal Billing (IB)

      Intra-Account Adjustment (IAA)

      Pre-Encumbrance - encumbrance lines only (PE)

      Procurement Card (PCDO)

      Service Billing (SB)

      Transfer of Funds (TF)

      Year-End Distribution of Income and Expense (YEDI)

      Year-End Transfer of Funds (YETF)

The basic format of the template is shown below.

Standard_Import template format (fields listed in order required by template)

Column

Field Name

A

Chart Code

exclaim.gif    If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template.

B

Account Number

C

Sub-Account Number

D

Object Code

E

Sub-Object Code

F

Project Code

G

Organization Reference Id

H

Line Description

I

Amount

More:

AV_Import.xlxs