Table: Internal Usage Audit List Details

Table: ICINCAD
View: IC0301
Record length: 768
Flags: A R 

Keys: 1

Title  Flags  Fields

Day End Number  DAYENDSEQ, TRANSSEQ, LINENO

Fields: 32

Field  Type  Title  Presentation 

DAYENDSEQ  Long  Day End Number   
TRANSSEQ  Long  Transaction Sequence   
LINENO  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
FMTITEMNO  String*24  Item Number  Mask: %-24C
ITEMDESC  String*60  Item Description   
CATEGORY  String*6  Category  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
QUANTITY  BCD*10.4  Quantity   
UNIT  String*10  Unit of Measure  Mask: %-10w
CONVERSION  BCD*10.6  Conversion Factor   
STOCKQTY  BCD*10.4  Quantity in Stocking Unit   
STOCKUNIT  String*10  Stocking Unit of Measure  Mask: %-10w
UNITCOST  BCD*10.6  User-Specified Cost   
EXTCOST  BCD*10.3  Extended Cost   
VARIANCE  BCD*10.3  Variance   
COMMENTS  String*250  Comments   
EMPLOYEENO  String*60  Used By   
STOCKITEM  Boolean  Stock Item   
ICSEXPACCT  String*45  Consumable Expense Account  Mask: %-45C
VARACCT  String*45  Cost Variance Account  Mask: %-45C
ICACCT  String*45  Inventory Control Account  Mask: %-45C
VALUES  Long  Optional Fields   
PMCONTRACT  String*16  P/M Contract   
PMPROJECT  String*16  P/M Project   
PMCATEGORY  String*16  P/M Category   
PMDETAIL  Long  P/M Detail   
PMOHACCT  String*45  P/M Overhead Account  Mask: %-45C
PMOHAMT  BCD*10.3  P/M Overhead Amount   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.