GLInvoiceAccountingTransaction

Version: 1.33

GLInvoiceAccountingTransaction is a type of GLAccountingTransaction. GLAccountingTransactions include GLAdjustmentAccountingTransactions, GLPaymentAccountingTransactions, and GLInvoiceAccountingTransaction.

GLAccountingTransactions are grouped into a GLTransactionBatch.

G/L Invoice Accounting Transactions can be viewed in the Gotransverse interface as well as queried and viewed through the Gotransverse API.

Parameters

Each GLInvoiceAccountingTransaction shown from the query shows information for a number of elements in the entity. The following table shows the elements, details of the elements, and brief descriptions.

Elements

Element Name	Query Key	Element Type	Field Length	Description
GLAccountingTransaction		GLAccountingTransaction	- -	Refer to GLAccountingTransaction.
invoice		Invoice	- -	The invoice. Refer to Invoice for more information.

Query a GLInvoiceAccountingTransaction

Query Key Information

Querying to see GLInvoiceAccountingTransactions needs to include one of the following parameters. If you do not know the value for the parameter, query separately to learn the value.

Query Key Parameters -GLInvoiceAccountingTransaction

Query Key	Value	Definition
eid	Long	The eid number of the GLInvoiceAccountingTransaction.
batchNum	String	The number of the GLTransactionBatch in which the GLInvoiceAccountingTransaction is a member.
GLTransactionBatchEid	Long	The eid number of the GLTransactionBatch in which the GLInvoiceAccountingTransaction is a member.
batchPostedOn	Date	The date on which the GLTransactionBatch was posted in which the GLInvoiceAccountingTransaction is a member.
occurredOn	Date	The date on which the GLInvoiceAccountingTransaction occurred.
currencyType		The current currency type of the GLInvoiceAccountingTransaction.
originalCurrencyType		If applicable, the original currency type of the GLInvoiceAccountingTransaction. Refer to CurrencyType for list of currencies used in Gotransverse.

Query

Query to Use	Query for	Parameter Name and Value	Returns
SimpleDataQuery	GLInvoiceAccountingTransaction	<parameter name><parameter value>	List of your GLInvoiceAccountingTransactions for that parameter name and value.

SOAP

SOAP Example Query for Parameters OriginalCurrencyType and GLAccountingTransaction EID

In the following SOAP query of GLInvoiceAccountingTransaction, the parameter of originalCurrencyType was used which in this example is "USD" and the parameter of the EID of the GLInvoiceAccountingTransaction ("4435") which can be learned through a separate query. Refer to CurrencyType for list of currencies used in Gotransverse.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.tractbilling.com/billing/1_31/service">
    <soapenv:Header/>
    <soapenv:Body>
        <ser:query>
            <ser:queryRequest queryScope="DEEP">
                <dom:simpleDataQuery>
                    <dom:type>GLInvoiceAccountingTransaction</dom:type>
                    <parameter parameter="originalCurrencyType" parameterValue="USD"/>
                    <parameter parameter="eid" parameterValue="4435"/>
                </dom:simpleDataQuery>
            </ser:queryRequest>
        </ser:query>
    </soapenv:Body>
</soapenv:Envelope>

SOAP Example Query for Parameters BatchPostedOn and GLAccountingTransaction EID

In the following SOAP query of GLInvoiceAccountingTransaction, the parameter of batchPostedOn was used which in this example is "2014-01-08" and the parameter of the EID of the GLInvoiceAccountingTransaction ("4435") which can be learned through a separate query. For information on the use of the "greater than" operator of "GT" Refer to SQLOperator.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 
xmlns:ser="http://www.tractbilling.com/billing/1_31/service">   <soapenv:Header/>   <soapenv:Body>      <ser:query>         <ser:queryRequest queryScope="DEEP">            <dom:simpleDataQuery>               <dom:type>GLInvoiceAccountingTransaction</dom:type>               <parameter parameter="batchPostedOn" operator="GT" parameterValue="2014-01-08"/>               <parameter parameter="eid" parameterValue="4435"/>  
            </dom:simpleDataQuery>         </ser:queryRequest>      </ser:query>   </soapenv:Body>

REST Mount Points

Query

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions/<eid>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?eid=<eid>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?batchNum=<batchNum>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?glTransactionBatchEid=<glTransactionBatchEid>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?batchPostedOn=<batchPostedOn>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?occurredOn=<occurredOn>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?currencyType=<currencyType>

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?originalCurrencyType=<originalCurrencyType>

REST Example Queries

The following examples show different sets of parameters in the queries.

REST Example Query for Parameters "batchNum" and "currencyType"

The following REST query of a GLInvoiceAccountingTransaction uses the parameter of batchNum ("327") and currencyType ("USD").

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?batchNum=327&currencyType=USD&queryScope=DEEP

REST Example Query for Parameters "GLAccountingTransactionEID" and "batchPostedOn"

The following REST query of a GLInvoiceAccountingTransaction uses the parameter of GLAccountingTransactionEID ("4435") which can be learned through a separate query, and batchPostedOn ("2014-07-05").

• GET https://my.tractbilling.com/t/s/r/1.33/glInvoiceAccountingTransactions?eid=4435&batchPostedOn=2014-07-05&queryScope=DEEP