View: Receipt Details

RotoID: IC0580
Table: ICREED
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ICREED

Compositions: 9

RotoID Tables Title DLL
IC0590 ICREEH Receipt Headers ICREEH
IC0310 ICITEM Items ICITEM
IC0750 ICUNIT Units of Measure ICUNIT
IC0210 ICCATG Categories ICCATG
IC0370 ICLOC Locations ICLOC
IC0290 ICILOC Location Details ICILOC
IC0585 ICREEDO Receipt Detail Optional Fields ICREEDO
IC0587 ICREEDS Receipt Detail Serial Numbers ICREEDS
IC0582 ICREEDL Receipt Detail Lot Numbers ICREEDL

Keys: 1

Title Fields
Sequence Number SEQUENCENO, LINENO

Fields: 64

Field Index Type Title Attributes Presentation
SEQUENCENO 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 E A C 
CATEGORY 5 String*6 Category E A C  Mask: %-6N
LOCATION 6 String*6 Location E A  Mask: %-6N
RECPQTY 7 BCD*10.4 Quantity Received E A 
RETURNQTY 8 BCD*10.4 Quantity Returned E A C 
RECPUNIT 9 String*10 Unit of Measure E A  Mask: %-10w
CONVERSION 10 BCD*10.6 Conversion Factor E A C 
ADDCSTHM 11 BCD*10.3 Prorated Add'l. Cost-Func. E A C 
ADDCSTSRC 12 BCD*10.3 Prorated Add'l. Cost-Src. E A C 
UNITCOST 13 BCD*10.6 Unit Cost E A 
ADJUNITCST 14 BCD*10.6 Adjusted Unit Cost E A C 
ADJCOST 15 BCD*10.3 Adjusted Cost E A C 
ADJCOSTHM 16 BCD*10.3 Adjusted Cost-Functional E A C 
RECPCOST 17 BCD*10.3 Extended Cost E A 
RECPCOSTHM 18 BCD*10.3 Extended Cost-Functional E A C 
RETURNCOST 19 BCD*10.3 Return Cost E A C 
COSTDATE 20 Date Costing Date E A C 
COSTSEQNO 21 Long Costing Sequence No. E A C 
ORIGQTY 22 BCD*10.4 Original Receipt Qty. E A C 
ORIGUNTCST 23 BCD*10.6 Original Unit Cost E A C 
ORIGEXTCST 24 BCD*10.3 Original Extended Cost E A C 
ORIGEXTHM 25 BCD*10.3 Original Extended Cost-Func. E A C 
COMMENTS 26 String*250 Comments E A 
LABELS 27 Integer Labels E A 
STOCKITEM 28 Boolean Stock Item E A C 
MANITEMNO 29 String*24 Manufacturer's Item Number E A  Mask: %-24C
VENDITEMNO 30 String*24 Vendor Item Number E A 
DETAILNUM 31 Integer Detail Line Number E A 
RETQTY 32 BCD*10.4 Quantity Returned To Date E A C 
RETEXTCST 33 BCD*10.3 Returned Ext. Cost To Date E A C 
RETEXTHM 34 BCD*10.3 Returned Ext. Cost-Func. To Date E A C 
ADJEXTCST 35 BCD*10.3 Adjusted Ext. Cost To Date E A C 
ADJEXTHM 36 BCD*10.3 Adjusted Ext. Cost-Func. To Date E A C 
PREVQTY 37 BCD*10.4 Previous Day-End Receipt Qty. E A C 
PREVUNTCST 38 BCD*10.6 Previous Day-End Unit Cost E A C 
PREVEXTCST 39 BCD*10.3 Previous Day-End Ext. Cost E A C 
PREVEXTHM 40 BCD*10.3 Previous Day-End Ext. Cost-Func. E A C 
UNFMTITMNO 41 String*24 Unformatted Item Number E A  Mask: %-24C
CHKBELZERO 42 Boolean Check Below Zero E A 
REVLINE 43 Integer Revision List Line Number E A 
IPCID 44 Long Inter-process Comm. ID E A 
FORCEPOPSN 45 Boolean Force Pop-up SN E A 
POPUPSN 46 Integer Pop-up SN E A 
CLOSESN 47 Boolean Close SN E A 
LTSETID 48 Long LT Set ID E A 
FORCEPOPLT 49 Boolean Force Pop-up LT E A 
POPUPLT 50 Integer Pop-up LT E A 
CLOSELT 51 Boolean Close LT E A 
VALUES 52 Long Optional Fields E A C 
PROCESSCMD 53 Integer Process Command E A C  List:11 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
27 = Auto-assign Serials
28 = Auto-assign Lots
31 = Post Serials/Lots to IC Inventory
SERIALQTY 54 Long Serial Quantity E A C 
LOTQTY 55 BCD*10.4 Lot Quantity E A C 
SQTYMOVED 56 Long Serial Quantity Returned E A C 
LQTYMOVED 57 BCD*10.4 Lot Quantity Returned 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 
RECPTYPE 61 Integer Receipt Type E A C  List:4 entries
1 = Receipt
2 = Return
3 = Adjustment
4 = Complete
SALLOCFROM 62 String*40 Allocate from Serial E A C 
LALLOCFROM 63 String*40 Allocate from Lot E A C 
METERHWND 64 Long Serial/Lot Window Handle E A C 

This page was generated on 2021-Nov-24

© 2021 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).