FEC_RPT_VW(SQL View) |
Index Back |
|---|---|
FEC Data staging tableFEC Data staging table for detail acconts |
| SELECT FEC_APPL_ID ,BUSINESS_UNIT ,LEDGER ,FEC_ACCOUNT ,FEC_DOC_SEQ_NBR ,FISCAL_YEAR ,ACCOUNTING_PERIOD ,BUSINESS_UNIT_TXN , JOURNAL_ID ,JOURNAL_LINE ,JRNL_CODE ,ACCOUNTING_DT ,FEC_THIRD_PARTY ,FEC_DOC_REFERENCE ,ACCOUNT_DESCR ,JRNL_DESCR ,NAME , DOC_DATE ,LINE_DESCR ,POSTED_TOTAL_DR ,POSTED_TOTAL_CR ,FEC_MATCH_DOC_REF ,FEC_MATCH_DOC_DATE ,POSTED_DATE ,POSTED_TRAN_AMT ,CURRENCY_CD ,PROCESS_INSTANCE FROM PS_FEC_RPT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 4 | FEC_ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 5 | FEC_DOC_SEQ_NBR |
Character(20) | VARCHAR2(20) NOT NULL | Document Sequence Number |
| 6 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 7 | ACCOUNTING_PERIOD |
Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 8 | BUSINESS_UNIT_TXN | Character(5) | VARCHAR2(5) NOT NULL | Transaction Business Unit |
| 9 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 10 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
| 11 | JRNL_CODE | Character(8) | VARCHAR2(8) NOT NULL | Journal Code |
| 12 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 13 | FEC_THIRD_PARTY | Character(17) | VARCHAR2(17) NOT NULL | Third Party |
| 14 | FEC_DOC_REFERENCE | Character(30) | VARCHAR2(30) NOT NULL | Document Reference |
| 15 | ACCOUNT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Account Description |
| 16 | JRNL_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Journal Description |
| 17 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 18 | DOC_DATE | Date(10) | DATE | Document Date |
| 19 | LINE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered. |
| 20 | FEC_TOTAL_DR | Character(26) | VARCHAR2(26) NOT NULL | Posted Total Debits |
| 21 | FEC_TOTAL_CR | Character(26) | VARCHAR2(26) NOT NULL | Posted Total Credits |
| 22 | FEC_MATCH_DOC_REF | Character(40) | VARCHAR2(40) NOT NULL | Match Document Reference |
| 23 | FEC_MATCH_DOC_DATE | Date(10) | DATE | Matching Document Date |
| 24 | POSTED_DATE | Date(10) | DATE | Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger. |
| 25 | FEC_TRAN_AMT | Character(26) | VARCHAR2(26) NOT NULL | Posted Transaction Amount |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |