IU_AUDIT_INH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	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	BANK_ACCT_LED_TYPE	Character(1)	VARCHAR2(1) NOT NULL	The general ledger account type associated with a given bank/counterparty account. 12/04/02 VL Added Translate Dit - AR for JFMIP RM1.1 A=Cash - AR B=Bank Charge C=Cash - AP D=Draft - AP F=Fees G=Control H=Cash I=Interest L=Cntrl - AP P=Dep - AR R=Cntrl - AR S=Draft - AR T=Disc - AR U=AROffSetDr V=AROffSetCr W=Dit - AR
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