IU_AUDIT_INH(SQL Table) |
Index Back |
---|---|
ChartField Inheritance AuditAudit 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 |