03333 445950

 

                                

 

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


SOP_ITEM
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
ADD_DISC_RATE Disc % 0 12 12 RightAlignment Y Y 4 -99.9999 99.9999 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9]{4}$ Extra discount rate 2.5575 Numeric 8ByteDouble OptionalUse > Additional discount percentage rate.
BASE_FULL_NET Full 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Net before discount 1000 Numeric 8ByteDouble OptionalUse > Item net value before any discounts.
BASE_NET Net 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Discounted net 1000 Numeric 8ByteDouble OptionalUse > Discounted item net value.
BASE_NETVALUE_DISCOUNT Net Disc 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\.0-9]*$ ^\+?[0-9]+\.[0-9][0-9]$ Net discount value 1000 Numeric 8ByteDouble OptionalUse > Base Net discount value.
BASE_TAX Tax 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Item Tax value 1000 Numeric 8ByteDouble OptionalUse > The Tax value for the item.
COMMENT_1 Comment 1 0 60 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Comment 1 Any Text Text String OptionalUse > A comment line.
COMMENT_2 Comment 2 0 60 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Comment 2 Any Text Text String OptionalUse > A comment line.
DELIVERY_DATE Delivery 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})?)$ Delivery Date 2451158 JulianDateNumber Date OptionalUse > The delivery date associated with this document or item.
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.
DESCRIPTION Description 0 60 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Product description A Sample Product Name Text String OptionalUse > The name of the product associated with this code.
DISCOUNT_RATE Disc % 0 12 12 RightAlignment Y Y 4 -99.9999 99.9999 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9]{4}$ Discount rate 25 Numeric 8ByteDouble OptionalUse > Scheme based discount percentage rate.
DUE_DATE Due 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})?)$ Due Date 2451158 JulianDateNumber Date OptionalUse > The due date associated with this item.
EXT_ORDER_REF Ext Ord Ref 0 30 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ External ref Any Text Text String OptionalUse > External ref for SOP to INV Link.
EXT_ORDER_LINE_REF Ext Ord Line Ref 0 7 10 RightAlignment Y Y 0 0 9999999 ^[0-9]*$ ^[0-9]*$ External line ref 21 Text 4ByteInt OptionalUse > External line ref for SOP to INV Link.
FULL_NET_AMOUNT Full 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Net before discount 1000 Numeric 8ByteDouble OptionalUse > Item net value before any discounts.
INVOICE_NUMBER Invoice No. 0 7 10 RightAlignment Y Y 0 0 9999999 ^[0-9]*$ ^[0-9]*$ Invoice Number 21 Text 4ByteInt OptionalUse > The number of the invoice.
ITEM_NUMBER Item No 0 7 7 RightAlignment N N 0 0 9999999 ^[0-9]*$ ^[0-9]*$ Item Number 1 Numeric 2ByteInt SpecialUse primary="Y" > The number of this item within the current document
ITEMID Item ID 0 7 10 RightAlignment Y Y 0 0 9999999 ^[0-9]*$ ^[0-9]*$ Unique item identifier 21 Numeric 4ByteInt OptionalUse > Unique Identifier, unaffected by file maintenance routines (new v2008/v14).
JOB_REFERENCE Job Reference 0 20 20 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Job Costing reference Any Text Text String OptionalUse > A Job Costing reference
NET_AMOUNT Net 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Discounted net 1000 Numeric 8ByteDouble OptionalUse > Discounted item net value.
NETVALUE_DISCOUNT Net Disc 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\.0-9]*$ ^\+?[0-9]+\.[0-9][0-9]$ Net discount value 1000 Numeric 8ByteDouble OptionalUse > Net discount value.
NEXT_ITEM Next Item 0 10 10 RightAlignment Y Y 0 0 999999999 ^[0-9]*$ ^[0-9]*$ Next Item Pos. 21 0 Numeric 4ByteInt SpecialUse > Position of next item on invoice.
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 item nominal code.
PROJECT_ID Project ID 0 7 10 RightAlignment Y Y 0 0 9999999 ^[0-9]*$ ^[0-9]*$ Project ID 21 Numeric 4ByteInt OptionalUse > The Project ID (new v2008/v14).
QTY_ALLOCATED Allocated Qty 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ The item allocated quantity 1000 ExtNumeric 8ByteDouble OptionalUse > <validentry>stockqty</validentry> The quantity currently allocated for this item.
QTY_DELIVERED Delivered Qty 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ The delivered item quantity 1000 ExtNumeric 8ByteDouble OptionalUse > <validentry>stockqty</validentry> The delivered quantity associated with this item.
QTY_DESPATCH Despatch Qty 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ The pending despatch item quantity 1000 ExtNumeric 8ByteDouble OptionalUse > <validentry>stockqty</validentry> The quantity to despatch or despatched on the current delivery associated with this item.
QTY_ORDER Order Qty 0 12 12 RightAlignment Y Y 2 0 1000000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ The item quantity 1000 ExtNumeric 8ByteDouble OptionalUse > <validentry>stockqty</validentry> The quantity associated with this item.
SERVICE_FLAG Service 0 1 1 LeftAlignment N N 0 0 2 ^[0-9]*$ ^[0-9]$ Item type code 1 Numeric 2ByteInt OptionalUse > Invoice item type code.
STOCK_CODE Product Code 0 30 20 LeftAlignment Y Y 0 0 0 ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ ^[A-Z0-9#_/!%&amp;\.\-\$\(\)\042\054&apos;]*$ Product identifier A-WIDGET-CODE Text String RequiredUse > The stock code for the invoice item.
TAX_AMOUNT Tax 0 12 12 RightAlignment Y Y 2 -99999999.99 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.
TAX_RATE Tax Rate 0 12 12 RightAlignment Y Y 2 -99999999.99 1000000000 ^[\.0-9]*$ ^[0-9]+\.[0-9]+$ Tax rate percentage 17.5 Numeric 8ByteDouble OptionalUse > The Tax Rate for the item.
TEXT Service Text 0 4096 30 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Text for a service item A Service Summary Text String OptionalUse > The text for a service item.
UNIT_OF_SALE Unit of Sale 0 8 8 LeftAlignment N N 0 0 0 ^.*$ ^.*$ Unit of Sale Units Text String OptionalUse > The unit of sale for this product.
UNIT_PRICE Unit Price 0 12 12 RightAlignment Y Y 2 -9999999.999 100000000 ^[\+\-\.0-9]*$ ^[\+\-]?[0-9]+\.[0-9][0-9]$ Item Unit Price 1000 0 ExtNumeric 8ByteDouble OptionalUse > <validentry>unitprice</validentry> The unit price for this item
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 item is attached to. </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