IU_AUDIT_INH

(SQL Table)
Index Back

ChartField Inheritance Audit

Audit of non-bank ChartField Inheritance and Bank ChartField Inheritance SQL Objects

# 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