| DB | Areas | X-idx | Tables | Sequences | <- acr-poltar | acr-sainvhdr -> | HtmlDict 11 |
Clients Recurring Billing
| Area | FinData |
|---|---|
| Dumpname | recbills |
| Label | Clients Recurring Billing |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 115 | acct-cde | X | Acct Code | character | x(4) | |||
| 15 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 195 | appr-user-id | X | Approved User Id | character | x(8) | |||
| 95 | area-cde | X | Area Code | character | x(3) | |||
| 85 | bal-amt | X | Balance Amount | decimal-2 | ZZZ,ZZZ,ZZ9.99 | 0 | ||
| 125 | clerk-no | X | Clerk No | integer | >9 | 0 | ||
| 10 | client-no | X | Client No | character | x(6) | |||
| 105 | cost-cde | X | Cost Code | character | x(4) | |||
| 135 | date-capt | X | Date Captured | date | 99/99/9999 | ? | ||
| 235 | due-day | X | Due Day | integer | 99 | 0 | ||
| 165 | eff-date | X | Effective Date | date | 99/99/9999 | ? | ||
| 75 | inv-amt | X | Invoice Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 255 | inv-name | X | Nam | character | x(30) | |||
| 185 | inv-stat | X | Invoice Status | logical | Approved/Unapproved | FALSE | ||
| 245 | last-gen | X | Last Generated | date | 99/99/9999 | ? | ||
| 155 | no-of | X | No Of | integer | >>9 | 0 | ||
| 145 | no-of-times | X | No Of Times | integer | 999 | 0 | ||
| 5 | recur-doc-no | X | Recurrance Document No | integer | ZZZZZ9 | 0 | ||
| 45 | recur-freq | X | Recurrance Frequency | character | ! | |||
| 35 | recur-type | X | Recurrance Type | integer | >9 | 0 | ||
| 55 | ref-no | X | Ref No | character | x(12) | |||
| 25 | remit-to-acct | X | Remit To | character | xxxxxx-xx-x | |||
| 175 | start-mth | X | Start Month | integer | 99 | 0 | ||
| 265 | tax-amt | X | Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 70 | tax-cat | X | Tax Category | character | X(2) | |||
| 65 | tax-cde | X | Tax Code | character | x(2) | 0 | ||
| 275 | tax-incl-excl | X | Tax Incl/Excl | logical | Incl/Excl | Incl | ||
| 205 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 225 | upd-time | X | At | integer | 99999 | 0 | ||
| 215 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| acr-recur | P U | recur-doc-no (+) | integer |
| no-of | no-of (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-clerk acr-clienthist acr-clntacct lsc-bp-acct sys-taxrate |
| Child tables |
|---|
| acp-recur-inv acp-recur-invln |
| generated 18-9-2026 10:01 |