Table PREPINVOICEP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREPINVOICEP | PREPIP | Prepayment invoice payments | A/P-A/R accounting | PREPM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PREPIP0 | INVNUM+PAYNUM+PAYLIN | No | |
| PREPIP1 | PAYNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PREPIP]CREUSR | Other | ||||
| INVNUM | Invoice number | VCR | ||||||
| NUMVCR | Accounting document | VCR | ||||||
| PAYAMTNOT | Paid amount -tax | MD1 | ||||||
| PAYAMTNOTLED | Led. paid amt -tax | MD1 | ||||||
| PAYAMTTAX | Tax paid | MD1 | ||||||
| PAYAMTTAXLED | Tax paid led | MD1 | ||||||
| PAYLIN | Line | C | 4 | |||||
| PAYNUM | Payment number | VCR | ||||||
| PCNTCUR | Contract currency | CUR | [TCU]TCU0=[PREPIP]PCNTCUR | Block | ||||
| PCNTLIN | Line number | L | 8 | |||||
| PCNTNUM | Contract number | PREPI | [PREPI]PREPI0=[PREPIP]PCNTNUM | Other | ||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP(indice);[V]GCURLEG | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PREPIP]UPDUSR | Other | ||||
| VAT | Tax code | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block |