Cash Flow Manual Adjustment Import Format

A

1

Manual Entry Number

8

Integer

No

If you are updating an existing cash flow manual adjustment entry, enter the manual entry number. If you are importing a new entry, leave this field blank.

B

2

Type

1

Integer

Yes, only if creating a new entry

Enter one of the following to indicate the manual adjustment type:

• 1  - Inflows

• 2 - Outflows

If you are updating an existing entry, leave this field blank.

C

3

Company Code

20

Note The length depends on the length set up for the company account element.

Integer

Yes

Enter a valid company code to associate with the cash flow manual adjustment entry. For information on setting up company codes, see Company Maintenance.

D

4

Cash Flow Category Code

20

Character

Yes, only if creating a new entry

Enter a valid cash flow category code. For information on setting up cash flow categories, see Cash Flow Category Maintenance.

Note You cannot enter the Beginning Cash or Ending Cash category. The category must also be assigned the same type as the manual adjustment.

E

5

Cash Flow Subcategory Code

20

Character

No

Enter a valid cash flow subcategory code.

F

6

Amount

14

>>>,>>>,>>9.99

Yes

Enter the amount of the cash flow manual adjustment entry.

G

7

Currency

8

Character

No

Enter the currency for the manual adjustment entry.

H

8

Occurrence

1

Integer

Yes, only if creating a new entry

Enter one of the following:

• 1 - One Time

• 2 - Recurring

If you are updating an existing entry, leave this field blank.

I

9

Start Date

10

99/99/9999

Yes, only if creating a new entry

Enter the date for a one-time cash flow manual adjustment entry, or the start date for a recurring cash flow manual adjustment entry.

If you are updating an existing entry, leave this field blank.

J

10

End Date

10

99/99/9999

Yes, only if creating a new recurring entry

Enter the end date of the cash flow manual adjustment entry if the entry is recurring.

K

11

Frequency

1

Integer

Yes, only if creating a new recurring entry

Enter one of the following frequencies if the entry is recurring:

• 1 - Daily

• 2 - Weekly

• 3 - Bi-Weekly

• 4 - Semi-Monthly

• 5 - Monthly

• 6 - Quarterly

L

12

Interval

2

Integer

No

Enter an interval for the recurring cash flow manual adjustment entry.

Example If you selected Monthly for the Frequency field and you enter 2 as the interval, the entry is created every 2 months.

If this is a recurring cash flow manual adjustment entry, and this field is blank, it defaults to 1.

M

13

Primary Source

20

Character

No

Enter the primary source of the cash flow manual adjustment entry.

N

14

Secondary Source

20

Character

No

Enter the secondary source of the cash flow manual adjustment entry.

O

15

Journal Number

8

Integer

No

Enter the general ledger journal entry number associated with the cash flow manual adjustment entry.

P

16

Description

40

Character

No

Enter a description of the cash flow manual adjustment entry.

Q

17

Cash Account

29

Character

No

Enter a valid cash general ledger account for the cash flow manual adjustment entry. The account must be a Cash category account.