Difference between revisions of "MYOB Endpoint: JournalTransactionsTable"

no edit summary
(Created page with "== Overview == The MYOB '''JournalTransactionsTable''' endpoint allows you to access all transactions that affect your General Ledger (sales, purchases, pa...")
 
Line 11: Line 11:
The following fields are available for the JournalTransactions endpoint.
The following fields are available for the JournalTransactions endpoint.


;UID
;JournalUID
:A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.
:A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.


;DisplayID
;JournalNumber
:A [[Field Type: Text|text field]] used as the default transaction number (invoice number, purchase number, etc.)
:A [[Field Type: Text|text field]] used as the default transaction number (invoice number, purchase number, etc.)


Line 27: Line 27:
:* Inventory
:* Inventory


;SourceTransaction
;SourceTransactionUID
:A [[Field Type: Record|record field]] that provides details to the source transaction.
:See [[#SourceTransaction Fields|SourceTransaction Fields]] for more information.
 
;DateOccurred
:A [[Field Type: Date|date field]] that indicates the date of the transaction.
 
;DatePosted
:A [[Field Type: Date|date field]] that indicates the date the transaction was entered into MYOB.
 
;Description
:A [[Field Type: Text|text field]] that provides the memo for the transaction.
 
;Lines
:A [[Field Type: Table|table field]] that provides the list of all affected general ledger accounts.
:See [[#Lines Fields|Lines Fields]] for more information.
 
;RowVersion
:A [[Field Type: Row Version|row version field]].
 
 
== SourceTransaction Fields ==
 
The [[#Fields|SourceTransaction]] field contains the following sub-fields.
 
;UID
:A [[Field Type: GUID|GUID field]] that provides the ID of the source transaction.
:A [[Field Type: GUID|GUID field]] that provides the ID of the source transaction.


;SourceTransaction
;SourceTransactionType
:A [[Field Type: Text|text field]] that indicates the type of transaction that originated this entry.
:A [[Field Type: Text|text field]] that indicates the type of transaction that originated this entry.
:Possible values are:
:Possible values are:
Line 72: Line 47:
:* DebitSettlement
:* DebitSettlement


;DateOccurred
:A [[Field Type: Date|date field]] that indicates the date of the transaction.
;DatePosted
:A [[Field Type: Date|date field]] that indicates the date the transaction was entered into MYOB.


== Lines Fields ==
;Description
:A [[Field Type: Text|text field]] that provides the memo for the transaction.


The [[#Fields|Lines]] field contains the following sub-fields.
;LineDescription
:A [[Field Type: Text|text field]] that provides the line memo for the transaction.


;Account
;Account
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Accounts|general ledger account]] for this entry.
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Accounts|general ledger account]] for this entry.
;Job
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Jobs|job]] for this entry.


;Amount
;Amount
Line 86: Line 71:
:A [[Field Type: Boolean|true/false field]] that indicates if the amount is a credit or debit.
:A [[Field Type: Boolean|true/false field]] that indicates if the amount is a credit or debit.


;Job
;UnitCount
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Jobs|job]] for this entry.
:A [[Field Type: Decimal|decimal field]] that provides the unit count for this entry..
 
;Description
:A [[Field Type: Text|text field]] that provides the line memo for the transaction.


;ReconciledDate
;ReconciledDate
:A [[Field Type: Date|date field]] that indicates the date the transaction was reconciled.
:A [[Field Type: Date|date field]] that indicates the date the transaction was reconciled.


;UnitCount
;RowVersion
:A [[Field Type: Decimal|decimal field]] that provides the unit count for this entry..
:A [[Field Type: Row Version|row version field]].




Line 106: Line 88:
== Related Fields ==
== Related Fields ==


:[[MYOB Field: Accounts|Accounts]]
: N/A
:[[MYOB Field: Jobs|Jobs]]
 


== Related Endpoints==
== Related Endpoints==
3,301

edits