Standard_Import.xls

The Standard_Import.xlstemplate 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