IU_AUDIT_IN_VW2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_IU_BANK	Character(5)	VARCHAR2(5) NOT NULL	Bank Setid
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	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
4	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
5	IU_BANK_ACCT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bank Account Type A=Receivables Cash B=Bank Charge C=Payables Cash Account D=Payables Draft Account F=Bank Statement Fees G=Control Account H=Cash Account I=Bank Statement Interest L=Payables Control Account P=Receivables - Deposit Control R=Receivables - Control Account S=Receivables Draft Control T=Receivables Disc Draft Control U=AR Cash Cntrl OffSet Debit V=AR Cash Cntrl OffSet Credit W=Deposit in Transit
6	IU_INH_GRP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Missing ChartField Inheritance Group
7	IU_LIST_SQL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Missing ChartField Inheritance and Bank ChartField Inheritance Field List SQL Objects
8	IU_OVR_SQL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Missing ChartField Inheritance and Bank ChartField Inheritance Field Override SQL Objects