BUSINESS_UNITCONTRACT_NUMTREE_NODETP_NODE_CHRG_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT ,CONTRACT_NUM ,TREE_NODE ,0 FROM PS_TP_CHARGES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 4 | DEFERRED_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount Deferred |