JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

248 COLUMNS | 2 INDEXES | Print definition?920 | 41 | F41UI001 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F41UI001IT2482Inventory Transactions Detail File"T" Work Files41: Inventory ManagementBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT ITCTID, ITJOBS, ITLNID, ITNLIN, ITACTN, ITDOC, ITDCT, ITKCO, ITSFX, ITICU, ITICUT, ITIST, ITITM, ITLITM, ITAITM, ITMCU, ITLOCN, ITLOTN, ITTRQT, ITUNCS, ITPAID, ITPRRC, ITTRUM, ITTRDJ, ITDGL, ITGLPT, ITPLOT, ITLDSQ, ITTRNO, ITFRTO, ITLMCX, ITLOTS, ITLOTP, ITLOTG, ITKIT, ITMMCU, ITDMCT, ITDMCS, ITBALU, ITDCTO, ITDOCO, ITKCOO, ITSFXO, ITIPCD, ITAN8, ITTREF, ITTREX, ITRCD, ITSRP1, ITSRP2, ITSRP3, ITSRP4, ITSRP5, ITSRP6, ITSRP7, ITSRP8, ITSRP9, ITSRP0, ITPRP1, ITPRP2, ITPRP3, ITPRP4, ITPRP5, ITPRP6, ITPRP7, ITPRP8, ITPRP9, ITPRP0, ITFIFO, ITBUYR, ITPRGR, ITRPRC, ITORPR, ITCARP, ITCARS, ITSHCN, ITSHCM, ITCYCL, ITSTKT, ITBACK, ITINMG, ITABCS, ITABCM, ITABCI, ITOVR, ITSRNR, ITTAX1, ITLTLV, ITLTMF, ITLTCM, ITANPL, ITOPC, ITOPV, ITACQ, ITMLQ, ITLLX, ITLTPU, ITMPST, ITMPSP, ITMRPP, ITSLD, ITITC, ITSNS, ITPCTM, ITMMPC, ITCDCD, ITSTDP, ITFRMP, ITCOTY, ITTHRP, ITOT1Y, ITOT2Y, ITFRGD, ITTHGD, ITSTDG, ITORDW, ITMTF1, ITMTF2, ITMTF3, ITMTF4, ITMTF5, ITEXPD, ITDEFD, ITSFLT, ITMAKE, ITSRCE, ITPBIN, ITPQOH, ITPBCK, ITPREQ, ITQWBO, ITOT1P, ITOT2P, ITOT1A, ITHCOM, ITPCOM, ITFCOM, ITFUN1, ITQOWO, ITQTTR, ITQTIN, ITQTO1, ITQTO2, ITQONL, ITQTRI, ITQTRO, ITQTY1, ITQTY2, ITLRCJ, ITNCDJ, ITURCD, ITURDT, ITURAT, ITURAB, ITURRF, ITLDSC, ITMMEJ, ITPN, ITFY, ITDSC1, ITCLEV, ITPLEV, ITUOM1, ITLEDG, ITANI, ITSBL, ITSBLT, ITWR01, ITASII, ITICOS, ITLQOH, ITTQOH, ITTVIA, ITLINN, ITVARA, ITCSMT, ITPCSM, ITCSMF, ITPCSF, ITABRN, ITALON, ITACOS, ITAPRI, ITRLOT, ITLOT1, ITLOT2, ITLOT3, ITMCUF, ITLOTF, ITLOCF, ITFTRN, ITENTC, ITAEXP, ITCYNO, ITTGG, ITSLAT, ITSDCT, ITJEL1, ITJEL2, ITJEL3, ITJEL4, ITJEL5, ITJEL6, ITVUIL, ITBPFG, ITOT5Y, ITAGSQ, ITMODE, ITDTO, ITPSR, ITPSRY, ITSHAN, ITDSC2, ITDUAL, ITSREQ, ITSQWO, ITHCMS, ITSCMS, ITSWSC, ITSWHC, ITSIBW, ITSOBW, ITUOM2, ITBODJ, ITOHDJ, ITDLEJ, ITSBDJ, ITBBDJ, ITU1DJ, ITU2DJ, ITU3DJ, ITU4DJ, ITU5DJ, ITLOTC, ITPJCM, ITPRJM, ITCFGSID, ITPJDM, ITCCFL, ITDOC1, ITCONV, ITCNV1, ITJEL7, ITJEL8, ITTGN, ITRFLN, ITORIG, ITOILNTY FROM F41UI001

