03333 445950

 

                                

 

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


AUDIT_SPLIT
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
AMOUNT_PAID Amount Paid 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Amount paid 5 Numeric 8ByteDouble OptionalUse > Amount paid.
BANK_FLAG Bank_flag 0 1 1 LeftAlignment N N 0 0 1 ^.*$ ^.*$ Bank_flag 0 Numeric 1ByteInt ReservedUse > Bank_flag
DATE Date 0 10 10 LeftAlignment N N 0 2440588 2488069 ^[0-9 /]*$ ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ Transaction Date 2451158 JulianDateNumber Date RequiredUse > The transaction date.
DELETED_FLAG Deleted_flag 0 1 1 LeftAlignment N N 0 0 1 ^.*$ ^.*$ Deleted_flag 0 Numeric 1ByteInt ReservedUse > Deleted_flag
DEPT_NUMBER Dept 0 3 3 RightAlignment N N 0 0 999 ^[0-9]*$ ^[0-9][0-9]?[0-9]?$ Item department 100 0 Numeric 2ByteInt OptionalUse > The department for item anaylsis.
DETAILS Details 0 60 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Transaction details A sale Text String OptionalUse > A text description for the transaction.
DOCTOR_LINK DOCTOR_LINK 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ DOCTOR_LINK Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of DOCTOR_LINK.
FIRST_USAGE FIRST_USAGE 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ FIRST_USAGE Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of FIRST_USAGE.
FOREIGN_AMOUNT_PAID Foreign Amount Paid 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Foreign amount paid 5 Numeric 8ByteDouble OptionalUse > Foreign Amount paid.
FOREIGN_NET_AMOUNT Foreign Net Amount 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Foreign net Amount 5 Numeric 8ByteDouble OptionalUse > Foreign Net Amount.
FOREIGN_TAX_AMOUNT Foreign Tax Amount 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Foreign tax Amount 5 Numeric 8ByteDouble OptionalUse > Foreign Tax Amount.
HEADER_NUMBER HEADER_NUMBER 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ HEADER_NUMBER Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of HEADER_NUMBER.
INTERNAL_REF Ex. Ref 0 30 15 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Transaction Ex. Ref A sale Text String OptionalUse > The extra reference
LAST_USAGE LAST_USAGE 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ LAST_USAGE Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of LAST_USAGE.
NET_AMOUNT NET_AMOUNT 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Net_amount 5 Numeric 8ByteDouble OptionalUse > Net_amount.
NEXT_NOMINAL NEXT_NOMINAL 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ NEXT_NOMINAL Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of NEXT_NOMINAL.
NEXT_SPLIT NEXT_SPLIT 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ NEXT_SPLIT Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of NEXT_SPLIT.
NUMBER_OF_USAGE NUMBER_OF_USAGE 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ NUMBER_OF_USAGE 21 0 Numeric 4ByteInt SpecialUse > NUMBER_OF_USAGE
NOMINAL_CODE N/C 4 8 8 LeftAlignment Y Y 0 0 0 ^[0-9]*$ ^[0-9]*$ Nominal account code 0 Text String OptionalUse > The nominal code.
PAID_FLAG Paid_flag 0 1 1 LeftAlignment N N 0 0 1 ^.*$ ^.*$ Paid_flag 0 Numeric 1ByteInt ReservedUse > Paid_flag
POSTED_DATE POSTED_DATE 0 10 10 LeftAlignment N N 0 2440588 2488069 ^[0-9 /]*$ ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ Transaction POSTED_DATE 2451158 JulianDateNumber Date RequiredUse > The transaction POSTED_DATE.
PREV_NOMINAL PREV_NOMINAL 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ PREV_NOMINAL Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of PREV_NOMINAL.
PREV_SPLIT PREV_SPLIT 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ PREV_SPLIT Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of PREV_SPLIT.
STATUS Status 0 3 3 RightAlignment N N 0 0 999 ^[0-9]*$ ^[0-9][0-9]?[0-9]?$ Item status 100 0 Numeric 2ByteInt OptionalUse > The status for item anaylsis.
TAX_AMOUNT Tax 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Item Tax value 1000 Numeric 8ByteDouble OptionalUse > The Tax value for the item.
TAX_CODE Tax Code T 0 3 3 LeftAlignment N N 0 0 99 ^[0-9]*$ ^[1-9]?[0-9]$ Tax code 1 Numeric 2ByteInt OptionalUse > The item tax code.
TRAN_NUMBER Tran No. 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ Unique Transaction Number 21 0 Numeric 4ByteInt SpecialUse > A system generated Unique Transaction Number.
TYPE Type 0 3 2 LeftAlignment N N 0 0 25 ^[A-Z]*$ ^[A-Z]?[A-Z]?[A-Z]$ Transaction type code 1 Enumerated 2ByteInt OptionalUse > <validentry>UN</validentry> <validentry>SI</validentry> <validentry>SC</validentry> <validentry>SR</validentry> <validentry>SA</validentry> <validentry>SD</validentry> <validentry>PI</validentry> <validentry>PC</validentry> <validentry>PP</validentry> <validentry>PA</validentry> <validentry>PD</validentry> <validentry>BP</validentry> <validentry>BR</validentry> <validentry>CP</validentry> <validentry>CR</validentry> <validentry>JD</validentry> <validentry>JC</validentry> <validentry>VP</validentry> <validentry>VR</validentry> <validentry>CC</validentry> <validentry>CD</validentry> <validentry>PAI</validentry> <validentry>PAO</validentry> <validentry>CO</validentry> <validentry>SP</validentry> <validentry>PR</validentry> Type code for the transaction.
UNIQUE_REF UNIQUE_REF 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ UNIQUE_REF 21 0 Numeric 4ByteInt SpecialUse > UNIQUE_REF.
USER_NAME User 0 32 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ user name A sale Text String OptionalUse > User name.
VAT_FLAG VAT_FLAG 0 1 1 LeftAlignment N N 0 0 1 ^.*$ ^.*$ VAT_FLAG 0 Numeric 1ByteInt ReservedUse > VAT reconciliation flag
VAT_RECONCILED_DATE VAT_RECONCILED_DATE 0 10 10 LeftAlignment N N 0 2440588 2488069 ^[0-9 /]*$ ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ Transaction VAT_RECONCILED_DATE 2451158 JulianDateNumber Date OptionalUse > Date of VAT Reconciliation
RecordNumber RecordNumber 0 10 10 0 RightAlignment N N 0 0 2147483647 ^[0-9]*$ ^[0-9]*$ Record number 12 PaddedNumeric None SpecialUse primary="Y" > The record number. A pseudo primary index.
Project Project 0 8 8 LeftAlignment Y Y 0 0 0 ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ Project Reference SKYEWR01 Text String OptionalUse > The reference a Project that the split is attached to.
ProjectCostCode Cost Code 0 8 8 LeftAlignment Y Y 0 0 0 ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ Project CostCode LAB Text String OptionalUse > The reference a ProjectCostCode that the split is associated with. </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