Composite Keys
This appendix lists the composite keys by product area.
Composite Keys
This section lists the composite keys for certain tables that the system converts during the base currency conversion. Use the composite key to create and run a query or batch program over the F0086 table.
Financial Management
This table lists the composite keys for JD Edwards EnterpriseOne Financial Management tables:
|
Table Name |
Table Number |
Composite Key |
|
Taxes |
F0018 |
For F03B11 and F0411 table conversions: TDDOCO, TDDCTO, TDKCOO, TDSFXO For the F0911 table conversion: TDDOCO, TDDCTO, TDKCOO, TDSFXO, TDLNID |
|
Customer Ledger |
F03B11 |
RPDOC, RPDCT, RPKCO, RPSFX |
|
Accounts Payable Ledger |
F0411 |
RPDOC, RPDCT, RPKCO, RPSFX |
|
Accounts Payable - Matching Document |
F0413 |
RMDOCM, RMDCTM, RMPYE |
|
Accounts Payable Matching Document Detail |
F0414 |
RNDOC, RNDCT, RNDCTM, RNKCO, RNSFX |
|
Account Balances |
F0902 |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
|
Account Balances - 52 Period Accounting |
F0902B |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
|
Account Ledger |
F0911 |
GLDCT, GLDOC, GLKCO, GLDGJ, GLJELN, GLLT, GLEXTL |
|
Multi-Site Consolidation Transfer File |
F1002 |
GQEDBT, GBEDUS, GQEDTN, GQSERK, GQMCU, GQOBJ, GQSUB, GQSBL, GQSBLT, GQCRCD, GQCRCX |
(ITA) Localization
This table lists the composite keys for the Suspended IVA Generation - Receipt/Rebate Control - Italy table (F743B14I):
|
Table Name |
Table Number |
Composite Key |
|
Suspended IVA Generation - Receipt/Rebate Control - Italy |
F743B14I |
TIDOC, TIDCT, TIKCO, TISFX, TIDOCM, TIDCTM |
Manufacturing
This table lists the composite keys for JD Edwards EnterpriseOne Manufacturing tables:
|
Table Name |
Table Number |
Composite Key |
|
Location Tracking Table |
F1204 |
FMNUMB, FMEFTB, FMAL, FMNNBR |
|
Equipment License Master |
F1206 |
FHNUMB, FHADDS, FHLNUM |
|
Equipment Rates |
F1301 |
FGRTTB, FGRTGR, FGNUMB, FGEFTB, FGERC |
|
Rental Rules |
F1302 |
FKCO, FKMCU |
|
Equipment Location Billing |
F1304 |
FNTRNN, FNNNBR, FNLOC |
|
Work Center Rates File |
F30008 |
IWMCU, IWLEDG |
|
Bill of Materials Changes File |
F3011 |
IZMMCU, IZKIT, IZTBM, IZITM |
|
Purge - Shop Floor Parts List |
F3111S |
WMCMCU, WMCPIT, WMCOBY, WMDOCO, WMOPSQ |
|
Outbound Work Order Parts List |
F3111Z1 |
SZCMCU, SZCPIT, SZCOBY, SZDOCO, SZOPSQ |
|
Work Order Time Transactions |
F31122 |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
|
Work Order Time Transactions Unedited Transaction Table |
F31122Z1 |
SZYST, SZAN8, SZDGL, SZDOCO, SZOPSQ, SZTYR |
|
Purge Work Order Time Transactions |
F31122S |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
|
Rules Table Detail |
F3283 |
$2RRN |
|
Assembly Inclusion Rules |
F3293 |
KYKIT, KYMCU, KYATOT, KYATO#, KYATOS |
|
Needed for upgrade from Release Xe and earlier |
F32961 |
KLDOCO, KLDCTO, KLKCOO, KLLNID, KLITM, KLMCU, KLATLV |
|
Forecast File |
F3460 |
MFITM, MFMCU, MFDRQJ, MFTYPF, MFDCTO |
|
EDI Planning Schedule Detail - Inbound |
F47062 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
|
EDI Planning Schedule Detail - Outbound |
F47067 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
|
Work Order Master File |
F4801 |
WADCTO, WATYPS, WASRST, WADPL, WAAN8, WADOCO |
|
Billing Detail Workfile |
F4812 |
WDBCI, WDDGL, WDPRSQ, WDSBSQ, WDSCSQ, WDCCOD |
|
Billing Workfile History |
F4812H |
WDBCI, WDDGL, WDCCOD, WDPRSQ, WDSBSQ, WDSCSQ |
|
Invoice Summary Work File |
F4822 |
W4DOCZ, W4DCTI, W4KCOI, W4SFX |
|
Contract Billing Line Detail |
F5202 |
G6DOCO, G6DCTO, G6KCOO, G6COCH, G6OPIM, G6LNID |
Distribution
This table lists the composite keys for JD Edwards EnterpriseOne Distribution tables:
|
Table Name |
Table Number |
Composite Key |
|
Batch Receiver File - Order Headings |
F4001Z |
SYDOCO, SYDCTO, SYKCOO |
|
Batch Receiver File - Order Headings |
F4011Z |
SZDOCO, SZDCTO, SZKCOO |
|
Price by Item |
F4207 |
PMPCTY, PMMCAT, PMCLV, PMCXPJ |
|
Sales Order Detail File - Tag File |
F49211 |
UDDOCO, UDDCTO, UDKCOO, UDLNID |
|
Item Cost File |
F4105 |
COITM, COMCU, COLOCN, COLOTN, COLEDG |
|
Average Cost Work file |
F41051 |
CHITM, CHMCU, CHLOCN, CHLOTN |
|
Item Ledger File |
F4111 |
ILDOC, ILDCT, ILKCO |
|
Item ASOF File |
F41112 |
INITM, INMCU, INLOCN, INGLPT, INCTRY, INFY |
|
Item History |
F4115 |
IHITM, IHMCU, IHCTRY, IHFY |
|
Container Deposit File |
F4118 |
CNCO, CNMCU, CNAN8, CNITM, CNRORN, CNRCTO |
|
Container Transaction File |
F41181 |
CMCO, CMMCU, CMAN8, CMITM, CMDOCO, CMDCTO |
|
Cycle Count Transaction File |
F4141 |
PJITM, PJMCU, PJLOCN, PJLOTN |
|
EDI Product Activity Data Detail - Inbound |
F47122 |
MJEKCO, MJDOC, MJDCT |
|
EDI Product Activity Data Detail - Outbound |
F47127 |
MJEKCO, MJDOC, MJDCT |
|
Sales Order Header File |
F4201 |
SHDOCO, SHDCTO, SHKCOO, SHSFXO |
|
Sales Order Detail File |
F4211 |
SDDOCO, SDDCTO, SDKCOO, SDLNID |
|
S.O. Detail Ledger File |
F42199 |
SLDOCO, SLDCTO, SLKCOO, SLLNID |
|
Commission Constants File |
F42004 |
CMAN8, CMDCTO, CMCCTY, CMCXPJ |
|
Sales Commission File |
F42005 |
SCDOCO, SCDCTO, SCKCOO, SCLNID |
|
Order Hold Constants |
F42008 |
HCMCU, HCHCOD |
|
Sales Summary History File |
F4229 |
SSAN8, SSMCU, SSDCTO, SSITM, SSLNTY, SSSRP1, SSSRP2, SSSRP3, SSSEP4, SSSPR5, SSSSFY |
|
EDI Purchase Order Header - Inbound |
F47011 |
SYEDOC, SYEDCT, SYEKCO |
|
EDI Purchase Order Detail - Inbound |
F47012 |
SZEDOC, SZEDCT, SZEKCO |
|
EDI Request for Quote Header - Inbound |
F47091 |
SYEDOC, SYEDCT, SYEKCO |
|
EDI Request for Quote Detail - Inbound |
F47092 |
SZEDOC, SZEDCT, SZEKCO |
|
EDI Purchase Order Change Header - Inbound |
F47131 |
EDOC, EDCT, EKCO, EDLN |
|
EDI Purchase Order Change Detail - Inbound |
F47132 |
EDOC, EDCT, EKCO, EDLN |
|
EDI P.O. Acknowledgement. Header - Outbound |
F47026 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Acknowledgement. Detail - Outbound |
F47027 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Shipping Notice Detail - Outbound |
F47037 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Header (Sales) - Outbound |
F47046 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Invoice Detail (Sales) - Outbound |
F47047 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Response to RFQ Header - Outbound |
F47106 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Response to RFQ Detail - Outbound |
F47107 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI P.O. Change Acknowledgement Header - Outbound |
F47146 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgement Detail - Outbound |
F47147 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
Item Cost Components |
F41291 |
IGPRP5, IGITM, IGMCU, IGLVLA, IGEFFT |
|
Purchase Order Header |
F4301 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Supplier/Item Relationships |
F43090 |
PCAN8, PCMCU, PCITM |
|
Purchase Order Detail |
F4311 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Purchase Order Detail File |
F4311T |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Purchase Order Receiver File |
F43121 |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
|
Purchase Order Receiver Tag File |
F43121T |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
|
P.O. Detail Ledger File - Flexible Version |
F43199 |
OLDOCO, OLDCTO, OLKCOO, OLSFXO, OLLNID, OLNLIN, OLCORD, OLUPMJ, OLTDAY |
|
Purchasing Tolerance Rules |
F4322 |
PZFNTY, PZITM, PZPRP1, PZCO |
|
Multiple Requisition File |
F4332 |
P2DOCO, P2DCTO, P2KCOO, P2LNID, P2OORN, P2OCTO, P2OKCO, P2OGNO |
|
Purchase Rebate History |
F4343 |
RHAN8, RHAGSQ, RHDCTO, RHDOCO, RHKCOO, RHLNID |
|
EDI Purchase Order Header - Outbound |
F47016 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Purchase Order Additional Header - Outbound |
F470161 |
S3EDOC, S3EDCT, S3EKCO, S3EDLN |
|
EDI Purchase Order Additional Detail - Outbound |
F47017 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Purchase Order Additional Detail - Outbound |
F470171 |
S4EDOC, S4EDCT, S4EKCO, S4EDLN |
|
EDI P.O. Acknowledgment Header - Inbound |
F47021 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Acknowledgment Detail - Inbound |
F47022 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Header - Inbound |
F47041 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Invoice Detail - Inbound |
F47042 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Summary - Inbound |
F47044 |
SWEDOC, SWEDCT, SWEKCO, SWEDLN |
|
EDI Receiving Advice Header - Inbound |
F47071 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Receiving Advice Detail - Inbound |
F47072 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Receiving Advice Header - Outbound |
F47076 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Receiving Advice Detail - Outbound |
F47077 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Request for Quote Header - Outbound |
F47096 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Request for Quote Detail - Outbound |
F47097 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Purchase Order Change Header - Outbound |
F47136 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgment Header - Inbound |
F47141 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgment Detail - Inbound |
F47142 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
Price Variable Table |
F4075 |
VBVBT, VBEFTJ |
|
Price Adjustment Ledger File |
F4074 |
ALDOCO, ALDCTO, ALKCOO, ALLNID |
|
EDI Tolerance Rules |
F4722 |
PZEDST, PZAN8, PZEDSP, PZCO |