[Home] [Help]
View: IGSBV_AS_DOCUMENT_ORDERS
Product: | IGS - Student System (Obsolete) |
Description: | Shows the Orders placed for Transcripts and Enrollment Certificates. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
ORDER_NUMBER |
ORDER_DESCRIPTION |
"_LA:ORDER_STATUS" |
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" |
SUBMIT_METHOD |
PERSON_ID |
ORDER_PLACED_BY |
INVOICE_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |