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

244 COLUMNS | 5 INDEXES | Print definition?812 | 43 | F4311Z TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4311ZPW2445Purchase Order Generator FileRegular Work Files43: ProcurementNo
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 PWCTID, PWJOBS, PWACTN, PWEDFL, PWKCOO, PWDOCO, PWDCTO, PWSFXO, PWLNID, PWMCU, PWCO, PWOKCO, PWOORN, PWOCTO, PWOGNO, PWRKCO, PWRORN, PWRCTO, PWRLLN, PWDMCT, PWDMCS, PWBALU, PWAN8, PWSHAN, PWDRQJ, PWTRDJ, PWPDDJ, PWOPDJ, PWADDJ, PWCNDJ, PWPEFJ, PWPPDJ, PWPSDJ, PWDSVJ, PWDGL, PWPN, PWVR01, PWVR02, PWITM, PWLITM, PWAITM, PWLOCN, PWLOTN, PWFRGD, PWTHGD, PWFRMP, PWTHRP, PWDSC1, PWDSC2, PWLNTY, PWNXTR, PWLTTR, PWRLIT, PWPDS1, PWPDS2, PWPDS3, PWPDS4, PWPDS5, PWPDP1, PWPDP2, PWPDP3, PWPDP4, PWPDP5, PWUOM, PWUORG, PWUCHG, PWUOPN, PWUREC, PWCREC, PWURLV, PWOTQY, PWPRRC, PWAEXP, PWACHG, PWAOPN, PWAREC, PWARLV, PWFTN1, PWTRLV, PWPROV, PWAMC3, PWECST, PWCSTO, PWCSMP, PWINMG, PWASN, PWPRGR, PWCLVL, PWCATN, PWDSPR, PWPTC, PWTX, PWEXR1, PWTXA1, PWATXT, PWCNID, PWCDCD, PWNTR, PWFRTH, PWFRTC, PWZON, PWFRAT, PWRATT, PWANBY, PWANCR, PWMOT, PWCOT, PWSHCM, PWSHCN, PWUOM1, PWPQOR, PWUOM2, PWSQOR, PWUOM3, PWITWT, PWWTUM, PWITVL, PWVLUM, PWGLC, PWCTRY, PWFY, PWSTTS, PWRCD, PWFUF1, PWFUF2, PWGRWT, PWGWUM, PWLT, PWANI, PWAID, PWOMCU, PWOBJ, PWSUB, PWSBLT, PWSBL, PWASID, PWCCMP, PWTAG, PWWR01, PWPL, PWELEV, PWR001, PWRTNR, PWLCOD, PWPURG, PWPROM, PWFNLP, PWAVCH, PWPRPY, PWUNCD, PWMATY, PWRTGC, PWRCPF, PWPS01, PWPS02, PWPS03, PWPS04, PWPS05, PWPS06, PWPS07, PWPS08, PWPS09, PWPS10, PWCRMD, PWARTG, PWCORD, PWCHDT, PWDOCC, PWCHLN, PWCRCD, PWCRR, PWFRRC, PWFEA, PWFUC, PWFEC, PWFCHG, PWFAP, PWFREC, PWURCD, PWURDT, PWURAT, PWURAB, PWURRF, PWTORG, PWUSER, PWPID, PWJOBN, PWUPMJ, PWTDAY, PWIVI, PWWRTH, PWPOGS, PWSTKT, PWCNV2, PWCONV, PWMODE, PWUKID, PWSOPO, PWSEQ, PWPSRY, PWPSR, PWSFX, PWMSGT, PWMTST, PWLNIX, PWAREV, PWDETD, PWDETF, PWABT1, PWABR1, PWABT2, PWABR2, PWABT3, PWABR3, PWABT4, PWABR4, PWOSFX, PWHCLD, PWDOC8, PWODCT, PWCO0, PWSFIX, PWLINN, PWSHPN, PWPEID, PWTCID, PWDUAL, PWPRJM, PWDLEJ, PWPMTN, PWXDCK, PWMCLN, PWUNSPSC, PWCMDCDE, PWRSFX, PWVR03, PWMACT, PWBLKT, PWAFND, PWWVID, PWCNTRTID, PWCNTRTDID, PWMOADJ, PWWVTY FROM F4311Z

TOP812 | 43 | F4311Z COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PWCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2PWJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3PWACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
4PWEDFLFlag - Transaction EditCharacterGeneric Edit10 Allow NULL? 
5PWKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
6PWDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7PWDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8PWSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
9PWLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
10PWMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11PWCOCompanyStringGeneric Edit50 Allow NULL? 
12PWOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
13PWOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
14PWOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
15PWOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
16PWRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
17PWRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
18PWRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
19PWRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
20PWDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
21PWDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
22PWBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
23PWAN8Address NumberNumericUDC80 Allow NULL? 
24PWSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
25PWDRQJDate - RequestedDateGeneric Edit60
26PWTRDJDate - Order/TransactionDateGeneric Edit60
27PWPDDJDate - Scheduled PickDateGeneric Edit60
28PWOPDJDate - Original Promised DeliveryDateGeneric Edit60
29PWADDJDate - Actual Ship DateDateGeneric Edit60
30PWCNDJDate - CancelDateGeneric Edit60
31PWPEFJDate - Price Effective DateDateGeneric Edit60
32PWPPDJDate - Promised ShipmentDateGeneric Edit60
33PWPSDJDate - Future Date 2DateGeneric Edit60
34PWDSVJDate - Service/TaxDateGeneric Edit60
35PWDGLDate - For G/L (and Voucher)DateGeneric Edit60
36PWPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
37PWVR01ReferenceStringGeneric Edit250 Allow NULL? 
38PWVR02Reference 2StringGeneric Edit250 Allow NULL? 
39PWITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
40PWLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
41PWAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
42PWLOCNLocationStringGeneric Edit200 Allow NULL? 
43PWLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
44PWFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
45PWTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
46PWFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
47PWTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
48PWDSC1DescriptionStringGeneric Edit300 Allow NULL? 
49PWDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
50PWLNTYLine TypeStringGeneric Edit20 Allow NULL? 
51PWNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
52PWLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
53PWRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
54PWPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
55PWPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
56PWPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
57PWPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
58PWPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
59PWPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
60PWPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
61PWPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
62PWPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
63PWPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
64PWUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
65PWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
66PWUCHGUnits - On HoldNumericGeneric Edit152 Allow NULL? 
67PWUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
68PWURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
69PWCRECUnits - Cumulative ReceivedNumericGeneric Edit152 Allow NULL? 
70PWURLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
71PWOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
72PWPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
73PWAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
74PWACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
75PWAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
76PWARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
77PWARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
78PWFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
79PWTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
80PWPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
81PWAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
82PWECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
83PWCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
84PWCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
85PWINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
86PWASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
87PWPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
88PWCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
89PWCATNCatalogStringUDC (40 CN)80 Allow NULL? 
90PWDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
91PWPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
92PWTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
93PWEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
94PWTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
95PWATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
96PWCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
97PWCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
98PWNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
99PWFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
100PWFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
101PWZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
102PWFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
103PWRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
104PWANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
105PWANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
106PWMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
107PWCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
108PWSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
109PWSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
110PWUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
111PWPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
112PWUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
113PWSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
114PWUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
115PWITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
116PWWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
117PWITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
118PWVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
119PWGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
120PWCTRYCenturyNumericGeneric Edit20 Allow NULL? 
121PWFYFiscal YearNumericGeneric Edit20 Allow NULL? 
122PWSTTSLine StatusStringGeneric Edit20 Allow NULL? 
123PWRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
124PWFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
125PWFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
126PWGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
127PWGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
128PWLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
129PWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
130PWAIDAccount IDStringGeneric Edit80 Allow NULL? 
131PWOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
132PWOBJObject AccountStringGeneric Edit60 Allow NULL? 
133PWSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
134PWSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
135PWSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
136PWASIDSerial NumberStringGeneric Edit250 Allow NULL? 
137PWCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
138PWTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
139PWWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
140PWPLPlan NumberStringGeneric Edit40 Allow NULL? 
141PWELEVElevationStringGeneric Edit30 Allow NULL? 
142PWR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
143PWRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
144PWLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
145PWPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
146PWPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
147PWFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
148PWAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
149PWPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
150PWUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
151PWMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
152PWRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
153PWRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
154PWPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
155PWPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
156PWPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
157PWPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
158PWPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
159PWPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
160PWPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
161PWPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
162PWPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
163PWPS10Purchase Order Status 10CharacterUDC (00 XS)10 Allow NULL? 
164PWCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
165PWARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
166PWCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
167PWCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
168PWDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
169PWCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
170PWCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
171PWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
172PWFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
173PWFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
174PWFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
175PWFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
176PWFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
177PWFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
178PWFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
179PWURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
180PWURDTUser Reserved DateDateGeneric Edit60
181PWURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
182PWURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
183PWURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
184PWTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
185PWUSERUser IDStringGeneric Edit100 Allow NULL? 
186PWPIDProgram IDStringGeneric Edit100 Allow NULL? 
187PWJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
188PWUPMJDate - UpdatedDateGeneric Edit60
189PWTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
190PWIVIInventory Interface Y/N - DistributionCharacterUDC (H40 IV)10 Allow NULL? 
191PWWRTHFlag - Write Ledger Record (Y/N)CharacterGeneric Edit10 Allow NULL? 
192PWPOGSPO Generator Source SystemCharacterGeneric Edit10 Allow NULL? 
193PWSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
194PWCNV2Conversion Factor - Purchasing to PrimarNumericGeneric Edit157 Allow NULL? 
195PWCONVConversion FactorNumericGeneric Edit157 Allow NULL? 
196PWMODEMode - ProcessingCharacterGeneric Edit10 Allow NULL? 
197PWUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
198PWSOPOFlag - Sales/PurchasingCharacterGeneric Edit10 Allow NULL? 
199PWSEQSequence NumberNumericGeneric Edit60 Allow NULL? 
200PWPSRYSource TypeStringUDC (38 DY)20 Allow NULL? 
201PWPSRSourceStringGeneric Edit120 Allow NULL? 
202PWSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
203PWMSGTMessage TypeCharacterUDC (34 MT)10 Allow NULL? 
204PWMTSTMaterial Status Code W.O.StringUDC (31 MS)20 Allow NULL? 
205PWLNIXLine Number - X-REFNumericGeneric Edit63 Allow NULL? 
206PWAREVAdjustment Revision LevelNumericGeneric Edit30 Allow NULL? 
207PWDETDAmount - Detached Adj. DomesticNumericGeneric Edit154 Allow NULL? 
208PWDETFAmount - Detached Adj. ForeignNumericGeneric Edit154 Allow NULL? 
209PWABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
210PWABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
211PWABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
212PWABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
213PWABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
214PWABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
215PWABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
216PWABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
217PWOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
218PWHCLDHold CodeCharacterUDC (34 HC)10 Allow NULL? 
219PWDOC8DocumentStringGeneric Edit80 Allow NULL? 
220PWODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
221PWCO0CompanyStringGeneric Edit50 Allow NULL? 
222PWSFIXSuffixStringGeneric Edit30 Allow NULL? 
223PWLINNLine NumberNumericGeneric Edit73 Allow NULL? 
224PWSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
225PWPEIDProcess IDNumericGeneric Edit150 Allow NULL? 
226PWTCIDTransaction IDNumericGeneric Edit150 Allow NULL? 
227PWDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
228PWPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
229PWDLEJLot Effectivity DateDateGeneric Edit60
230PWPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
231PWXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
232PWMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
233PWUNSPSCUNSPSC Commodity CodeStringGeneric Edit80 Allow NULL? 
234PWCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
235PWRSFXRelated Order SuffixStringGeneric Edit30 Allow NULL? 
236PWVR03ReferenceStringGeneric Edit250 Allow NULL? 
237PWMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
238PWBLKTBlankets ExistsCharacterGeneric Edit10 Allow NULL? 
239PWAFNDContracts FoundNumericGeneric Edit150 Allow NULL? 
240PWWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
241PWCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
242PWCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
243PWMOADJManual Override Adjustment FlagCharacterCheck Box10 Allow NULL? 
244PWWVTYVessel ClassCharacterGeneric Edit10 Allow NULL? 

TOP812 | 43 | F4311Z INDEXES

NumberDescription
1Machine Key Job Number A (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2PEIDProcess IDAscending
3TCIDTransaction IDAscending
4JOBSJob NumberAscending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
2Original Order Number Type +
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3OORNOriginal Order NumberAscending
4OCTOOriginal Order TypeAscending
5OKCODocument Company (Original Order)Ascending
6OGNOOriginal Line NumberAscending
3Original Order Type Key +
ElementAliasDescriptionSequence
1OORNOriginal Order NumberAscending
2OCTOOriginal Order TypeAscending
3OKCODocument Company (Original Order)Ascending
4OGNOOriginal Line NumberAscending
5SFXDocument Pay ItemAscending
4CTID PEID TCID JOBS A+
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2PEIDProcess IDAscending
3TCIDTransaction IDAscending
4JOBSJob NumberAscending
5SFXOOrder SuffixAscending
6ACTNAction CodeAscending
7LNIDLine NumberAscending
5CTID PEID TCID MCLN+
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2PEIDProcess IDAscending
3TCIDTransaction IDAscending
4JOBSJob NumberAscending
5SFXOOrder SuffixAscending
6MCLNMatrix Control Line NumberAscending