INVOICE_FORM_IDBI_AGIVCFORM_VW(SQL View) |
Index Back |
|---|---|
Active Invoice Form Options |
| SELECT A.INVOICE_FORM_ID , A.DESCR FROM PS_BI_IVC_FORM A , PS_BI_IVC_LAYOUT B WHERE A.INVOICE_LAYOUT_ID = B.INVOICE_LAYOUT_ID AND (B.INVOICE_LAYOUT_ID NOT LIKE 'SF%' AND B.INVOICE_LAYOUT_ID NOT LIKE 'GM%') AND B.PAGE_ORIENTATION <> 'L' AND A.STATUS_BI = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_FORM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Invoice Form |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |