SETIDCNAO_ACCOUNTCR=Credit
DR=Debit
CNAO_ARACCT_VW(SQL View) |
Index Back |
|---|---|
CNAO AR Account viewCNAO AR Account view |
| SELECT SETID , CNAO_ACCOUNT , NATURAL_BALANCE , ACCOUNT_NODE FROM PS_CNAO_ACCOUNT WHERE ACCT_AR_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNAO_ACCOUNT |
Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 3 | NATURAL_BALANCE | Character(2) | VARCHAR2(2) NOT NULL |
Natural Balance
CR=Credit DR=Debit |
| 4 | ACCOUNT_NODE | Character(20) | VARCHAR2(20) NOT NULL | GL Account |