CURR_LOG_TBL_VW

(SQL View)
 Index Back

MultiCurrency Calculation Log


SELECT A.PROCESS_INSTANCE , A.REQUEST_NBR , A.PROCESS_GROUP , A.CURR_STEP , A.ACCOUNT , A.FROM_CURRENCY_TYPE , A.BUSINESS_UNIT , A.LEDGER , A.ALTACCT , A.DEPTID , %subrec(CF12_AN_SBR, A) , A.PROJECT_ID , A.BOOK_CODE , A.GL_ADJUST_TYPE , A.CURRENCY_CD , A.STATISTICS_CODE , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.POSTED_TOTAL_AMT , A.POSTED_TRAN_AMT , A.POSTED_BASE_AMT , A.RESTATED_AMT , A.REVAL_ADJUSTMENT , A.RATE_MULT , A.RATE_DIV , A.TARGET_CURRENCY FROM PS_CURR_LOG_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
3 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
4 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
6 FROM_CURRENCY_TYPE Character(1) VARCHAR2(1) NOT NULL From Currency Type
L=Ledger Base Currency
S=Specify
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
12 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
13 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
14 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
16 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
17 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
18 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
19 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
20 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
21 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
22 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
23 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
24 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
25 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
28 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
29 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.
30 POSTED_TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
31 POSTED_TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Posted Transaction Amount
32 POSTED_BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination, in the base currency of the business unit. Unless the Separate Debit/Credit option is set up, the ledger stores net amounts only.
33 RESTATED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remeasured Amount
34 REVAL_ADJUSTMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Revaluation Adjustment Amount
35 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
36 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
37 TARGET_CURRENCY Character(3) VARCHAR2(3) NOT NULL Target Currency