| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DCollection.Company_ID | Link to Company |
| tiCreationUsr_ID | integer | DCollection.CreationUsr_ID | Link to Usr |
| tcCustomCombo0 | character | DCollection.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | DCollection.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | DCollection.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | DCollection.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | DCollection.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | DCollection.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | DCollection.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | DCollection.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | DCollection.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | DCollection.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | DCollection.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | DCollection.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | DCollection.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | DCollection.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | DCollection.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | DCollection.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | DCollection.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | DCollection.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | DCollection.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | DCollection.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | DCollection.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | DCollection.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | DCollection.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | DCollection.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | DCollection.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | DCollection.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | DCollection.CustomLong1 | Custom Long Field |
| tcCustomNote | character | DCollection.CustomNote | Custom Note Field |
| tcCustomShort0 | character | DCollection.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | DCollection.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | DCollection.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | DCollection.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | DCollection.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | DCollection.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | DCollection.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | DCollection.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | DCollection.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | DCollection.CustomShort9 | Custom Short Field |
| tiDCollection_ID | integer | DCollection.DCollection_ID | Record ID |
| tdDCollectionBalanceCC | decimal | DCollection.DCollectionBalanceCC | SC Balance |
| tdDCollectionBalanceCreditCC | decimal | DCollection.DCollectionBalanceCreditCC | SC Credit Balance |
| tdDCollectionBalanceCreditLC | decimal | DCollection.DCollectionBalanceCreditLC | BC Credit Balance |
| tdDCollectionBalanceCreditTC | decimal | DCollection.DCollectionBalanceCreditTC | TC Credit Balance |
| tdDCollectionBalanceDebitCC | decimal | DCollection.DCollectionBalanceDebitCC | SC Debit Balance |
| tdDCollectionBalanceDebitLC | decimal | DCollection.DCollectionBalanceDebitLC | BC Debit Balance |
| tdDCollectionBalanceDebitTC | decimal | DCollection.DCollectionBalanceDebitTC | TC Debit Balance |
| tdDCollectionBalanceLC | decimal | DCollection.DCollectionBalanceLC | BC Balance |
| tdDCollectionBalanceTC | decimal | DCollection.DCollectionBalanceTC | TC Balance |
| tcDCollectionBankFileFormat | character | DCollection.DCollectionBankFileFormat | Bank File Format |
| ttDCollectionCreationDate | date | DCollection.DCollectionCreationDate | Creation Date |
| tiDCollectionCreationTime | integer | DCollection.DCollectionCreationTime | Creation Time |
| tcDCollectionIncSelCodeList | character | DCollection.DCollectionIncSelCodeList | Customer Payment Selection Code |
| tlDCollectionIsAutomatic | logical | DCollection.DCollectionIsAutomatic | Automatic |
| tlDCollectionIsExecuted | logical | DCollection.DCollectionIsExecuted | Executed |
| tcDCollectionName | character | DCollection.DCollectionName | Name |
| tiDCollectionNumber | integer | DCollection.DCollectionNumber | Number |
| tdDCollectionOrigCreditCC | decimal | DCollection.DCollectionOrigCreditCC | SC Original Credit |
| tdDCollectionOrigCreditLC | decimal | DCollection.DCollectionOrigCreditLC | SC Original Credit |
| tdDCollectionOrigCreditTC | decimal | DCollection.DCollectionOrigCreditTC | TC Original Credit |
| tdDCollectionOrigDebitCC | decimal | DCollection.DCollectionOrigDebitCC | SC Original Debit |
| tdDCollectionOrigDebitLC | decimal | DCollection.DCollectionOrigDebitLC | BC Original Debit |
| tdDCollectionOrigDebitTC | decimal | DCollection.DCollectionOrigDebitTC | TC Original Debit |
| tcDCollectionReference | character | DCollection.DCollectionReference | 1099 Box Reference |
| ttDCollectionRequestedDate | date | DCollection.DCollectionRequestedDate | Requested Date |
| tiDCollectionYear | integer | DCollection.DCollectionYear | Year/Customer Payment Selection Code |
| tiDPaySel_ID | integer | DCollection.DPaySel_ID | Link to DPaySel |
| tiGL_ID | integer | DCollection.GL_ID | GL Account |
| ttLastModifiedDate | date | DCollection.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | DCollection.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | DCollection.LastModifiedUser | Last Modified User |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DCollection) |
each DCollection where