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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

228 COLUMNS | 12 INDEXES | Print definition?920 | 43 | F4311 TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4311PD22812Purchase Order Detail FileTransaction Files43: Procurement
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 PDKCOO, PDDOCO, PDDCTO, PDSFXO, PDLNID, PDMCU, PDCO, PDOKCO, PDOORN, PDOCTO, PDOGNO, PDRKCO, PDRORN, PDRCTO, PDRLLN, PDDMCT, PDDMCS, PDBALU, PDAN8, PDSHAN, PDDRQJ, PDTRDJ, PDPDDJ, PDOPDJ, PDADDJ, PDCNDJ, PDPEFJ, PDPPDJ, PDPSDJ, PDDSVJ, PDDGL, PDPN, PDVR01, PDVR02, PDITM, PDLITM, PDAITM, PDLOCN, PDLOTN, PDFRGD, PDTHGD, PDFRMP, PDTHRP, PDDSC1, PDDSC2, PDLNTY, PDNXTR, PDLTTR, PDRLIT, PDPDS1, PDPDS2, PDPDS3, PDPDS4, PDPDS5, PDPDP1, PDPDP2, PDPDP3, PDPDP4, PDPDP5, PDUOM, PDUORG, PDUCHG, PDUOPN, PDUREC, PDCREC, PDURLV, PDOTQY, PDPRRC, PDAEXP, PDACHG, PDAOPN, PDAREC, PDARLV, PDFTN1, PDTRLV, PDPROV, PDAMC3, PDECST, PDCSTO, PDCSMP, PDINMG, PDASN, PDPRGR, PDCLVL, PDCATN, PDDSPR, PDPTC, PDTX, PDEXR1, PDTXA1, PDATXT, PDCNID, PDCDCD, PDNTR, PDFRTH, PDFRTC, PDZON, PDFRAT, PDRATT, PDANBY, PDANCR, PDMOT, PDCOT, PDSHCM, PDSHCN, PDUOM1, PDPQOR, PDUOM2, PDSQOR, PDUOM3, PDITWT, PDWTUM, PDITVL, PDVLUM, PDGLC, PDCTRY, PDFY, PDSTTS, PDRCD, PDFUF1, PDFUF2, PDGRWT, PDGWUM, PDLT, PDANI, PDAID, PDOMCU, PDOBJ, PDSUB, PDSBLT, PDSBL, PDASID, PDCCMP, PDTAG, PDWR01, PDPL, PDELEV, PDR001, PDRTNR, PDLCOD, PDPURG, PDPROM, PDFNLP, PDAVCH, PDPRPY, PDUNCD, PDMATY, PDRTGC, PDRCPF, PDPS01, PDPS02, PDPS03, PDPS04, PDPS05, PDPS06, PDPS07, PDPS08, PDPS09, PDPS10, PDCRMD, PDARTG, PDCORD, PDCHDT, PDDOCC, PDCHLN, PDCRCD, PDCRR, PDFRRC, PDFEA, PDFUC, PDFEC, PDFCHG, PDFAP, PDFREC, PDURCD, PDURDT, PDURAT, PDURAB, PDURRF, PDTORG, PDUSER, PDPID, PDJOBN, PDUPMJ, PDTDAY, PDVR05, PDVR04, PDSHPN, PDRSHT, PDPRJM, PDOSFX, PDMERL, PDMCLN, PDMACT, PDKTLN, PDFTRL, PDDUAL, PDDRQT, PDDLEJ, PDCTAM, PDCPNT, PDCHT, PDCHRT, PDCHRS, PDCHMJ, PDBCRC, PDVR03, PDLDNM, PDMKFR, PDPMTN, PDUKID, PDUNSPSC, PDCMDCDE, PDRSFX, PDWVID, PDCNTRTID, PDCNTRTDID, PDMOADJ, PDPODC01, PDPODC02, PDPODC03, PDPODC04, PDJBCD, PDSRQTY, PDSRUOM, PDCFGFL, PDPMPN, PDPNS FROM F4311

