JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

200 COLUMNS | 8 INDEXES | Print definition?920 | 42 | F42565 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42565IW2008Invoice Print FileRegular Work Files42: Sales 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 IWCTID, IWJOBS, IWDOC, IWDCT, IWKCO, IWDOCO, IWDCTO, IWKCOO, IWLNID, IWOSEQ, IWSUBSEQ, IWAN8, IWSHAN, IWMCU, IWCO, IWITM, IWPRNT, IWDSC1, IWDSC2, IWUITM, IWUOM, IWUOM4, IWSOQS, IWSOBK, IWSOCN, IWUPRC, IWAEXP, IWECST, IWPCT1, IWDRQJ, IWCOMM, IWLNTY, IWTXYN, IWCDSC, IWIVI, IWCITM, IWIVD, IWRORN, IWRCTO, IWRKCO, IWINMG, IWTAX1, IWTXA1, IWEXR1, IWTAXA, IWTA1, IWTA2, IWTA3, IWTA4, IWTA5, IWTXR1, IWTXR2, IWTXR3, IWTXR4, IWTXR5, IWTC2, IWTT3, IWTT4, IWTT5, IWFVTY, IWHBUS, IWTRAT, IWATXA, IWSTAM, IWPTC, IWADSC, IWUSER, IWPID, IWJOBN, IWUPMJ, IWTDAY, IWEDOC, IWEDCT, IWEKCO, IWEDLN, IWSFXO, IWPA8, IWDSCT, IWTAXT, IWTAX2, IWTAX3, IWTAX4, IWTAX5, IWATXN, IWLPRC, IWCRCD, IWCRDC, IWCRR, IWLITM, IWCARS, IWDMCS, IWDMCT, IWRSSN, IWDTPU, IWSHPN, IWDETP, IWDCNS, IWDNTP, IWEMCU, IWDNTY, IWSTPU, IWSEQN, IWTEMP, IWREFN, IWREFQ, IWLOAD, IWTRP, IWMMCO, IWVMCU, IWVCF, IWMCUS, IWWGTR, IWAMBR, IWBUM5, IWBUM4, IWBUM3, IWSTOK, IWDTYS, IWLOTN, IWAIEP, IWAILP, IWAITR, IWAIT1, IWAIT2, IWAIT3, IWAIT4, IWAIT5, IWAICM, IWAITX, IWAITA, IWAITU, IWAIAD, IWAIX1, IWAIX2, IWAIX3, IWAIS1, IWAIS2, IWAIS3, IWAIS4, IWAIS5, IWAICC, IWAIRR, IWAITD, IWAITS, IWSPHD, IWATAM, IWATAT, IWAIAM, IWAIAT, IWN1FU, IWN2FU, IWN3FU, IWC1FU, IWC2FU, IWD1FU, IWD2FU, IWS1FU, IWS2FU, IWFVTR, IWBSDVAL, IWSRFLAG, IWSOOR, IWRCD, IWPBAN, IWOORN, IWODOC, IWODCT, IWOCTO, IWFTAN, IWDOC1, IWDCT4, IWITMU, IWUTAM, IWUOM2, IWSQOR, IWCIRV, IWPSJOBNO, IWJOBSQ, IWCARDNO, IWRLIT, IWKITID, IWKITAMTDOM, IWKITAMTFOR, IWKITDIRTY, IWKTLN, IWSTKT, IWRKIT, IWSIDT, IWAST, IWTUPRC, IWTAEXP, IWTAIEP, IWUTA, IWETA, IWTKITAMTD, IWTKITAMTF, IWDTXJ, IWUTP, IWOILNTY, IWAEXPO FROM F42565

