BU_AR_DEFLT_VW (SQL View)	Index Back
AR BU Currency Data Fields

BU_AR_DEFLT_VW

(SQL View)

AR BU Currency Data Fields

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.DST_ID_AR , B.PYMNT_TERMS_CD , B.RT_TYPE , C.BASE_CURRENCY , B.FORMAT_CURRENCY , B.CALENDAR_ID , B.PAYMENT_METHOD , B.ORIGIN_ID_PENSION , B.GROUP_TYPE_PENSION , C.DOC_SEQ FROM PS_BUS_UNIT_TBL_AR A , PS_BUS_UNIT_OPT_AR B , PS_BUS_UNIT_TBL_GL C WHERE B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'BUS_UNIT_OPT_AR') AND C.BUSINESS_UNIT = A.BUSINESS_UNIT_GL

# 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 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.

5 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.

6 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. "

7 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.

8 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

9 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

10 ORIGIN_ID_PENSION Character(5) VARCHAR2(5) NOT NULL Pension Origin ID

11 GROUP_TYPE_PENSION Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

12 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing

#	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	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.
5	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.
6	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. "
7	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.
8	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
9	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
10	ORIGIN_ID_PENSION	Character(5)	VARCHAR2(5) NOT NULL	Pension Origin ID
11	GROUP_TYPE_PENSION	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
12	DOC_SEQ	Character(1)	VARCHAR2(1) NOT NULL	Enable Document Sequencing