[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Shows the Orders placed for Transcripts and Enrollment Certificates. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ORDER_NUMBER
, ORDER_DESCRIPTION
, '_LA:ORDER_STATUS:IGS_LOOKUP_VALUES:IGS_AS_ORDER_STATUS:MEANING'
, DATE_COMPLETED
, ADDR_LINE_1
, ADDR_LINE_2
, ADDR_LINE_3
, ADDR_LINE_4
, CITY
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, POSTAL_CODE
, EMAIL_ADDRESS
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, FAX_COUNTRY_CODE
, FAX_AREA_CODE
, FAX_NUMBER
, DELIVERY_FEE
, ORDER_FEE
, '_LA:REQUEST_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOC_REQTYPE:MEANING'
, SUBMIT_METHOD
, PERSON_ID
, ORDER_PLACED_BY
, INVOICE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_AS_ORDER_HDR WITH READ ONLY