INVOICE_LAYOUT_IDE=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher
BI_IVCLAYOUT_VW(SQL View) |
Index Back |
|---|---|
Active Billing Invoice Layouts |
| SELECT invoice_layout_id , page_orientation , descr FROM PS_BI_IVC_LAYOUT WHERE status_bi = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_LAYOUT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Invoice Layout ID |
| 2 | PAGE_ORIENTATION | Character(1) | VARCHAR2(1) NOT NULL |
Layout Type
E=Crystal L=SQR - Landscape P=SQR - Portrait X=XML Publisher |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |