Dictionary >  Module Sales >  Table Sales invoice detail  

Display all Hide all

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
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          
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  
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