OPERATORB=Business Unit Currency
C=Customer Default Currency
O=Other
B=Business Unit Currency
C=Customer Default Currency
O=Other
Default Value: B
EU_OPR_PREF_CUR(SQL Table) |
Index Back |
|---|---|
Operator Currency PreferenceIt stores the operator's display currency preference in the AR/AP multi-currency enhancement. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPERATOR |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 2 | EU_OP_DSP_CUR | Character(1) | VARCHAR2(1) NOT NULL |
Last Operator Display Currency Type Choice :
'B': Displays Business Unit Currency Code
'C': Displays Customer Currency Code
'O': Displays Other Operator-choosen Currency Code
B=Business Unit Currency C=Customer Default Currency O=Other |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 5 | EU_AP_OP_DSP_CUR | Character(1) | VARCHAR2(1) NOT NULL |
Last Operator Choice for AP
B=Business Unit Currency C=Customer Default Currency O=Other Default Value: B |
| 6 | EU_AP_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | AP Currency Code |
| 7 | EU_AP_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | AP Rate Type |