TOP920 | 43 | F4311 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2PDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3PDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4PDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5PDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6PDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7PDCOCompanyStringGeneric Edit50 Allow NULL? 
8PDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9PDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10PDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11PDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12PDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13PDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14PDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15PDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16PDDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17PDDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18PDBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
19PDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
20PDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
21PDDRQJDate - RequestedDateGeneric Edit60
22PDTRDJDate - Order/TransactionDateGeneric Edit60
23PDPDDJDate - Scheduled PickDateGeneric Edit60
24PDOPDJDate - Original Promised DeliveryDateGeneric Edit60
25PDADDJDate - Actual Ship DateDateGeneric Edit60
26PDCNDJDate - CancelDateGeneric Edit60
27PDPEFJDate - Price Effective DateDateGeneric Edit60
28PDPPDJDate - Promised ShipmentDateGeneric Edit60
29PDPSDJDate - Future Date 2DateGeneric Edit60
30PDDSVJDate - Service/TaxDateGeneric Edit60
31PDDGLDate - For G/L (and Voucher)DateGeneric Edit60
32PDPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
33PDVR01ReferenceStringGeneric Edit250 Allow NULL? 
34PDVR02Reference 2StringGeneric Edit250 Allow NULL? 
35PDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
36PDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
37PDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
38PDLOCNLocationStringGeneric Edit200 Allow NULL? 
39PDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
40PDFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
41PDTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
42PDFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
43PDTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
44PDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
45PDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
46PDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
47PDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
48PDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
49PDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
50PDPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
51PDPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
52PDPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
53PDPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
54PDPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
55PDPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
56PDPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
57PDPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
58PDPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
59PDPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
60PDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
61PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
62PDUCHGUnits - On HoldNumericGeneric Edit150 Allow NULL? 
63PDUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
64PDURECUnits - ReceivedNumericGeneric Edit150 Allow NULL? 
65PDCRECUnits - Cumulative ReceivedNumericGeneric Edit150 Allow NULL? 
66PDURLVUnits - RelievedNumericGeneric Edit150 Allow NULL? 
67PDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
68PDPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
69PDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
70PDACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
71PDAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
72PDARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
73PDARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
74PDFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
75PDTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
76PDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
77PDAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
78PDECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
79PDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
80PDCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
81PDINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
82PDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
83PDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
84PDCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
85PDCATNCatalogStringUDC (40 CN)80 Allow NULL? 
86PDDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
87PDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
88PDTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
89PDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
90PDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
91PDATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
92PDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
93PDCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
94PDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
95PDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
96PDFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
97PDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
98PDFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
99PDRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
100PDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
101PDANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
102PDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
103PDCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
104PDSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
105PDSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
106PDUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
107PDPQORUnits - Primary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
108PDUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
109PDSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
110PDUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
111PDITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
112PDWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
113PDITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
114PDVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
115PDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
116PDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
117PDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
118PDSTTSLine StatusStringGeneric Edit20 Allow NULL? 
119PDRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
120PDFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
121PDFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
122PDGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
123PDGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
124PDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
125PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
126PDAIDAccount IDStringGeneric Edit80 Allow NULL? 
127PDOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
128PDOBJObject AccountStringGeneric Edit60 Allow NULL? 
129PDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
130PDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
131PDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
132PDASIDSerial NumberStringGeneric Edit250 Allow NULL? 
133PDCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
134PDTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
135PDWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
136PDPLPlan NumberStringGeneric Edit40 Allow NULL? 
137PDELEVElevationStringGeneric Edit30 Allow NULL? 
138PDR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
139PDRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
140PDLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
141PDPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
142PDPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
143PDFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
144PDAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
145PDPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
146PDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
147PDMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
148PDRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
149PDRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
150PDPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
151PDPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
152PDPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
153PDPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
154PDPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
155PDPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
156PDPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
157PDPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
158PDPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
159PDPS10Purchase Order Status 10CharacterGeneric Edit10 Allow NULL? 
160PDCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
161PDARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
162PDCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
163PDCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
164PDDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
165PDCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
166PDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
167PDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
168PDFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
169PDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
170PDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
171PDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
172PDFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
173PDFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
174PDFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
175PDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
176PDURDTUser Reserved DateDateGeneric Edit60
177PDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
178PDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
179PDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
180PDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
181PDUSERUser IDStringGeneric Edit100 Allow NULL? 
182PDPIDProgram IDStringGeneric Edit100 Allow NULL? 
183PDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
184PDUPMJDate - UpdatedDateGeneric Edit60
185PDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
186PDVR05Outside Reference 2StringGeneric Edit250 Allow NULL? 
187PDVR04Outside Reference 1StringGeneric Edit250 Allow NULL? 
188PDSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
189PDRSHTRequested Ship TimeNumericGeneric Edit60 Allow NULL? 
190PDPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
191PDOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
192PDMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
193PDMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
194PDMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
195PDKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
196PDFTRLAmount - Foreign Tax RelievedNumericGeneric Edit152 Allow NULL? 
197PDDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
198PDDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
199PDDLEJLot Effectivity DateDateGeneric Edit60
200PDCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
201PDCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
202PDCHTChange Order Time of DayNumericGeneric Edit70 Allow NULL? 
203PDCHRTTime - Scheduled Required (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
204PDCHRSShift Code - Scheduled RequiredCharacterUDC (00 SH)10 Allow NULL? 
205PDCHMJChange Order Date - UpdatedDateGeneric Edit60
206PDBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
207PDVR03ReferenceStringGeneric Edit250 Allow NULL? 
208PDLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
209PDMKFRAddress Number - Mark-forNumericGeneric Edit80 Allow NULL? 
210PDPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
211PDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
212PDUNSPSCUNSPSC Commodity CodeStringGeneric Edit80 Allow NULL? 
213PDCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
214PDRSFXRelated Order SuffixStringGeneric Edit30 Allow NULL? 
215PDWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
216PDCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
217PDCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
218PDMOADJManual Override Adjustment FlagCharacterCheck Box10 Allow NULL? 
219PDPODC01Purchase Line Code 01StringUDC (43 C7)30 Allow NULL? 
220PDPODC02Purchase Line Code 02StringUDC (43 C8)30 Allow NULL? 
221PDPODC03Purchase Line Code 03StringUDC (43 L7)100 Allow NULL? 
222PDPODC04Purchase Line Code 04StringUDC (43 L8)100 Allow NULL? 
223PDJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
224PDSRQTYService QuantityNumericGeneric Edit154 Allow NULL? 
225PDSRUOMService Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
226PDCFGFLCreated By Configurator FlagCharacterGeneric Edit10 Allow NULL? 
227PDPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
228PDPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP920 | 43 | F4311 INDEXES

NumberDescription
1Doc No Order Type + 1 (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
2Order Type Next Status +
ElementAliasDescriptionSequence
1DCTOOrder TypeAscending
2NXTRStatus Code - NextAscending
3LNTYLine TypeAscending
3Address Number
ElementAliasDescriptionSequence
1AN8Address NumberAscending
4Item Number Branch + A
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3PDDJDate - Scheduled PickAscending
5Item Number Order Type +
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2DCTOOrder TypeAscending
3DOCODocument (Order No Invoice etc.)Ascending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
6Order Number Order Type +
ElementAliasDescriptionSequence
1OORNOriginal Order NumberAscending
2OCTOOriginal Order TypeAscending
3OKCODocument Company (Original Order)Ascending
4OGNOOriginal Line NumberAscending
5PDDJDate - Scheduled PickAscending
7Address No Item no (Short) +
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
9AID DCTO DOCO KCOO SFXO LNID
ElementAliasDescriptionSequence
1AIDAccount IDAscending
2DCTOOrder TypeAscending
3DOCODocument (Order No Invoice etc.)Ascending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
10Subledger Subledger Type
ElementAliasDescriptionSequence
1SBLSubledger - G/LAscending
2SBLTSubledger TypeAscending
11DOCO DCTO KCOO SHAN +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SHANAddress Number - Ship ToAscending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
12Item Number Status Next +
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2NXTRStatus Code - NextAscending
13Shipment Number SHPN
ElementAliasDescriptionSequence
1SHPNShipment NumberAscending