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 |