For the type, "OM" stand for the namespace prefix "Winbooks.TORM.OM"
Decimal separator is a point
Date are given in Unix Timestamp. Example: "/Date(1520491871000)/" = GMT: Thursday, March 8, 2018 6:51:11 AM
Schema
The schema is this one:
- GLTransHeader
- → BookPeriod
- → Journal
- → PayCode
- GLTransactions (List of OM.Accounting.GLTrans)
- → BookPeriod (the same as in the header, it's repeated to improve the performances of some queries)
- → Currency
- → GLAccount
- → Supplier
- → Customer
- → Vat
- → GLTrans (parent GLTrans in case of subtransactions for the difference of payment or the VAT in the financial and misc.op.)
- → GLMatch
OM
GLTransHeader
Type: OM.Accounting.GLTransHeader
Property | Type | Foreigner Id | Friendly code property | Comment |
---|---|---|---|---|
BookPeriod | OM.Accounting.BookPeriod | BookPeriod_Id | Book period (month) of the booking | |
Journal | OM.Accounting.Journal | Journal_Id | JournalCode | |
PayCode | OM.Accounting.PayCode | PayCode_Id | PayCodeCode | Payment delay (30 days, ...) |
GLTransactions | List of OM.Accounting.GLTrans | see here under | ||
DocNumber | long | Number of the doc in the journal. This number can be reinitialized every fiscal year or every book period, depending on the settings of the folder. | ||
BookDate | DateTime | Date of the document | ||
DueDate | DateTime? | Due date for the payment (sales & purchase invoices) | ||
IsLocked | bool | The booking is locked by and for the accountant level and cannot be modified anymore. | ||
IsImported | bool | The booking was imported from another software | ||
bool | ||||
IsChecked | bool | The booking is locked by and for the input profile and can only be modified by the accountant profile or higher (administrator). | ||
IsDoc | bool | There is a document (pdf, jpeg, ...) attached to the invoice | ||
bool | ||||
Memo | string | Note attached to the document | ||
MemoType | short | 0 - None 1 - Green 5 - Yellow 9 - Red | ||
Reference | ||||
PaymentStatus | short? | null - None | ||
CommentPayment | Note for the payment status |
GLTrans
Type: OM.Accounting.GLTrans
Property | Type | Foreigner Id | Friendly code property | Comment |
---|---|---|---|---|
GLTransHeader | OM.Accounting.GLTransHeader | GLTransHeader_Id | ||
BookPeriod | OM.Accounting.BookPeriod | BookPeriod_Id | Same as GLTransHeader.BookPeriod | |
Currency | OM.Currency | Currency_Id | CurrencyCode | |
GLAccount | OM.Accounting.GLAccount | GLAccount_Id | GLAccountCode | |
GLAccount2 | OM.Accounting.GLAccount | GLAccount2_Id | GLAccount2Code | |
CentralAccountType | OM.Accounting.CentralAccountType | CentralAccountType_Id | CentralAccountTypeCode | Same as GLAccount.CentralAccountType at the time of the booking |
Vat | OM.Accounting.Vat | Vat_Id | VatCode | |
DeductibilityRate | OM.Accounting.DeductibilityRate | DeductibilityRate_Id | DeductibilityRateCode | |
Customer | OM.Customer | Customer_Id | CustomerCode | |
Supplier | OM.Supplier | Supplier_Id | SupplierCode | |
GLTrans | OM.Accounting.GLTrans | GLTrans_Id | ||
GLMatch | OM.Accounting.GLMatch | GLMatch_Id | GLMacthCode | |
CodaTransaction | OM.Accounting.CodaTransaction | CodaTransaction_Id | ||
VatPeriod | OM.Accounting.BookPeriod | VatPeriod_Id | ||
LineOrder | int | |||
ValueDate | DateTime | |||
Amount | decimal | |||
Amount2 | decimal? | |||
VatBaseAmount | decimal? | |||
TurnOverAmount | decimal? | |||
VatTaxAmount | decimal? | |||
IsNegativeBooking | bool | |||
IsVatInputByUser | bool | |||
IsVatAllocation | bool | |||
OldestMatchedDate | DateTime? | |||
CurrencyAmount | decimal? | |||
CurrencyRate | decimal? | |||
CurrencyVatBaseAmount | decimal? | |||
CurrencyVatTaxAmount | decimal? | |||
CommentBooking | string | |||
CommentBooking2 | string | |||
CommentExternal | string | |||
Reference | string | |||
BankStatementReference | string | |||
VatDate | DateTime? | |||
VatEvent | short | UnKnown Delivery Payment | ||
IsNegativeBooking | bool | |||
IsVatInputByUser | bool | |||
IsVatAllocation | bool | |||
IsCoda | bool |