View: Adjustment Details

RotoID: IC0110
Table: ICADED
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ICADED

Compositions: 10

RotoID Tables Title DLL

IC0120 ICADEH Adjustment Headers ICADEH
IC0310 ICITEM Items ICITEM
IC0370 ICLOC Locations ICLOC
IC0290 ICILOC Location Details ICILOC
IC0750 ICUNIT Units of Measure ICUNIT
GL0001 GLAMF Accounts GLAMF
IC0260 ICCOST Receipt Cost ICCOST
IC0115 ICADEDO Adjustment Detail Opt. Fields ICADEDO
IC0117 ICADEDS Adjustment Detail Serial Numbers ICADEDS
IC0113 ICADEDL Adjustment Detail Lot Numbers ICADEDL

Keys: 1

Title Fields

Sequence Number ADJENSEQLINENO

Fields: 53

Field Index Type Title Attributes Presentation

ADJENSEQ 1 Long Sequence Number E A K R 
LINENO 2 Integer Line Number E A K R 
ITEMNO 3 String*24 Item Number E A  Mask: %-24C
ITEMDESC 4 String*60 Item Description A C 
LOCATION 5 String*6 Location E A  Mask: %-6N
TRANSTYPE 6 Integer Transaction Type E A  List:6 entries
1 = Quantity Increase
2 = Quantity Decrease
3 = Cost Increase
4 = Cost Decrease
5 = Both Increase
6 = Both Decrease
QUANTITY 7 BCD*10.4 Quantity E A X 
UNIT 8 String*10 Unit of Measure E A X  Mask: %-10w
CONVERSION 9 BCD*10.6 Conversion Factor E A 
EXTCOST 10 BCD*10.3 Cost Adjustment A X 
COMMENTS 11 String*250 Comments E A 
WOFFACCT 12 String*45 Adjustment/Write-Off Account A X  Mask: %-45C
ORIGACCT 13 String*45 Original Write-Off Account A C  Mask: %-45C
COSTMETHOD 14 Integer Costing Method A C 
MDALLOCATE 15 Integer Bucket Type A X  List:3 entries
1 = Offset Bucket
2 = Specific Bucket
3 = Prorate
RECEIPT 16 String*22 Document Number A X  Mask: %-22C
COSTDATE 17 Date Cost Date A X 
COSTSEQNUM 18 Long Costing Sequence Number A C X 
STOCKITEM 19 Boolean Stock Item E A C 
MANITEMNO 20 String*24 Manufacturer's Item Number E A  Mask: %-24C
DETAILNUM 21 Integer Detail Line Number E A 
PMCONTRACT 22 String*16 P/M Contract E A 
PMPROJECT 23 String*16 P/M Project E A 
PMCATEGORY 24 String*16 P/M Category E A 
PMOHACCT 25 String*45 P/M Overhead Account E A  Mask: %-45C
PMOHAMT 26 BCD*10.3 P/M Overhead Amount E A 
VALUES 27 Long Optional Fields E A C 
SERIALQTY 28 Long Number of Serials E A C 
LOTQTY 29 BCD*10.4 Lot Quantity E A C 
SERIALCOST 30 BCD*10.3 Serials' Cost E A C 
LOTCOST 31 BCD*10.3 Lots' Cost E A C 
AVGCOST 101 BCD*10.6 Average Cost A C 
COSTUNIT 102 String*10 Cost UOM A C  Mask: %-10w
REVLINE 103 Integer Revision List Line Number E A 
IPCID 104 Long Inter-process Comm. ID E A 
FORCEPOPSN 105 Boolean Force Pop-up SN E A 
POPUPSN 106 Integer Pop-up SN E A 
CLOSESN 107 Boolean Close SN E A 
LTSETID 108 Long LT Set ID E A 
FORCEPOPLT 109 Boolean Force Pop-up LT E A 
POPUPLT 110 Integer Pop-up LT E A 
CLOSELT 111 Boolean Close LT E A 
UNFMTITMNO 112 String*24 Unformatted Item Number E A  Mask: %-24C
OOVERLOC 113 String*6 Process Command Location E A C  Mask: %-6N
OOVERSORTC 114 String*60 Process Command Sort Code E A C 
OOVERITEMN 115 String*24 Process Command Item Number E A C  Mask: %-24C
PROCESSCMD 116 Integer Process Command E A C  List:11 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
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
XGENALCQTY 117 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 118 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 119 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 120 String*40 Allocate from Serial E A C 
LALLOCFROM 121 String*40 Allocate from Lot E A C 
METERHWND 122 Long Serial/Lot Window Handle E A C