TOP920 | 42 | F42565 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IWCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2IWJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3IWDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
4IWDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
5IWKCODocument CompanyStringGeneric Edit50 Allow NULL? 
6IWDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7IWDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8IWKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
9IWLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
10IWOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
11IWSUBSEQSub-Sequence NumberNumericGeneric Edit40 Allow NULL? 
12IWAN8Address NumberNumericGeneric Edit80 Allow NULL? 
13IWSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
14IWMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
15IWCOCompanyStringGeneric Edit50 Allow NULL? 
16IWITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
17IWPRNTPrint Data (Y/N)CharacterUDC (48 PN)10 Allow NULL? 
18IWDSC1DescriptionStringGeneric Edit300 Allow NULL? 
19IWDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
20IWUITMItem Number - Unknown Format EnteredStringGeneric Edit260 Allow NULL? 
21IWUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
22IWUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
23IWSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
24IWSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
25IWSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
26IWUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
27IWAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
28IWECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
29IWPCT1Percent1NumericGeneric Edit30 Allow NULL? 
30IWDRQJDate - RequestedDateGeneric Edit60
31IWCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
32IWLNTYLine TypeStringGeneric Edit20 Allow NULL? 
33IWTXYNText (Y/N)CharacterGeneric Edit10 Allow NULL? 
34IWCDSCInclude in Cash Discount CalculationCharacterGeneric Edit10 Allow NULL? 
35IWIVIInventory Interface Y/N - DistributionCharacterUDC (H40 IV)10 Allow NULL? 
36IWCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
37IWIVDDate - InvoiceDateGeneric Edit60
38IWRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
39IWRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
40IWRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
41IWINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
42IWTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
43IWTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
44IWEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
45IWTAXADescription - Tax AreaStringGeneric Edit300 Allow NULL? 
46IWTA1Tax AuthorityNumericGeneric Edit80 Allow NULL? 
47IWTA2Tax Authority 2NumericGeneric Edit80 Allow NULL? 
48IWTA3Tax Authority 3NumericGeneric Edit80 Allow NULL? 
49IWTA4Tax Authority 4NumericGeneric Edit80 Allow NULL? 
50IWTA5Tax Authority 5NumericGeneric Edit80 Allow NULL? 
51IWTXR1Tax Rate 1NumericGeneric Edit73 Allow NULL? 
52IWTXR2Tax Rate 2NumericGeneric Edit73 Allow NULL? 
53IWTXR3Tax Rate 3NumericGeneric Edit73 Allow NULL? 
54IWTXR4Tax Rate 4NumericGeneric Edit73 Allow NULL? 
55IWTXR5Tax Rate 5NumericGeneric Edit73 Allow NULL? 
56IWTC2Tax Calculation MethodCharacterGeneric Edit10 Allow NULL? 
57IWTT3Tax TypeCharacterUDC (H00 TU)10 Allow NULL? 
58IWTT4Tax TypeCharacterUDC (H00 TU)10 Allow NULL? 
59IWTT5Tax TypeCharacterUDC (H00 TU)10 Allow NULL? 
60IWFVTYFactor Value - TypeCharacterUDC (H00 FV)10 Allow NULL? 
61IWHBUSHas Been UsedCharacterGeneric Edit10 Allow NULL? 
62IWTRATTotal Area Tax RateNumericGeneric Edit63 Allow NULL? 
63IWATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
64IWSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
65IWPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
66IWADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
67IWUSERUser IDStringGeneric Edit100 Allow NULL? 
68IWPIDProgram IDStringGeneric Edit100 Allow NULL? 
69IWJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
70IWUPMJDate - UpdatedDateGeneric Edit60
71IWTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
72IWEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
73IWEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
74IWEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
75IWEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
76IWSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
77IWPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
78IWDSCTDiscount AmountNumericGeneric Edit152 Allow NULL? 
79IWTAXTAmount - Sales Tax Total 1NumericGeneric Edit152 Allow NULL? 
80IWTAX2Amount - Sales Tax Total 2NumericGeneric Edit152 Allow NULL? 
81IWTAX3Amount - Sales Tax Total 3NumericGeneric Edit152 Allow NULL? 
82IWTAX4Amount - Sales Tax Total 4NumericGeneric Edit152 Allow NULL? 
83IWTAX5Amount - Sales Tax Total 5NumericGeneric Edit152 Allow NULL? 
84IWATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
85IWLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
86IWCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
87IWCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
88IWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
89IWLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
90IWCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
91IWDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
92IWDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
93IWRSSNRouting Step NumberNumericGeneric Edit31 Allow NULL? 
94IWDTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
95IWSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
96IWDETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
97IWDCNSDocument Number SourceCharacterUDC (49 DA)10 Allow NULL? 
98IWDNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
99IWEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
100IWDNTYDensityNumericGeneric Edit72 Allow NULL? 
101IWSTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
102IWSEQNSequence NumberNumericGeneric Edit70 Allow NULL? 
103IWTEMPTemperatureNumericGeneric Edit72 Allow NULL? 
104IWREFNReference NumberStringGeneric Edit300 Allow NULL? 
105IWREFQReference Number QualifierStringUDC (41 X6)20 Allow NULL? 
106IWLOADDate - Scheduled LoadDateGeneric Edit60
107IWTRPTrip NumberNumericGeneric Edit80 Allow NULL? 
108IWMMCOCompanyStringGeneric Edit50 Allow NULL? 
109IWVMCUDepot - TripStringGeneric Edit120 Allow NULL? 
110IWVCFVolume Correction FactorNumericGeneric Edit75 Allow NULL? 
111IWMCUSBusiness Unit - SubsequentStringGeneric Edit120 Allow NULL? 
112IWWGTRWeight ResultNumericGeneric Edit150 Allow NULL? 
113IWAMBRVolume - AmbientNumericGeneric Edit150 Allow NULL? 
114IWBUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
115IWBUM4Unit of Measure 4StringUDC (00 UM)20 Allow NULL? 
116IWBUM3Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
117IWSTOKVolume - StandardNumericGeneric Edit150 Allow NULL? 
118IWDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
119IWLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
120IWAIEPAs If Extended PriceNumericGeneric Edit152 Allow NULL? 
121IWAILPAs If List PriceNumericGeneric Edit154 Allow NULL? 
122IWAITRAs If Total Tax RateNumericGeneric Edit63 Allow NULL? 
123IWAIT1As If Tax AuthorityNumericGeneric Edit80 Allow NULL? 
124IWAIT2As If Tax Authority 2NumericGeneric Edit80 Allow NULL? 
125IWAIT3As If Tax Authority 3NumericGeneric Edit80 Allow NULL? 
126IWAIT4As If Tax Authority 4NumericGeneric Edit80 Allow NULL? 
127IWAIT5As If Tax Authority 5NumericGeneric Edit80 Allow NULL? 
128IWAICMAs If Tax Calculation MethodCharacterGeneric Edit10 Allow NULL? 
129IWAITXAs If Amount - TaxableNumericGeneric Edit152 Allow NULL? 
130IWAITAAs If Amount - TaxNumericGeneric Edit152 Allow NULL? 
131IWAITUAs If Amount Tax UnroundedNumericGeneric Edit154 Allow NULL? 
132IWAIADAs If Amount - DiscountNumericGeneric Edit152 Allow NULL? 
133IWAIX1As If Tax Type 1CharacterUDC (H00 TU)10 Allow NULL? 
134IWAIX2As If Tax Type 2CharacterUDC (H00 TU)10 Allow NULL? 
135IWAIX3As If Tax Type 3CharacterUDC (H00 TU)10 Allow NULL? 
136IWAIS1As If Amount - Sales Tax Total 1NumericGeneric Edit152 Allow NULL? 
137IWAIS2As If Amount - Sales Tax Total 2NumericGeneric Edit152 Allow NULL? 
138IWAIS3As If Amount - Sales Tax Total 3NumericGeneric Edit152 Allow NULL? 
139IWAIS4As If Amount - Sales Tax Total 4NumericGeneric Edit152 Allow NULL? 
140IWAIS5As If Amount - Sales Tax Total 5NumericGeneric Edit152 Allow NULL? 
141IWAICCAs If Currency CodeStringGeneric Edit30 Allow NULL? 
142IWAIRRAs If Currency Conversion Rate-Spot RateNumericGeneric Edit150 Allow NULL? 
143IWAITDAs If Transaction DateDateGeneric Edit60
144IWAITSAs If Print Tax SummaryCharacterGeneric Edit10 Allow NULL? 
145IWSPHDSpecial Handling Code - User Def CodesStringGeneric Edit100 Allow NULL? 
146IWATAMPrepayment Tax AmountNumericGeneric Edit152 Allow NULL? 
147IWATATPrepayment AmountNumericGeneric Edit152 Allow NULL? 
148IWAIAMAs If Prepayment Tax AmountNumericGeneric Edit152 Allow NULL? 
149IWAIATAs If Prepayment AmountNumericGeneric Edit152 Allow NULL? 
150IWN1FUFuture Use - Math Numeric 1NumericGeneric Edit152 Allow NULL? 
151IWN2FUFuture Use - Math Numeric 2NumericGeneric Edit158 Allow NULL? 
152IWN3FUFutrue Use Math Numeric 3NumericGeneric Edit158 Allow NULL? 
153IWC1FUFuture Use - Character 1CharacterGeneric Edit10 Allow NULL? 
154IWC2FUFuture Use - Character 1CharacterGeneric Edit10 Allow NULL? 
155IWD1FUFuture Use - Date 1DateGeneric Edit60
156IWD2FUFuture Use - Date 2DateGeneric Edit60
157IWS1FUFuture Use String 1StringGeneric Edit300 Allow NULL? 
158IWS2FUFuture Use String 2StringGeneric Edit300 Allow NULL? 
159IWFVTRFactor ValueNumericGeneric Edit154 Allow NULL? 
160IWBSDVALBased on ValueNumericGeneric Edit154 Allow NULL? 
161IWSRFLAGSliding Rate FlagCharacterGeneric Edit10 Allow NULL? 
162IWSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
163IWRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
164IWPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
165IWOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
166IWODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
167IWODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
168IWOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
169IWFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
170IWDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
171IWDCT4Document TypeStringUDC (00 DT)20 Allow NULL? 
172IWITMUItem Used in Tax CalculationCharacterGeneric Edit10 Allow NULL? 
173IWUTAMUnroundedTaxAmountNumericGeneric Edit154 Allow NULL? 
174IWUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
175IWSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
176IWCIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
177IWPSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
178IWJOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
179IWCARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
180IWRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
181IWKITIDKit IdentifierNumericGeneric Edit150 Allow NULL? 
182IWKITAMTDOMAccumulated Amount Invoiced (Domestic)NumericGeneric Edit152 Allow NULL? 
183IWKITAMTFORAccumulated Amount Invoiced (Foreign)NumericGeneric Edit152 Allow NULL? 
184IWKITDIRTYKit Component Dirty FlagCharacterGeneric Edit10 Allow NULL? 
185IWKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
186IWSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
187IWRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
188IWSIDTScheduled Invoice DateDateGeneric Edit60
189IWASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
190IWTUPRCTaxed Unit PriceNumericGeneric Edit154 Allow NULL? 
191IWTAEXPTaxed Extended PriceNumericGeneric Edit152 Allow NULL? 
192IWTAIEPTaxed As If Extended PriceNumericGeneric Edit152 Allow NULL? 
193IWUTAUnit Tax AmountNumericGeneric Edit154 Allow NULL? 
194IWETAExtended Tax AmountNumericGeneric Edit152 Allow NULL? 
195IWTKITAMTDKit Taxed Price InvoicedNumericGeneric Edit152 Allow NULL? 
196IWTKITAMTFForeign Kit Taxed Price InvoicedNumericGeneric Edit152 Allow NULL? 
197IWDTXJInternal SO Tax DateDateGeneric Edit60
198IWUTPUse Taxed PricesCharacterGeneric Edit10 Allow NULL? 
199IWOILNTYOutbound Inventory InterfaceCharacterUDC (42I LT)10 Allow NULL? 
200IWAEXPOEstimated - Extended PriceNumericGeneric Edit152 Allow NULL? 

TOP920 | 42 | F42565 INDEXES

NumberDescription
1Invoice Nbr Invoice Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DCTDocument TypeAscending
5KCODocument CompanyAscending
6DOCODocument (Order No Invoice etc.)Ascending
7DCTOOrder TypeAscending
8KCOOOrder Company (Order Number)Ascending
9LNIDLine NumberAscending
10OSEQSequence NumberAscending
11SUBSEQSub-Sequence NumberAscending
2Address Nbr Currency Code +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3AN8Address NumberAscending
4CRCDCurrency Code - FromAscending
5CRDCCurrency Code - ToAscending
6CRRCurrency Conversion Rate - Spot RateAscending
7PTCPayment Terms CodeAscending
3Item Nbr Unit Price +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3LITM2nd Item NumberAscending
4UPRCAmount - Price per UnitAscending
5UOMUnit of Measure as InputAscending
6LNTYLine TypeAscending
7UOM4Unit of Measure - PricingAscending
8DOCDocument (Voucher Invoice etc.)Ascending
9DCTDocument TypeAscending
10KCODocument CompanyAscending
4Order Nbr Order Type +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6LNIDLine NumberAscending
7UPRCAmount - Price per UnitAscending
8UOMUnit of Measure as InputAscending
9LNTYLine TypeAscending
10UOM4Unit of Measure - PricingAscending
5Computer ID Job Number
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
6Order Number Kit ID +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DCTDocument TypeAscending
5KCODocument CompanyAscending
6DOCODocument (Order No Invoice etc.)Ascending
7DCTOOrder TypeAscending
8KCOOOrder Company (Order Number)Ascending
9KITIDKit IdentifierAscending
10LNIDLine NumberAscending
11OSEQSequence NumberAscending
12SUBSEQSub-Sequence NumberAscending
7Item Nbr Adj Name +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3ITMItem Number - ShortAscending
4UPRCAmount - Price per UnitAscending
5UOMUnit of Measure as InputAscending
6UOM4Unit of Measure - PricingAscending
7DOCDocument (Voucher Invoice etc.)Ascending
8DCTDocument TypeAscending
9KCODocument CompanyAscending
10ASTPrice Adjustment NameAscending
8Adj Name Line Nbr +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6LNIDLine NumberAscending
7UPRCAmount - Price per UnitAscending
8UOMUnit of Measure as InputAscending
9UOM4Unit of Measure - PricingAscending
10ASTPrice Adjustment NameAscending