optim

JDE 주요테이블

@ipajama 2011. 10. 22. 23:56
728x90


  1. 00
    1. * F0002     : Next Number - Automatic   
    2.   F0030     : Bank Transit Master / Bank Account Information
    3.   F0041Z1   : Transaction Control File (store-and-forward only)
    4.   F0005     : UDC(User Defined Codes)   
    5. * F0006     : BU(Business Unit Master)
    6.   F0006S    : Date Effective Business Unit Master
    7.   F0008     : Date Fiscal Patterns  
    8. * F0009     : General Constants  
    9.   F00091    : Supplemental Database Date Types  
    10.   F00092    : Supplemental Date  
    11. * F0010     : Company Constants  
    12. * F0011     : Batch Control Records  
    13. * F0012     : AAI(Automatic Accounting Instructions Master)  
    14.   F0018     : Taxes
    15.   F0018R    : Tax Reconciliation Repository
    16.   F0025     : Ledger Type Master File  
    17.   F0050A    : Structure Define File  
  2. 01 - Address Book
    1. * F0101     : A/B(Address Book) Master   
    2.   F0111     : A/B - Who's Who
    3.   F0115     : A/B - Contact Phone Numbers
    4.   F0116     : A/B - Address By Date
    5.   F0150     : Address Organization Structure Master
  3. 03B - A/R 
    1. * F03012(?) : Customer Master by Line Of Business
    2.   F03012A   : Customer Date Effective Category Codes
    3. * F03B012(?): Customer Master by LOB(Line Of Business)
    4. * F03B11    : Customer Ledger
    5.   F03B11Z1  : Batch Invoices
    6. * F03B112   : Invoice Revisions
    7. * F03B13    : Receipts Header  
    8.   F03B13Z1  : Electronic Receipts Input
    9. * F03B14    : Receipts Detail
    10.   F03B571   : Auto Debit Batch Control
    11.   F03B575   : Auto Debit Invoice Select And Build
  4. 04 - A/P
    1. * F0401     : Supplier Master  
    2. * F0411     : A/P Ledger  
    3.   F0411A    : As Of A/P Ledger
    4.   F0411Z1   : Voucher Transactions - Batch Upload
    5. * F0413     : A/P Matching Document  
    6.   F0413A    : As Of A/P Payment Register  
    7. * F0414     : A/P Matching Document Detail  
    8.   F0414A    : As Of A/P Detail  
    9.   F0450     : Payee Control  
    10.   F04571    : A/P Payment Processing - Header
    11.   F04572    : A/P Payment Processing - Summary
    12.   F04572OW  : A/P Payment Tape
    13.   F04573    : A/P Payment Processing - Detail
  5. 09 - G/A
    1. * F0901     : Account Master
    2. * F0902     : Account Balances
    3. * F0911     : Account Ledger
    4.   F0911Z1   : Journal Entry Transactions - Batch File
    5.   F0911R    : WF - Account Ledger Reconciliation  
    6.   F0912     : Cost Allocations/Flex Budgeting  
    7.   F0912A    : Index Computation Entry File  
    8.   F0912B    : Variable Allocation File  
    9.   F0916     : Bank Statement Header  
    10.   F0917     : Bank Statement Detail  
  6. 12 - F/A(Fixed Assets)
    1. * F1201     : Asset Master
    2. * F1202     : Asset Account Balances
    3.   F1204     : Location Tracking
    4. * F1211     : 
  7. 13 - Equipment
  8. 40 -
    1.   F4016     : Print Messages
    2.   F4016     : Distribution/Manufacturing Constants
    3.   F4015     : Order Template
    4.   F40203    : Order Activity Rules
    5.   F4090     : AAI Record Type
    6.   F4095     : AAI Values
  9. 41 - Inventory
    1. * F4101     : Item Master
    2.   F4105     : Item Cost
    3.   F41061    : Supplier Price/Catalog File
  10. 42 - Sales
    1. * F4201     : Sales Order Header
    2.   F42019    : Purges Order to History
    3.   F4209     : Held Orders
    4. * F4211     : Sales Order Detail
    5.   F42119    : Purges Order to History - Detail
  11. 43 - Procurement
    1. * F4301     : Purchase Order Header
    2. * F4311     : Purchase Order Detail 
    3.   F43121    : Purchase Order Receiver
    4.   F43199    : PO Detail Ledger
    5.   F4322     : Puchasing Tolerance Rules
    6.   F43090    : Supplier/Item Relationships
    7.   F43092    : Purchase Order Receipt Routing
  12. 51 - Job Cost

    [출처] 주요테이블|작성자 75_


참조: http://blog.naver.com/75_/120050256507

728x90
저작자표시 비영리 변경금지 (새창열림)