https://registry.kingsu.ca/mediawiki/index.php?action=history&feed=atom&title=INVLOG_StructureINVLOG Structure - Revision history2026-04-19T17:44:48ZRevision history for this page on the wikiMediaWiki 1.27.0https://registry.kingsu.ca/mediawiki/index.php?title=INVLOG_Structure&diff=291&oldid=prevWikiSysop: New page: <table border><Caption>INVLOG</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>...2009-09-08T04:40:52Z<p>New page: <table border><Caption>INVLOG</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>...</p>
<p><b>New page</b></p><div><table border><Caption>INVLOG</caption><br />
<tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>Name</th></tr><tr><td><b><i>ENTCODE</i></b></td><td>N</td><td>5</td><td>0</td><td>99999</td><td>File #</td><td>Application File Number</td><td></td><td>ENTCODE</td></tr><br />
<tr><td><b><i>STUDID</i></b></td><td>N</td><td>6</td><td>0</td><td>999999</td><td>Student ID</td><td>Student Identification Number</td><td></td><td>STUDID</td></tr><br />
<tr><td><b><i>INVDATE</i></b></td><td>D</td><td>8</td><td>0</td><td></td><td>Invdate</td><td></td><td>invlog_INVDATE</td><td>INVDATE</td></tr><br />
<tr><td><b><i>CREDITS</i></b></td><td>N</td><td>5</td><td>2</td><td></td><td>Credits</td><td>Amount of credit associated with this course</td><td></td><td>CREDITS</td></tr><br />
<tr><td><b><i>AMOUNT</i></b></td><td>N</td><td>8</td><td>2</td><td></td><td>Amount</td><td></td><td>invlog_AMOUNT</td><td>AMOUNT</td></tr><br />
<tr><td><b><i>TNUMBER</i></b></td><td>N</td><td>6</td><td>0</td><td></td><td>Transaction Number</td><td>Transaction Number</td><td>tnumber</td><td>TNUMBER</td></tr><br />
<tr><td><b><i>TYPE</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Type</td><td>Transaction Type</td><td>invlog_TYPE</td><td>TYPE</td></tr><br />
<tr><td><b><i>EXPORTED</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Exported</td><td>Record Exported</td><td>invlog_EXPORTED</td><td>EXPORTED</td></tr><br />
<tr><td><b><i>FTPTUC</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Student Status</td><td>Student status for this individual</td><td></td><td>STDSTAT</td></tr><br />
<tr><td><b><i>MANUAL</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Manual</td><td>Calculate Manually</td><td>invlog_MANUAL</td><td>MANUAL</td></tr><br />
<tr><td><b><i>MANCODE</i></b></td><td>C</td><td>14</td><td>0</td><td></td><td>Mancode</td><td>Item Code</td><td>invlog_MANCODE</td><td>MANCODE</td></tr><br />
<tr><td><b><i>YEARTERM</i></b></td><td>C</td><td>8</td><td>0</td><td></td><td>Yearterm</td><td>Academic Year and Term</td><td></td><td>YEARTERM</td></tr><br />
<tr><td><b><i>INVTIME</i></b></td><td>C</td><td>8</td><td>0</td><td></td><td>Invtime</td><td>Invoice Time</td><td>invlog_INVTIME</td><td>INVTIME</td></tr><br />
<tr><td><b><i>OPERATOR</i></b></td><td>C</td><td>14</td><td>0</td><td></td><td>Operator</td><td>Operator who made this entry or last changed it</td><td></td><td>OPERATOR</td></tr><br />
<tr><td><b><i>LASTITEM</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Lastitem</td><td>Marks last item in set</td><td>invlog_LASTITEM</td><td>LASTITEM</td></tr><br />
<tr><td><b><i>IDCENT</i></b></td><td>N</td><td>2</td><td>0</td><td>99</td><td>ID Century</td><td>Century of Student Identification Number</td><td></td><td>IDCENT</td></tr><br />
<tr><td><b><i>LOCKED</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Locked</td><td>Record barred from changes</td><td></td><td>LOCKED</td></tr><br />
</table></div>WikiSysop