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
55: Reserved for Clients
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F55IF425SD25410Sales Order per BO - 2005Transaction Files55: Reserved for ClientsAS400 Coexistence Tables
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 SDKCOO, SDDOCO, SDDCTO, SDLNID, SDMCU, SDSFXO, SDCO, SDOKCO, SDOORN, SDOCTO, SDOGNO, SDRKCO, SDRORN, SDRCTO, SDRLLN, SDDMCT, SDDMCS, SDBALU, SDAN8, SDSHAN, SDPA8, SDDRQJ, SDTRDJ, SDGS1A, SDPDDJ, SDOPDJ, SDADDJ, SDGS1B, SDIVD, SDGS1C, SDCNDJ, SDDGL, SDRSDJ, SDPEFJ, SDPPDJ, SDPSDJ, SDVR01, SDVR02, SDITM, SDLITM, SDAITM, SDLOCN, SDLOTN, SDFRGD, SDTHGD, SDFRMP, SDTHRP, SDEXDP, SDDSC1, SDDSC2, SDLNTY, SDNXTR, SDLTTR, SDEMCU, SDRLIT, SDKTLN, SDCPNT, SDRKIT, SDKTP, SDSRP1, SDSRP2, SDSRP3, SDSRP4, SDSRP5, SDPRP1, SDPRP2, SDPRP3, SDPRP4, SDPRP5, SDUOM, SDUORG, SDSOQS, SDSOBK, SDSOCN, SDSONE, SDUOPN, SDQTYT, SDQRLV, SDCOMM, SDOTQY, SDUPRC, SDAEXP, SDAOPN, SDPROV, SDTPC, SDAPUM, SDLPRC, SDUNCS, SDECST, SDCSTO, SDTCST, SDINMG, SDPTC, SDRYIN, SDDTBS, SDTRDC, SDFUN2, SDASN, SDPRGR, SDCLVL, SDDSPR, SDDSFT, SDFAPP, SDCADC, SDKCO, SDDOC, SDDCT, SDODOC, SDODCT, SDOKC, SDPSN, SDDELN, SDPRMO, SDDFTN, SDTAX1, SDTXA1, SDEXR1, SDATXT, SDPRIO, SDRESL, SDBACK, SDSBAL, SDAPTS, SDLOB, SDEUSE, SDDTYS, SDCDCD, SDNTR, SDVEND, SDANBY, SDCARS, SDMOT, SDCOT, SDROUT, SDSTOP, SDZON, SDCNID, SDFRTH, SDAFT, SDSHCM, SDSHCN, SDSERN, SDUOM1, SDPQOR, SDUOM2, SDSQOR, SDUOM4, SDITWT, SDWTUM, SDITVL, SDVLUM, SDRPRC, SDORPR, SDORP, SDCMGP, SDCMGL, SDGLC, SDCTRY, SDFY, SDSTTS, SDSO01, SDSO02, SDSO03, SDSO04, SDSO05, SDSO06, SDSO07, SDSO08, SDSO09, SDSO10, SDSO11, SDSO12, SDSO13, SDSO14, SDSO15, SDSLSM, SDSLCM, SDSLM2, SDSLC2, SDACOM, SDCMCG, SDGRWT, SDGWUM, SDANI, SDAID, SDOMCU, SDOBJ, SDSUB, SDLT, SDSBL, SDSBLT, SDLCOD, SDUPC1, SDUPC2, SDUPC3, SDSWMS, SDUNCD, SDCRMD, SDCRCD, SDCRR, SDFPRC, SDFUP, SDFEA, SDFUC, SDFEC, SDURAB, SDURRF, SDTORG, SDTDAY, SDALPH, SDAC04, SDDL01, SDALPH1, SDAA03, SDDL02, SDPTD, SDCW01, SDA201, SDCW02, SDA202, SDCW03, SDA203, SDCW04, SDA204, SDCW05, SDA301, SDCW06, SDA302, SDCW07, SDA303, SDCNV1, SDUPAX, SDA111, SDCNV2, SDPRIC, SDA112, SDCNV3, SDPRIF, SDA113, SDCNV4, SDNPRC, SDA114, SDCNV5, SDXPRC, SDA115, SDCLQT, SDCLAM, SDPNC, SDSVYR, SDAST, SDAA08, SDABIT, SDACID, SDAIDS FROM F55IF425

