Table Abbreviation Description Module Activity code
ITMMVT ITV Product-site totals Common Data  

Key Description Duplicates Activity code
ITV0 ITMREF+STOFCY No  
ITV1 STOFCY+ITMREF No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AINVDTAAVC Invoicing element   MD7         SPD
AINVDTACST Invoicing element   MD7         SPD
ALABAVC MAP labor cost   MD7         LABD
ALABCST MAP labor cost   MD7         LABD
AMACAVC MAP machine cost   MD7         MACD
AMACCST MAP machine cost   MD7         MACD
AMATAVC MAP material cost   MD7         MATD
AMATCST MAP material cost   MD7         MATD
AOVELABAVC MAP labor OH   MD7         SPD
AOVELABCST MAP labor OH   MD7         SPD
AOVEMACAVC MAP machine OH   MD7         SPD
AOVEMACCST MAP machine OH   MD7         SPD
AOVEMATAVC MAP material OH   MD7         SPD
AOVEMATCST MAP material OH   MD7         SPD
AOVESCOAVC MAP sub-con OH   MD7         SPD
AOVESCOCST MAP sub-con OH   MD7         SPD
ASCOAVC MAP sub-con cost   MD7         SPD
ASCOCST MAP sub-con cost   MD7         SPD
AUUID Single identifier   AUUID          
AVC Average cost   MD7          
AVCBASAMT AUC base amount   MD7          
AVCBASQTY AUC base quantity   QTY          
BPRCTLSTO Loan stock 'Q'   QTY          
BPRPHYSTO Loan stock 'A'   QTY          
BPRREJSTO Loan stock 'R'   QTY          
CFGVCRNUM Journal number config   VCR         CFG
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CTLALL Int. allocated 'Q'   QTY          
CTLSTO Internal 'Q'   QTY          
CUNDAT Count date 12 D          
CUNDIM Number of lines   C 3        
CUNISSMVT Issues since count   L 7        
CUNNBR No. of counts   L 8        
CUNNBREQU No. of accurate counts   L 8        
CUNQTYCLC Expected count quantities 12 QTY          
CUNQTYNEW Actual count quantities 12 QTY          
CUNRCPMVT Receipts since count   L 7        
CUNSTO Stock last count   QTY          
DETSHT Detail shortage   QTY          
EXPNUM Export number   L 8        
GLOALL Global allocated   QTY          
GLOSHT Global shortage   QTY          
ITMREF Product   ITF     [ITF]ITF0=ITMREF;STOFCY Delete  
LASCUNDAT Last count   D          
LASCUNLIS Last global list   VCR          
LASISSDAT Last issue date   D          
LASPURDAT Last purchase date   D          
LASPURPRI Last purchase price   MD6          
LASRCPDAT Last receipt date   D          
LASRCPPRI Last receipt cost   MD6          
LASREODAT Last reorder date   D          
LINVDTACST Invoicing element   MD6         SPD
LLABCST Last price lab cost   MD6         LABD
LMACCST Last price mch cost   MD6         MACD
LMATCST Last price mat cost   MD6         MATD
LOVELABCST Last price lab OH   MD6         SPD
LOVEMACCST Last price mch OH   MD6         SPD
LOVEMATCST Last price mat OH   MD6         SPD
LOVESCOCST Last price sub-con OH   MD6         SPD
LSCOCST Last price sub-c cost   MD6         SPD
NEXCUNDAT Next count   D          
ORDSTO On reorder   QTY          
PHYALL Int. allocated 'A'   QTY          
PHYSTO Internal 'A'   QTY          
PLFCTLSTO Dock 'Q'   QTY          
PLFPHYSTO Dock 'A'   QTY          
PLFREJSTO Dock 'R'   QTY          
REJALL Int. allocated 'R'   QTY          
REJSTO Internal 'R'   QTY          
SALSTO On sales orders   QTY          
SCCALL Allocated   QTY          
SCCLNDSTO Stock   QTY          
SCOCTLALL Alloc. subcon. 'Q'   QTY          
SCOCTLSTO Subcon. 'Q'   QTY          
SCOPHYALL Alloc. subcon. 'A'   QTY          
SCOPHYSTO Subcon. 'A'   QTY          
SCOREJALL Alloc. subcon. 'R'   QTY          
SCOREJSTO Sub-con stock 'R'   QTY          
STOFCY Storage site   FCY     [FCY]FCY0=[ITV]STOFCY Block  
TRAAMT Amount transfer   MD7          
TRASTO Transferred stock   QTY          
TRFSTO In-transit stock   QTY          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VCRLIN Entry line no.   L 8        
VCRNUM Entry   VCR          
VCRTYP Entry type   M 15 701      
WAISTO Pending issues   QTY