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 |