RVL_BUCUR_AR_VW(SQL View) |
Index Back |
|---|---|
Reval AR Acctg Ent by Currency |
| SELECT DISTINCT business_unit , prcs_inst_rvl , foreign_currency , ledger , currency_cd , accounting_dt , gl_distrib_status , journal_id , journal_date FROM PS_RVL_ACCTG_LN_AR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARED_NONVW |
| 2 | PRCS_INST_RVL |
Number(10,0) | DECIMAL(10) NOT NULL | Revaluation Process Instance |
| 3 | FOREIGN_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 4 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 8 | 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. |
| 9 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |