Internal Issue & Reorder level Tables 1

[ZABARVAN]

Hello
Need help know internal issues and IC Reorder Level tables for reports generation. Will appreciate the help.
Thanking You
Zab

 

[Jay Converse]

From the 6.0 AOM:

Roto ID:IC0286 DLL Name: ICICED Internal Usage Details


View Composition - 9 view(s)
IC0288 - ICICEH Internal Usage Headers
IC0287 - ICICEDO Internal Usage Detail Optional F
IC0284 - ICICEDS Internal Usage Serial Numbers
IC0310 - ICITEM Items
IC0750 - ICUNIT Units of Measure
IC0210 - ICCATG Categories
IC0370 - ICLOC Locations
IC0290 - ICILOC Location Details
IC0282 - ICICEDL Internal Usage Lot Numbers

Index List - 1 Index(es)
0 - Sequence Number
SEQUENCENO, LINENO

Field List - 47 fields

Name Type Size Prec Description Index Attrib Initial Value
SEQUENCENO Long 4 0 Sequence Number 1 RKEA 0
LINENO Integer 2 0 Line Number 2 RKEA 0
ITEMNO String 24 0 Item Number 3 EA
Mask Presentation - %-24C
ITEMDESC String 60 0 Item Description 4 CEA
CATEGORY String 6 0 Category 5 EA
Mask Presentation - %-6N
LOCATION String 6 0 Location 6 EA
Mask Presentation - %-6N
QUANTITY BCD 10 4 Quantity 7 EA 0
UNIT String 10 0 Unit of Measure 8 EA
Mask Presentation - %-10w
CONVERSION BCD 10 6 Conversion Factor 9 CEA 0
UNITCOST BCD 10 6 Unit Cost 10 EAX 0
EXTCOST BCD 10 3 Extended Cost 11 EAX 0
SERIALNO Boolean 2 0 Serial Numbers 12 EAX False
COMMENTS String 250 0 Comments 13 EA
MANITEMNO String 24 0 Manufacturer's Item Number 14 EA
Mask Presentation - %-24C
VALUES Long 4 0 Optional Fields 15 CEA 0
DETAILNUM Integer 2 0 Detail Line Number 16 EA 0
GLACCT String 45 0 GL Account 17 EA
Mask Presentation - %-45C
EMPLOYEENO String 60 0 Employee Number 18 EA
FASDETAIL Boolean 2 0 FAS Attached 19 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
SERIALQTY Long 4 0 Number of Serials 20 CEA 0
LOTQTY BCD 10 4 Lot Quantity 21 CEA 0
FUNCTION Integer 2 0 Function 41 EA 0
REVLINE Integer 2 0 Revision List Line Number 42 EA 0
IPCID Long 4 0 Inter-process Comm. ID 43 EA 0
FORCEPOPSN Boolean 2 0 Force Pop-up SN 44 EA False
POPUPSN Integer 2 0 Pop-up SN 45 EA 0
CLOSESN Boolean 2 0 Close SN 46 EA False
LTSETID Long 4 0 LT Set ID 47 EA 0
FORCEPOPLT Boolean 2 0 Force Pop-up LT 48 EA False
POPUPLT Integer 2 0 Pop-up LT 49 EA 0
CLOSELT Boolean 2 0 Close LT 50 EA False
UNFMTITMNO String 24 0 Unformatted Item Number 51 EA
Mask Presentation - %-24C
PROCESSCMD Integer 2 0 Process Command 52 CEA 0
List Presentation with 9 items in the list:
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
31 - Post Serials/Lots to IC Inventory
FASDB String 32 0 Database 53 EA
FASCMP String 32 0 Company 54 EA
FASTMPL String 25 0 Template 55 EA
TEXTDESC String 80 0 Asset Description 56 EA
SEPQTY Boolean 2 0 Separate Quantities 57 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
FASQTY BCD 10 5 Asset Quantity 58 EA 0
UOM String 10 0 Unit of Measure 59 EA
AMTHC BCD 10 3 Amount 60 EA 0
XGENALCQTY BCD 10 4 Serial/Lot Quantity to Process 61 CEA 0
XLOTMAKQTY BCD 10 4 Number of Lots to Generate 62 CEA 0
XPERLOTQTY BCD 10 4 Quantity per Lot 63 CEA 0
SALLOCFROM String 40 0 Allocate from Serial 64 CEA
LALLOCFROM String 40 0 Allocate from Lot 65 CEA
METERHWND Long 4 0 Serial/Lot Window Handle 66 CEA 0
---------------------------------------------------------------------------------------------------------------
Roto ID:IC0287 DLL Name: ICICEDO Internal Usage Detail Optional F


