AR_INHERIT_VW (SQL View)	Index Back
AR Inherited CF's This view contains all ChartFields that have inheritance option set to Always inherit.

AR_INHERIT_VW

(SQL View)

AR Inherited CF's

This view contains all ChartFields that have inheritance option set to Always inherit.

SELECT SETID , CF_INHERIT_GRP , FIELDNAME , ' ' FROM PS_CF_INHERIT_TBL WHERE CF_INHERIT_OPT IN ('A', 'I') AND CF_INHERIT_GRP = 'ARBI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 CF_INHERIT_GRP Character(4) VARCHAR2(4) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: CF_INHERIT_TBL.CF_INHERIT_GRP.SearchInit
APCA=Payables Header Level Entries
APEA=Payables Distrib Level Entries
APPE=Payables Period End Accruals
APVN=Payables VAT Non-Recoverable
ARBI=Receivables and Billing
ARRE=Receivables Revaluation
DMAC=Deduction Management Accounts
EXCA=Expenses Control Accounts
EXCR=Expenses Cash Advance Recon
EXPY=Expenses Payroll Offset
EXVN=Expenses VAT Non-Recoverable
GLVI=GL Journal VAT Input Other
GLVN=GL Journal VAT Non-Recoverable
GLVO=GL Journal VAT Output
POCA=Purchasing Control Accounts
POEA=Purchasing Expense Accounts
POVN=Purchasing VAT Non-Recoverable
TDAC=Promotions Mgmt. Accounts
TRVI=Treasury VAT Input Other
TRVN=Treasury VAT Non-Recoverable
TRVO=Treasury VAT Output

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

4 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CF_INHERIT_GRP	Character(4)	VARCHAR2(4) NOT NULL	If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: CF_INHERIT_TBL.CF_INHERIT_GRP.SearchInit APCA=Payables Header Level Entries APEA=Payables Distrib Level Entries APPE=Payables Period End Accruals APVN=Payables VAT Non-Recoverable ARBI=Receivables and Billing ARRE=Receivables Revaluation DMAC=Deduction Management Accounts EXCA=Expenses Control Accounts EXCR=Expenses Cash Advance Recon EXPY=Expenses Payroll Offset EXVN=Expenses VAT Non-Recoverable GLVI=GL Journal VAT Input Other GLVN=GL Journal VAT Non-Recoverable GLVO=GL Journal VAT Output POCA=Purchasing Control Accounts POEA=Purchasing Expense Accounts POVN=Purchasing VAT Non-Recoverable TDAC=Promotions Mgmt. Accounts TRVI=Treasury VAT Input Other TRVN=Treasury VAT Non-Recoverable TRVO=Treasury VAT Output
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	FIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Field Value