TEMPLATE_IDBI_CF_TMPLT_VW(SQL View) |
Index Back |
|---|---|
Billing CF Config Template VW |
| SELECT A.TEMPLATE_ID , A.DST_CODE_SW , A.BUDGET_DT_SW , A.UOM_SW , A.STATISTICS_CODE_SW , B.FIELDNAME FROM PS_BI_CF_TMPLT_HDR A , PS_BI_CF_TMPLT_LN B WHERE A.TEMPLATE_ID = B.TEMPLATE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 2 | DST_CODE_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Distribution Code |
| 3 | BUDGET_DT_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Budget Date |
| 4 | UOM_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Unit of Measure |
| 5 | STATISTICS_CODE_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Statistics Code |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |