BU_CRNCY_VW_MT(SQL View) |
Index Back |
|---|---|
AR BU Currency Data Fields |
| SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.DST_ID_AR , A.DST_ID_REAL , A.DST_ID_REAL_GAIN , A.DST_ID_REAL_LOSS , A.DST_ID_UNREAL_GAIN , A.DST_ID_UNREAL_LOSS , B.PYMNT_TERMS_CD , B.RT_TYPE , C.BASE_CURRENCY , B.FORMAT_CURRENCY , B.CALENDAR_ID , B.PAYMENT_METHOD FROM PS_BUS_UNIT_TBL_AR A , PS_BUS_UNIT_OPT_AR B , PS_BUS_UNIT_TBL_GL C , PS_WS_ITEM D WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND D.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND REC_GROUP_ID = 'AR_03' AND RECNAME = 'BUS_UNIT_OPT_AR') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: BU_GL_UPDATE_VW |
| 3 | DST_ID_AR | Character(10) | VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
Prompt Table: DST_CODE_AR_VW |
| 4 | DST_ID_REAL | Character(10) | VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
Prompt Table: DST_CODE_RL_VW |
| 5 | DST_ID_REAL_GAIN | Character(10) | VARCHAR2(10) NOT NULL | Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables). |
| 6 | DST_ID_REAL_LOSS | Character(10) | VARCHAR2(10) NOT NULL | Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables). |
| 7 | DST_ID_UNREAL_GAIN | Character(10) | VARCHAR2(10) NOT NULL | Unrealized Gain Code |
| 8 | DST_ID_UNREAL_LOSS | Character(10) | VARCHAR2(10) NOT NULL | Unrealized Loss Code |
| 9 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 10 | 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. |
| 11 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 12 | FORMAT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here. |
| 13 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 14 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |