Event Charges - Mass Addition Information

Event Charge Import Template

Positiion Header Name Can Import Empty? Suggested Values Notes
0 Insert Yes *INSERT Loader will default to INSERT.  Header Row must start with an asterisk (*).
1 OrganizationName Conditional   Either Organizaiton Name or Code is required.
2 OrganizationCode Conditional   Either Organizaiton Name or Code is required.
3 CampName Conditional   Either Camp Name or Code is required.
4 CampCode Conditional   Either Camp Name or Code is required.
5 EventYear No 2019 Value is validated against the XX_EVENTYEAR lookup values.
6 EventName No   Event Name of the event.
7 TransactionType No Payment
Refund
Credit
Manual Fee
Late Fee
Validated against the XX_EVENTCHRGTYPE lookup values.
8 RegionName Conditional   Either Region Name or Code is required.
9 RegionCode Conditional   Either Region Name or Code is required.
10 UnitName Conditional   Either Unit Name or Code is required.
11 UnitCode Conditional   Either Unit Name or Code is required.
12 Amount No   The amount for the transaction.
Must be a numeric value.
13 PaymentMethod Conditional CashOrCheck
Counter
Validated against the XX_CUEVENTCHGPAYMETHOD lookup values.
Online payments are not allowed through event charge imports.
14 Status No Pending
Posted
Validated against the XX_EVENTCHGORDERSTAT lookup values.
15 PersonID Conditional   Either the PersonID or PersonNo is required.
Person being used must be assigned to the unit given in either unit name or unit code.
16 PersonNo (BSAID) Conditional   Either the PersonID or PersonNo is required.
Person being used must be assigned to the unit given in either unit name or unit code.
17 FirstName Yes   Not used by loader, but it displays the person's name as output for success or failure.
18 LastName Yes   Not used by loader, but it displays the person's name as output for success or failure.
19 CreditPrefix Yes   Optional for Credit Transactions.  This text will be added to the event charge name.