CF_INHERIT_TBL(SQL Table) |
Index Back |
---|---|
ChartField Inheritance |
# | 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).
Prompt Table: FS_CF_TMPLT_VW |
4 | CF_INHERIT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Inheritance Option.
A=Always Inherit D=Use Unit Default I=Inherit Within Unit N=Do Not Inherit Default Value: N |