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

230 COLUMNS | 8 INDEXES | Print definition?910 | 43 | F43199 TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F43199OL2308P.O. Detail Ledger File - Flexible VersionHistory Files43: ProcurementBusiness 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 OLKCOO, OLDOCO, OLDCTO, OLSFXO, OLLNID, OLMCU, OLCO, OLOKCO, OLOORN, OLOCTO, OLOGNO, OLRKCO, OLRORN, OLRCTO, OLRLLN, OLDMCT, OLDMCS, OLBALU, OLAN8, OLSHAN, OLDRQJ, OLTRDJ, OLPDDJ, OLOPDJ, OLADDJ, OLCNDJ, OLPEFJ, OLPPDJ, OLPSDJ, OLDSVJ, OLDGL, OLPN, OLVR01, OLVR02, OLITM, OLLITM, OLAITM, OLLOCN, OLLOTN, OLFRGD, OLTHGD, OLFRMP, OLTHRP, OLDSC1, OLDSC2, OLLNTY, OLNXTR, OLLTTR, OLRLIT, OLPDS1, OLPDS2, OLPDS3, OLPDS4, OLPDS5, OLPDP1, OLPDP2, OLPDP3, OLPDP4, OLPDP5, OLUOM, OLUORG, OLUCHG, OLUOPN, OLUREC, OLCREC, OLURLV, OLOTQY, OLPRRC, OLAEXP, OLACHG, OLAOPN, OLAREC, OLARLV, OLFTN1, OLTRLV, OLPROV, OLAMC3, OLECST, OLCSTO, OLCSMP, OLINMG, OLASN, OLPRGR, OLCLVL, OLCATN, OLDSPR, OLPTC, OLTX, OLEXR1, OLTXA1, OLATXT, OLCNID, OLCDCD, OLNTR, OLFRTH, OLFRTC, OLZON, OLFRAT, OLRATT, OLANBY, OLANCR, OLMOT, OLCOT, OLSHCM, OLSHCN, OLUOM1, OLPQOR, OLUOM2, OLSQOR, OLUOM3, OLITWT, OLWTUM, OLITVL, OLVLUM, OLGLC, OLCTRY, OLFY, OLSTTS, OLRCD, OLFUF1, OLFUF2, OLGRWT, OLGWUM, OLLT, OLANI, OLAID, OLOMCU, OLOBJ, OLSUB, OLSBLT, OLSBL, OLASID, OLCCMP, OLTAG, OLWR01, OLPL, OLELEV, OLR001, OLRTNR, OLLCOD, OLPURG, OLPROM, OLFNLP, OLAVCH, OLPRPY, OLUNCD, OLMATY, OLRTGC, OLRCPF, OLPS01, OLPS02, OLPS03, OLPS04, OLPS05, OLPS06, OLPS07, OLPS08, OLPS09, OLPS10, OLCRMD, OLARTG, OLCORD, OLCHDT, OLDOCC, OLCHLN, OLCRCD, OLCRR, OLFRRC, OLFEA, OLFUC, OLFEC, OLFCHG, OLFAP, OLFREC, OLURCD, OLURDT, OLURAT, OLURAB, OLURRF, OLTORG, OLUSER, OLPID, OLJOBN, OLUPMJ, OLTDAY, OLVR05, OLVR04, OLSHPN, OLSHMT, OLRSHT, OLPRJM, OLDLEJ, OLOSFX, OLMERL, OLMCLN, OLMACT, OLKTLN, OLFTRL, OLDRQT, OLCTAM, OLCPNT, OLCHT, OLPMTN, OLCHRT, OLCHRS, OLCHMJ, OLBCRC, OLDUAL, OLUKID, OLLDNM, OLMKFR, OLMFLG, OLDLNID, OLCMDCDE, OLUNSPSC, OLRSFX, OLWVID, OLCNTRTID, OLCNTRTDID, OLMOADJ, OLPODC01, OLPODC02, OLPODC03, OLPODC04, OLJBCD, OLSRQTY, OLSRUOM, OLCFGFL, OLPMPN, OLPNS FROM F43199

TOP910 | 43 | F43199 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2OLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3OLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4OLSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5OLLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6OLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7OLCOCompanyStringGeneric Edit50 Allow NULL? 
8OLOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9OLOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10OLOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11OLOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12OLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13OLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14OLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15OLRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16OLDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17OLDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18OLBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
19OLAN8Address NumberNumericUDC80 Allow NULL? 
20OLSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
21OLDRQJDate - RequestedDateGeneric Edit60
22OLTRDJDate - Order/TransactionDateGeneric Edit60
23OLPDDJDate - Scheduled PickDateGeneric Edit60
24OLOPDJDate - Original Promised DeliveryDateGeneric Edit60
25OLADDJDate - Actual Ship DateDateGeneric Edit60
26OLCNDJDate - CancelDateGeneric Edit60
27OLPEFJDate - Price Effective DateDateGeneric Edit60
28OLPPDJDate - Promised ShipmentDateGeneric Edit60
29OLPSDJDate - Future Date 2DateGeneric Edit60
30OLDSVJDate - Service/TaxDateGeneric Edit60
31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60
32OLPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
33OLVR01ReferenceStringGeneric Edit250 Allow NULL? 
34OLVR02Reference 2StringGeneric Edit250 Allow NULL? 
35OLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
36OLLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
37OLAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
38OLLOCNLocationStringGeneric Edit200 Allow NULL? 
39OLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
40OLFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
41OLTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
42OLFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
43OLTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
44OLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
45OLDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
46OLLNTYLine TypeStringGeneric Edit20 Allow NULL? 
47OLNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
48OLLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
49OLRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
50OLPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
51OLPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
52OLPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
53OLPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
54OLPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
55OLPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
56OLPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
57OLPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
58OLPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
59OLPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
60OLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
62OLUCHGUnits - On HoldNumericGeneric Edit152 Allow NULL? 
63OLUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
64OLURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
65OLCRECUnits - Cumulative ReceivedNumericGeneric Edit152 Allow NULL? 
66OLURLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
67OLOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
68OLPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
69OLAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
70OLACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
71OLAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
72OLARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
73OLARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
74OLFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
75OLTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
76OLPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
77OLAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
78OLECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
79OLCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
80OLCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
81OLINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
82OLASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
83OLPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
84OLCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
85OLCATNCatalogStringUDC (40 CN)80 Allow NULL? 
86OLDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
87OLPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
88OLTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
89OLEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
90OLTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
91OLATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
92OLCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
93OLCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
94OLNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
95OLFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
96OLFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
97OLZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
98OLFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
99OLRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
100OLANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
101OLANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
102OLMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
103OLCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
104OLSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
105OLSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
106OLUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
107OLPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
108OLUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
109OLSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
110OLUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
111OLITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
112OLWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
113OLITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
114OLVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
115OLGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
116OLCTRYCenturyNumericGeneric Edit20 Allow NULL? 
117OLFYFiscal YearNumericGeneric Edit20 Allow NULL? 
118OLSTTSLine StatusStringGeneric Edit20 Allow NULL? 
119OLRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
120OLFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
121OLFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
122OLGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
123OLGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
124OLLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
126OLAIDAccount IDStringGeneric Edit80 Allow NULL? 
127OLOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
128OLOBJObject AccountStringGeneric Edit60 Allow NULL? 
129OLSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
130OLSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
131OLSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
132OLASIDSerial NumberStringGeneric Edit250 Allow NULL? 
133OLCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
134OLTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
135OLWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
136OLPLPlan NumberStringGeneric Edit40 Allow NULL? 
137OLELEVElevationStringGeneric Edit30 Allow NULL? 
138OLR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
139OLRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
140OLLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
141OLPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
142OLPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
143OLFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
144OLAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
145OLPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
146OLUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
147OLMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
148OLRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
149OLRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
150OLPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
151OLPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
152OLPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
153OLPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
154OLPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
155OLPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
156OLPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
157OLPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
158OLPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
159OLPS10Purchase Order Status 10CharacterUDC (00 XS)10 Allow NULL? 
160OLCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
161OLARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
162OLCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
163OLCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
164OLDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
165OLCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
166OLCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
167OLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
168OLFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
169OLFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
170OLFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
171OLFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
172OLFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
173OLFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
174OLFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
175OLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
176OLURDTUser Reserved DateDateGeneric Edit60
177OLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
178OLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
179OLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
180OLTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
181OLUSERUser IDStringGeneric Edit100 Allow NULL? 
182OLPIDProgram IDStringGeneric Edit100 Allow NULL? 
183OLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
184OLUPMJDate - UpdatedDateGeneric Edit60
185OLTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
186OLVR05Outside Reference 2StringGeneric Edit250 Allow NULL? 
187OLVR04Outside Reference 1StringGeneric Edit250 Allow NULL? 
188OLSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
189OLSHMTShipment number (ITLS)StringGeneric Edit150 Allow NULL? 
190OLRSHTRequested Ship TimeNumericGeneric Edit60 Allow NULL? 
191OLPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
192OLDLEJLot Effectivity DateDateGeneric Edit60
193OLOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
194OLMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
195OLMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
196OLMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
197OLKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
198OLFTRLAmount - Foreign Tax RelievedNumericGeneric Edit152 Allow NULL? 
199OLDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
200OLCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
201OLCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
202OLCHTChange Order Time of DayNumericGeneric Edit70 Allow NULL? 
203OLPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
204OLCHRTTime - Scheduled Required (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
205OLCHRSShift Code - Scheduled RequiredCharacterUDC (00 SH)10 Allow NULL? 
206OLCHMJChange Order Date - UpdatedDateGeneric Edit60
207OLBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
208OLDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
209OLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
210OLLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
211OLMKFRAddress Number - Mark-forNumericGeneric Edit80 Allow NULL? 
212OLMFLGManufacturing Work Order FlagCharacterGeneric Edit10 Allow NULL? 
213OLDLNIDDistributionLine NumberNumericGeneric Edit63 Allow NULL? 
214OLCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
215OLUNSPSCUNSPSC Commodity CodeStringGeneric Edit80 Allow NULL? 
216OLRSFXRelated Order SuffixStringGeneric Edit30 Allow NULL? 
217OLWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
218OLCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
219OLCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
220OLMOADJManual Override Adjustment FlagCharacterCheck Box10 Allow NULL? 
221OLPODC01Purchase Line Code 01StringUDC (43 C7)30 Allow NULL? 
222OLPODC02Purchase Line Code 02StringUDC (43 C8)30 Allow NULL? 
223OLPODC03Purchase Line Code 03StringUDC (43 L7)100 Allow NULL? 
224OLPODC04Purchase Line Code 04StringUDC (43 L8)100 Allow NULL? 
225OLJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
226OLSRQTYService QuantityNumericGeneric Edit154 Allow NULL? 
227OLSRUOMService Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
228OLCFGFLCreated By Configurator FlagCharacterGeneric Edit10 Allow NULL? 
229OLPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
230OLPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP910 | 43 | F43199 INDEXES

NumberDescription
1Doc Company Order No + A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
6LTLedger TypesAscending
7CORDChange Order NumberAscending
8UPMJDate - UpdatedAscending
9TDAYTime of DayAscending
2OrderNum OrderType +A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5CORDChange Order NumberAscending
3doco dcto kcoo sfxo lnid chln
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
6LTLedger TypesAscending
7CHLNChange Order Line NumberAscending
4LedgerTy AcctID GLDate
ElementAliasDescriptionSequence
1LTLedger TypesAscending
2AIDAccount IDAscending
3DGLDate - For G/L (and Voucher)Ascending
5mcu nxtr doco dcto +A
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2NXTRStatus Code - NextAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6SFXOOrder SuffixAscending
7LNIDLine NumberAscending
6mcu lttr doco dcto +A
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2LTTRStatus Code - LastAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6SFXOOrder SuffixAscending
7LNIDLine NumberAscending
7UniqueKeyID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
8POKeys dlnid
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
6DLNIDDistributionLine NumberAscending