| DB | Areas | X-idx | Tables | Sequences | <- cbk-shortack | cbk-tender-lnk -> | HtmlDict 11 |
Cashbook Tender
| Area | FinData |
|---|---|
| Dumpname | tender |
| Label | Cashbook Tender |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 120 | bank-acct-no | X | Bank Account No | character | x(12) | |||
| 290 | bank-auth-cde | X | Authorization Code | character | x(6) | |||
| 270 | bank-batch-no | X | Batch No | character | x(4) | 0 | ||
| 110 | bank-branch-no | X | Bank Branch No | character | x(8) | |||
| 230 | bank-cde | X | Bank Code | character | x(2) | |||
| 280 | bank-item-no | X | Item No | character | x(3) | |||
| 250 | bank-recpt-no | X | Receipt No | character | x(4) | 0 | ||
| 240 | bank-ref-no | X | Ref No | character | x(12) | |||
| 260 | bank-seq-no | X | Sequence No | character | x(4) | 0 | ||
| 300 | bank-term-id | X | Bank Term Id | character | x(8) | |||
| 52 | bank-trn-no | X | Bank Trn No | character | x(8) | |||
| 310 | change-amt | X | Change! Due | decimal-2 | ->>,>>9.99 | 0 | ||
| 130 | chq-date | X | Cheque Date | date | 99/99/9999 | ? | ||
| 100 | chq-no | X | Cheque No | integer | 9999999999 | 0 | ||
| 320 | convert-change | X | Converted Change | decimal-2 | ->>,>>9.99 | 0 | D: The amount of change that was converted to Loyalty Points | |
| 160 | cr-card-no | X | Credit Card No | character | x(20) | |||
| 90 | deposit-no | X | Deposit No | character | x(8) | |||
| 220 | drawer-name | X | Drawer Name | character | x(40) | |||
| 170 | expiry-date | X | Expiry Date | character | 99/9999 | |||
| 50 | mail-no | X | Mail No | character | x(8) | |||
| 140 | post-dated | X | Post Dated | logical | Yes/No | no | ||
| 80 | recon-no | X | Reconciled No | character | x(8) | |||
| 40 | recpt-no | X | Receipt No | character | x(12) | |||
| 175 | tel-no | X | Tel No | character | x(20) | |||
| 180 | teller-user-id | X | Teller User Id | character | x(8) | |||
| 70 | tender-amt | X | Tender Amount | decimal-2 | >>>,>>>,>>9.99- | 0 | ||
| 20 | tender-date | X | Tender Date | date | 99/99/9999 | ? | ||
| 10 | tender-no | X | Tender No | character | x(8) | |||
| 30 | tender-stat | X | Tender Status | character | x(2) | |||
| 60 | tender-type | X | Tender Type | character | x(2) | |||
| 150 | trnf-date | X | Transfer Date | date | 99/99/9999 | ? | ||
| 190 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 210 | upd-time | X | At | integer | 99999 | 0 | ||
| 200 | upd-user-id | X | By | character | x(12) | D: User ID. |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| tender-no | P U | tender-no (+) | character |
| bank-acct-no | bank-acct-no (+) | character | |
| bank-branch-no (+) | character | ||
| bank-batch-no | bank-term-id (+) | character | |
| bank-batch-no (+) | character | ||
| bank-ref-no | bank-ref-no (+) | character | |
| bank-trn-no | bank-trn-no (+) | character | |
| chq-date | chq-date (+) | date | |
| chq-no | chq-no (+) | integer | |
| bank-acct-no (+) | character | ||
| bank-branch-no (+) | character | ||
| cr-card-no | cr-card-no (+) | character | |
| deposit-no | deposit-no (+) | character | |
| mail-no | mail-no (+) | character | |
| tender-stat (+) | character | ||
| tender-type (+) | character | ||
| tender-date (+) | date | ||
| tender-amt (+) | decimal | ||
| post-dated | post-dated (+) | logical | |
| recon-no | recon-no (+) | character | |
| tender-stat (+) | character | ||
| tender-type (+) | character | ||
| recpt-no | recpt-no (+) | character | |
| teller-user-id | teller-user-id (+) | character | |
| tender-stat (+) | character | ||
| tender-date | tender-date (+) | date | |
| teller-user-id (+) | character | ||
| tender-type (+) | character | ||
| tender-stat | tender-stat (+) | character | |
| tender-type | tender-type (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| cbk-bnkacct cbk-deposit cbk-mailhdr cbk-receipt cbk-recon inv-combocom inv-comboitem |
| Child tables |
|---|
| cbk-tender-lnk pos-apprcheqtrn |
| generated 24-6-2026 08:24 |