| DB | Areas | X-idx | Tables | Sequences | <- acr-ageing | acr-arinv -> | HtmlDict 11 |
Accounts Receivable Invoice Allocation
| Area | FinData |
|---|---|
| Dumpname | aralloc |
| Label | Accounts Receivable Invoice Allocation |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 90 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 30 | alloc-amt | X | Alloc Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 70 | alloc-date | X | Alloc Date | date | 99/99/9999 | ? | ||
| 80 | alloc-descr | X | Alloc Descr | character | x(30) | |||
| 37 | alloc-source | X | Alloc Source | character | ! | |||
| 39 | alloc-type-ind | X | Alloc Type Ind | logical | Cap/Int | No | ||
| 20 | inv-no | X | Invoice No | character | x(12) | |||
| 21 | inv-trn-type | X | Transaction Type | character | x(3) | |||
| 25 | ln-no | X | Line No | integer | >>>>>9 | 0 | ||
| 35 | recpt-date | X | Receipt Date | date | 99/99/9999 | ? | ||
| 10 | recpt-no | X | Receipt No | character | x(12) | |||
| 15 | recpt-trn-type | X | Transaction Type | character | x(3) | |||
| 40 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 50 | upd-time | X | At | integer | 99999 | 0 | ||
| 60 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| inv-no | P | inv-no (+) | character |
| ln-no (+) | integer | ||
| acct-no | acct-no (+) | character | |
| alloc-date | alloc-date (+) | date | |
| alloc-source | alloc-source (+) | character | |
| inv-type | inv-no (+) | character | |
| inv-trn-type (+) | character | ||
| recpt-date | recpt-date (+) | date | |
| recpt-no | recpt-no (+) | character | |
| recpt-trn-type (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-clntacct cbk-pcinvhdr cbk-receipt inv-combocom inv-comboitem |
| generated 18-9-2026 10:01 |