03333 445950

 

                                

 

Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.


PURCHASE_LEDGER_MEMO
Name Label Prefix Postfix Minlength Maxlength Widthhint Padding Alignment Casesensitive Allcaps Dp Minvalue Maxvalue Validchars Validformat Tooltip Sample Default Nature Storage Usage Primary Key Details
ACCOUNT_REF A/C 0 8 8 LeftAlignment Y Y 0 0 0 ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ Account Reference SKYEWR01 Text String SpecialUse primary="Y" > The account reference for the account, usually used to identify and sequence accounts.<br>Valid references consist of uppercase letters or numbers or both. As well as letters and numbers you may use <strong>-_</strong> and <strong>&</strong>. Spaces are not allowed.Numbers sort before letters, so ACC9 appears before ACCA.
TEXT Memo Text 0 32768 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Memo text Some memo notes Text String OptionalUse > Memo text
RecordNumber RecordNumber 0 10 10 0 RightAlignment N N 0 0 2147483647 ^[0-9]*$ ^[0-9]*$ Record number 12 PaddedNumeric None SpecialUse > The record number. </header> </sydd>
 


Accounting, Pay as you go Sage 50 Support, Excel Reports, Sage Reports, Sage 50 3rd Party integration and more!

This Sage 50 import website is copyright Making I.T. Happen 2022