Cash Flow Manager Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: CASHFLOW.DAT

The CASHFLOW.DAT file holds fields for the Cash Flow Manager.

Indexes and Their Uses

The CASHFLOW.DAT file has the following indexes:

0 = By GUIDE

1 = By Cash flow ID

2 = By Cash flow description

Fields

The following table shows the fields available in the CASHFLOW.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

CashFlowGuid

UBinary

16

CashFlowID

Zstring

31

CashFlowDescription

Zstring

51

Transaction Types

Zstring

51

List of Journal Transaction types (see Journal in JrnlRow.dat

UseDueDate

Logical

1

Use Due Date flag

True-Use Due Date

False-Use Average Days to Pay

InactiveAccount

Logical

1

Use Inactive Cash Account Flag

AvgDayToPayForAll

integer

4

Unused

AdjTotalBeginningBal

Decimal

Unused

Notes

ZString

251

Additional notes

TimeFrame

Integer

4

Cash Flow time frame enumeration:

0--Next 7 days

1--next 14 days

2--Next 30 days

3--Next 3 months

4--Next 6 months

5--Next 12 months

LastUpdateCounter

Integer

4

Helps to detect when record in table changes after it is opened.