ACCOUNTALTACCTBS=Balance Sheet
OB=Off Balance Sheet
N=Not Carry Forward
O=Other
Y=Carry Forward
A=Active
I=Inactive
CLO_ACCT_TMP004(SQL Table) |
Index Back |
|---|---|
Acct temp record for closingStore account information for use during closing process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 2 | ALTACCT |
Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 3 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 4 | BAL_SHEET_IND | Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 5 | BALANCE_FWD_SW | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward O=Other Y=Carry Forward |
| 6 | STATISTICS_ACCOUNT | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a general ledger account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. A unit of measure (UNIT_OF_MEASURE) must be specified with a statistical account. |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |