View: Order Kitting Details

RotoID: OE0502
Table: OEORDDD
Protocol: Detail, Ordered revisions
DLL:OEORDDD

Compositions: 3

RotoID Tables Title DLL
OE0500 OEORDD Order Details OEORDD
OE0504 OEORDDDS Order Kitting Serial Numbers OEORDDDS
OE0506 OEORDDDL Order Kitting Detail Lot Numbers OEORDDDL

Keys: 4

Title Fields
Uniq./Line Number/Parent Cmp. Nu ORDUNIQ, LINENUM, PRNCOMPNUM, COMPNUM
Uniq./Line Number/Component Numb ORDUNIQ, LINENUM, COMPNUM
Uniq./Detail Number/Component Nu ORDUNIQ, DETAILNUM, COMPNUM
Component Number/Uniq./Detail Nu COMPONENT, ORDUNIQ, LINENUM, PRNCOMPNUM, COMPNUM

Fields: 76

Field Index Type Title Attributes Presentation
ORDUNIQ 1 BCD*10.0 Order Uniquifier E A K R 
LINENUM 2 Integer Detail Line Number E A K R 
PRNCOMPNUM 3 Long Parent Component Number E A K R 
COMPNUM 4 Long Component Number E A K R 
DETAILNUM 5 Integer Detail Number E A 
COMPONENT 6 String*24 Component Item E A  Mask: %-24C
DESC 7 String*60 Description E A X 
ACCTSET 8 String*6 Item Account Set E A X  Mask: %-6N
USERCOSTMD 9 Boolean User-Specified Costing Method E A X 
LOCATION 10 String*6 Location E A X  Mask: %-6N
PICKSEQ 11 String*10 Picking Sequence E A X 
STOCKITEM 12 Boolean Stock Item E A X 
QTY 13 BCD*10.4 Kitting Quantity E A 
PRNQTYORD 14 BCD*10.4 Parent Quantity Ordered E A 
PRNQTYSHIP 15 BCD*10.4 Parent Quantity Shipped E A 
PRNUNIT 16 String*10 Parent Unit of Measure E A C  Mask: %-10c
PRNUNTCONV 17 BCD*10.6 Parent Unit Conversion E A 
QTYORDERED 18 BCD*10.4 Quantity Ordered E A 
QTYSHIPPED 19 BCD*10.4 Quantity Shipped E A 
QTYPO 20 BCD*10.4 P/O Quantity Ordered E A C 
ORDUNIT 21 String*10 Order Unit of Measure E A C  Mask: %-10c
UNITCONV 22 BCD*10.6 Order Unit Conversion E A C 
UNITCOST 23 BCD*10.6 Order Unit Cost E A X 
MOSTREC 24 BCD*10.6 Most Recent Unit Cost E A C 
STDCOST 25 BCD*10.6 Standard Unit Cost E A C 
COST1 26 BCD*10.6 Alternate Unit Cost 1 E A C 
COST2 27 BCD*10.6 Alternate Unit Cost 2 E A C 
AVGCOST 28 BCD*10.6 Average Unit Cost E A C 
LASTCOST 29 BCD*10.6 Last Unit Cost E A C 
COSTUNIT 30 String*10 Costing Unit of Measure E A C  Mask: %-10c
COSUNTCST 31 BCD*10.6 Costing Unit Cost E A X 
COSUNTCONV 32 BCD*10.6 Costing Unit Conversion E A C 
EXTOCOST 33 BCD*10.3 Extended Order Cost E A C 
UNITWEIGHT 34 BCD*10.4 Unit Weight E A X 
EXTWEIGHT 35 BCD*10.4 Extended Weight E A X 
GLNONSTKCR 37 String*45 Non-stock Clearing Account E A X  Mask: %-45C
WEIGHTUNIT 38 String*10 Weight Unit of Measure E A X 
WEIGHTCONV 39 BCD*10.6 Weight Conversion Factor E A C 
PRNWGTCONV 40 BCD*10.6 Parent Weight Conversion Factor E A X 
PRNUWEIGHT 41 BCD*10.4 Parent Weight UOM Unit Weight E A C 
PRNEXTWGHT 42 BCD*10.4 Parent WUOM Extended Unit Weight E A C 
DDTLNO 43 String*6 Kit No. E A X  Mask: %-6N
SERIALQTY 44 Long Serial Quantity E A C 
LOTQTY 45 BCD*10.4 Lot Quantity E A C 
SQTYMOVED 46 Long Serial Qty. Shipped E A C 
LQTYMOVED 47 BCD*10.4 Lot Qty. Shipped E A C 
SLITEM 48 Integer Item Serialized/Lotted? E A C P  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
CMPUNTCOST 100 BCD*10.6 Component Unit Cost E A C 
CMPMOSTREC 101 BCD*10.6 Most Recent Component Cost E A C 
CMPSTDCOST 102 BCD*10.6 Standard Component Cost E A C 
CMPCOST1 103 BCD*10.6 Alternate Component Cost 1 E A C 
CMPCOST2 104 BCD*10.6 Alternate Component Cost 2 E A C 
CMPAVGCOST 105 BCD*10.6 Average Component Cost E A C 
CMPLSTCOST 106 BCD*10.6 Last Component Cost E A C 
GLNONSTKCD 107 String*60 Non-stock Clearing Acct. Desc. E A 
IPCID 108 Long Inter-process Comm. ID E A 
FPOPSNQO 109 Boolean Force Pop-up SN on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPSNQS 110 Boolean Force Pop-up SN on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPSN 111 Integer Pop-up SN E A  List:2 entries
0 = No
1 = Yes
CLOSESN 112 Boolean Close SN E A  List:2 entries
0 = No
1 = Yes
LTSETID 113 Long LT Set ID E A 
FPOPLTQO 114 Boolean Force Pop-up LT on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPLTQS 115 Boolean Force Pop-up LT on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPLT 116 Integer Pop-up LT E A  List:2 entries
0 = No
1 = Yes
CLOSELT 117 Boolean Close LT E A  List:2 entries
0 = No
1 = Yes
SERIALITEM 118 Boolean Component Serialized E A  List:2 entries
0 = No
1 = Yes
UNFMTITEM 119 String*24 Unformatted Item Number E A  Mask: %-24C
LOTTEDITEM 120 Boolean Component Lotted E A  List:2 entries
0 = No
1 = Yes
WUOMDESC 121 String*60 Weight UOM Description A C 
PROCESSCMD 122 Integer Process Command E A C  List:17 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
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
29 = Create List of Existing Serials/Lots
31 = Post Serials/Lots to IC Inventory
32 = Verify Serials/Lots
XGENALCQTY 123 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 124 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 125 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 126 String*40 Allocate from Serial E A C 
LALLOCFROM 127 String*40 Allocate from Lot E A C 
METERHWND 128 Long Serial/Lot Window Handle E A C 

This page was generated on 2022-Aug-18

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