Cash Receipts Data Entry Table Formats

Follow DPS specifications for preparing a file containing cash receipt data.

Field Name Data Type Notes
RefNo varchar
TransDate datetime
BankCode varchar
TransComment varchar
Description varchar
WBS1 varchar
WBS2 varchar
WBS3 varchar
Invoice varchar
Account varchar
Amount decimal
Interest varchar
TaxCode varchar
TaxBasis decimal
Retainer varchar