You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


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

PropertyTypeForeigner IdFriendly code propertyComment
BookPeriodOM.Accounting.BookPeriodBookPeriod_Id
Book period (month) of the booking
JournalOM.Accounting.JournalJournal_IdJournalCode
PayCodeOM.Accounting.PayCodePayCode_IdPayCodeCodePayment delay (30 days, ...)
GLTransactionsList of OM.Accounting.GLTrans

see here under
DocNumberlong

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.
BookDateDateTime

Date of the document
DueDateDateTime?

Due date for the payment (sales & purchase invoices)
IsLockedbool

The booking is locked by and for the accountant level and cannot be modified anymore.
IsImportedbool

The booking was imported from another software
IsTempbool

The booking is a temporary one for simulation
IsCheckedbool

The booking is locked by and for the input profile and can only be modified by the accountant profile or higher (administrator).
IsDocbool

There is a document (pdf, jpeg, ...) attached to the invoice
IsVatCompletelyDeclaredbool


VatStatus



Memostring

Note attached to the document
MemoTypeshort

0 - None
1 - Green
5 - Yellow
9 - Red
Reference



PaymentStatusshort?

null - None
1 - Block
2 - Approved
3 - Paid

CommentPayment


Note for the payment status


GLTrans

Type: OM.Accounting.GLTrans

PropertyTypeForeigner IdFriendly code propertyComment
GLTransHeaderOM.Accounting.GLTransHeaderGLTransHeader_Id

BookPeriodOM.Accounting.BookPeriodBookPeriod_Id
Same as GLTransHeader.BookPeriod
CurrencyOM.CurrencyCurrency_IdCurrencyCode
GLAccountOM.Accounting.GLAccountGLAccount_IdGLAccountCode
GLAccount2OM.Accounting.GLAccountGLAccount2_IdGLAccount2Code
CentralAccountTypeOM.Accounting.CentralAccountTypeCentralAccountType_IdCentralAccountTypeCodeSame as GLAccount.CentralAccountType at the time of the booking
VatOM.Accounting.VatVat_IdVatCode
DeductibilityRateOM.Accounting.DeductibilityRateDeductibilityRate_IdDeductibilityRateCode
CustomerOM.CustomerCustomer_IdCustomerCode
SupplierOM.SupplierSupplier_IdSupplierCode
GLTransOM.Accounting.GLTransGLTrans_Id

GLMatchOM.Accounting.GLMatchGLMatch_IdGLMacthCode
CodaTransactionOM.Accounting.CodaTransactionCodaTransaction_Id

VatPeriodOM.Accounting.BookPeriodVatPeriod_Id

LineOrderint


ValueDateDateTime


Amountdecimal


Amount2decimal?


VatBaseAmountdecimal?


TurnOverAmountdecimal?


VatTaxAmountdecimal?


IsNegativeBookingbool


IsVatInputByUserbool


IsVatAllocationbool


OldestMatchedDateDateTime?


CurrencyAmountdecimal?


CurrencyRatedecimal?


CurrencyVatBaseAmountdecimal?


CurrencyVatTaxAmountdecimal?


CommentBookingstring


CommentBooking2string


CommentExternalstring


Referencestring


BankStatementReferencestring


VatDateDateTime?


VatEventshort

UnKnown
Delivery
Payment
IsNegativeBookingbool


IsVatInputByUserbool


IsVatAllocationbool


IsCodabool




  • No labels