MYOB Endpoint: JournalTransactions: Difference between revisions

(34 intermediate revisions by the same user not shown)

Line 1:

== Overview ==

The MYOB '''JournalTransactions''' [[Endpoints|endpoint]] allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).

The MYOB '''JournalTransactions''' [[MYOB Endpoints|endpoint]] allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).

It does not give you complete details of each transaction. Instead, it provides information as to how the transaction affected the General Ledger.

Note an alternate endpoint named [[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

== Fields ==

The following fields are available for the JournalTransactions endpoint.

;DataFile

:A [[Field Type: Record|record field]] that provides the [[Field: DataFile|DataFile]] associated with the data.

;UID

:A [[Field Type: GUID|GUID field]] representing the internal id of ~~a card~~. 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

Line 75:

Line 80:

The [[#Fields|Lines]] field contains the following sub-fields.

;LineIndex

:A [[Field Type: Integer|integer field]] that provides a index (1,2,3...) for each line of a journal transaction.

;Account

Line 86:

Line 94:

;Job

:A [[Field Type: Record|record field]] that provides the [[MYOB Field: ~~Job~~|job]] for this entry.

:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Jobs|job]] for this entry.

;Description

Line 111:

Line 119:

== Related Endpoints==

:~~None~~

:[[MYOB Endpoint: CreditRefunds|CreditRefunds]]

:[[MYOB Endpoint: CreditSettlements|CreditSettlements]]

:[[MYOB Endpoint: DebitRefunds|DebitRefunds]]

:[[MYOB Endpoint: DebitSettlements|DebitSettlements]]

:[[MYOB Endpoint: CustomerPayments|CustomerPayments]]

:[[MYOB Endpoint: GeneralJournals|GeneralJournals]]

:[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]]

:[[MYOB Endpoint: InventoryBuildTransactions|InventoryBuildTransactions]]

:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]]

:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]]

:[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]]

:[[MYOB Endpoint: PurchasesItemInvoices|PurchasesItemInvoices]]

:[[MYOB Endpoint: PurchasesMiscellaneousInvoices|PurchasesMiscellaneousInvoices]]

:[[MYOB Endpoint: PurchasesProfessionalInvoices|PurchasesProfessionalInvoices]]

:[[MYOB Endpoint: PurchasesServiceInvoices|PurchasesServiceInvoices]]

:[[MYOB Endpoint: ReceiveMoneyTransactions|ReceiveMoneyTransactions]]

:[[MYOB Endpoint: SalesAllInvoices|SalesAllInvoices]]

:[[MYOB Endpoint: SalesItemInvoices|SalesItemInvoices]]

:[[MYOB Endpoint: SalesMiscellaneousInvoices|SalesMiscellaneousInvoices]]

:[[MYOB Endpoint: SalesProfessionalInvoices|SalesProfessionalInvoices]]

:[[MYOB Endpoint: SalesServiceInvoices|SalesServiceInvoices]]

:[[MYOB Endpoint: SalesTimeBillingInvoices|SalesTimeBillingInvoices]]

:[[MYOB Endpoint: SpendMoneyTransactions|SpendMoneyTransactions]]

:[[MYOB Endpoint: SupplierPayments|SupplierPayments]]

:[[MYOB Endpoint: TransferMoneyTransactions|TransferMoneyTransactions]]

== Related Topics ==

:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]]

:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]]

:[[MYOB Models]]

:[[MYOB Endpoints]]

@@ Line 1: / Line 1: @@
 == Overview ==
-The MYOB '''JournalTransactions''' [[Endpoints|endpoint]] allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).
+The MYOB '''JournalTransactions''' [[MYOB Endpoints|endpoint]] allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).
 It does not give you complete details of each transaction. Instead, it provides information as to how the transaction affected the General Ledger.
+Note an alternate endpoint named [[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
 == Fields ==
 The following fields are available for the JournalTransactions endpoint.
+;DataFile
+:A [[Field Type: Record|record field]] that provides the [[Field: DataFile|DataFile]] associated with the data.
 ;UID
-:A [[Field Type: GUID|GUID field]] representing the internal id of a card. 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
@@ Line 75: / Line 80: @@
 The [[#Fields|Lines]] field contains the following sub-fields.
+;LineIndex
+:A [[Field Type: Integer|integer field]] that provides a index (1,2,3...) for each line of a journal transaction.
 ;Account
@@ Line 86: / Line 94: @@
 ;Job
-:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Job|job]] for this entry.
+:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Jobs|job]] for this entry.
 ;Description
@@ Line 111: / Line 119: @@
 == Related Endpoints==
-:None
+:[[MYOB Endpoint: CreditRefunds|CreditRefunds]]
+:[[MYOB Endpoint: CreditSettlements|CreditSettlements]]
+:[[MYOB Endpoint: DebitRefunds|DebitRefunds]]
+:[[MYOB Endpoint: DebitSettlements|DebitSettlements]]
+:[[MYOB Endpoint: CustomerPayments|CustomerPayments]]
+:[[MYOB Endpoint: GeneralJournals|GeneralJournals]]
+:[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]]
+:[[MYOB Endpoint: InventoryBuildTransactions|InventoryBuildTransactions]]
+:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]]
+:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]]
+:[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]]
+:[[MYOB Endpoint: PurchasesItemInvoices|PurchasesItemInvoices]]
+:[[MYOB Endpoint: PurchasesMiscellaneousInvoices|PurchasesMiscellaneousInvoices]]
+:[[MYOB Endpoint: PurchasesProfessionalInvoices|PurchasesProfessionalInvoices]]
+:[[MYOB Endpoint: PurchasesServiceInvoices|PurchasesServiceInvoices]]
+:[[MYOB Endpoint: ReceiveMoneyTransactions|ReceiveMoneyTransactions]]
+:[[MYOB Endpoint: SalesAllInvoices|SalesAllInvoices]]
+:[[MYOB Endpoint: SalesItemInvoices|SalesItemInvoices]]
+:[[MYOB Endpoint: SalesMiscellaneousInvoices|SalesMiscellaneousInvoices]]
+:[[MYOB Endpoint: SalesProfessionalInvoices|SalesProfessionalInvoices]]
+:[[MYOB Endpoint: SalesServiceInvoices|SalesServiceInvoices]]
+:[[MYOB Endpoint: SalesTimeBillingInvoices|SalesTimeBillingInvoices]]
+:[[MYOB Endpoint: SpendMoneyTransactions|SpendMoneyTransactions]]
+:[[MYOB Endpoint: SupplierPayments|SupplierPayments]]
+:[[MYOB Endpoint: TransferMoneyTransactions|TransferMoneyTransactions]]
+== Related Topics ==
+:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]]
+:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]]
+:[[MYOB Models]]
+:[[MYOB Endpoints]]