| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DCollection.Company_ID | Link to Company |
| tiDCollection_ID | integer | DCollection.DCollection_ID | Record ID |
| tcDCollectionIncSelCodeList | character | DCollection.DCollectionIncSelCodeList | Customer Payment Selection Code |
| tcDCollectionName | character | DCollection.DCollectionName | Name |
| tiDCollectionNumber | integer | DCollection.DCollectionNumber | Number |
| tcDCollectionReference | character | DCollection.DCollectionReference | 1099 Box Reference |
| ttDCollectionRequestedDate | date | DCollection.DCollectionRequestedDate | Requested Date |
| tiDCollectionYear | integer | DCollection.DCollectionYear | Year/Customer Payment Selection Code |
| tiGL_ID | integer | DCollection.GL_ID | GL Account |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DCollection) |
each DCollection where