TOP812 | 55 | F55IF425 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2SDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3SDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4SDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5SDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6SDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
7SDCOCompanyStringGeneric Edit50 Allow NULL? 
8SDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9SDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10SDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11SDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12SDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13SDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14SDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16SDDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17SDDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18SDBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
19SDAN8Address NumberNumericUDC80 Allow NULL? 
20SDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
21SDPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
22SDDRQJDate - RequestedDateGeneric Edit60
23SDTRDJDate - Order/TransactionDateGeneric Edit60
24SDGS1AGeneric String x 10StringGeneric Edit100 Allow NULL? 
25SDPDDJDate - Scheduled PickDateGeneric Edit60
26SDOPDJDate - Original Promised DeliveryDateGeneric Edit60
27SDADDJDate - Actual Ship DateDateGeneric Edit60
28SDGS1BGeneric String x 10StringGeneric Edit100 Allow NULL? 
29SDIVDDate - InvoiceDateGeneric Edit60
30SDGS1CGeneric String x 10StringGeneric Edit100 Allow NULL? 
31SDCNDJDate - CancelDateGeneric Edit60
32SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
33SDRSDJDate - Promised DeliveryDateGeneric Edit60
34SDPEFJDate - Price Effective DateDateGeneric Edit60
35SDPPDJDate - Promised ShipmentDateGeneric Edit60
36SDPSDJDate - Future Date 2DateGeneric Edit60
37SDVR01ReferenceStringGeneric Edit250 Allow NULL? 
38SDVR02Reference 2StringGeneric Edit250 Allow NULL? 
39SDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
40SDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
41SDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
42SDLOCNLocationStringGeneric Edit200 Allow NULL? 
43SDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
44SDFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
45SDTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
46SDFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
47SDTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
48SDEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
49SDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
50SDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
51SDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
52SDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
53SDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
54SDEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
55SDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
56SDKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
57SDCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
58SDRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
59SDKTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
60SDSRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
61SDSRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
62SDSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
63SDSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
64SDSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
65SDPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
66SDPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
67SDPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
68SDPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
69SDPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
70SDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
71SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
72SDSOQSQuantity ShippedNumericGeneric Edit152 Allow NULL? 
73SDSOBKUnits - Qty Backordered/HeldNumericGeneric Edit152 Allow NULL? 
74SDSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
75SDSONEUnits - Future Quantity CommittedNumericGeneric Edit152 Allow NULL? 
76SDUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
77SDQTYTUnits - Shipped to DateNumericGeneric Edit152 Allow NULL? 
78SDQRLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
79SDCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
80SDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
81SDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
82SDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
83SDAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
84SDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
85SDTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
86SDAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
87SDLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
88SDUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
89SDECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
90SDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
91SDTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
92SDINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
93SDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
94SDRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
95SDDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
96SDTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
97SDFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
98SDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
99SDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
100SDCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
101SDDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
102SDDSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
103SDFAPPDiscount Application TypeCharacterGeneric Edit10 Allow NULL? 
104SDCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
105SDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
106SDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
107SDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
108SDODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
109SDODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
110SDOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
111SDPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
112SDDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
113SDPRMONumber - Promotion NumberStringGeneric Edit80 Allow NULL? 
114SDDFTNDraft NumberNumericGeneric Edit80 Allow NULL? 
115SDTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
116SDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
117SDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
118SDATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
119SDPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
120SDRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
121SDBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
122SDSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
123SDAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
124SDLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
125SDEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
126SDDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
127SDCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
128SDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
129SDVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
130SDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
131SDCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
132SDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
133SDCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
134SDROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
135SDSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
136SDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
137SDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
138SDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
139SDAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
140SDSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
141SDSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
142SDSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
143SDUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
144SDPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
145SDUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
146SDSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
147SDUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
148SDITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
149SDWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
150SDITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
151SDVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
152SDRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
153SDORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
154SDORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
155SDCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
156SDCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
157SDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
158SDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
159SDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
160SDSTTSLine StatusStringGeneric Edit20 Allow NULL? 
161SDSO01Inter Branch SalesCharacterGeneric Edit10 Allow NULL? 
162SDSO02On Hand UpdatedCharacterGeneric Edit10 Allow NULL? 
163SDSO03Configurator Print FlagCharacterGeneric Edit10 Allow NULL? 
164SDSO04Sales Order Status 04CharacterGeneric Edit10 Allow NULL? 
165SDSO05Substitute Item IndicatorCharacterGeneric Edit10 Allow NULL? 
166SDSO06Preference Commitment IndicatorCharacterGeneric Edit10 Allow NULL? 
167SDSO07Ship date (PDDJ) overriddenCharacterGeneric Edit10 Allow NULL? 
168SDSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
169SDSO09Price Adj. History IndicatorCharacterGeneric Edit10 Allow NULL? 
170SDSO10Preference Production AllocationCharacterGeneric Edit10 Allow NULL? 
171SDSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
172SDSO12Deferred entries flagCharacterGeneric Edit10 Allow NULL? 
173SDSO13Euro Conversion Status FlagCharacterGeneric Edit10 Allow NULL? 
174SDSO14Sales Order Status 14CharacterGeneric Edit10 Allow NULL? 
175SDSO15Sales Order Status 15CharacterGeneric Edit10 Allow NULL? 
176SDSLSMSalesperson 01NumericGeneric Edit80 Allow NULL? 
177SDSLCMSalesperson Commission 001NumericGeneric Edit73 Allow NULL? 
178SDSLM2Salesperson 02NumericGeneric Edit80 Allow NULL? 
179SDSLC2Salesperson Commission 002NumericGeneric Edit73 Allow NULL? 
180SDACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
181SDCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
182SDGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
183SDGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
184SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
185SDAIDAccount IDStringGeneric Edit80 Allow NULL? 
186SDOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
187SDOBJObject AccountStringGeneric Edit60 Allow NULL? 
188SDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
189SDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
190SDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
191SDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
192SDLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
193SDUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
194SDUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
195SDUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
196SDSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
197SDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
198SDCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
199SDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
200SDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
201SDFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
202SDFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
203SDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
204SDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
205SDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
206SDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
207SDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
208SDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
209SDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
210SDALPHName - AlphaStringGeneric Edit400 Allow NULL? 
211SDAC04Category Code - Address Book 04StringUDC (01 04)30 Allow NULL? 
212SDDL01DescriptionStringGeneric Edit300 Allow NULL? 
213SDALPH1Name - Alpha Contact 1StringGeneric Edit400 Allow NULL? 
214SDAA03Alpha Spec. Data 03StringGeneric Edit30 Allow NULL? 
215SDDL02Description 02StringGeneric Edit300 Allow NULL? 
216SDPTDDescription - Payment TermsStringGeneric Edit300 Allow NULL? 
217SDCW01Amount - Unit Cost - Wtd Avg Prior 01NumericGeneric Edit154 Allow NULL? 
218SDA201Work Order TypeStringUDC (48 OT)20 Allow NULL? 
219SDCW02Amount - Unit Cost - Wtd Avg Prior 02NumericGeneric Edit154 Allow NULL? 
220SDA202Generic 2 String 02StringGeneric Edit20 Allow NULL? 
221SDCW03Amount - Unit Cost - Wtd Avg Prior 03NumericGeneric Edit154 Allow NULL? 
222SDA203Generic 2 String 03StringGeneric Edit20 Allow NULL? 
223SDCW04Amount - Unit Cost - Wtd Avg Prior 04NumericGeneric Edit154 Allow NULL? 
224SDA204Carton Creation StatusStringUDC (46 RS)20 Allow NULL? 
225SDCW05Amount - Unit Cost - Wtd Avg Prior 05NumericGeneric Edit154 Allow NULL? 
226SDA301Generic String 01StringGeneric Edit30 Allow NULL? 
227SDCW06Amount - Unit Cost - Wtd Avg Prior 06NumericGeneric Edit154 Allow NULL? 
228SDA302Generic String 02StringGeneric Edit30 Allow NULL? 
229SDCW07Amount - Unit Cost - Wtd Avg Prior 07NumericGeneric Edit154 Allow NULL? 
230SDA303Generic String 03StringGeneric Edit30 Allow NULL? 
231SDCNV1Conversion Factor - Secondary to PrimaryNumericGeneric Edit157 Allow NULL? 
232SDUPAXUnit Price - EnteredNumericUDC154 Allow NULL? 
233SDA111Generic Character11CharacterGeneric Edit10 Allow NULL? 
234SDCNV2Conversion Factor - Purchasing to PrimarNumericGeneric Edit157 Allow NULL? 
235SDPRICUnit Price per PrimaryNumericGeneric Edit154 Allow NULL? 
236SDA112Cross Docking SupplyCharacterGeneric Edit10 Allow NULL? 
237SDCNV3Conversion Factor - Pricing to PrimaryNumericGeneric Edit157 Allow NULL? 
238SDPRIFUnit Price per Primary-ForeignNumericGeneric Edit154 Allow NULL? 
239SDA113Generic Character13CharacterGeneric Edit10 Allow NULL? 
240SDCNV4Conversion Factor - Shipping to PrimaryNumericGeneric Edit157 Allow NULL? 
241SDNPRCUnit Price per Primary - NewNumericGeneric Edit154 Allow NULL? 
242SDA114Generic Character14CharacterGeneric Edit10 Allow NULL? 
243SDCNV5Weight per Primary UnitNumericGeneric Edit157 Allow NULL? 
244SDXPRCUnit Price per SimulatedNumericGeneric Edit154 Allow NULL? 
245SDA115Generic Character15CharacterGeneric Edit10 Allow NULL? 
246SDCLQTClosing QuantityNumericGeneric Edit152 Allow NULL? 
247SDCLAMAmount - ClosingNumericGeneric Edit152 Allow NULL? 
248SDPNCPeriod Number - CurrentNumericGeneric Edit20 Allow NULL? 
249SDSVYRFiscal YearNumericGeneric Edit40 Allow NULL? 
250SDASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
251SDAA08Alpha Spec. Data 08StringGeneric Edit80 Allow NULL? 
252SDABITBill Item Table - AssociatedStringGeneric Edit80 Allow NULL? 
253SDACIDActivity IDStringGeneric Edit80 Allow NULL? 
254SDAIDSAccount ID - SubcontractStringGeneric Edit80 Allow NULL? 

