The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
The CASHFLOW.DAT file holds fields for the Cash Flow Manager.
The CASHFLOW.DAT file has the following indexes:
0 = By GUIDE
1 = By Cash flow ID
2 = By Cash flow description
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. |