View: Assemblies

RotoID: IC0160
Table: ICASEN
Protocol: Header, Key auto generate
DLL:ICASEN

Compositions: 6

RotoID Tables Title DLL
IC0200 ICBOMH Bills of Material ICBOMH
IC0370 ICLOC Locations ICLOC
IC0290 ICILOC Location Details ICILOC
IC0165 ICASENO Assembly Optional Fields ICASENO
IC0162 ICASENL Assembly Lot Details ICASENL
IC0167 ICASENS Assembly Serial Details ICASENS

Keys: 10

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

Fields: 75

Field Index Type Title Attributes Presentation
ASSMENSEQ 1 Long Sequence Number E A K R 
TRANSNUM 2 BCD*10.0 Transaction Number E A C 
DOCNUM 3 String*22 Assembly Number E A  Mask: %-22C
TRANSDATE 4 Date Transaction Date E A 
FISCYEAR 5 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 6 Integer Fiscal Period E A P  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 7 String*60 Reference E A 
HDRDESC 8 String*60 Description E A 
ITEMNO 9 String*24 Item Number E A  Mask: %-24C
BOMNO 10 String*6 BOM Number E A  Mask: %-6N
LOCATION 11 String*6 Location E A  Mask: %-6N
QUANTITY 12 BCD*10.4 Quantity E A 
UNIT 13 String*10 Unit of Measure A C 
TRANSTYPE 14 Integer Transaction Type E A  List:2 entries
1 = Assembly
2 = Disassembly
DOCUNIQ 15 BCD*10.0 IC-Unique Document Number E A 
STATUS 16 Integer Record Status E A  List:4 entries
1 = Entered
2 = Posted
3 = Costed
20 = Day End Completed
DELETED 17 Boolean Record Deleted E A  List:2 entries
0 = No
1 = Yes
MANITEMNO 18 String*24 Manufacturer's Item Number E A  Mask: %-24C
UNITCOST 19 BCD*10.6 Unit Cost E A 
FROMASSNUM 20 String*22 From Assembly Number E A  Mask: %-22C
FROMASSQTY 21 BCD*10.4 From Assembly Quantity E A 
DISASSCOST 22 BCD*10.3 Disassembly Cost E A 
PRINTED 23 Boolean Record Printed E A  List:2 entries
0 = No
1 = Yes
VALUES 24 Long Optional Fields E A C 
MASTASSNUM 25 String*22 Master Assembly Number E A C  Mask: %-22C
COMPASSMTD 26 Integer Component Assembly Method E A P  List:3 entries
0 = None
1 = All Component Master Items
2 = Component Master Items with Insufficient Quantity
USEDQTY 27 BCD*10.4 Quantity Used E A C 
NEEDQTYSTK 28 BCD*10.4 Qty Needed (Stocking UOM) E A C 
MULTLEVEL 29 Integer Multilevel Level E A C 
MULTSEQ 30 Long Multilevel Seq. No. E A C 
PRNMULTSEQ 31 Long Multilevel Parent Seq. No. E A C 
PRNASSNUM 32 String*22 Multilevel Parent Assembly No. E A C  Mask: %-22C
CMPMASTITM 33 String*24 Component's Master Item No. E A C  Mask: %-24C
ENTEREDBY 34 String*8 Entered By E A C  Mask: %-8N
DATEBUS 35 Date Posting Date E A 
SITEMCOUNT 36 Long Serial Items in Assembly E A C 
LITEMCOUNT 37 Long Lot Items in Assembly E A C 
REMAINASSD 38 BCD*10.4 Assembly Quantity Remaining E A 
CONVERSION 41 BCD*10.6 Conversion Factor E A C 
IPCID 42 Long Inter-process Comm. ID E A 
ESTIMACOST 43 BCD*10.3 Estimated Cost E A 
FORCEPOPSN 44 Boolean Force Pop-up SN E A 
POPUPSN 45 Integer Pop-up SN E A 
CLOSESN 46 Boolean Close SN E A 
LTSETID 47 Long LT Set ID E A 
FORCEPOPLT 48 Boolean Force Pop-up LT E A 
POPUPLT 49 Integer Pop-up LT E A 
CLOSELT 50 Boolean Close LT E A 
CDOCNUM 51 String*22 Assembly Number E A 
POSTSEQNUM 52 Long Post Sequence Number A C 
FROMASSSEQ 53 Long From Assembly Seq. A C 
PROCESSCMD 54 Integer Process Command E A C  List:8 entries
0 = Nothing to Process
1 = Insert Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
FMTITEMNO 55 String*24 Formatted Item Number A C 
FMTCMPMAST 56 String*24 Formatted Comp. Master Item No. A C 
ITEMDESC 57 String*60 Item Description A C 
GLBATCHID 58 String*6 G/L Batch ID E A C  Mask: %06D
XGENALCQTY 59 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 60 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 61 BCD*10.4 Quantity per Lot E A C 
THISCOMPID 62 Long Comp ID Currently Processed E A C 
XPRNCOMPID 63 Long Parent Serial/Lot Component ID A C 
XITEM 64 String*24 Serial/Lot Item A C 
XBOMNO 65 String*6 Serial/Lot BOM Number A C 
XUNIT 66 String*10 Serial/Lot Item Unit of Measure A C 
XPRNITEM 67 String*24 Serial Master Item A C 
SQTYNEEDED 68 BCD*10.4 Serial Quantity Required A C 
LQTYNEEDED 69 BCD*10.4 Lot Quantity Required A C 
SQTYGENALC 70 BCD*10.4 Serial Quantity E A C 
LQTYGENALC 71 BCD*10.4 Lot Quantity E A C 
XPRNSERNUM 72 String*40 Master Serial Number E A C 
XPRNSACTN 73 Integer Master Serial Process Action E A C  List:5 entries
0 = None
1 = Add Master Serial
2 = Delete Master Serial
3 = Verify Master Serial
4 = Assign Master Serials to Comps
SALLOCFROM 74 String*40 Allocate from Serial E A C 
LALLOCFROM 75 String*40 Allocate from Lot E A C 
METERHWND 76 Long Serial/Lot Window Handle E A C 
NOUPDATE 77 Boolean Disallow save/post A C 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).