{"id":1927,"date":"2014-07-11T10:38:58","date_gmt":"2014-07-11T09:38:58","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1927&lang=en"},"modified":"2020-07-30T13:56:01","modified_gmt":"2020-07-30T12:56:01","slug":"gl-movement","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1927","title":{"rendered":"GL Movement"},"content":{"rendered":"

General ledger movement:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;EntryNumber;GLMovType;GLMovDate;CD;GLMovementCurrency;CurrencyRate;CyAmount;Amount;
\nGLAccountNumber;Description;VATCode;VATRate;BankStatment;BankAccountNumber;CyVATValue;VATValue;PLCenterCode;
\nLineNumber<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of transaction to import<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy<\/td>\n<\/tr>\n
3<\/td>\nRef<\/span><\/td>\nChar(255)<\/td>\nUnique Reference by accounting entry<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nDescription which can be used in the entry editor used to validate entries<\/td>\n<\/tr>\n
5<\/td>\nEntryNumber<\/span><\/td>\nLong<\/td>\nEntry number<\/td>\n<\/tr>\n
6<\/td>\nGLMovType<\/span><\/td>\nLong<\/td>\nGL Movement type<\/td>\n<\/tr>\n
7<\/td>\nGLMovDate<\/span><\/td>\nDate\/Time<\/td>\nDate of the entry
\n(YYYYMMDD)<\/td>\n<\/tr>\n
8<\/td>\n‘C D’<\/span><\/td>\nChar(1)<\/td>\nD for Debit \/ C for Credit<\/td>\n<\/tr>\n
9<\/td>\nGLMovementCurrency<\/span><\/td>\nChar(10)<\/td>\nTransaction currency<\/td>\n<\/tr>\n
10<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate (not mandatory if amount is provided)<\/td>\n<\/tr>\n
11<\/td>\nCyAmount<\/span><\/td>\nDouble<\/td>\nAmount in transaction currency<\/td>\n<\/tr>\n
12<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount in capital currency<\/td>\n<\/tr>\n
13<\/td>\nGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nAccount Number [*]<\/td>\n<\/tr>\n
14<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription of the accounting entry<\/td>\n<\/tr>\n
15<\/td>\nVATCode<\/span><\/td>\nChar(20)<\/td>\nBlank if no VAT
\nVAT code if VAT (must match VAT code in DeMaSy)<\/td>\n<\/tr>\n
16<\/td>\nVATRate<\/span><\/td>\nDouble<\/td>\nVAT rate (0 if no VAT or rate if VAT)<\/td>\n<\/tr>\n
17<\/td>\nBankStatment<\/span><\/td>\nLong<\/td>\nBank statement number if accounting entry on a bank otherwise 0<\/td>\n<\/tr>\n
18<\/td>\nBankAccountNumber<\/span><\/td>\nChar(50)<\/td>\nBank account number if entry on a bank account [*]<\/td>\n<\/tr>\n
19<\/td>\nCyVATValue<\/span><\/td>\nDouble<\/td>\nVAT Value in transaction currency<\/td>\n<\/tr>\n
20<\/td>\nVATValue<\/span><\/td>\nDouble<\/td>\nVAT Value in capital currency<\/td>\n<\/tr>\n
21<\/td>\nPLCenterCode<\/span><\/td>\nChar(50)<\/td>\nProfit and Loss Center (must match in DeMaSy)<\/td>\n<\/tr>\n
22<\/td>\nLineNumber<\/span><\/td>\nLong<\/td>\nLine of the entry<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains information of miscellaneous accounting entries.
\nAn accounting entry will always consist of a minimum of one debit and one credit records.<\/p>\n

In order to ensure these operations will be properly dealt with, it is required to either:
\n– Provide DeMaSy with debit and credit account numbers.
\n– Assign each possible operation a code allowing to setup account keys (to be evaluated separately)<\/p>\n

[*] In DeMaSy there is a link between an account of the chart of account and a bank account.
\nOne must have one or the other.<\/p>\n","protected":false},"excerpt":{"rendered":"

General ledger movement: RecordType;DBId;Ref;Desc;EntryNumber;GLMovType;GLMovDate;CD;GLMovementCurrency;CurrencyRate;CyAmount;Amount; GLAccountNumber;Description;VATCode;VATRate;BankStatment;BankAccountNumber;CyVATValue;VATValue;PLCenterCode; LineNumber Nr Name Type Description 1 RecordType Long Type of transaction to import 2 DBId Long Database ID in DeMaSy 3 Ref Char(255) Unique Reference by accounting entry 4 Desc Char(255) Description which can be used in the entry editor used to validate entries 5 EntryNumber Long Entry number 6 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1927","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1927"}],"version-history":[{"count":23,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1927\/revisions"}],"predecessor-version":[{"id":9329,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1927\/revisions\/9329"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}