View Composition - 1 view(s)
IC0286 - ICICED Internal Usage Details

Index List - 2 Index(es)
0 - Internal Usage Detail Optional F
SEQUENCENO, LINENO, OPTFIELD
1 - Optional Field/Internal Usage De
OPTFIELD, SEQUENCENO, LINENO

Field List - 20 fields

Name Type Size Prec Description Index Attrib Initial Value
SEQUENCENO Long 4 0 Sequence Number 1 RKEA 0
LINENO Integer 2 0 Line Number 2 RKEA 0
OPTFIELD String 12 0 Optional Field 3 RKEA
Mask Presentation - %-12N
VALUE String 60 0 Value 4 EAP
Mask Presentation - %-60c
TYPE Integer 2 0 Type 5 CEA 1
List Presentation with 7 items in the list:
1 - Text
100 - Amount
6 - Number
8 - Integer
9 - Yes/No
3 - Date
4 - Time
LENGTH Integer 2 0 Length 6 CEA 60
DECIMALS Integer 2 0 Decimals 7 CEA 0
ALLOWNULL Boolean 2 0 Allow Blank 8 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
VALIDATE Boolean 2 0 Validate 9 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
SWSET Integer 2 0 Value Set 10 EA 0
List Presentation with 3 items in the list:
0 - No
1 - Yes
99 - Not Applicable
VALINDEX Long 4 0 Typed Value Field Index 20 CEA 21
VALIFTEXT String 60 0 Text Value 21 CEAP
Mask Presentation - %-60c
VALIFMONEY BCD 10 3 Amount Value 22 CEA 0
VALIFNUM BCD 10 0 Number Value 23 CEAT 0
VALIFLONG Long 4 0 Integer Value 24 CEA 0
VALIFBOOL Boolean 2 0 Yes/No Value 25 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
VALIFDATE Date 5 0 Date Value 26 CEA
VALIFTIME Time 5 0 Time Value 27 CEA 12:00:00 AM
FDESC String 60 0 Optional Field Description 28 CEA
VDESC String 60 0 Value Description 29 CEA
---------------------------------------------------------------------------------------------------------------
Roto ID:IC0288 DLL Name: ICICEH Internal Usage Headers


View Composition - 2 view(s)
IC0286 - ICICED Internal Usage Details
IC0289 - ICICEHO Internal Usage Optional Fields

Index List - 6 Index(es)
0 - Sequence Number
SEQUENCENO
1 - Transaction Number
TRANSNUM
2 - Record Status
STATUS, TRANSNUM
3 - Document Number
DOCNUM
4 - IC-Unique Document Number
DOCUNIQ
5 - Status by Document Number
STATUS, DOCNUM

Field List - 22 fields

