CNAO_ACCOUNT(SQL Table) |
Index Back |
|---|---|
CNAO Accounts Tbl. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ACCOUNT_NODE |
Character(20) | VARCHAR2(20) NOT NULL | GL Account |
| 3 | ACCOUNT_LEVEL | Signed Number(4,0) | DECIMAL(3) NOT NULL | Account Level |
| 4 | SUMMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Summary Flag |
| 5 | PARENT_NODE | Character(20) | VARCHAR2(20) NOT NULL | Parent Tree Node |
| 6 | CNAO_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 7 | NATURAL_BALANCE | Character(2) | VARCHAR2(2) NOT NULL |
Natural Balance
CR=Credit DR=Debit |
| 8 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.
Prompt Table:
ACCT_TYPE_TBL
|
| 9 | ACCT_CSFL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cash Flow Related
Y/N Table Edit Default Value: N |
| 10 | ACCT_AR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Report for Receivables
Y/N Table Edit Default Value: N |
| 11 | ACCT_AP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Report for Payables
Y/N Table Edit Default Value: N |
| 12 | ACCT_CUST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subsidiary Customer
Y/N Table Edit Default Value: N |
| 13 | ACCT_SUPL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subsidiary Supplier
Y/N Table Edit Default Value: N |
| 14 | ACCT_DEPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subsidiary Department
Y/N Table Edit Default Value: N |
| 15 | ACCT_EMPL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subsidiary Employee
Y/N Table Edit Default Value: N |
| 16 | ISNEW_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Is New
Default Value: Y |