Table PINVOICEV
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PINVOICEV | PIV | Costing purchase invoices | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PIV0 | NUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BETCPY | Intercompany | M | 4 | 1 | ||||
| BPCINV | Bill-to customer | BPR | [BPR]BPR0=[PIV]BPCINV | Block | ||||
| BPR | BP | BPR | [BPR]BPR0=[PIV]BPR | Block | ||||
| CLCLINAMT | Calculated lines -tax | MD1 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[PIV]CPY | Block | ||||
| CPYLAN | Company language | LAN | [TLA]TLA0=[PIV]CPYLAN | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation author | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[PIV]CUR | Block | ||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[PIV]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[PIV]DSPWEU | Block | ||||
| EXPNUM | Export number | L | 8 | |||||
| INVDTALIN1 | Invoice line element | PFI | [PFI]PFI0=[PIV]INVDTALIN1 | Block | PPR | |||
| INVDTALIN2 | Invoice line allocation elemen | 9 | PFI | [PFI]PFI0=[PIV]INVDTALIN2 | Block | |||
| INVDTAVAT1 | Price line tax | VAT | [TVT]TVT0=INVDTAVAT1(indice);[V]GSUPCLE | Block | PPR | |||
| INVDTAVAT2 | Distribution line tax | 9 | VAT | [TVT]TVT0=INVDTAVAT2(indice);[V]GSUPCLE | Block | |||
| INVTYP | Invoice category | M | 15 | 645 | ||||
| LAN | Language | LAN | [TLA]TLA0=[PIV]LAN | Block | ||||
| LINNBR | Number of lines | C | 4 | |||||
| NUM | Document no. | VCR | ||||||
| PIHTYP | Purchase invoice cat. | M | 20 | 533 | ||||
| PIVTYP | Usr invoice type | TPV | [TPV]TPV0=PIVTYP;[V]GSUPCLE | Block | ||||
| PRILINNBR | Number of different price line | C | 4 | |||||
| QTYLINNBR | Number of different quantity L | C | 4 | |||||
| SIHNUM | Sales invoice no. | VCR | ||||||
| TEX1 | Text | TXC | ||||||
| TEX2 | Text | TXC | ||||||
| TOTLINAMT | Invoice lines excluding tax | MD1 | ||||||
| TOTLINQTY | Total quantity lines | DCB | 11.6 | |||||
| TOTLINVOU | Line volume total | QTY | ||||||
| TOTLINWEU | Line weight total | QTY | ||||||
| TOTTAXAMT | Tax total | MD1 | ||||||
| TSSCOD | Statistical group | ADI | [ADI]CODE=indice+40;TSSCOD(indice) | Other | STS | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change author | A | 5 |