...
Column | Data Type | Length | Description |
---|---|---|---|
hIdx | INT | 4 | Primary Key |
TermName | VARCHAR | 10 | Term Name |
TermDesc | VARCHAR | 80 | Term Description |
DeptName | VARCHAR | 20 | Department Name |
CourseName | VARCHAR | 20 | Course Name |
CourseDesc | VARCHAR | 80 | Course Description |
CourseCmnt | VARCHAR | 80 | Course Comment |
CourseSection | VARCHAR | 10 | Course Section |
SectionID | VARCHAR | 20 | SectionID |
SectionCmnt | VARCHAR | 80 | Section Comment |
Instructor | VARCHAR | 40 | Instructor Name |
CourseItmReqDate | DATETIME | 8 | Course Request Date |
ReqType | VARCHAR | 30 | Request Type |
ReqQty | INT | 4 | Request Quantity |
EnrollEsti | INT | 4 | Estimated Enrollment |
EnrollActu | INT | 4 | Actual Enrollment |
BookAuthor | VARCHAR | 45 | Author |
BookTitle | VARCHAR | 128 | Title/Description |
BookISBN | VARCHAR | 30 | ISBN/Catalog Number |
BookEdition | VARCHAR | 20 | Edition |
BookBinding | VARCHAR | 20 | Binding |
BookCopyright | VARCHAR | 2 | Copyright Year |
VendorCode | VARCHAR | 10 | Vendor Code |
VendorName | VARCHAR | 50 | Vendor Name |
SKUnew | INT | 4 | SKU of new item |
SKUused | INT | 4 | SKU of used item |
SKULinked | VARCHAR | 1 | ‘C’ = Child, ‘P’ = Parent, ‘’ = Neither |
SKUParent | INT | 4 | SKU of parent item |
BookStatus | VARCHAR | 15 | Book Status |
BookStatusDate | DATETIME | 8 | Book Status |
ItemComment | VARCHAR | 25 | Item Comment |
AdoptStatus | TINYINT | 1 | Adoption Status |
NewOnly | TINYINT | 1 | New Only Flag |
RetailNew | MONEY | 8 | New Retail Price |
RetailUsed | MONEY | 8 | Used Retail Price |
RentalNew | MONEY | 8 | New Rental Price |
RentalUsed | MONEY | 8 | Used Rental Price |
SOHNew | INT | 4 | New Stock On Hand |
SOHUsed | INT | 4 | Used Stock On Hand |
OnOrderNew | INT | 4 | New On Order and Proposed On Order |
OnOrderUsed | INT | 4 | Used On Order and Proposed On Order |
tm_stamp | TIMESTAMP | 8 | Timestamp |
ASCII Delimited Format
TermName CHAR 10
TermDesc CHAR 80
DeptName CHAR 20
CourseName CHAR 20
CourseDesc CHAR 80
CourseCmnt CHAR 80
CourseSection CHAR 10
SectionID CHAR 20
SectionCmnt CHAR 80
Instructor CHAR 40
CourseItmReqDate DATETIME
ReqType CHAR 30
ReqQty INT
EnrollEsti INT
EnrollActu INT
BookAuthor CHAR 45
BookTitle CHAR 128
BookISBN CHAR 30
BookEdition CHAR 20
BookBinding CHAR 20
BookCopyright CHAR 2
VendorCode CHAR 10
VendorName CHAR 50
SKUnew INT
SKUused INT
SKULinked CHAR 1
SKUParent INT
BookStatus CHAR 15
BookStatusDate DATETIME
ItemComment CHAR 25
AdoptStatus INT
NewOnly INT
RetailNew MONEY
RetailUsed MONEY
RentalNew MONEY
RentalUsed MONEY
SOHNew INT
SOHUsed INT
OnOrderNew INT
OnOrderUsed INT
...
TermName | CHAR | 10 |
TermDesc | CHAR | 80 |
DeptName | CHAR | 20 |
CourseName | CHAR | 20 |
CourseDesc | CHAR | 80 |
CourseCmnt | CHAR | 80 |
CourseSection | CHAR | 10 |
SectionID | CHAR | 20 |
SectionCmnt | CHAR | 80 |
Instructor | CHAR | 40 |
CourseItmReqDate | DATETIME | |
ReqType | CHAR | 30 |
ReqQty | INT | |
EnrollEsti | INT | |
EnrollActu | INT | |
BookAuthor | CHAR | 45 |
BookTitle | CHAR | 128 |
BookISBN | CHAR | 30 |
BookEdition | CHAR | 20 |
BookBinding | CHAR | 20 |
BookCopyright | CHAR | 2 |
VendorCode | CHAR | 10 |
VendorName | CHAR | 50 |
SKUnew | INT | |
SKUused | INT | |
SKULinked | CHAR | 1 |
SKUParent | INT | |
BookStatus | CHAR | 15 |
BookStatusDate | DATETIME | |
ItemComment | CHAR | 25 |
AdoptStatus | INT | |
NewOnly | INT | |
RetailNew | MONEY | |
RetailUsed | MONEY | |
RentalNew | MONEY | |
RentalUsed | MONEY | |
SOHNew | INT | |
SOHUsed | INT | |
OnOrderNew | INT | |
OnOrderUsed | INT |
XML Definition
The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.
...