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 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: