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

104 COLUMNS | 11 INDEXES | Print definition?812 | 48S | F4822 TABLE

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4822W410411Invoice Summary Work FileTransaction Files48S: Service BillingNo
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 W4DOCO, W4DCTO, W4KCOO, W4PCTN, W4PCTT, W4PCKO, W4APPL, W4ADJN, W4COCH, W4LNID, W4OPIM, W4PRTP, W4BLSP, W4AN8O, W4AN8J, W4PTC, W4CO, W4MCU, W4SBL, W4SBLT, W4GLC, W4BTFR, W4BTDT, W4DGL, W4DDJ, W4DSVJ, W4ICU, W4DOCZ, W4DCTI, W4KCOI, W4SFX, W4APDT, W4APPO, W4VOID, W4INVF, W4INTY, W4U, W4UM, W4UP, W4FUP, W4PUHP, W4AA, W4ACR, W4THPD, W4FHPD, W4RTHP, W4PTHP, W4FTHP, W4TXA1, W4EXR1, W4STAM, W4CTAM, W4PTAM, W4FPTA, W4ATXA, W4CTXA, W4PATX, W4FATX, W4ATXN, W4CTXN, W4RTRE, W4RGLC, W4PRET, W4RTNR, W4RCTL, W4RTNG, W4FTNG, W4RTNP, W4FTNP, W4DDTR, W4FDTR, W4STML, W4FTML, W4PSMA, W4FSMA, W4RTN1, W4SMRT, W4SMRF, W4SMRP, W4SMPF, W4TLAB, W4FLAB, W4TBUR, W4FBUR, W4ADSC, W4CDS, W4CRRM, W4CRCD, W4CRCF, W4CRR, W4CRRD, W4RMK, W4MIVL, W4MISM, W4PID, W4JOBN, W4USER, W4MUPM, W4UPMT, W4VGCSF, W4VGCOA, W4VVTY, W4VVTC, W4PYWP FROM F4822

