PROJ_TTYP_LN_VW(SQL View) |
Index Back |
|---|---|
Project Trans Type Lines View |
| SELECT PROJ_TRANS_TYPE ,PROJ_DIST_TYPE ,DESCR ,DEBIT_CREDIT ,DESCRSHORT FROM PS_PROJ_TXN_TYP_LN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROJ_TRANS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Project Transaction Type |
| 2 | PROJ_DIST_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Project Distribution Type
AP=Accounts Payable Liability AR=Accounts Receivable AS=Fixed Asset CA=Contra Asset CG=Cost of Goods Sold CL=Contra Liability EX=Expense IF=Intercompany From IN=Inventory IT=Intercompany To RE=Revenue UE=Unearned Revenue UR=Unbilled Receivable WP=Work in Progress |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DEBIT_CREDIT | Character(2) | VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit DR=Debit |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |