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