GLAdjustmentAccountingTransaction

Version: 1.33

GLAdjustmentAccountingTransaction is a type of GLAccountingTransaction. GLAccountingTransactions include GLAdjustmentAccountingTransactions (on this page, scroll down for details), GLPaymentAccountingTransactions, and GLInvoiceAccountingTransactions.

GLAccountingTransactions are grouped into a GLTransactionBatch.

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

Parameters

Each GLAdjustmentAccountingTransaction 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.
accountAdjustment		Adjustment	- -	The adjustment. Refer to Adjustment for more information.

Query a GLAdjustmentAccountingTransaction

Query Key Information

Querying to see GLAdjustmentAccountingTransactions 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 - GLAdjustmentAccountingTransaction

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

Query

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

SOAP

SOAP Example Query for Parameters "originalCurrencyType" and "GLAccountingTransaction EID"

In the following SOAP query of GLAdjustmentAccountingTransaction, the parameter of originalCurrencyType was used which in this example is "USD" and the parameter of the EID of the GLAdjustmentAccountingTransaction ("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>GLAdjustmentAccountingTransaction</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 GLAdjustmentAccountingTransaction, the parameter of batchPostedOn was used which in this example is "2014-01-08" and the parameter of the EID of the GLAdjustmentAccountingTransaction ("36080305") 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>GLAdjustmentAccountingTransaction</dom:type>
                    <parameter parameter="batchPostedOn" operator="GT" parameterValue="2014-01-08"/>
                    <parameter parameter="eid" parameterValue="36080305"/>
                </dom:simpleDataQuery>
            </ser:queryRequest>
        </ser:query>
    </soapenv:Body>

REST Mount Points

Query

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

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

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

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

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

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

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

• GET https://my.tractbilling.com/t/s/r/1.33/glAdjustmentAccountingTransactions?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 GLAdjustmentAccountingTransaction uses the parameter of batchNum ("327") and currencyType ("USD").

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

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

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

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