FEC_PRODUCT_TBL(SQL Table) |
Index Back |
---|---|
FEC Product table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
2 | FEC_APPL_ID | Character(3) | VARCHAR2(3) NOT NULL |
Reporting Application
AM=Asset Management AP=Payables AR=Receivables BI=Billing CA=Contracts EX=Expenses GC=Global Consolidation GL=General Ledger GM=Grants GP=Global Payroll INV=Inventory OM=Order Management OT=Other PC=Project Costing PO=Purchasing TR=Cash Management |
3 | DESCR20A | Character(20) | VARCHAR2(20) NOT NULL | Short Description |
4 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL | System Data |