ACCT_ATTRIB_TBL (SQL Table)	Index Back
Account Balancing Attribute The fields stored in this table are the account attribute fields which require different account chartfield values in various chartfield value definition (e.g. Journal Edit Suspense CF, Balance Suspense CF, Position Accounting CF, ... ) based on the value of these account attribute fields. For example, if the fields are Book Code and Balance Sheet Indicator, user needs to define one set of Edit Suspense CF for each different combination of Book Code and Balance Sheet Indicator value. The Account value in each set must match the Book Code and Balance Sheet Indicator values of that set.

ACCT_ATTRIB_TBL

(SQL Table)

Account Balancing Attribute

The fields stored in this table are the account attribute fields which require different account chartfield values in various chartfield value definition (e.g. Journal Edit Suspense CF, Balance Suspense CF, Position Accounting CF, ... ) based on the value of these account attribute fields. For example, if the fields are Book Code and Balance Sheet Indicator, user needs to define one set of Edit Suspense CF for each different combination of Book Code and Balance Sheet Indicator value. The Account value in each set must match the Book Code and Balance Sheet Indicator values of that set.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: RECFLD_ACT_VW

2 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Default Value

3 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Y/N Table Edit
Default Value: N