TOP920 | 41 | F41UI001 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ITCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2ITJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3ITLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
4ITNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
5ITACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
6ITDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7ITDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
8ITKCODocument CompanyStringGeneric Edit50 Allow NULL? 
9ITSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
10ITICUBatch NumberNumericGeneric Edit80 Allow NULL? 
11ITICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
12ITISTBatch StatusCharacterUDC (98 IC)10 Allow NULL? 
13ITITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
14ITLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
15ITAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
16ITMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
17ITLOCNLocationStringGeneric Edit200 Allow NULL? 
18ITLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
19ITTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
20ITUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
21ITPAIDAmount - Extended Cost/PriceNumericGeneric Edit152 Allow NULL? 
22ITPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
23ITTRUMUnit of Measure - TransactionStringUDC (00 UM)20 Allow NULL? 
24ITTRDJDate - Order/TransactionDateGeneric Edit60
25ITDGLDate - For G/L (and Voucher)DateGeneric Edit60
26ITGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
27ITPLOTParent LotStringGeneric Edit300 Allow NULL? 
28ITLDSQSequence Number - Location DetailNumericGeneric Edit80 Allow NULL? 
29ITTRNOTransaction Line NumberNumericGeneric Edit50 Allow NULL? 
30ITFRTOFrom/ToCharacterGeneric Edit10 Allow NULL? 
31ITLMCXLot Master Cardex (Y/N)CharacterGeneric Edit10 Allow NULL? 
32ITLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
33ITLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
34ITLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
35ITKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
36ITMMCUBranchStringGeneric Edit120 Allow NULL? 
37ITDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
38ITDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
39ITBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
40ITDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
41ITDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
42ITKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
43ITSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
44ITIPCDAs Of Posted CodeCharacterUDC (H41 IP)10 Allow NULL? 
45ITAN8Address NumberNumericGeneric Edit80 Allow NULL? 
46ITTREFTransaction ReferenceStringGeneric Edit80 Allow NULL? 
47ITTREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
48ITRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
49ITSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
50ITSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
51ITSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
52ITSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
53ITSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
54ITSRP6Category Code 6StringUDC (41 06)60 Allow NULL? 
55ITSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
56ITSRP8Category Code 8StringUDC (41 08)60 Allow NULL? 
57ITSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
58ITSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
59ITPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
60ITPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
61ITPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
62ITPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
63ITPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
64ITPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
65ITPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
66ITPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
67ITPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
68ITPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
69ITFIFOFIFO ProcessingCharacterGeneric Edit10 Allow NULL? 
70ITBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
71ITPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
72ITRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
73ITORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
74ITCARPPreferred Carrier - PurchasingNumericGeneric Edit80 Allow NULL? 
75ITCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
76ITSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
77ITSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
78ITCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
79ITSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
80ITBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
81ITINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
82ITABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
83ITABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
84ITABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
85ITOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
86ITSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
87ITTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
88ITLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
89ITLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
90ITLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
91ITANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
92ITOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
93ITOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
94ITACQQuantity - Accounting CostNumericGeneric Edit150 Allow NULL? 
95ITMLQQuantity - MFG LeadtimeNumericGeneric Edit150 Allow NULL? 
96ITLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
97ITLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
98ITMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
99ITMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
100ITMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
101ITSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
102ITITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
103ITSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
104ITPCTMPercent MarginNumericGeneric Edit73 Allow NULL? 
105ITMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
106ITCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
107ITSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
108ITFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
109ITCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
110ITTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
111ITOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
112ITOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
113ITFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
114ITTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
115ITSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
116ITORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
117ITMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
118ITMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
119ITMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
120ITMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
121ITMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
122ITEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
123ITDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
124ITSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
125ITMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
126ITSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
127ITPBINPrimary Location (P/S)CharacterGeneric Edit10 Allow NULL? 
128ITPQOHQuantity on Hand - Primary unitsNumericGeneric Edit150 Allow NULL? 
129ITPBCKQuantity on BackorderNumericGeneric Edit150 Allow NULL? 
130ITPREQQuantity on Purchase Order-primary unitsNumericGeneric Edit150 Allow NULL? 
131ITQWBOQuantity on Work Order ReceiptNumericGeneric Edit150 Allow NULL? 
132ITOT1PQuantity 1 - Other primary unitsNumericGeneric Edit150 Allow NULL? 
133ITOT2PQuantity 2 - Other primary unitsNumericGeneric Edit150 Allow NULL? 
134ITOT1AQuantity - Other Purchasing 1NumericGeneric Edit150 Allow NULL? 
135ITHCOMQuantity - Hard CommittedNumericGeneric Edit150 Allow NULL? 
136ITPCOMQuantity Soft CommittedNumericGeneric Edit150 Allow NULL? 
137ITFCOMQuantity on Future CommitNumericGeneric Edit150 Allow NULL? 
138ITFUN1Quantity - Work Order Soft CommitNumericGeneric Edit150 Allow NULL? 
139ITQOWOQuantity - Work Order Hard CommitNumericGeneric Edit150 Allow NULL? 
140ITQTTRUnits - In Transit - Primary unitsNumericGeneric Edit150 Allow NULL? 
141ITQTINUnits - In Inspection - Primary unitsNumericGeneric Edit150 Allow NULL? 
142ITQTO1Units - In Operation 1 - Primary unitsNumericGeneric Edit150 Allow NULL? 
143ITQTO2Units - In Operation 2 - Primary unitsNumericGeneric Edit150 Allow NULL? 
144ITQONLQuantity - On Loan to ManufacturingNumericGeneric Edit150 Allow NULL? 
145ITQTRIQuantity Inbound - WarehouseNumericGeneric Edit150 Allow NULL? 
146ITQTROQuantity Outbound - WarehouseNumericGeneric Edit150 Allow NULL? 
147ITQTY1Future Use QuantityNumericGeneric Edit150 Allow NULL? 
148ITQTY2Future Use Quantity 2NumericGeneric Edit150 Allow NULL? 
149ITLRCJDate - Last Receipt (Julian)DateGeneric Edit60
150ITNCDJDate - Next Count (Julian)DateGeneric Edit60
151ITURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
152ITURDTUser Reserved DateDateGeneric Edit60
153ITURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
154ITURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
155ITURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
156ITLDSCDescription - LotStringGeneric Edit300 Allow NULL? 
157ITMMEJDate - Lot ExpirationDateGeneric Edit60
158ITPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
159ITFYFiscal YearNumericGeneric Edit20 Allow NULL? 
160ITDSC1DescriptionStringGeneric Edit300 Allow NULL? 
161ITCLEVLevel - Inventory CostCharacterUDC (H40 CL)10 Allow NULL? 
162ITPLEVLevel - Sales Base PriceCharacterUDC (H40 PL)10 Allow NULL? 
163ITUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
164ITLEDGCost MethodStringUDC (40 CM)20 Allow NULL? 
165ITANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
166ITSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
167ITSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
168ITWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
169ITASIIAsset Number-InputStringGeneric Edit260 Allow NULL? 
170ITICOSAmount - Inventory Unit CostNumericGeneric Edit154 Allow NULL? 
171ITLQOHQuantity on Hand - LocationNumericGeneric Edit150 Allow NULL? 
172ITTQOHQuantity - Total Primary on HandNumericGeneric Edit150 Allow NULL? 
173ITTVIAAmount - VarianceNumericGeneric Edit152 Allow NULL? 
174ITLINNLine NumberNumericGeneric Edit73 Allow NULL? 
175ITVARAAmount - VarianceNumericGeneric Edit152 Allow NULL? 
176ITCSMTCosting Method - SalesStringUDC (40 CM)20 Allow NULL? 
177ITPCSMCosting Method - PurchasingStringUDC (40 CM)20 Allow NULL? 
178ITCSMFCosting Method - Sales - FromStringUDC (40 CM)20 Allow NULL? 
179ITPCSFCosting Method - Purchasing - FromStringUDC (40 CM)20 Allow NULL? 
180ITABRNAdd Branch RecordCharacterGeneric Edit10 Allow NULL? 
181ITALONAdd Location RecordCharacterGeneric Edit10 Allow NULL? 
182ITACOSAdd Cost RecordCharacterGeneric Edit10 Allow NULL? 
183ITAPRIAdd Base Price RecordCharacterGeneric Edit10 Allow NULL? 
184ITRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
185ITLOT1Memo Lot 1StringGeneric Edit300 Allow NULL? 
186ITLOT2Memo Lot 2StringGeneric Edit300 Allow NULL? 
187ITLOT3Memo Lot 3StringGeneric Edit300 Allow NULL? 
188ITMCUFBU - FromStringGeneric Edit120 Allow NULL? 
189ITLOTFLot - FromStringGeneric Edit300 Allow NULL? 
190ITLOCFLocation - FromStringGeneric Edit200 Allow NULL? 
191ITFTRNFrom TransactionCharacterGeneric Edit10 Allow NULL? 
192ITENTCCost EnteredCharacterGeneric Edit10 Allow NULL? 
193ITAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
194ITCYNOCycle Count NumberNumericGeneric Edit80 Allow NULL? 
195ITTGGTag NumberNumericGeneric Edit80 Allow NULL? 
196ITSLATScrapped AmountNumericGeneric Edit154 Allow NULL? 
197ITSDCTSales Document TypeStringUDC (00 DT)20 Allow NULL? 
198ITJEL1Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
199ITJEL2Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
200ITJEL3Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
201ITJEL4Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
202ITJEL5Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
203ITJEL6Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
204ITVUILVoid Update Item ledgerCharacterGeneric Edit10 Allow NULL? 
205ITBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
206ITOT5YDetail Costing FlagCharacterGeneric Edit10 Allow NULL? 
207ITAGSQAgreement Sequence NumberNumericGeneric Edit60 Allow NULL? 
208ITMODEMode - ProcessingCharacterGeneric Edit10 Allow NULL? 
209ITDTODue ToCharacterUDC (38 DT)10 Allow NULL? 
210ITPSRSourceStringGeneric Edit120 Allow NULL? 
211ITPSRYSource TypeStringUDC (38 DY)20 Allow NULL? 
212ITSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
213ITDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
214ITDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
215ITSREQQuantity on Purchase Order - SecondaryNumericGeneric Edit150 Allow NULL? 
216ITSQWOSecondary Quantity on Work Order ReceiptNumericGeneric Edit150 Allow NULL? 
217ITHCMSSecondary Quantity Hard CommittedNumericGeneric Edit150 Allow NULL? 
218ITSCMSSecondary Quantity Soft CommittedNumericGeneric Edit150 Allow NULL? 
219ITSWSCSecondaryQuantity W.O. Soft CommitNumericGeneric Edit150 Allow NULL? 
220ITSWHCSecondary Quantity WO Hard CommitNumericGeneric Edit150 Allow NULL? 
221ITSIBWSecondary Quantity Inbound - WarehouseNumericGeneric Edit150 Allow NULL? 
222ITSOBWSecondary Quantity Outbound - WarehouseNumericGeneric Edit150 Allow NULL? 
223ITUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
224ITBODJBased On DateDateGeneric Edit60
225ITOHDJOn Hand DateDateGeneric Edit60
226ITDLEJLot Effectivity DateDateGeneric Edit60
227ITSBDJSell By DateDateGeneric Edit60
228ITBBDJBest Before DateDateGeneric Edit60
229ITU1DJUser Lot Date 1DateGeneric Edit60
230ITU2DJUser Lot Date 2DateGeneric Edit60
231ITU3DJUser Lot Date 3DateGeneric Edit60
232ITU4DJUser Lot Date 4DateGeneric Edit60
233ITU5DJUser Lot Date 5DateGeneric Edit60
234ITLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
235ITPJCMProject Hard Committed Quantity in PrimaNumericGeneric Edit150 Allow NULL? 
236ITPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
237ITCFGSIDUnique Configuration IDStringGeneric Edit320 Allow NULL? 
238ITPJDMProject Hard Committed Quantity in SeconNumericGeneric Edit150 Allow NULL? 
239ITCCFLCost Changed FlagCharacterGeneric Edit10 Allow NULL? 
240ITDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
241ITCONVConversion FactorNumericGeneric Edit157 Allow NULL? 
242ITCNV1Conversion Factor - Secondary to PrimaryNumericGeneric Edit157 Allow NULL? 
243ITJEL7Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
244ITJEL8Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
245ITTGNTransaction Group NumberNumericGeneric Edit73 Allow NULL? 
246ITRFLNRelated From Line NumberNumericGeneric Edit73 Allow NULL? 
247ITORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
248ITOILNTYOutbound Inventory InterfaceCharacterUDC (42I LT)10 Allow NULL? 

TOP920 | 41 | F41UI001 INDEXES

NumberDescription
1Computer Job Line (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3LNIDLine NumberAscending
4NLINNumber of LinesAscending
5DCTOOrder TypeAscending
6DOCODocument (Order No Invoice etc.)Ascending
7KCOOOrder Company (Order Number)Ascending
8SFXOOrder SuffixAscending
2Job Number
ElementAliasDescriptionSequence
1JOBSJob NumberAscending