GL Transaction Table

Transgl table. The primary keys vary on the type of transaction so you may want to refer to the data dictionary when reviewing this table



On Wednesday, November 18, 2015 1:19 PM, "jdtrent@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-864890425yiv3331259981ygrp-text">
  
  
  <div></div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">Hi,</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">I&#39;m having a heck of a time finding a GL transaction history table. Right now I&#39;m looking for COS transactions related to shipped orders, but it would be handy to have available.</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">I&#39;ve found the journal entries, but not a table for all transaction history. Guidance?</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">Thanks,</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">Joe</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">--</div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">Joe D. Trent</div><div><span></span></div><div style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51, 51, 51);">Bigham Ag Equipment</div><div><span><br clear="none" class="ygrps-yiv-864890425yiv3331259981yui-cursor"></span></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981 -- #ygrps-yiv-864890425yiv3331259981ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp #ygrps-yiv-864890425yiv3331259981hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp #ygrps-yiv-864890425yiv3331259981ads {
margin-bottom:10px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp .ygrps-yiv-864890425yiv3331259981ad {
padding:0 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp .ygrps-yiv-864890425yiv3331259981ad p {
margin:0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mkp .ygrps-yiv-864890425yiv3331259981ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ygrp-lc {
font-family:Arial;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ygrp-lc #ygrps-yiv-864890425yiv3331259981hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ygrp-lc .ygrps-yiv-864890425yiv3331259981ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity span {
font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity span span {
color:#ff7900;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981activity span .ygrps-yiv-864890425yiv3331259981underline {
text-decoration:underline;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981attach div a {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981attach img {
border:none;padding-right:5px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981attach label a {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981bold a {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 dd.ygrps-yiv-864890425yiv3331259981last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 dd.ygrps-yiv-864890425yiv3331259981last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 dd.ygrps-yiv-864890425yiv3331259981last p span.ygrps-yiv-864890425yiv3331259981yshortcuts {
margin-right:0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981attach-table div div a {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981attach-table {
width:400px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981file-title a, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981file-title a:active, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981file-title a:hover, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981file-title a:visited {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981photo-title a, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981photo-title a:active, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981photo-title a:hover, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div.ygrps-yiv-864890425yiv3331259981photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 div#ygrps-yiv-864890425yiv3331259981ygrp-mlmsg #ygrps-yiv-864890425yiv3331259981ygrp-msg p a span.ygrps-yiv-864890425yiv3331259981yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981green {
color:#628c2a;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 o {
font-size:0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981photos div {
float:left;width:72px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981reco-category {
font-size:77%;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981reco-desc {
font-size:77%;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 .ygrps-yiv-864890425yiv3331259981replbq {
margin:4px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg select, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 input, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg pre, #ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 code {
font:115% monospace;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-mlmsg #ygrps-yiv-864890425yiv3331259981logo {
padding-bottom:10px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-msg p#ygrps-yiv-864890425yiv3331259981attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-reco #ygrps-yiv-864890425yiv3331259981reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-sponsor #ygrps-yiv-864890425yiv3331259981ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-text {
font-family:Georgia;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-text tt {
font-size:120%;}

#ygrps-yiv-864890425 #ygrps-yiv-864890425yiv3331259981 #ygrps-yiv-864890425yiv3331259981ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-864890425



Hi,

I'm having a heck of a time finding a GL transaction history table. Right now I'm looking for COS transactions related to shipped orders, but it would be handy to have available.

I've found the journal entries, but not a table for all transaction history. Guidance?

Thanks,

Joe

--

Joe D. Trent

Bigham Ag Equipment