Table SINVOICEV
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SINVOICEV | SIV | Costing sales invoice | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SIV0 | NUM | No | |
| SIV1 | SIHORI+SIHORINUM | Yes | |
| SIV2 | INVTYP+NUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADRVAL | Validated | M | 4 | 1 | LTA | |||
| ARVDAT | Arrival date | D | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BETCPY | Intercompany | M | 4 | 1 | ||||
| BETFCY | Intersites | M | 4 | 1 | ||||
| BPAADD | Delivery address | BPD | [BPD]BPD0=BPCORD;BPAADD | Block | ||||
| BPCGRU | Group customer | BPR | [BPR]BPR0=[SIV]BPCGRU | Block | ||||
| BPCINV | Bill-to customer | BPR | [BPR]BPR0=[SIV]BPCINV | Block | ||||
| BPCORD | Sold-to | BPR | [BPR]BPR0=[SIV]BPCORD | Block | ||||
| BPDADDLIG | Delivery address | 3 | ADL | |||||
| BPDCRY | Delivery country | CRY | [TCY]TCY0=[SIV]BPDCRY | Block | ||||
| BPDCRYNAM | Delivery country name | NCY | ||||||
| BPDCTY | Delivery city | CTY | ||||||
| BPDNAM | Ship-to customer name | 2 | NAM | |||||
| BPDPOSCOD | Deliv postal code | POS | ||||||
| BPDSAT | Delivery country | SAT | ||||||
| BPIEECNUM | EU identification | A | 20 | DEB | ||||
| BPINAM | Bill-to customer name | 2 | NAM | |||||
| BPRFCT | Factor | FCT | [FCT]FCT0=[SIV]BPRFCT | Block | FCT | |||
| BPRPAY | Pay-by | BPR | [BPR]BPR0=[SIV]BPRPAY | Block | ||||
| CMGNUM | Marketing campaign | CMG | [CMG]CMG0=[SIV]CMGNUM | RTZ | ||||
| CNDNAM | Delivery contact | AIN | [AIN]AIN0=CNDNAM | Block | ||||
| CNINAM | Invoice contact | AIN | [AIN]AIN0=CNINAM | Block | ||||
| CNOREN | Memo reason | ADI | [ADI]CODE=8;CNOREN | Block | ||||
| COPNBE | Credit memo copy no. | C | 1 | |||||
| COPNBR | Invoice copies | C | 1 | |||||
| CPY | Company | CPY | [CPY]CPY0=[SIV]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[SIV]CUR | Block | ||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DISCRGTYP | Discount / charge type | M | 10 | 255 | SPR | |||
| DPEDAT | Departure date | D | ||||||
| DSPTOTQTY | Quantity total | DCB | 9.6 | |||||
| DSPTOTVOL | Volume aggregation | QTY | ||||||
| DSPTOTWEI | Weight aggregation | QTY | ||||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[SIV]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[SIV]DSPWEU | Block | ||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[SIV]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| EECNAT | Transaction nature | TEC | [TEC]TEC0=EECNAT;[V]GSUPCLE | Block | DEB | |||
| EECNATR | Transaction nature | TEC | [TEC]TEC0=EECNATR;[V]GSUPCLE | Block | DEB | |||
| EECSCH | Intrastat rule | TSC | [TSC]TSC0=EECSCH;[V]GSUPCLE | Block | DEB | |||
| EECSCHR | Intrastat rule | TSC | [TSC]TSC0=EECSCHR;[V]GSUPCLE | Block | DEB | |||
| EECTRN | Intrastat transp. mode | M | 15 | 237 | DEB | |||
| ENTCOD | Stock auto journal | GAU | [GAU]GAU0=[SIV]ENTCOD | Block | ||||
| ETA | Arrival time | HM | ||||||
| ETD | Departure time | HM | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FFWADD | Forwarding agent address | ADR | ||||||
| FFWNUM | Freight agent | BPT | [BPT]BPT0=[SIV]FFWNUM | Block | ||||
| GEOCOD | Geographic code | GEO | KUS | |||||
| ICTCTY | Incoterm town | CTY | ||||||
| INSATI | Prepayment amt +tax | 4 | MD1 | |||||
| INSCTYFLG | City interior flag | A | 1 | KUS | ||||
| INSLIN | line | 4 | C | 3 | ||||
| INSORDNUM | Order no. | 4 | VCR | |||||
| INVCNOSTA | Credit memo status on invoice | M | 4 | 1 | ||||
| INVDAT | Invoice date | D | ||||||
| INVDTA | Invoicing element | SFI | [SFI]SFI0=[SIV]INVDTA | Other | SFI | |||
| INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
| INVDTADSP | Distrib key | DSP | [DSP]DSP0=INVDTADSP;1 | Other | SFI | |||
| INVDTALIN | Invoice line element | C | 2 | SPR | ||||
| INVDTATYP | Value type | M | 6 | 2227 | SFI | |||
| INVREF | Reference | REF | ||||||
| INVSTA | Status | M | 15 | 2261 | ||||
| INVTYP | Invoice category | M | 15 | 645 | ||||
| LAN | Language | LAN | [TLA]TLA0=[SIV]LAN | Block | ||||
| LICPLATE | Registration | REGLIC | ||||||
| LINNBR | Number of lines | C | 4 | |||||
| NUM | Invoice no. | VCR | ||||||
| OPGNUM | Marketing operation | VCR | ||||||
| OPGTYP | Operation type | A | 3 | |||||
| ORIFCY | Original site | FCY | [FCY]FCY0=[SIV]ORIFCY | Block | ||||
| PAM | Payment method | 4 | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | |||
| PIHNUM | Purchase invoice no. | VCR | ||||||
| PJT | Project | PJT | [PIM]PIM0=[SIV]PJT | Block | ||||
| PLISTC | Structure code | PRS | [PRS]PRS0=1;PLISTC | Other | ||||
| PRITYP | Price - / +tax | M | 6 | 243 | ||||
| REP | Sales rep | REP | [REP]REP0=[SIV]REP | Block | REP | |||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SIV]SALFCY | Block | ||||
| SFISSTCOD | SST tax code | ADI | [ADI]CODE=203;SFISSTCOD | Block | SFI | |||
| SIHCFMFLG | Electronic signature | M | 4 | 1 | KPO | |||
| SIHNUMEND | Final number | VCR | KPO | |||||
| SIHORI | Document origin | M | 12 | 413 | ||||
| SIHORIDAT | Source date | D | ||||||
| SIHORINUM | Original document no. | VCR | ||||||
| SIHORITYP | Source doc type | M | 15 | 476 | ||||
| SIHTEX1 | Invoice header text | TXC | ||||||
| SIHTEX2 | Invoice footer text | TXC | ||||||
| SIVTYP | Sales invoice type | TSV | [TSV]TSV0=SIVTYP;[V]GSUPCLE | Block | ||||
| SRGLOCDEF | Dock location | LOC | [STC]STC0=STOFCY;SRGLOCDEF | Other | ||||
| STARPT | Printing | M | 4 | 1 | ||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SIV]STOFCY | Block | ||||
| STOMVTFLG | Stock transaction | M | 4 | 1 | ||||
| TRLLICPLATE | Trailer license plate | REGLIC | ||||||
| TRSCOD | Movement code | ADI | [ADI]CODE=14;TRSCOD | RTZ | ||||
| TSCCOD | Statistical group | ADI | [ADI]CODE=indice+30;TSCCOD(indice) | Other | STC | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VTT | Vertex transaction type | A | 1 | KUS |