Table PINVOICE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PINVOICE | PIH | Purchase invoices | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PIH0 | NUM | No | |
| PIH1 | BPR+BPRVCR | Yes | |
| PIH2 | GTE+NUM | No | |
| PIH3 | ACCDAT+BPR | Yes | |
| PIH4 | CUR+BPR+NUM | No | SVC |
| PIH5 | CPY+EECNUMDEB+ACCDAT | Yes | DEB |
| PIH6 | RCRNUM+RCRDAT | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Internal number | L | 8 | |||||
| AMTATI | Amount + tax | MD1 | ||||||
| AMTATIL | Invoice amt. + tax (co) | MD1 | ||||||
| AMTNOT | Amount - tax | MD1 | ||||||
| AMTNOTL | Amount - tax (co) | MD1 | ||||||
| AMTSUBJ1099 | Amt. subject to 1099 | MD1 | S1099 | |||||
| AMTTAX | Tax amount | 20 | MD1 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BASDEP | Early disc/late charge calc basis | MD1 | ||||||
| BASTAX | Tax basis | 20 | MD1 | |||||
| BELVCS | VCS number | VCS | KBE | |||||
| BOX1099 | 1099 box | A | 4 | S1099 | ||||
| BPAADDLIG | Address line | 3 | ADL | |||||
| BPAINV | Address | ADR | ||||||
| BPAPAY | Pay-to BP address | ADR | ||||||
| BPR | BP | BPR | [BPR]BPR0=[PIH]BPR | Block | ||||
| BPRDAT | Source date | D | ||||||
| BPRNAM | Company name | 2 | NAM | |||||
| BPRPAY | Pay-by | BPR | [BPR]BPR0=[PIH]BPRPAY | Block | ||||
| BPRSAC | Control | SAC | ||||||
| BPRVCR | Source document | A | 20 | |||||
| BPYADDLIG | Address line | 3 | ADL | |||||
| BPYCRY | Country | CRY | [TCY]TCY0=[PIH]BPYCRY | Block | ||||
| BPYCRYNAM | Country name | NCY | ||||||
| BPYCTY | City | CTY | ||||||
| BPYNAM | Company name | 2 | NAM | |||||
| BPYPOSCOD | Postal code | POS | ||||||
| BPYSAT | County | SAT | ||||||
| BVRBID | Bank account number | BID | KSW | |||||
| BVRREFLINE | ISR reference line | A | 55 | KSW | ||||
| CAI | CAI number | A | 10 | KAG | ||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CEEFLG | EU invoice | M | 4 | 1 | ||||
| CLSVCR | Class | A | 10 | KAG | ||||
| CPY | Company | CPY | [CPY]CPY0=[PIH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation author | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[PIH]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CSHVAT | Cash VAT tax rule | M | 4 | 1 | KSP | |||
| CTY | City | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[PIH]CUR | Block | ||||
| CURLED | Ledger currency | 10 | CUR | [TCU]TCU0=[PIH]CURLED | Block | |||
| CURTYP | Rate type | M | 15 | 202 | ||||
| DAS2 | Fees declaration | M | 4 | 1 | FEE2 | |||
| DATVLYCAI | CAI validity date | D | 1 | KAG | ||||
| DEDTAX | Deductible tax | 20 | MD1 | |||||
| DEP | Early discount/Late charge | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DEPRAT | Early discount rate | RAT | ||||||
| DEPTYP | Price - / +tax | M | 6 | 243 | ||||
| DES | Comments | 5 | DES | |||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[PIH]DIE | Block | ANA | |||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[PIH]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| EECNAT | Transaction nature | TEC | [TEC]TEC0=EECNAT;[V]GSUPCLE | Block | DEB | |||
| EECNUM | EU identification | A | 20 | DEB | ||||
| EECNUMDEB | EU Intrastat | C | 4 | DEB | ||||
| EECSCH | Intrastat rule | TSC | [TSC]TSC0=EECSCH;[V]GSUPCLE | Block | DEB | |||
| EECTRN | Intrastat transp. mode | M | 15 | 237 | DEB | |||
| ENDDATSVC | End service | D | SVC | |||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Site | FCY | [FCY]FCY0=[PIH]FCY | Block | ||||
| FFWADD | Forwarding agent address | ADR | ||||||
| FFWNUM | Freight agent | BPT | [BPT]BPT0=[PIH]FFWNUM | Block | ||||
| FIY | Fiscal year | C | 2 | |||||
| FLD40REN | Field 40 - reason | ADI | [ADI]CODE=8300;FLD40REN | Block | KPO | |||
| FLD41REN | Field 41 - reason | ADI | [ADI]CODE=8301;FLD41REN | Block | KPO | |||
| FRM1099 | 1099 form | M | 15 | 3601 | S1099 | |||
| GTE | Entry type | GTE | [GTE]GTE0=GTE;[V]GSUPCLE | Block | ||||
| ICTCTY | Incoterm town | CTY | ||||||
| INVNUM | Invoice number | VCR | ||||||
| INVREF | Internal reference | REF | ||||||
| INVTYP | Invoice category | M | 15 | 645 | ||||
| JOU | Journal | JOU | [JOU]JOU0=JOU;[V]GSUPCLE | Block | ||||
| LASDATSVC | Accrued costs posted | D | SVC | |||||
| LED | Ledger | 10 | LED | [LED]LED0=[PIH]LED | Block | |||
| NBRCPY | Number of companies | C | 2 | |||||
| NBRTAX | Number of taxes | C | 2 | |||||
| NUM | Document no. | VCR | ||||||
| ORIDOCNUM | Original document no. | A | 30 | KPO | ||||
| ORIMOD | Source module | M | 10 | 14 | ||||
| PAZ | Pay approval | M | 15 | 510 | ||||
| PER | Period | C | 2 | |||||
| PIHTYP | Purchase invoice cat. | M | 20 | 533 | ||||
| PIVTYP | Invoice type | TPV | [TPV]TPV0=PIVTYP;[V]GSUPCLE | Block | ||||
| PJTH | Project | PJT | [PIM]PIM0=[PIH]PJTH | Block | ||||
| PORIMPLIQNUM | Import tax pmt no | VCR | KPO | |||||
| POSCOD | Postal code | POS | ||||||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
| PURPRITYP | Supplier amount type | M | 10 | 243 | ||||
| PURTYP | Purchase type | 20 | M | 5 | 646 | |||
| RATDAT | Rate date | D | ||||||
| RATDIV | Dividing rate | 10 | RCU | |||||
| RATMLT | Multiplying rate | 10 | RCU | |||||
| RCRDAT | Recurrence date | D | ||||||
| RCRNUM | Recurring number | VCR | ||||||
| RITAMT | Amount | 10 | DCB | 9.2 | WTHMG | |||
| RITAMTDED | Amount deducted | 10 | DCB | 9.2 | WTHMG | |||
| RITBAS | Bases | 10 | DCB | 9.2 | WTHMG | |||
| RITBASDED | Deducted basis | 10 | DCB | 9.2 | WTHMG | |||
| RITCOD | Withholding code | 10 | RTZ | [RTZ]RTZ0=[PIH]RITCOD | Block | WTHMG | ||
| RITINV | Proforma | VCR | WTHMG | |||||
| RITNBR | No. of withholdings | C | 4 | WTHMG | ||||
| RITPAY | Payment | VCR | WTHMG | |||||
| SAT | County | SAT | ||||||
| SCUVCR | Branch | A | 10 | KAG | ||||
| SEQVCR | Sequence | A | 10 | KAG | ||||
| SINUM | Integrale part no. | A | 10 | SMI | ||||
| SNS | Sign | C | 2 | |||||
| SPACUS | SCD reference | A | 40 | KSP | ||||
| SPACUSBPR | SCD BP code | BPS | [BPS]BPS0=[PIH]SPACUSBPR | Block | KSP | |||
| SPACUSDAT | SCD date | D | KSP | |||||
| SPADERNUM | DER code | A | 60 | KSP | ||||
| STA | Status | M | 15 | 509 | ||||
| STRDATSVC | Start service | D | SVC | |||||
| STRDUDDAT | Due date basis | D | ||||||
| TAX | Taxes | 20 | VAT | [TVT]TVT0=TAX(indice);[V]GSUPCLE | Block | |||
| TWMSTA | Match status | M | 15 | 585 | ||||
| TYPVCR | Document type | A | 10 | KAG | ||||
| UBLAMT | Unblock amount | MD8 | ||||||
| UBLDAT | Unblock date | D | ||||||
| UBLUSR | Unblock user | AUS | [AUS]CODUSR=[PIH]UBLUSR | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change author | A | 5 | |||||
| VAC | Tax rule | TVB | [TVB]TVB0=VAC;[V]GSUPCLE | Block | ||||
| VATDAT | Tax date on credit | D |