Table PREPINVOICE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREPINVOICE | PREPI | Prepayment invoice | A/P-A/R accounting | PREPM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PREPI0 | PCNTNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PREPI]CREUSR | Other | ||||
| CURLED | Ledger currency | 10 | CUR | [TCU]TCU0=[PREPI]CURLED | Block | |||
| CURTYP | Rate type | M | 15 | 202 | ||||
| DEDTYP | Prepayment deduction type | M | 15 | 2824 | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[PREPI]DIE | Block | ANA | |||
| FNLBPACC | Final invoice control | SAC | ||||||
| FNLDAT | Final date | D | ||||||
| LED | Ledger | 10 | LED | [LED]LED0=[PREPI]LED | Block | |||
| PCNTAMTATI | Amount + tax | MD1 | ||||||
| PCNTAMTNOT | Amount - tax | MD1 | ||||||
| PCNTBPR | BP | BPR | [BPR]BPR0=[PREPI]PCNTBPR | Block | ||||
| PCNTCUR | Contract currency | CUR | [TCU]TCU0=[PREPI]PCNTCUR | Block | ||||
| PCNTDAT | Contract date | D | ||||||
| PCNTDEP | Early discount/Late charge | TDA | [TDA]TDA0=PCNTDEP;[V]GSUPCLE | Block | ||||
| PCNTDESC | Description | A | 50 | |||||
| PCNTFCY | Site | FCY | [FCY]FCY0=[PREPI]PCNTFCY | Block | ||||
| PCNTNUM | Contract number | PREPI | [PREPI]PREPI0=[PREPI]PCNTNUM | BSRA | ||||
| PCNTORI | Source | M | 15 | 2825 | ||||
| PCNTPTE | Payment term | PTE | [TPT]TPT0=PCNTPTE;[V]GCURLEG;1 | Block | ||||
| PCNTTYP | Customer/Supplier | M | 15 | 242 | ||||
| PCNTVAC | Tax rule | TVB | [TVB]TVB0=PCNTVAC;[V]GSUPCLE | Block | ||||
| PPBPACC | Control | SAC | ||||||
| RATAPL | Applicable rate | M | 15 | 2826 | ||||
| RATDAT | Rate date | D | ||||||
| RATDIV | Dividing rate | 10 | RCU | |||||
| RATMLT | Multiplying rate | 10 | RCU | |||||
| SOHNUM | Sales order | VCR | SALM | |||||
| SOPLIN | Sales order line | L | 8 | SALM | ||||
| SOPSEQ | Sequence | L | 8 | SALM | ||||
| STAT | Status | M | 2824 | |||||
| TOTPREPAMT | Total prepayment amt. | MD1 | SALM | |||||
| TOTPREPTAX | Total prepayment tax | MD1 | SALM | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PREPI]UPDUSR | Other | ||||
| VAT | Tax code | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block |