TOP812 | 48S | F4822 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1W4DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2W4DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3W4KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4W4PCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
5W4PCTTParent Contract TypeStringUDC (00 DT)20 Allow NULL? 
6W4PCKOParent Contract Document CompanyStringGeneric Edit50 Allow NULL? 
7W4APPLApplication NumberNumericGeneric Edit50 Allow NULL? 
8W4ADJNAdjustment NumberNumericGeneric Edit30 Allow NULL? 
9W4COCHContract Change NumberStringGeneric Edit30 Allow NULL? 
10W4LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
11W4OPIMOwner Pay ItemStringGeneric Edit150 Allow NULL? 
12W4PRTPPricing Type - ContractsCharacterUDC (52 PT)10 Allow NULL? 
13W4BLSPBill SuspendCharacterUDC (52 BS)10 Allow NULL? 
14W4AN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
15W4AN8JAddress Number - Alternate PayeeNumericGeneric Edit80 Allow NULL? 
16W4PTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
17W4COCompanyStringGeneric Edit50 Allow NULL? 
18W4MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
19W4SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
20W4SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
21W4GLCG/L OffsetStringGeneric Edit40 Allow NULL? 
22W4BTFRDate - Bill FromDateGeneric Edit60
23W4BTDTBilled ThroughDateGeneric Edit60
24W4DGLDate - For G/L (and Voucher)DateGeneric Edit60
25W4DDJDate - Net DueDateGeneric Edit60
26W4DSVJDate - Service/TaxDateGeneric Edit60
27W4ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
28W4DOCZDocument (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
29W4DCTIDocument Type - Invoice OnlyStringUDC (00 DI)20 Allow NULL? 
30W4KCOIDocument Company (Invoice)StringGeneric Edit50 Allow NULL? 
31W4SFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
32W4APDTApplication DateDateGeneric Edit60
33W4APPOApplication Posted CodeCharacterGeneric Edit10 Allow NULL? 
34W4VOIDVoid (V)CharacterUDC (H09 VO)10 Allow NULL? 
35W4INVFInvoice Format CodeStringGeneric Edit100 Allow NULL? 
36W4INTYInvoice TypeCharacterUDC (48 IT)10 Allow NULL? 
37W4UUnitsNumericGeneric Edit152 Allow NULL? 
38W4UMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
39W4UPAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
40W4FUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
41W4PUHPPrevious Billed This Period - UnitsNumericGeneric Edit152 Allow NULL? 
42W4AAAmountNumericGeneric Edit152 Allow NULL? 
43W4ACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
44W4THPDThis PeriodNumericGeneric Edit152 Allow NULL? 
45W4FHPDThis Period - ForeignNumericGeneric Edit152 Allow NULL? 
46W4RTHPThis Period - RestatedNumericGeneric Edit152 Allow NULL? 
47W4PTHPPrevious Billed This PeriodNumericGeneric Edit152 Allow NULL? 
48W4FTHPPrevious Billed This Period - ForeignNumericGeneric Edit152 Allow NULL? 
49W4TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
50W4EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
51W4STAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
52W4CTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
53W4PTAMAmount - Tax - PriorNumericGeneric Edit152 Allow NULL? 
54W4FPTAAmount - Tax - Prior - ForeignNumericGeneric Edit152 Allow NULL? 
55W4ATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
56W4CTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
57W4PATXAmount - Taxable - PreviousNumericGeneric Edit152 Allow NULL? 
58W4FATXAmount - Taxable - Previous ForeignNumericGeneric Edit152 Allow NULL? 
59W4ATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
60W4CTXNAmount - Foreign Non-TaxableNumericGeneric Edit152 Allow NULL? 
61W4RTRERetainage Release OnlyCharacterUDC (48 RR)10 Allow NULL? 
62W4RGLCRetention G/L OffsetStringGeneric Edit40 Allow NULL? 
63W4PRETPercent RetainageNumericGeneric Edit52 Allow NULL? 
64W4RTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
65W4RCTLRetainage Control FlagCharacterUDC (48S RC)10 Allow NULL? 
66W4RTNGRetainageNumericGeneric Edit152 Allow NULL? 
67W4FTNGRetainage - ForeignNumericGeneric Edit152 Allow NULL? 
68W4RTNPRetainage - PriorNumericGeneric Edit152 Allow NULL? 
69W4FTNPRetainage - Prior - ForeignNumericGeneric Edit152 Allow NULL? 
70W4DDTRDeferred Tax - DomesticNumericGeneric Edit152 Allow NULL? 
71W4FDTRDeferred Tax - ForeignNumericGeneric Edit152 Allow NULL? 
72W4STMLAccrual/Deferral (Stored Materials)NumericGeneric Edit152 Allow NULL? 
73W4FTMLAcc/Def (Stored Materials) - ForeignNumericGeneric Edit152 Allow NULL? 
74W4PSMAPrevious Billed Stored MaterialNumericGeneric Edit152 Allow NULL? 
75W4FSMAPrev. Billed Stored Material - ForeignNumericGeneric Edit152 Allow NULL? 
76W4RTN1Retainage Rule - Stored MaterialStringGeneric Edit30 Allow NULL? 
77W4SMRTStored Materials RetainageNumericGeneric Edit152 Allow NULL? 
78W4SMRFStored Materials Retainage - ForeignNumericGeneric Edit152 Allow NULL? 
79W4SMRPStored Materials Retainage - Prior AmtNumericGeneric Edit152 Allow NULL? 
80W4SMPFStored Materials Retainage - Prior-ForNumericGeneric Edit152 Allow NULL? 
81W4TLABAmount - Total LaborNumericGeneric Edit152 Allow NULL? 
82W4FLABAmount - Foreign Total LaborNumericGeneric Edit152 Allow NULL? 
83W4TBURAmount - Total BurdenNumericGeneric Edit152 Allow NULL? 
84W4FBURAmount - Foreign Total BurdenNumericGeneric Edit152 Allow NULL? 
85W4ADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
86W4CDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
87W4CRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
88W4CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
89W4CRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
90W4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
91W4CRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
92W4RMKName - RemarkStringGeneric Edit300 Allow NULL? 
93W4MIVLMode of Input - ValuesCharacterGeneric Edit10 Allow NULL? 
94W4MISMMode of Input - SMCharacterGeneric Edit10 Allow NULL? 
95W4PIDProgram IDStringGeneric Edit100 Allow NULL? 
96W4JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
97W4USERUser IDStringGeneric Edit100 Allow NULL? 
98W4MUPMDate - UpdatedDateGeneric Edit60
99W4UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
100W4VGCSFGeoCode Ship FromStringGeneric Edit100 Allow NULL? 
101W4VGCOAGeoCode Order AcceptStringGeneric Edit100 Allow NULL? 
102W4VVTYVertex Transaction TypeStringUDC (73 TY)60 Allow NULL? 
103W4VVTCVertex Product CategoryStringUDC (73 PC)100 Allow NULL? 
104W4PYWPPay When PaidCharacterGeneric Edit10 Allow NULL? 

TOP812 | 48S | F4822 INDEXES

NumberDescription
1Invoice Number Invoice Type + (Primary/Unique)
ElementAliasDescriptionSequence
1DOCZDocument (Order # Invoice etc.)Ascending
2DCTIDocument Type - Invoice OnlyAscending
3KCOIDocument Company (Invoice)Ascending
4SFXDocument Pay ItemAscending
2Batch Number Invoice Number +
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2DOCZDocument (Order # Invoice etc.)Ascending
3DCTIDocument Type - Invoice OnlyAscending
4KCOIDocument Company (Invoice)Ascending
3Invoice Number Doc Type +
ElementAliasDescriptionSequence
1DOCZDocument (Order # Invoice etc.)Ascending
2DCTIDocument Type - Invoice OnlyAscending
3KCOIDocument Company (Invoice)Ascending
4ICUBatch NumberAscending
5SFXDocument Pay ItemAscending
4Contract Number Type +A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4COCHContract Change NumberAscending
5LNIDLine NumberAscending
7Contract Number Type +B
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4APPLApplication NumberAscending
5ADJNAdjustment NumberAscending
6COCHContract Change NumberAscending
7LNIDLine NumberAscending
8Contract Number Type +C
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4COCHContract Change NumberAscending
5LNIDLine NumberAscending
6APPLApplication NumberAscending
7ADJNAdjustment NumberAscending
9Contract Number Type +D
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4APPOApplication Posted CodeAscending
10Batch Number Address Number +
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2AN8OAddress Number - Job A/RAscending
3KCOIDocument Company (Invoice)Ascending
4DOCZDocument (Order # Invoice etc.)Ascending
5DCTIDocument Type - Invoice OnlyAscending
11Contract Number Type +E
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4APPLApplication NumberDescending
5ADJNAdjustment NumberDescending
6COCHContract Change NumberAscending
7LNIDLine NumberAscending
12Contract Number Type +F
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4COCHContract Change NumberAscending
5LNIDLine NumberAscending
6APPLApplication NumberDescending
7ADJNAdjustment NumberDescending
13Contract Number Type +G
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending