Table UNPAID
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| UNPAID | UNP | Doubtful receipt entry | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| UNP0 | NUM+CUR | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | 10 | GAC | [GAC]GAC0=COA(indice);ACC(indice) | Block | |||
| ACCBPR | BP account | 10 | GAC | [GAC]GAC0=COA(indice);ACCBPR(indice) | Block | |||
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Internal number | 50 | UNQ | |||||
| ACCSTA | Function | C | 2 | |||||
| AMTACC | Amount + tax | MD1 | ||||||
| AMTACCNUM | Amount | 50 | MD1 | |||||
| AMTBPR | Amount - tax | MD1 | ||||||
| AMTCRG | Line charge amount | MD1 | ||||||
| AMTVAT | Tax amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BAN | Code | BAN | [BAN]BAN0=[UNP]BAN | Block | ||||
| BPR | BP | BPR | [BPR]BPR0=[UNP]BPR | Block | ||||
| BPRBAN | BP | BPR | [BPR]BPR0=[UNP]BPRBAN | Block | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| COA | Chart code | 10 | COA | [COA]COA0=[UNP]COA | Block | |||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[UNP]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[UNP]CUR | Block | ||||
| DES | Entry description | DES | ||||||
| DESVCR | Entry description | DES | ||||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[UNP]DIE | Block | ANA | |||
| DUDDAT | Due date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[UNP]FCY | Block | ||||
| FLGACT | Debit note | M | 4 | 1 | ||||
| FLGCRG | Expenses on separate journal | M | 4 | 1 | ||||
| GRP | Group | A | 16 | |||||
| IPT | Allocation | M | 4 | 1 | ||||
| JOU | Journal | JOU | [JOU]JOU0=JOU;[V]GSUPCLE | Block | ||||
| NUM | Payment no. | VCR | ||||||
| RENNOTPAY | Late payment reason | ADI | [ADI]CODE=310;RENNOTPAY | Block | ||||
| TAX | Tax | VAT | [TVT]TVT0=TAX;[V]GSUPCLE | Block | ||||
| TYPVCR | Reference | A | 1 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[UNP]UPDUSR | Other |