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