Table: Assemblies

Table: ICASEN
View: IC0160
Record length: 476
Flags: A R 

Keys: 10

Title  Flags  Fields
Sequence Number  ASSMENSEQ
Transaction Number  M  TRANSNUM
Type and Sequence Number  M  TRANSTYPE, ASSMENSEQ
Type and Document Number  M  TRANSTYPE, DOCNUM
Record Status  M  STATUS, TRANSNUM
Document Number  DOCNUM
IC-Unique Document Number  D M  DOCUNIQ
Status by Document Number  M  STATUS, DOCNUM
Master Assembly Number  M  MASTASSNUM, DOCNUM
Master Assembly/Multilevel Seq.  D M  MASTASSNUM, MULTSEQ

Fields: 42

Field  Type  Title  Presentation 
ASSMENSEQ  Long  Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSNUM  BCD*10.0  Transaction Number   
DOCNUM  String*22  Assembly Number  Mask: %-22C
TRANSDATE  Date  Transaction Date   
FISCYEAR  String*4  Fiscal Year  Mask: %4D
FISCPERIOD  Integer  Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
REFERENCE  String*60  Reference   
HDRDESC  String*60  Description   
ITEMNO  String*24  Item Number  Mask: %-24C
BOMNO  String*6  BOM Number  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
QUANTITY  BCD*10.4  Quantity   
UNIT  String*10  Unit of Measure   
TRANSTYPE  Integer  Transaction Type  List: 2 entries
1=Assembly
2=Disassembly
DOCUNIQ  BCD*10.0  IC-Unique Document Number   
STATUS  Integer  Record Status  List: 4 entries
1=Entered
2=Posted
3=Costed
20=Day End Completed
DELETED  Boolean  Record Deleted  List: 2 entries
0=No
1=Yes
MANITEMNO  String*24  Manufacturer's Item Number  Mask: %-24C
UNITCOST  BCD*10.6  Unit Cost   
FROMASSNUM  String*22  From Assembly Number  Mask: %-22C
FROMASSQTY  BCD*10.4  From Assembly Quantity   
DISASSCOST  BCD*10.3  Disassembly Cost   
PRINTED  Boolean  Record Printed  List: 2 entries
0=No
1=Yes
VALUES  Long  Optional Fields   
MASTASSNUM  String*22  Master Assembly Number  Mask: %-22C
COMPASSMTD  Integer  Component Assembly Method  List: 3 entries
0=None
1=All Component Master Items
2=Component Master Items with Insufficient Quantity
USEDQTY  BCD*10.4  Quantity Used   
NEEDQTYSTK  BCD*10.4  Qty Needed (Stocking UOM)   
MULTLEVEL  Integer  Multilevel Level   
MULTSEQ  Long  Multilevel Seq. No.   
PRNMULTSEQ  Long  Multilevel Parent Seq. No.   
PRNASSNUM  String*22  Multilevel Parent Assembly No.  Mask: %-22C
CMPMASTITM  String*24  Component's Master Item No.  Mask: %-24C
ENTEREDBY  String*8  Entered By  Mask: %-8N
DATEBUS  Date  Posting Date   
SITEMCOUNT  Long  Serial Items in Assembly   
LITEMCOUNT  Long  Lot Items in Assembly   
REMAINASSD  BCD*10.4  Assembly Quantity Remaining   

This page was generated on 2009-Nov-19

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