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  TRANSTYPEASSMENSEQ
Type and Document Number M  TRANSTYPEDOCNUM
Record Status M  STATUSTRANSNUM
Document Number DOCNUM
IC-Unique Document Number D M  DOCUNIQ
Status by Document Number M  STATUSDOCNUM
Master Assembly Number M  MASTASSNUMDOCNUM
Master Assembly/Multilevel Seq. D M  MASTASSNUMMULTSEQ

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