View: Transfer Details

RotoID: IC0730
Table: ICTRED
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ICTRED

Compositions: 9

RotoID Tables Title DLL

IC0740 ICTREH Transfer Headers ICTREH
IC0310 ICITEM Items ICITEM
IC0750 ICUNIT Units of Measure ICUNIT
IC0370 ICLOC Locations ICLOC
IC0290 ICILOC Location Details ICILOC
IC0100 ICACCT Account Sets ICACCT
IC0735 ICTREDO Transfer Detail Optional Fields ICTREDO
IC0738 ICTREDS Transfer Detail Serial Numbers ICTREDS
IC0733 ICTREDL Transfer Detail Lot Numbers ICTREDL

Keys: 1

Title Fields

Sequence Number TRANFENSEQLINENO

Fields: 58

Field Index Type Title Attributes Presentation

TRANFENSEQ 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 Description A C 
FROMLOC 5 String*6 From Location A X  Mask: %-6N
FRLOCDESC 6 String*60 Description A C 
TOLOC 7 String*6 To Location A X  Mask: %-6N
TOLOCDESC 8 String*60 Description A C 
QUANTITY 9 BCD*10.4 Quantity Transferred A X 
UNIT 10 String*10 Unit of Measure A X  Mask: %-10w
CONVERSION 11 BCD*10.6 Conversion Factor E A 
COMMENTS 12 String*250 Comments A X 
UNITCOST 13 BCD*10.6 Unit Cost A X 
EXTCOST 14 BCD*10.3 Extended Cost A X 
MPRORATE 15 BCD*10.3 Manual Proration E A X 
UNITWEIGHT 16 BCD*10.4 Unit Weight A X 
EXTWEIGHT 17 BCD*10.4 Extended Weight A X 
MANITEMNO 18 String*24 Manufacturer's Item Number E A  Mask: %-24C
GITLOC 19 String*6 Goods in Transit Location A X  Mask: %-6N
GITLOCDESC 20 String*60 Goods in Transit Location Desc A C 
DETAILNUM 21 Integer Detail Line Number E A 
QTYREQ 22 BCD*10.4 Quantity Requested A X 
UNITREQ 23 String*10 Unit of Measure Qty Requested A X  Mask: %-10w
FACTORREQ 24 BCD*10.6 Conversion Factor Qty Requested E A 
COMPLETE 25 Integer Line Completed E A X 
FROMTRNLNO 26 Integer From Transfer Detail Line No. E A 
VALUES 27 Long Optional Fields E A C 
WEIGHTUNIT 28 String*10 Weight Unit of Measure A 
WEIGHTCONV 29 BCD*10.6 Weight Conversion Factor A 
AMTCONTROL 30 BCD*10.3 GL Control Amount E A 
AUPRORATE 31 BCD*10.3 Prorated Additional Cost E A 
SERIALQTY 32 Long Serial Quantity E A C 
LOTQTY 33 BCD*10.4 Lot Quantity E A C 
SQTYMOVED 34 Long Serial Quantity Received E A C 
LQTYMOVED 35 BCD*10.4 Lot Quantity Received E A C 
FUNCTION 41 Integer Function E A 
REVLINE 42 Integer Revision List Line Number E A 
IPCID 43 Long Inter-process Comm. ID 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 
QTYTRA 51 BCD*10.4 Quantity Transfered to Date E A 
QTYREC 52 BCD*10.4 Quantity Received to Date E A 
TRCOMPLETE 53 Integer Transit Completed E A C X 
QTYOUT 54 BCD*10.4 Quantity Outstanding E A 
UNFMTITMNO 55 String*24 Unformatted Item Number E A  Mask: %-24C
PROCESSCMD 56 Integer Process Command E A C  List:10 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
31 = Post Serials/Lots to IC Inventory
WUOMDESC 57 String*60 Weight UOM Description E A C 
XGENALCQTY 58 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 59 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 60 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 61 String*40 Allocate from Serial E A C 
LALLOCFROM 62 String*40 Allocate from Lot E A C 
METERHWND 63 Long Serial/Lot Window Handle E A C