TOP812 | 55 | F55IF425 INDEXES

NumberDescription
1Order Number Order Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
2Order Type Next Status +B
ElementAliasDescriptionSequence
1DCTOOrder TypeAscending
2NXTRStatus Code - NextAscending
3LNTYLine TypeAscending
3Address Number
ElementAliasDescriptionSequence
1AN8Address NumberAscending
4Ship To
ElementAliasDescriptionSequence
1SHANAddress Number - Ship ToAscending
5Pick Slip Number
ElementAliasDescriptionSequence
1PSNPick Slip NumberAscending
6Short Item Branch
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3PDDJDate - Scheduled PickAscending
7Address No Short Item +C
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2ITMItem Number - ShortAscending
3UOMUnit of Measure as InputAscending
4CRCDCurrency Code - FromAscending
5OTQYOther Quantity (1/2)Ascending
6DCTOOrder TypeAscending
7DOCODocument (Order No Invoice etc.)Ascending
8ShipmentNumber
ElementAliasDescriptionSequence
1CDCDCommodity CodeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5LNIDLine NumberAscending
9Short Item Branch +D
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3DRQJDate - RequestedAscending
10Original Order No Type Co
ElementAliasDescriptionSequence
1OORNOriginal Order NumberAscending
2OCTOOriginal Order TypeAscending
3OKCODocument Company (Original Order)Ascending