A joined logical file can be used in place of two or more of the physical files needed for the report. This is advantageous because the physical files are joined during the creation of the logical. Also, duplicate records may be eliminated from the report and performance may be improved when logical files are utilized.
Below is a partial list of some of the more common joined logical files. This information was obtained from Software Versions Repository.
| File ID | Description |
|---|---|
| F00147JA | Multi-Tiered Payment Terms Join F00147/F0014/F0411 |
| F00147JB | Multi-Tiered Payment Terms Join F00147/F0014/F0311 |
| F0101JA | JF - Address Suppl Data Information (F0101 F01092 F01093) |
| F0101JB | JF - Address Mailing Labels (F0101 F0111 F0116) |
| F0101JC | JF - Address Mailing Labels (F0101 F0116 F0401 F0301) |
| F0101JD | JF - Address Mailing Labels (F0101 F0116 F0115) |
| F0101JE | JF - Address Mailing Labels (F0101 F0116) |
| F0101JF | JF - Supplier Analysis (F0101 F0401) |
| F01133JA | JF - PPAT Message Distribution (F01133 F01131) |
| F0301JA | JF - Customer and Address Information (F0101 F0301) |
| F0301JB | JF - Customer Mstr & Customer Co/BU Default (F0301 & F03015) |
| F0315JA | JF - A/R STATEMENTS ONLY - F0315/F0101/F0301 - Address No. |
| F03465JA | JF - AR Netting Workfile (F0101/F03465) ABAN8/ROAN8 |
| F0411JA | A/P Payment File - JF (F0101/F0411) - ABAN8/RPPYE |
| F0411JB | A/P 1099 Join File JF (F0411/F0414) |
| F0411JC | A/P Report File - JF (F0101/F0411) - ABAN8/RPAN8 |
| F0411JD | A/P 'As Of' Build File - JF (F0411/F0414/F0413) |
| F0411JE | A/P Payment File - JF (F0101/F0411) - ABAN8/RPPYE |
| F0413JA | A/P Matching Doc File - JF (F0101/F0413/F0414) - Payment Id |
| F0414JB | A/P - JF (F0413/F0414) |
| F0414JC | A/P - JF (F0413/F0414/F09320) |
| F04571JA | JF - F04571/F04572 - A/P Payment Information |
| F06146JA | Joined Logical file - F060116 and F06146 |
| F08JA | JF - Applicant Information (F08401 F08092 F08093) |
| F08JE | JF - Employee Information (F060116 F08092 F08093) |
| F08JH | JF - Case Information (F08601 F08092 F08093) |
| F08JJ | JF - Job Information (F08001 F08092 F08093) |
| F08JP | JF - Participant Information (F08901 F08092 F08093) |
| F08JR | JF - Requisition Information (F08102 F08092 F08093) |
| F08JS | JF - FSA Employee Balance (F08370 F060116) |
| F08JT | JF - Pay Grade/Step Workfile Build (F060118 F060116) |
| F08320JA | JF - Plans/Options (F083202 F08320) |
| F08330JA | JF - Employee Enrollment (F08330 F0101) |
| F0901JA | Joined - MCU joined file f0006 and f0901 |
| F1011JA | JF - F0006/F0901 - Company, Cost Center |
| F10430JA | Multi-Site Cons. File - JF (F10430/F0901) AID |
| F1201JA | JF - F1201/F1207 - Asset Item Number |
| F1201JB | JF - Fx Assets Suppl Data Information (F1201 F12092 F12093) |
| F1201JC | JF - Fx Assets Spec Sheet Information (F1201 F1216) |
| F1201JD | JF - F1202/F1201 - Item Balance/Item Master Join Logical |
| F1201JE | JF - F1201/F4801 - Item Master/Work Order Join Logical |
| F1501JA | JF - F1501/F0101 - Address Number |
| F1503JA | JF - F1503/F1501 - Lease Number |
| F1511JB | JF - (F1511 F0311) |
| F1515JA | JF - A/R STATEMENTS ONLY - F1515/F0101/F0301 - Address No. |
| F1515WJA | JF - TENANT STATEMENTS ONLY - F1515W/F0101/F0301 - Address |
| F1901JA | JF - Service Address/Meter Position (F1901 F1905) |
| F1902JA | JF - Service Agreement/Connection (F1902 F1903) |
| F1902JB | JF - Serv Agrmt/Connections/Bill Item (F1902 F1903 F1926) |
| F3411JA | JF - Planning Message/Branch (F3411/F4102) |
| F3460JA | JF Forecast/Branch (F3460 F4102) |
| F3911JA | JF - F4111/F3911 |
| F4072JA | JF - Price key ID. (F4072 F4094) |
| F4074JA | JF - Adj. Name / Adj. Control Code (F4074 F4071) |
| F4077JA | JF - Price key ID. (F4077 F4094) |
| F4077JB | JF - Price key ID. (F4077 F4094) - Select Approved |
| F4101JA | JF - Item Information (F4101 F41092) |
| F4101JB | JF - Item Master/ Cost Ledger (F4101 F4105) |
| F4101JC | JF- Item Master/Item Location/Cost Ledger(F4101 F4102 F4105) |
| F4101JD | JF-Item Master/Item Branch/Item Location(F4101 F4102 F41021) |
| F4101JE | JF-Item Master/Item Branch(F4101 F4102) |
| F4102JA | JF - Location/Branch (F4102 F41021) |
| F41021JA | JF - Location/Branch (F41021 F4102) |
| F41021JB | JF - Location/Lot Master (F41021 F4108) |
| F41021JC | JF - Location/Item Master (F41021 F4101) |
| F4106JA | JF - Location/Branch (F4106 F4094) |
| F41112JA | JF (F41112/F4101/F0006) |
| F4211JA | Sales Order Detail/Shipment Detail Join File |
| F43090JA | JF - Supplier Item Relationships/Item Master (F43090/F4101) |
| F4311JA | JF - SUBCONTRACTS - Cst Ctr, Ord No., Ord Typ, Suffix, Line |
| F4450JA | JF - Lot Proceed Entry (F4450 F0006) |
| F4456JA | JF - Lot Proceed Entry - F4456 F0006 |
| F46012JA | JF - Fixed Locations (F46012 F4100 F4102) |
| F46029JA | LF for Empty Locations - MCU,BSLN,SRUL,SEQ,DISN,WSQP,LOCN |
| F47141JA | JF - PO Acknowledgment Header & Tax Tag - XPI |
| F47142JA | JF - PO Acknowledgment Detail & Tax Tag - XPI |
| F4801JA | JF - F4801/F3111 - Street Name, Area |
| F4801JB | JF - F4801/F48092 - Order Number |
| F4801JC | JF - F4801/F3111 - Street Name, Area |
| F49211JA | Sales Order Detail Join Logical - DOCO, DCTO, KCOO, LNID |
| F49219JA | Sales Order Detail Tag Logical - Doc, Doc Type |
| F51901JA | Account Master Extended Details |