Table SINVOICED
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SINVOICED | SID | Sales invoice detail | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SID0 | NUM+SIDLIN | No | |
| SID1 | BPCINV+SALFCY+NUM+SIDLIN | No | |
| SID2 | SOHNUM+CREDAT+NUM | Yes | |
| SID3 | SDHNUM+SDDLIN | Yes | |
| SID4 | CONNUM | Yes | |
| SID5 | SRHNUM | Yes | |
| PJMPJT1 | PJT | Yes | PJM |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLTYP | Allocation type | M | 15 | 294 | ||||
| AMTATILIN | Amount + tax | MD1 | ||||||
| AMTDEPLIN | Discount amount | MD1 | ||||||
| AMTLIN | Line amount | MD1 | ||||||
| AMTNOTLIN | Amount - tax | MD1 | ||||||
| AMTTAXLIN | Tax amount | 3 | MD1 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BASTAXLIN | Taxable amount | 6 | MD1 | |||||
| BPCINV | Bill-to customer | BPC | [BPC]BPC0=[SID]BPCINV | Other | ||||
| CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
| CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
| CONNUM | Service contract no. | VCR | ||||||
| CPRPRI | Cost price | MD8 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[SID]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DDTADEP | Invoice line allocation elemen | MD1 | SFL | |||||
| DDTANOT | Invoice line allocation elemen | MD1 | SFL | |||||
| DDTANUM | Invoice line allocation elemen | SFI | [SFI]SFI0=[SID]DDTANUM | Block | SFL | |||
| DISCRGREN1 | Discount 1 reason | SPR | [SPR]SPR0=[SID]DISCRGREN1 | Block | SP1 | |||
| DISCRGREN2 | Discount 2 reason | SPR | [SPR]SPR0=[SID]DISCRGREN2 | Block | SP2 | |||
| DISCRGREN3 | Discount 3 reason | SPR | [SPR]SPR0=[SID]DISCRGREN3 | Block | SP3 | |||
| DISCRGREN4 | Discount 4 reason | C | 4 | SP4 | ||||
| DISCRGREN5 | Discount 5 reason | C | 4 | SP5 | ||||
| DISCRGREN6 | Discount 6 reason | C | 4 | SP6 | ||||
| DISCRGREN7 | Discount 7 reason | C | 4 | SP7 | ||||
| DISCRGREN8 | Discount 8 reason | C | 4 | SP8 | ||||
| DISCRGREN9 | Discount 9 reason | C | 4 | SP9 | ||||
| DISCRGVAL1 | Discount/Charge 1 | MD8 | SP1 | |||||
| DISCRGVAL2 | Discount/Charge 2 | MD8 | SP2 | |||||
| DISCRGVAL3 | Discount/Charge 3 | MD8 | SP3 | |||||
| DISCRGVAL4 | Discount/Charge 4 | DCB | 19.8 | SP4 | ||||
| DISCRGVAL5 | Discount/Charge 5 | DCB | 19.8 | SP5 | ||||
| DISCRGVAL6 | Discount/Charge 6 | DCB | 19.8 | SP6 | ||||
| DISCRGVAL7 | Discount/Charge 7 | DCB | 19.8 | SP7 | ||||
| DISCRGVAL8 | Discount/Charge 8 | DCB | 19.8 | SP8 | ||||
| DISCRGVAL9 | Discount/Charge 9 | DCB | 19.8 | SP9 | ||||
| DSPLINFLG | Distribution | M | 4 | 1 | ||||
| DSPLINVOL | Line volume | QTY | ||||||
| DSPLINWEI | Line weight | QTY | ||||||
| DSPVOU | Volume unit | UOM | [TUN]TUN0=[SID]DSPVOU | Block | ||||
| DSPWEU | Weight unit | UOM | [TUN]TUN0=[SID]DSPWEU | Block | ||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EECFLOPHY | Physical flow | M | 4 | 1 | DEB | |||
| ENDDAT | End date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FOCFLG | Free | M | 10 | 439 | ||||
| GEOCOD | Geographic code | GEO | KUS | |||||
| GROPRI | Gross price | MD8 | ||||||
| IMPNUMLIG | Import line | L | 8 | |||||
| INSCTYFLG | City interior flag | A | 1 | KUS | ||||
| INVCNDUPD | Reinvoicing | M | 4 | 1 | ||||
| INVDAT | Invoice date | D | ||||||
| INVPRC | Percentage | DCB | 3.4 | |||||
| INVPRNBOM | Print component on invoice | M | 4 | 1 | ||||
| ITMDES | Description | DES | ||||||
| ITMDES1 | Description | DES | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[SID]ITMREF | Block | ||||
| LINEECFLG | Debit line | M | 4 | 1 | DEB | |||
| LINTYP | Line type | M | 15 | 423 | ||||
| LOC | Location filter | LOC | [STC]STC0=STOFCY;LOC | Block | ||||
| LOT | Filter lot | LOT | ||||||
| NETPRI | Net price | MD8 | ||||||
| NETPRIATI | Net price + tax | MD8 | ||||||
| NETPRINOT | Net price - tax | MD8 | ||||||
| NEXINVDAT | Reinvoicing date | D | ||||||
| NUM | Invoice no. | VCR | ||||||
| ORILIN | Free line source | L | 8 | |||||
| PERNBR | Periodicity | C | 4 | |||||
| PERTYP | Periodicity | M | 15 | 635 | ||||
| PFM | Margin | MD1 | ||||||
| PIDLIN | Purch invoice line | L | 8 | |||||
| PITFLG | Points management | QTY | ||||||
| PJT | Project | PJT | [PIM]PIM0=PJT | Block | ||||
| PRIORD | Order price | MD5 | ||||||
| PRIREN | Price reason | SPR | [SPR]SPR0=[SID]PRIREN | Block | ||||
| QTY | Invoiced qty. | QTY | ||||||
| QTYSTU | Invoiced STU | QTY | ||||||
| RATTAXLIN | Tax rates | RAT | ||||||
| REP1 | Sales rep 1 | REP | [REP]REP0=[SID]REP1 | Block | RE1 | |||
| REP2 | Sales rep 2 | REP | [REP]REP0=[SID]REP2 | Block | RE2 | |||
| REPAMT1 | Commission amount 1 | MD1 | RE1 | |||||
| REPAMT2 | Commission amount 2 | MD1 | RE2 | |||||
| REPBAS1 | Commission base 1 | MD1 | RE1 | |||||
| REPBAS2 | Commission base 2 | MD1 | RE2 | |||||
| REPCOE | Commission factor | CCR | ||||||
| REPRAT1 | Commission rate 1 | RAT | RE1 | |||||
| REPRAT2 | Commission rate 2 | RAT | RE2 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SID]SALFCY | Block | ||||
| SAU | Sales unit | UOM | [TUN]TUN0=[SID]SAU | Block | ||||
| SAUSTUCOE | SAL-STK conv. | COE | ||||||
| SDDLIN | Delivery line | L | 8 | |||||
| SDHNUM | Delivery no. | VCR | ||||||
| SGHNUM | Transfer document | VCR | ||||||
| SIDLIN | Invoice line | L | 8 | |||||
| SIDORI | Source doc type | M | 15 | 413 | ||||
| SIDORILIN | Invoice line | L | 8 | |||||
| SIDPSONUM | Project doc number | PSO | [PSOH]PSOH0=[SID]SIDPSONUM | Block | PJM | |||
| SIDSEQNUM | Line | L | 8 | PJM | ||||
| SIDTEX | Line text | TXC | ||||||
| SIHORINUM | Invoice no. | VCR | ||||||
| SOHNUM | Order no. | VCR | ||||||
| SOPLIN | Line | L | 8 | |||||
| SOQSEQ | Sequence number | L | 8 | |||||
| SRDLIN | Return line | L | 8 | |||||
| SRENUM | Service request | SRE | [SRE]SRE0=[SID]SRENUM | Other | ||||
| SRHNUM | Return no. | VCR | ||||||
| SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
| STA | Filter status | A | 12 | |||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SID]STOFCY | Block | ||||
| STOMGTCOD | Stock management | M | 15 | 215 | ||||
| STRDAT | Start date | D | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[SID]STU | Block | ||||
| SVICNUM | Scheduled invoices | VCR | ||||||
| TAXFLG | Taxable flag | M | 4 | 1 | KUS | |||
| TAXGEOFLG | Taxed geo flag | A | 1 | KUS | ||||
| TAXREGFLG | Recorded tax flag | M | 4 | 1 | KUS | |||
| TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACITM | Tax level | 3 | TVI | [TVI]TVI0=VACITM(indice);[V]GSUPCLE | Block | |||
| VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block | |||
| VCRINVCNDLIN | Due date line | L | 8 | |||||
| VCRINVCNDTYP | Due date origin | M | 15 | 476 | ||||
| VTC | Vertex transaction code | A | 1 | KUS | ||||
| VTS | Vertex transaction sub-type | A | 1 | KUS | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=WRH | Other | WRH |