Name Type Size Prec Description Index Attrib Initial Value
SEQUENCENO Long 4 0 Sequence Number 1 RKEA 0
TRANSNUM BCD 10 0 Transaction Number 2 CEA 1
DOCNUM String 22 0 Internal Usage Number 3 EA *** NEW ***
Mask Presentation - %-22C
HDRDESC String 60 0 Description 4 EA
TRANSTYPE Integer 2 0 Entry Type 5 EA 1
List Presentation with 2 items in the list:
1 - Internal Usage
2 - Return
TRANSDATE Date 5 0 Internal Usage Date 6 EA 4/3/11
FISCYEAR String 4 0 Fiscal Year 7 EA 2011
Mask Presentation - %4D
FISCPERIOD Integer 2 0 Fiscal Period 8 EAP 4
List Presentation with 12 items in the list:
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 0 Reference 9 EA
DOCUNIQ BCD 10 0 IC-Unique Document Number 10 EA 0
NEXTDTLNUM Integer 2 0 Next Detail Line Number 11 CEA 1
STATUS Integer 2 0 Record Status 12 EA 2
List Presentation with 4 items in the list:
1 - Entered
2 - Posted
3 - Costed
20 - Day End Completed
DELETED Boolean 2 0 Record Deleted 13 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
PRINTED Boolean 2 0 Record Printed 14 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
VALUES Long 4 0 Optional Fields 15 CEA 0
EMPLOYEENO String 60 0 Employee Number 16 EA
ENTEREDBY String 8 0 Entered By 17 EA
Mask Presentation - %-8N
DATEBUS Date 5 0 Posting Date 18 EA 4/3/11
POSTSEQNUM Long 4 0 Post Sequence Number 61 CA 0
CPACTIVE Boolean 2 0 Is Canadian Payroll Active? 62 CA False
List Presentation with 2 items in the list:
False - No
True - Yes
UPACTIVE Boolean 2 0 Is U.S. Payroll Active? 63 CA True
List Presentation with 2 items in the list:
False - No
True - Yes
PROCESSCMD Integer 2 0 Process Command 64 CEA 0
List Presentation with 2 items in the list:
0 - Nothing to Process
1 - Insert Optional Fields
---------------------------------------------------------------------------------------------------------------
Roto ID:IC0289 DLL Name: ICICEHO Internal Usage Optional Fields


View Composition - 1 view(s)
IC0288 - ICICEH Internal Usage Headers

Index List - 2 Index(es)
0 - Internal Usage Optional Field
SEQUENCENO, OPTFIELD
1 - Optional Field/Internal Usage He
OPTFIELD, SEQUENCENO

Field List - 19 fields

Name Type Size Prec Description Index Attrib Initial Value
SEQUENCENO Long 4 0 Sequence Number 1 RKEA 0
OPTFIELD String 12 0 Optional Field 2 RKEA
Mask Presentation - %-12N
VALUE String 60 0 Value 3 EAP
Mask Presentation - %-60c
TYPE Integer 2 0 Type 4 CEA 1
List Presentation with 7 items in the list:
1 - Text
100 - Amount
6 - Number
8 - Integer
9 - Yes/No
3 - Date
4 - Time
LENGTH Integer 2 0 Length 5 CEA 60
DECIMALS Integer 2 0 Decimals 6 CEA 0
ALLOWNULL Boolean 2 0 Allow Blank 7 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
VALIDATE Boolean 2 0 Validate 8 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
SWSET Integer 2 0 Value Set 9 EA 0
List Presentation with 3 items in the list:
0 - No
1 - Yes
99 - Not Applicable
VALINDEX Long 4 0 Typed Value Field Index 20 CEA 21
VALIFTEXT String 60 0 Text Value 21 CEAP
Mask Presentation - %-60c
VALIFMONEY BCD 10 3 Amount Value 22 CEA 0
VALIFNUM BCD 10 0 Number Value 23 CEAT 0
VALIFLONG Long 4 0 Integer Value 24 CEA 0
VALIFBOOL Boolean 2 0 Yes/No Value 25 CEA False
List Presentation with 2 items in the list:
False - No
True - Yes
VALIFDATE Date 5 0 Date Value 26 CEA
VALIFTIME Time 5 0 Time Value 27 CEA 12:00:00 AM
FDESC String 60 0 Optional Field Description 28 CEA
VDESC String 60 0 Value Description 29 CEA

 

[ZABARVAN]

Thank you so much.