DPU: Data Tables - Ice Ledger

Data Tables

List of Tables

Table	Description
sl	Sales Ledger - Customer Details
inv	Sales Invoices - Header Details
inv_itm	Sales Invoices - Items Details
pl	Purchase Ledger - Supplier Details
stk	Stock Records / Details

Table	Field	Description
access	dttm	Date and time when the record was updated.I.e. user logged on / off
access	id	User Access Privileges, record ID
access	ip	Workstation IP address
access	mod	List of access to different system modules / options
access	online	Is the user currently logged in
access	pwd	User login password or password hash value
access	stn	Workstation ID that the user is conencted on
access	usr	User Login Name - not case sensitive
adrbook	accref	Company (blank) / Customer / Supplier Account reference
adrbook	adr_desc	User description: Accounts, HQ, Northern Office etc..
adrbook	adr_nm	Company / Delivery Address Company Name
adrbook	adr1	Address Line 1
adrbook	adr2	Address Line 2
adrbook	adr3	Address Line 3
adrbook	adr4	Address Line 4
adrbook	adr5	Address Line 5
adrbook	adrn	Address number, 1+
adrbook	adrty	Record Type, 0=Company, 1=Customer, 2=Supplier
adrbook	adrty	Address Type. 0=Delivery, 1=Contact, 2=Registered
adrbook	ccd	Country Code
adrbook	cnt_nm	Contact Name
adrbook	cnt_role	Contact Role / Job Title
adrbook	created	Date and time when the record was created.
adrbook	e_mail	E-mail Address
adrbook	f_del	Flag denoting if the record has been deleted or not.
adrbook	fax	Fax Number
adrbook	modified	Date and time when the record was modified.
adrbook	notes	Notes
adrbook	strref	String account reference: Company (blank) / Customer / Supplier
adrbook	taxcd	Tax code
adrbook	tel	Telephone Number
adrbook	tel2	Other Telephone Number
adrbook	vat_reg_no	Vat Registration number
au	ac_gross	Gross amount in alternative currency (Euros)
au	ac_rate	Euro exchange rate
au	accref	Sales/Purchase/Bank Account Reference
au	amtpaid	Total amount paid (allocated against invoice/credit)
au	bnk_amt	Gross amount (signed for use in bank statements)
au	bnk_cd	Bank Account Reference
au	bnk_nm	Bank Account Name
au	bnk_rec_dt	Bank Reconciliation date
au	created	Date and time when the record was created.
au	curr_id	Foreign currency ID
au	dt	Transaction date
au	dtls	Details
au	duedt	Due date
au	f_del	Flag denoting if the record has been deleted or not.
au	f_paid	Transaction paid flag - y/n
au	frgn_amtpaid	Total amount paid in foreign currency (allocated against invoice/credit)
au	frgn_bnk_amt	Gross amount in foreign currency (signed for use in bank statements)
au	frgn_gross	Gross amount in foreign currency (signed according to transaction type)
au	frgn_net	Net amount in foreign currency (signed according to transaction type)
au	frgn_rate	Foreign currency exchange rate
au	frgn_tax	Tax amount in foreign currency (signed according to transaction type)
au	gross	Gross amount (signed according to transaction type)
au	id	Transaction number
au	idlive	Transaction number 2 (for live transactions, idlive = id, for completed transactions idlive = -id)
au	inv_ref	Invoice Reference Number
au	inv_ref_n	Invoice number
au	itm	No of items recorded in table auitm
au	left	Amount outstanding (against invoice/credit)
au	modified	Date and time when the record was modified.
au	net	Net amount (signed according to transaction type)
au	pmt	Amount paid (as Sales Receipt/Purchase Payment/Payment on Account)
au	s_paid	Transaction disputed/paid status - /p/d/dp
au	tax_amt	Tax amount (signed according to transaction type)
au	ty	Transaction type
au	usr	User name
auitm	accref	Sales/Purchase/Bank Account Reference
auitm	amtpaid	Total amount paid
auitm	auid	Parent table ID, au.id
auitm	bnk_cd	Bank Account Reference
auitm	created	Date and time when the record was created.
auitm	currcd	Currency code
auitm	dtls	Details
auitm	f_del	Flag denoting if the record has been deleted or not.
auitm	f_paid	Transaction paid flag - y/n
auitm	fc_gross	Gross amount in foreign currency (signed according to transaction type)
auitm	fc_net	Net amount in foreign currency (signed according to transaction type)
auitm	fc_tax	Tax amount in foreign currency (signed according to transaction type)
auitm	gross	Gross amount (signed according to transaction type)
auitm	id	Audit transaction items record ID
auitm	itmref	Item specific short reference
auitm	left	Amount outstanding (against invoice/credit)
auitm	modified	Date and time when the record was modified.
auitm	ncd	Nominal Code
auitm	net	Net amount (signed according to transaction type)
auitm	pmt	Amount paid (as Sales Receipt/Purchase Payment)
auitm	tax_amt	Tax amount (signed according to transaction type)
auitm	taxcd	Tax code (T0 to T99)
auitm	ty	Transaction type
auitm	xref	Cross reference ID of related item in this table, auitm.id
bins	batch	Batch reference
bins	docrefs	Comma delimited list of accompanying document references e.g. test certificates
bins	docs	List of relative path names of document, stored on the system, 1 per line
bins	grn	Goods received note record ID
bins	id	Item received storage bins / locations
bins	l1	Location / storage area 1
bins	l2	Location / storage area 2
bins	l3	Location / storage area 3
bins	l4	Location / storage area 4
bins	po	Purchase order ID
bins	q_alo	Quantity Allocated
bins	q_des	Quantity dispatched
bins	q_sto	Quantity stored in the bin / location
bins	stk	Stock code reference
cacheupd	id	Cache Update, record ID
cacheupd	info	Comments
cacheupd	modified	Timestamp of when the data affected by this query was last modified
cacheupd	ref	Query name / reference
cfg	ac_adr1	Accountant address line 1
cfg	ac_adr2	Accountant address line 2
cfg	ac_adr3	Accountant address line 3
cfg	ac_adr4	Accountant address line 4
cfg	ac_adr5	Accountant address line 5
cfg	ac_ccd	Country Code
cfg	ac_cnt	Contact Name / Accountant
cfg	ac_e_mail	Accountant email address
cfg	ac_edi	Accountant's EDI reference string
cfg	ac_fax	Accountant fax number
cfg	ac_in	Folder pathname for importing data from accountant
cfg	ac_nm	Accountant Company Name
cfg	ac_out	Folder pathname for exporting data for sending to accountant
cfg	ac_tel	Accountant telephone number
cfg	ac_url	Accountant web address
cfg	adr1	Company Address Line1
cfg	adr2	Company Address Line2
cfg	adr3	Company Address Line3
cfg	adr4	Company Address Line4
cfg	adr5	Company Address Line5
cfg	b_eor	End of report banner
cfg	bugt_m	Method of budgeting
cfg	ccd	Country Code
cfg	cnt	Contact Name
cfg	co_logo	Company logo file for use in printing documents with company logo
cfg	conm	Company Name
cfg	cr_ref	Credit Reference Number
cfg	created	Date and time when the record was created.
cfg	dadr1	Delivery Address Line1
cfg	dadr2	Delivery Address Line2
cfg	dadr3	Delivery Address Line3
cfg	dadr4	Delivery Address Line4
cfg	dadr5	Delivery Address Line5
cfg	def_bugt_chart	Default chart of accounts used for budgeting
cfg	def_chart	Default Chart of Accounts
cfg	del_ccd	Delivery Country Code
cfg	del_cnt	Delivery Address Company Name
cfg	del_e_mail	Delivery E-Mail Address
cfg	del_fax	Delivery Fax Number
cfg	del_nm	Delivery Address Company Name
cfg	del_role	Job Title / Role
cfg	del_tel	Delivery Telephone Number
cfg	del_tel2	Delivery Telephone Number 2
cfg	del_url	Delivery World Wide Web Address
cfg	duns_no	DUNS Number
cfg	e_mail	E-Mail Address
cfg	f_agebymth	Use Calendar Month Aged Periods
cfg	f_del	Flag denoting if the record has been deleted or not.
cfg	f_q2ord	Flag denoting if quotes are to be converted to Sales Orders.
cfg	f_till_inctax	Cash register tax inclusive flag
cfg	fax	Fax Number
cfg	fin_yr	Current Financial Year
cfg	id	Company Configurations
cfg	inv_crdno	Use Invoice numbering for Credit Notes
cfg	letr1	Default layout for Reminder Letter
cfg	letr2	Default layout for Warning Letter
cfg	letr3	Default layout for Legal Letter
cfg	modified	Date and time when the record was modified.
cfg	ncd_endpmt	Accruals Control Account
cfg	ncd_temp	Suspense Control Account
cfg	ncdbad_debts	Bad Debts Control Account
cfg	ncdcrdchrg	Credit Charges Control Account
cfg	ncdcrdors	Creditors Control Account
cfg	ncddebtors	Debtors Control Account
cfg	ncddef_bnk	Default Bank Control Account
cfg	ncddef_sales	Default Sales Control Account
cfg	ncddiscnt_buy	Purchase Discount Control Account
cfg	ncddiscnt_sales	Sales Discount Control Account
cfg	ncdkept_wages	Retained Earnings Control Account
cfg	ncdmisposts	Mispostings Control Account
cfg	ncdnlpp	Prepayments Control Account
cfg	ncdtax_buy	Purchase Tax Control Account
cfg	ncdtax_sales	Sales Tax Control Account
cfg	non_vat_taxcd	Default tax code for non-VAT transactions
cfg	nxt_crdno	Next Credit Note Number to be created
cfg	nxt_invno	Next Invoice number to be created
cfg	nxt_popno	Next POP number to be created
cfg	nxt_quoteno	Next quote number to be created
cfg	nxt_sopno	Next SOP number to be created
cfg	ok_negstk	Allow negative stock flag
cfg	pdf_inv	PDF Invoice Template
cfg	pdf_prn	Default PDF Printer
cfg	pmt_due_buy	Default Payment Due Days for Purchase
cfg	pmt_due_sales	Default Payment Due Days for Sales
cfg	puap1	Purchase Aged Period 1 (days)
cfg	puap2	Purchase Aged Period 2 (days)
cfg	puap3	Purchase Aged Period 3 (days)
cfg	puap4	Purchase Aged Period 4 (days)
cfg	qty_dp	Number of decimal places for product quantities
cfg	role	Job Title / Role
cfg	sa_add_disc1	Sales Additional Discount Percentage 1
cfg	sa_add_disc10	Sales Additional Discount Percentage 10
cfg	sa_add_disc2	Sales Additional Discount Percentage 2
cfg	sa_add_disc3	Sales Additional Discount Percentage 3
cfg	sa_add_disc4	Sales Additional Discount Percentage 4
cfg	sa_add_disc5	Sales Additional Discount Percentage 5
cfg	sa_add_disc6	Sales Additional Discount Percentage 6
cfg	sa_add_disc7	Sales Additional Discount Percentage 7
cfg	sa_add_disc8	Sales Additional Discount Percentage 8
cfg	sa_add_disc9	Sales Additional Discount Percentage 9
cfg	sa_age_by_month	Use Calendar Month Aged Periods
cfg	sa_aged_prd1	Sales Aged Period 1 (days)
cfg	sa_aged_prd2	Sales Aged Period 2 (days)
cfg	sa_aged_prd3	Sales Aged Period 3 (days)
cfg	sa_aged_prd4	Sales Aged Period 4 (days)
cfg	sa_amtsold1	Sales Amount for Discount 1
cfg	sa_amtsold10	Sales Amount for Discount 10
cfg	sa_amtsold2	Sales Amount for Discount 2
cfg	sa_amtsold3	Sales Amount for Discount 3
cfg	sa_amtsold4	Sales Amount for Discount 4
cfg	sa_amtsold5	Sales Amount for Discount 5
cfg	sa_amtsold6	Sales Amount for Discount 6
cfg	sa_amtsold7	Sales Amount for Discount 7
cfg	sa_amtsold8	Sales Amount for Discount 8
cfg	sa_amtsold9	Sales Amount for Discount 9
cfg	sl_disc1	Sales percentage discount for invoice amount >= discount level 1
cfg	sl_disc10	Sales percentage discount for invoice amount >= discount level 10
cfg	sl_disc2	Sales percentage discount for invoice amount >= discount level 2
cfg	sl_disc3	Sales percentage discount for invoice amount >= discount level 3
cfg	sl_disc4	Sales percentage discount for invoice amount >= discount level 4
cfg	sl_disc5	Sales percentage discount for invoice amount >= discount level 5
cfg	sl_disc6	Sales percentage discount for invoice amount >= discount level 6
cfg	sl_disc7	Sales percentage discount for invoice amount >= discount level 7
cfg	sl_disc8	Sales percentage discount for invoice amount >= discount level 8
cfg	sl_disc9	Sales percentage discount for invoice amount >= discount level 9
cfg	sl_invamt1	Sales Invoice amount to qualify for discount level 1
cfg	sl_invamt10	Sales Invoice amount to qualify for discount level 10
cfg	sl_invamt2	Sales Invoice amount to qualify for discount level 2
cfg	sl_invamt3	Sales Invoice amount to qualify for discount level 3
cfg	sl_invamt4	Sales Invoice amount to qualify for discount level 4
cfg	sl_invamt5	Sales Invoice amount to qualify for discount level 5
cfg	sl_invamt6	Sales Invoice amount to qualify for discount level 6
cfg	sl_invamt7	Sales Invoice amount to qualify for discount level 7
cfg	sl_invamt8	Sales Invoice amount to qualify for discount level 8
cfg	sl_invamt9	Sales Invoice amount to qualify for discount level 9
cfg	start_month	Start Month of Financial Year (1-12)
cfg	stkcat_label	Stock Category Label
cfg	tel	Telephone Number
cfg	tel2	Telephone Number 2
cfg	till_bnk	Cash register bank nominal
cfg	till_sa_ncd	Cash register sales nominal
cfg	till_short	Cash register discrepencies nominal
cfg	till_taxcd	Cash register tax code nominal
cfg	unit_dp	Number of decimal places for product units
cfg	url	World Wide Web Address
cfg	vat_cash	VAT Cash Accounting Flag
cfg	vat_reg_no	VAT Registration Number
cfg2	d	Decimal value / setting
cfg2	dtls	Short description for the record in question
cfg2	i	Integer value / setting
cfg2	id	2nd configuration table for specific values
cfg2	ref	Setting / configuration reference
cfg2	t	Text / string value / setting
cfg2	ty	Record type. N = Next number
cfgrt	id	Configurations for Run-Time, record ID
cfgrt	ke	Key reference / name
cfgrt	lstord	List order
cfgrt	notes	Comments / Notes
cfgrt	opts	Which options are user editable with precedence order; Number of fields; Field titles
cfgrt	ref	Reference: Workstation ID or User Login ID
cfgrt	ty	Configuration type, -1=Data specification, 0=Global, 1=User or 2=Workstation specific
cfgrt	vlu	Delimited string, containing all data / values
chqrun	amtpaid	Amount being paid towards the item
chqrun	bnknom	Bank account nominal code
chqrun	chqamt	Total cheque amount for all items that the cheque reffers to
chqrun	chqno	Cheque number
chqrun	chqrun	Cheque run number, generated automatically
chqrun	dtchq	Date on the cheque or the date of the cheque run
chqrun	dtpost	Date the this transaction was posted to the ledgers
chqrun	id	Cheque run record ID
chqrun	itmid	PI item ID, au_tr.id
chqrun	post	Payment posted flag. 0=No, 1=Yes
chqrun	prn	Cheque printed flag, 0=No, 1=Yes
chqrun	suref	Supplier account reference, pl.accref
colist	co_code	Company Database Name
colist	co_name	Company Name
colist	dttm	Date and time mode was set
colist	id	Company Master database, List of Companies, Record ID, 0 = Demo company
colist	mode	Mode: 0=OK, 1=New Login disabled, 2=Single User Mode
colist	msg	Details / descriptive message
colist	sec	Security / user login enabled (Y) or blank
colist	stn	Station ID that initiated mode set
colist	usr	User login ID that initiated mode set
con	coid	Selected company number / id
con	conm	Selected company name
con	dttm	Time stamp of when the record was last updated
con	id	Accounts master database, currently connected users list
con	sess	Session ID
con	sess	Workstation Session ID (1, 2, 3 etc..)
con	stn	Workstation ID that the user is conencting from
con	usr	User login ID
curr	bcur	Is the base currency
curr	cd	Currency code
curr	created	Date and time when the record was created.
curr	currsym	Currency symbol
curr	f_del	Flag denoting if the record has been deleted or not.
curr	in_emu	Is a member of the EMU
curr	maj_cu	Major currency unit
curr	min_cu	Minor currency unit
curr	modified	Date and time when the record was modified.
curr	nm	Currency name
curr	no	Currency number
curr	rate	Exchange Rate
fxd_asset	b_ntv	Net book value
fxd_asset	bs_ncd	Balance sheet nominal code
fxd_asset	buy_dt	Date of purchase
fxd_asset	buy_ref	Supplier / purchase reference
fxd_asset	cat	Category number
fxd_asset	cpr	Cost price
fxd_asset	created	Date and time when the record was created.
fxd_asset	dep_cd	Depreciation method code 1=Linear, 2=Reducing, 3=Written off
fxd_asset	dep_desc	Depreciation method description
fxd_asset	dep_last	Amount of last depreciation
fxd_asset	dep_nxt	Amount of next depreciation
fxd_asset	dep_rate	Depreciation rate
fxd_asset	dep_to_dt	Amount depreciated to date
fxd_asset	dept_nm	Department name
fxd_asset	deptno	Department number
fxd_asset	dtls1	Details 1
fxd_asset	dtls2	Details 2
fxd_asset	dtls3	Details 3
fxd_asset	f_del	Flag denoting if the record has been deleted or not.
fxd_asset	id	Fixed assets list record ID
fxd_asset	loc	Location / employee details that the asset is assigned to e.g. laptop
fxd_asset	modified	Date and time when the record was modified.
fxd_asset	pl_ncd	Profit and Loss nominal code
fxd_asset	ref	Fixed asset reference
fxd_asset	srlno	Serial number
fxd_asset	totmth	Total number of months that the depreciation have been applied
fxd_asset	valstart	Asset value at start of depreciation year
fxd_asset	vlu	Net asset value
gdn_itm	accref	Sales Account Reference
gdn_itm	created	Date and time when the record was created.
gdn_itm	cu_gdn	Customer's Goods Delivered Number
gdn_itm	dt	Date Goods Received
gdn_itm	f_del	Flag denoting if the record has been deleted or not.
gdn_itm	f_prn	Printed flag - 1/0
gdn_itm	gdn	Goods Despatch Note Number
gdn_itm	id	Goods despatch note record id
gdn_itm	info	Stock Description
gdn_itm	itm_no	Item number within Despatch Note
gdn_itm	modified	Date and time when the record was modified.
gdn_itm	ord_itm	Item number within Sales Order
gdn_itm	ordno	Sales Order Number
gdn_itm	qty_desped	Quantity Despatched
gdn_itm	qty_on_ord	Quantity on order
gdn_itm	stkcd	Stock Code
grn_itm	accref	Purchase Account Reference
grn_itm	created	Date and time when the record was created.
grn_itm	docs	List of documents, relative path name of files, 1 per line
grn_itm	dt	Date Goods Received
grn_itm	f_del	Flag denoting if the record has been deleted or not.
grn_itm	grn	GRN Number
grn_itm	id	Goods received note - items list
grn_itm	info	Stock Description
grn_itm	itm_no	Item number within GRN
grn_itm	modified	Date and time when the record was modified.
grn_itm	ord_itm	Item number within Purchase Order
grn_itm	ordno	Purchase Order Number
grn_itm	qty_on_ord	Quantity on order
grn_itm	qty_rcv	Quantity Received
grn_itm	stkcd	Stock Code
grn_itm	su_grn	Supplier's GRN Number
Back to Top \| Invoice Items Invoice Header Details
Table	Field	Description
inv	ac_gross	Gross amount in alternative currency (Euros)
inv	ac_rate	Alternative currency (Euro) exchange rate
inv	accref	Account reference
inv	adr1	Address line 1
inv	adr2	Address line 2
inv	adr3	Address line 3
inv	adr4	Address line 4
inv	adr5	Address line 5
inv	bnk_ref	Bank account used for payment
inv	carr_dept_nm	Carriage department name
inv	carr_deptno	Carriage department number
inv	carr_gross	Carriage gross amount (carriage net + carriage tax)
inv	carr_ncd	Carriage nominal code
inv	carr_net	Carriage net amount
inv	carr_tax	Carriage tax amount
inv	carr_taxcd	Carriage tax code (T0 to T99)
inv	cnt_nm	Contact name
inv	conm	Name
inv	created	Date and time when the record was created.
inv	cu_rdisc	Customer percentage discount rate
inv	cu_tel	Customer's telephone number
inv	curr	Which foreign currency
inv	curr_ty	Foreign or Euro currency
inv	cust_ordno	Customer's order number
inv	d_deptno	Global department number
inv	dadr1	Delivery address line 1
inv	dadr2	Delivery address line 2
inv	dadr3	Delivery address line 3
inv	dadr4	Delivery address line 4
inv	dadr5	Delivery address line 5
inv	del_nm	Delivery name
inv	delco_nm	Courier Name
inv	delco_no	Courier Number
inv	delref	Consignment Reference
inv	docnm	Invoice/Credit/Quote/Proforma label
inv	duns_no	DUNS Number
inv	eid	Event ID, events.id if this is a scheduled repeated invoice
inv	eseq	Event sequence number i.e. if repeated, repeat sequence number, 1 onwards
inv	f_del	Flag denoting if the record has been deleted or not.
inv	f_prn	Printed flag: o = No, 1 = Yes
inv	frgn_carr_gross	Carriage gross amount (carriage net + carriage tax) - foreign currency
inv	frgn_deltax	Carriage tax amount - foreign currency
inv	frgn_itmsgross	Gross amount (goods but not carriage) - foreign currency
inv	frgn_itmsnet	Net amount (goods but not carriage) - foreign currency
inv	frgn_itmstax	Tax amount (goods but not carriage) - foreign currency
inv	frgn_net	Carriage net amount - foreign currency
inv	frgn_prepaid	Amount prepaid - foreign currency
inv	frgn_rate	Foreign exchange rate
inv	frgn_stlm_disc	Settlement discount amount (reduction) - foreign currency
inv	frgn_stlm_tot	Invoice total after settlement discount - foreign currency
inv	frgninv_gross	Invoice gross amount (goods and carriage gross) - foreign currency
inv	frgninv_net	Invoice net amount (goods and carriage net) - foreign currency
inv	frgninv_tax	Invoice tax amount (goods and carriage tax) - foreign currency
inv	g_dept	Global department name
inv	g_dtls	Global details
inv	g_ncd	Global nominal code
inv	g_taxcd	Global tax code (T0 to T99)
inv	id	Sales Invoices, record ID. 0=Default settings for new records
inv	inv_dt	Invoice Date
inv	inv_gross	Invoice gross amount (goods and carriage gross)
inv	inv_net	Invoice net amount (goods and carriage net)
inv	inv_no	Invoice number
inv	inv_tax	Invoice tax amount (goods and carriage tax)
inv	inv_ty	Invoice type description
inv	inv_tycd	Invoice type code 1=Invoice, 2=Credit Note
inv	itmsgross	Gross amount (goods but not carriage)
inv	itmsnet	Net amount (goods but not carriage)
inv	itmstax	Tax amount (goods but not carriage)
inv	modified	Date and time when the record was modified.
inv	net1	Net amount at highest tax rate
inv	net2	Net amount at second highest tax rate
inv	net3	Net amount at third highest tax rate
inv	net4	Net amount at fourth highest tax rate
inv	net5	Net amount at fifth highest tax rate
inv	notes1	Notes 1
inv	notes2	Notes 2
inv	notes3	Notes 3
inv	ntvd_desc	Net value discount description
inv	ntvd_net	Net value discount value (foreign currency)
inv	ntvd_net_base	Net value discount (base currency)
inv	ntvd_note1	Net value discount comment 1
inv	ntvd_note2	Net value discount comment 2
inv	ntvd_rate	Net value discount percentage
inv	ordno	Corresponding order number
inv	pmt_ref	Payment reference
inv	pmt_ty	Payment Type: 0 - Already received. 3 - SR. 4 - SA.
inv	post	Posted flag - 1/0
inv	prepaid	Amount prepaid
inv	proj_id	ID of linked Project
inv	q_expdt	Quote expiry date
inv	recur_ref	Recurring entry reference
inv	s_quote	Quote status
inv	sid_quote	Quote status Id
inv	sop_dt	SOP Date
inv	sop_sid	SOP status Id
inv	sop_status	SOP status
inv	stlm_days	Settlement days
inv	stlm_disc	Settlement discount amount (reduction)
inv	stlm_discr	Settlement discount % rate
inv	stlm_tot	Invoice total after settlement discount
inv	tax_amt1	Tax amount at highest tax rate
inv	tax_amt2	Tax amount at second highest tax rate
inv	tax_amt3	Tax amount at third highest tax rate
inv	tax_amt4	Tax amount at fourth highest tax rate
inv	tax_amt5	Tax amount at fifth highest tax rate
inv	tax_rate1	Highest tax rate
inv	tax_rate2	Second highest tax rate
inv	tax_rate3	Third highest tax rate
inv	tax_rate4	Fourth highest tax rate
inv	tax_rate5	Fifth highest tax rate
inv	taxcd1	Tax code (T0 to T99)
inv	taxcd2	Tax code (T0 to T99)
inv	taxcd3	Tax code (T0 to T99)
inv	taxcd4	Tax code (T0 to T99)
inv	taxcd5	Tax code (T0 to T99)
inv	usr	Order taken by
inv	vlu_disc_rate	Value based discount rate
Back to Top \| Invoice Header Details Invoice Items Details
Table	Field	Description
inv_itm	created	Date and time when the record was created.
inv_itm	del_dt	Delivery date
inv_itm	dept_nm	Department name
inv_itm	deptno	Department number
inv_itm	disc_op	Percentage discount rate given by the operator
inv_itm	disc_qty	Quantity based percentage discount rate
inv_itm	discamt	Discount amount
inv_itm	ec_vat_info_id	The unique ID of the EC VAT Description applied to this item line
inv_itm	ext_ord_line_ref	External Order Line Ref for SOP to Invoice Link
inv_itm	ext_ord_ref	External Order Ref for SOP to Invoice Link
inv_itm	f_del	Flag denoting if the record has been deleted or not.
inv_itm	f_srv	Service invoice/credit flag
inv_itm	frgn_discamt	Discount amount - foreign currency
inv_itm	frgn_full_net	Full net amount (before discount) - foreign currency
inv_itm	frgn_gross	Gross amount (net after discount + tax) - foreign currency
inv_itm	frgn_net	Net amount (after discount) - foreign currency
inv_itm	frgn_tax	Tax amount - foreign currency
inv_itm	frgn_upr	Unit price - foreign currency
inv_itm	full_net	Full net amount (before discount)
inv_itm	gross	Gross amount (net after discount + tax)
inv_itm	id	Sales Invoice Items, record ID. 0=Default settings for new records
inv_itm	ii_desc	Description
inv_itm	inv_no	Invoice reference number
inv_itm	itm_no	Item number
inv_itm	itmid	Item ID
inv_itm	job_no	Job number
inv_itm	modified	Date and time when the record was modified.
inv_itm	ncd	Nominal code
inv_itm	negotiation_disc_net	Negotiation discount net (foreign currency)
inv_itm	negotiation_disc_net_base	Negotiation discount net (base currency)
inv_itm	net	Net amount (after discount)
inv_itm	note1	Comment 1
inv_itm	note2	Comment 2
inv_itm	param1	Customer specific item parameter 1 e.g. Length, height, width
inv_itm	param2	Customer specific item parameter 2 e.g. Length, height, width
inv_itm	param3	Customer specific item parameter 3 e.g. Length, height, width
inv_itm	param4	Customer specific item parameter 4 e.g. colour, texture, shape
inv_itm	param5	Customer specific item parameter 5 e.g. colour, texture, shape,
inv_itm	param6	Customer specific item parameter 6 e.g. colour, texture, shape,
inv_itm	prband	Selected price band 1 - 4,
inv_itm	qty	Quantity,
inv_itm	r_disc	Discount percentage rate applied to items,
inv_itm	sellpr	Sale price,
inv_itm	sellpr2	Sale price 2,
inv_itm	sellpr3	Sale price 3,
inv_itm	sellpr4	Sale price 4,
inv_itm	stkcd	Stockcode,
inv_itm	tax_amt	Tax amount,
inv_itm	tax_rate	Tax rate,
inv_itm	taxcd	Tax code (T0 to T99),
inv_itm	taxcd_id	Tax code,
inv_itm	txt	Service invoice/credit text,
inv_itm	upr	Unit price,
inv_itm	usale	Unit of sale
inv_itm	uwt	Unit weight
isaudit	amt	Goods value, rounded up to the nearest GBP or Euro
isaudit	docno	Document number, so, po, sales invoice, purchase invoice
isaudit	dt	Date the items were shipped or received for reporting
isaudit	from	EU country code that the goods are sent from
isaudit	id	Intrastat transactions audit file record ID
isaudit	ioid	Input / Output record ID (SOP / POP)
isaudit	nm	Short name / description for period return
isaudit	notc	2-Digit nature of transaction code, specific values, see Lists: IstatNoTC
isaudit	qty	Quantity received / shipped
isaudit	status	Record status. 0=Not processed, 1=Included in a report, 2=Submitted in report i.e. complete
isaudit	stkcd	Stock code / reference
isaudit	stknm	Stock item description
isaudit	su	Intrastat supplementary units
isaudit	terms	Delivery terms, see Lists: IstatTerms
isaudit	to	EU country code that the goods are sent to
isaudit	ty	Transaction type. 1=Received, 2=Sent
isaudit	wt	Total net weight of items, rounded up to the nearest Kg
iscc	cnkey	Intrastat commodity code
iscc	cnkey	Intrastat commodity code components
iscc	dashes	Number of dashes
iscc	depth	Nesting depth / lenel
iscc	dm
iscc	du
iscc	id	Intrastat commodity codes list
iscc	upd
lang_uk	id	Language File for UK, record ID
lang_uk	ref
lang_uk	trs
lang_uk	ty
lang_uk	uk
lists	dta	List data delimited by ~
lists	id	System and User definable drop down lists, record ID
lists	info	Help / Information about list
lists	list	Short name / reference for list
lists	modified	Date and time when the record was updated.
lists	no	List item number / sort order; -1=Header details
lists	tbl	1 = save the list as a table as well
manuf	adr1	Account Address Line1
manuf	adr2	Account Address Line2
manuf	adr3	Account Address Line3
manuf	adr4	Account Address Line4
manuf	adr5	Account Address Line5
manuf	ccd	Country Code
manuf	cnt_nm	Contact Name
manuf	conm	Account Name
manuf	e_mail	E-Mail Address
manuf	fax	Fax Number
manuf	id	Manufacturer record ID. 0=Default settings for new records
manuf	idclass	Class ID (see Lists.ManufClass)
manuf	qty_sold_bf	Brought forward quantity sold
manuf	qty_sold_fu	Future quantity sold
manuf	qty_sold_m1	Month 1 quantity sold
manuf	qty_sold_m10	Month 10 quantity sold
manuf	qty_sold_m11	Month 11 quantity sold
manuf	qty_sold_m12	Month 12 quantity sold
manuf	qty_sold_m2	Month 2 quantity sold
manuf	qty_sold_m3	Month 3 quantity sold
manuf	qty_sold_m4	Month 4 quantity sold
manuf	qty_sold_m5	Month 5 quantity sold
manuf	qty_sold_m6	Month 6 quantity sold
manuf	qty_sold_m7	Month 7 quantity sold
manuf	qty_sold_m8	Month 8 quantity sold
manuf	qty_sold_m9	Month 9 quantity sold
manuf	ref	Account Reference
manuf	tel	Telephone Number
manuf	tel2	Telephone Number (2)
manuf	trade_cnt	Trade Contact
manuf	url	World Wide Web Address
modules	f	Feature ID, user to group different options together
modules	hid	Help ID / Short Name
modules	id	List of System Modules, the order in which the modules / options are listed in user access
modules	level	Module / option cascade / indent level
modules	m	Does manager have access to this menu / option
modules	mid	Option / Module ID, used in application to determine system access
modules	nm	Name or description of module / option
modules	ord	List / sort order - for development only, not used in app
modules	ty	Module type / short description, for documentation only - not used in app
nl	accref	Account Code
nl	accty	Account Type Code
nl	bal_fu	Balance for Future
nl	balance	Balance
nl	balbf	Balance Brought forward
nl	balmth1	Balance Month 1
nl	balmth10	Balance Month 10
nl	balmth11	Balance Month 11
nl	balmth12	Balance Month 12
nl	balmth2	Balance Month 2
nl	balmth3	Balance Month 3
nl	balmth4	Balance Month 4
nl	balmth5	Balance Month 5
nl	balmth6	Balance Month 6
nl	balmth7	Balance Month 7
nl	balmth8	Balance Month 8
nl	balmth9	Balance Month 9
nl	bugt_m1	Budget Month 1
nl	bugt_m10	Budget Month 10
nl	bugt_m11	Budget Month 11
nl	bugt_m12	Budget Month 12
nl	bugt_m2	Budget Month 2
nl	bugt_m3	Budget Month 3
nl	bugt_m4	Budget Month 4
nl	bugt_m5	Budget Month 5
nl	bugt_m6	Budget Month 6
nl	bugt_m7	Budget Month 7
nl	bugt_m8	Budget Month 8
nl	bugt_m9	Budget Month 9
nl	cr_bf	Credit Brought Forward
nl	cr_fu	Credit for Future
nl	cr_m1	Credit Month 1
nl	cr_m10	Credit Month 10
nl	cr_m11	Credit Month 11
nl	cr_m12	Credit Month 12
nl	cr_m2	Credit Month 2
nl	cr_m3	Credit Month 3
nl	cr_m4	Credit Month 4
nl	cr_m5	Credit Month 5
nl	cr_m6	Credit Month 6
nl	cr_m7	Credit Month 7
nl	cr_m8	Credit Month 8
nl	cr_m9	Credit Month 9
nl	created	Date and time when the record was created.
nl	dbt_bf	Debit Brought Forward
nl	dbt_fu	Debit for Future
nl	dbt_m1	Debit Month 1
nl	dbt_m10	Debit Month 10
nl	dbt_m11	Debit Month 11
nl	dbt_m12	Debit Month 12
nl	dbt_m2	Debit Month 2
nl	dbt_m3	Debit Month 3
nl	dbt_m4	Debit Month 4
nl	dbt_m5	Debit Month 5
nl	dbt_m6	Debit Month 6
nl	dbt_m7	Debit Month 7
nl	dbt_m8	Debit Month 8
nl	dbt_m9	Debit Month 9
nl	f_del	Flag denoting if the record has been deleted or not.
nl	id	Nominal Ledger, record ID
nl	lastyr_m1	Prior Year Month 1
nl	lastyr_m10	Prior Year Month 10
nl	lastyr_m11	Prior Year Month 11
nl	lastyr_m12	Prior Year Month 12
nl	lastyr_m2	Prior Year Month 2
nl	lastyr_m3	Prior Year Month 3
nl	lastyr_m4	Prior Year Month 4
nl	lastyr_m5	Prior Year Month 5
nl	lastyr_m6	Prior Year Month 6
nl	lastyr_m7	Prior Year Month 7
nl	lastyr_m8	Prior Year Month 8
nl	lastyr_m9	Prior Year Month 9
nl	lastyr2_m1	Prior Year 2 Month 1
nl	lastyr2_m10	Prior Year 2 Month 10
nl	lastyr2_m11	Prior Year 2 Month 11
nl	lastyr2_m12	Prior Year 2 Month 12
nl	lastyr2_m2	Prior Year 2 Month 2
nl	lastyr2_m3	Prior Year 2 Month 3
nl	lastyr2_m4	Prior Year 2 Month 4
nl	lastyr2_m5	Prior Year 2 Month 5
nl	lastyr2_m6	Prior Year 2 Month 6
nl	lastyr2_m7	Prior Year 2 Month 7
nl	lastyr2_m8	Prior Year 2 Month 8
nl	lastyr2_m9	Prior Year 2 Month 9
nl	lastyr3_m1	Prior Year 3 Month 1
nl	lastyr3_m10	Prior Year 3 Month 10
nl	lastyr3_m11	Prior Year 3 Month 11
nl	lastyr3_m12	Prior Year 3 Month 12
nl	lastyr3_m2	Prior Year 3 Month 2
nl	lastyr3_m3	Prior Year 3 Month 3
nl	lastyr3_m4	Prior Year 3 Month 4
nl	lastyr3_m5	Prior Year 3 Month 5
nl	lastyr3_m6	Prior Year 3 Month 6
nl	lastyr3_m7	Prior Year 3 Month 7
nl	lastyr3_m8	Prior Year 3 Month 8
nl	lastyr3_m9	Prior Year 3 Month 9
nl	lastyr4_m1	Prior Year 4 Month 1
nl	lastyr4_m10	Prior Year 4 Month 10
nl	lastyr4_m11	Prior Year 4 Month 11
nl	lastyr4_m12	Prior Year 4 Month 12
nl	lastyr4_m2	Prior Year 4 Month 2
nl	lastyr4_m3	Prior Year 4 Month 3
nl	lastyr4_m4	Prior Year 4 Month 4
nl	lastyr4_m5	Prior Year 4 Month 5
nl	lastyr4_m6	Prior Year 4 Month 6
nl	lastyr4_m7	Prior Year 4 Month 7
nl	lastyr4_m8	Prior Year 4 Month 8
nl	lastyr4_m9	Prior Year 4 Month 9
nl	lastyr5_m1	Prior Year 5 Month 1
nl	lastyr5_m10	Prior Year 5 Month 10
nl	lastyr5_m11	Prior Year 5 Month 11
nl	lastyr5_m12	Prior Year 5 Month 12
nl	lastyr5_m2	Prior Year 5 Month 2
nl	lastyr5_m3	Prior Year 5 Month 3
nl	lastyr5_m4	Prior Year 5 Month 4
nl	lastyr5_m5	Prior Year 5 Month 5
nl	lastyr5_m6	Prior Year 5 Month 6
nl	lastyr5_m7	Prior Year 5 Month 7
nl	lastyr5_m8	Prior Year 5 Month 8
nl	lastyr5_m9	Prior Year 5 Month 9
nl	modified	Date and time when the record was modified.
nl	nm	Name
nl	quick_ratio	Account in Quick Ratio
nl	sofa_id	Sofa Category ID
nlbat	accref	Customer / supplier account reference
nlbat	bnkref	Bank account nominal code
nlbat	curr_id	Currency ID
nlbat	dom	Day of month (1 - 31) for repeat / scheduled entries
nlbat	dt	Transaction date
nlbat	dt_end	Last date that this entry will be executed on
nlbat	dt_start	Date that this entry will commence on
nlbat	dtls	Additional transaction details / description
nlbat	expncd	Expense related nominal code
nlbat	extref	External short reference customer / supplier / transaction
nlbat	f_act	Is this entry active flag
nlbat	f_jdjc	Transactions are Journal Debits / Credits
nlbat	f_noenddt	There is no scheduled end date flag. Active till cancelled.
nlbat	f_sch	Is this entry schduled flag
nlbat	f_usr	This list name is user defined. 0=System, 1=Used Defined
nlbat	gross
nlbat	id	Nominal ledger batch entries record ID
nlbat	last_dt	Date that this entry was last processed
nlbat	n_done	Number of times this entry has been processed
nlbat	n_prd	Number of periods (prd_ty) between repeat intervals
nlbat	n_tot	Total number of time the entry will be repeated
nlbat	net	Net amount in selected currency
nlbat	nm	Short name for the batch entry list
nlbat	note	Free text note as a reminder - for user use only
nlbat	nxt_dt	Next scheduled date that this entry will be processed on
nlbat	prd_ty	Repeat period type for this entry: 1=days, 2=weeks, 3=months, 4=years
nlbat	ref	Internal (our) short reference
nlbat	tax
nlbat	taxcd	Tax code
nlbat	ty	Transaction type: SI, SC, PI, PC, SA, PA, JD, JC etc..
nlcat	catnm	NL category name
nlcat	id	NL template categories
nlcat	tid	NL template ID, nltpl.id
nlcat	ty	NL Account category type, Bank, Debtors, Creditors, Sales, Purchases etc..
nlgrp	acty	Nominal code account type / control account
nlgrp	cid	NL Category ID, nlcat.id
nlgrp	grpnm	NL group name
nlgrp	hi	Highest NL account for this category
nlgrp	id	NL groups
nlgrp	lo	Lowest NL account for this category
nlgrp	tid	NL template ID, nltpl.id
nltpl	id	List of Nominal Ledger Templates
nltpl	tplnm	Template name / description
pi	ac_rate	Alternative currency (Euro) exchange rate
pi	accref	Supplier account regerence, pl.accref
pi	adr1	Address line 1
pi	adr2	Address line 2
pi	adr3	Address line 3
pi	adr4	Address line 4
pi	adr5	Address line 5
pi	bc_tot_cost	Base currency total cost including bank charges, currency conversion charges etc..
pi	carr_gross	delivery gross amount (delivery net + delivery tax)
pi	carr_ncd	Delivery nominal code
pi	carr_net	delivery net amount
pi	carr_tax	delivery tax amount
pi	carr_tax_rate	Delivery tax rate
pi	carr_taxcd	Delivery tax code
pi	cnt_nm	Contact name
pi	created	Date and time when the record was created.
pi	curr	Which foreign currency
pi	del_dt	Delivery date
pi	docnm	Purchase Invoice / Purchase Credit
pi	due_dt	Payment due date (Invoice date plus supplier terms)
pi	ex_rate	Foreign exchange rate
pi	f_del	Flag denoting if the record has been deleted or not.
pi	f_post	Posted flag - y or blank
pi	f_prn	Printed flag - y or blank
pi	frgn_carr_gross	delivery gross amount (delivery net + delivery tax) - foreign currency
pi	frgn_deltax	delivery tax amount - foreign currency
pi	frgn_itmsgross	Gross amount (goods but not delivery) - foreign currency
pi	frgn_itmsnet	Net amount (goods but not delivery) - foreign currency
pi	frgn_itmstax	Tax amount (goods but not delivery) - foreign currency
pi	frgn_net	delivery net amount - foreign currency
pi	frgninv_gross	Invoice gross amount (goods and delivery gross) - foreign currency
pi	frgninv_net	Invoice net amount (goods and delivery net) - foreign currency
pi	frgninv_tax	Invoice tax amount (goods and delivery tax) - foreign currency
pi	id	Purchase Invoice record ID
pi	inv_dt	Invoice Date
pi	inv_gross	Invoice gross amount (goods and delivery gross)
pi	inv_net	Invoice net amount (goods and delivery net)
pi	inv_no	Purchase Orders record ID
pi	inv_tax	Invoice tax amount (goods and delivery tax)
pi	inv_ty	Invoice type. 1=Purchase Invoice, 2=Purchase Credit
pi	inv_tycd	PI / PC
pi	invref	Supplier PI number / reference
pi	itmsgross	Gross amount (goods but not delivery)
pi	itmsnet	Net amount (goods but not delivery)
pi	itmstax	Tax amount (goods but not delivery)
pi	modified	Date and time when the record was modified.
pi	nm	Supplier company name
pi	ordno	Our order number
pi	tel	Supplier's telephone number
pi	tmp	Temp field for possible use during data import or any other unspecified purpose
pi	usr	User login id
pi_itm	created	Date and time when the record was created.
pi_itm	dept_nm	Department name
pi_itm	deptno	Department number
pi_itm	f_del	Flag denoting if the record has been deleted or not.
pi_itm	frgn_gross	Gross amount (net after discount + tax) - foreign currency
pi_itm	frgn_net	Net amount (after discount) - foreign currency
pi_itm	frgn_tax	Tax amount - foreign currency
pi_itm	frgn_upr	Unit price - foreign currency
pi_itm	gross	Gross amount (net after discount + tax)
pi_itm	id	Purchase Invoice Items record ID
pi_itm	itm_no	Item number
pi_itm	modified	Date and time when the record was modified.
pi_itm	ncd	Nominal code
pi_itm	net	Net amount (after discount)
pi_itm	qty	Quantity ordered
pi_itm	stk_desc	Item Description
pi_itm	stkcd	Stock code
pi_itm	tax	Tax amount
pi_itm	tax_rate	Tax rate
pi_itm	taxcd	Tax code (T0 to T99)
pi_itm	tmp	Temp field for possible use during data import or any other unspecified purpose
pi_itm	upr	Unit price

Back to Top \| Customers Purchase Ledger / Supplier Details
Table	Field	Description
pl	acchold	Account On Hold
pl	accref	Account Reference
pl	adr1	Account Address Line1
pl	adr2	Account Address Line2
pl	adr3	Account Address Line3
pl	adr4	Account Address Line4
pl	adr5	Account Address Line5
pl	agnc_cd	Credit Bureau code
pl	bacs_ref	BACS Reference for Electronic Transfer
pl	balance	Account balance
pl	bnk_accn	Bank Account Number
pl	bnk_adr1	Bank Address Line1
pl	bnk_adr2	Bank Address Line2
pl	bnk_adr3	Bank Address Line3
pl	bnk_adr4	Bank Address Line4
pl	bnk_adr5	Bank Address Line5
pl	bnk_bic	BIC/SWIFT Code
pl	bnk_iban	IBAN Number
pl	bnk_nm	Bank Name
pl	bnk_nm	Bank Account Name
pl	bnk_ref1	Additional References
pl	bnk_ref2	Additional References
pl	bnk_ref3	Additional References
pl	bnk_rn	Roll number
pl	bnk_scd	Bank Sort Code
pl	ccd	Country Code
pl	chqrunbal	Cheque run balance
pl	cnt_nm	Contact Name
pl	conm	Account Name
pl	cr_bf	Credits Brought Forward
pl	cr_cf	Credits Carry Forward
pl	cr_limit	Credit Limit
pl	cr_m1	Credits Month 1
pl	cr_m10	Credits Month 10
pl	cr_m11	Credits Month 11
pl	cr_m12	Credits Month 12
pl	cr_m2	Credits Month 2
pl	cr_m3	Credits Month 3
pl	cr_m4	Credits Month 4
pl	cr_m5	Credits Month 5
pl	cr_m6	Credits Month 6
pl	cr_m7	Credits Month 7
pl	cr_m8	Credits Month 8
pl	cr_m9	Credits Month 9
pl	cr_pos	Credit Position
pl	cr_poscd	Credit Position Code
pl	cr_ref	Credit Reference
pl	created	Date and time when the record was created.
pl	curr	Currency
pl	dadr1	Delivery Address Line1
pl	dadr2	Delivery Address Line2
pl	dadr3	Delivery Address Line3
pl	dadr4	Delivery Address Line4
pl	dadr5	Delivery Address Line5
pl	def_fid	Default Fund Number
pl	def_ncd	Default Nominal Code
pl	def_taxcd	Default tax code (T0 to T99)
pl	del_cntnm	Delivery Contact Name
pl	del_fax	Delivery Fax Number
pl	del_nm	Delivery Name
pl	del_tel	Delivery Telephone Number
pl	dept_nm	Department Name
pl	deptno	Department Number
pl	dt_accnt_opn	Date Account Opened
pl	dt_cr_app	Date of Credit Application
pl	dt_cr_rcv	Date Credit Application Received
pl	dt_nrev	Date of Next Credit Review
pl	duns_no	DUNS Number
pl	e_mail	E-Mail Address
pl	edi_acc	Unique Mailbox ID / reference for Document Exchange - alpha numeric string, (converted to lower case)
pl	f_del	Flag denoting if the record has been deleted or not.
pl	f_nomail	Mail On Hold
pl	f_termsok	Terms Agreed Flag
pl	fax	Fax Number
pl	hndp	Hircarra network delivery point ? 0=None, 1=email, 2=EDI
pl	id	Purchase Ledger record ID. 0=Default settings for new records
pl	inv_bf	Invoices Brought Forward
pl	inv_cf	Invoices Carry Forward
pl	inv_dt1	Date of First Invoice
pl	inv_m1	Invoices Month 1
pl	inv_m10	Invoices Month 10
pl	inv_m11	Invoices Month 11
pl	inv_m12	Invoices Month 12
pl	inv_m2	Invoices Month 2
pl	inv_m3	Invoices Month 3
pl	inv_m4	Invoices Month 4
pl	inv_m5	Invoices Month 5
pl	inv_m6	Invoices Month 6
pl	inv_m7	Invoices Month 7
pl	inv_m8	Invoices Month 8
pl	inv_m9	Invoices Month 9
pl	last_inv_dt	Last Invoice Date
pl	last_pmt_amt	Last Payment Amount
pl	last_pmt_dt	Date of Last Payment
pl	lastyr	Turnover Last Year
pl	lrev_dt	Date of Last Credit Review
pl	modified	Date and time when the record was modified.
pl	notes	General text memo / notes
pl	ok2chrg	Credit Charges (interest) can be applied by this Account
pl	override_taxcd	Override stock tax code in invoicing
pl	pdf_inv	Flag to indicate that invoices should be printed as PDF files
pl	pdf_stm	Flag to indicate that statements should be printed as PDF files
pl	pmt_bf	Payments Brought Forward
pl	pmt_cf	Payments Carry Forward
pl	pmt_due_days	Payment Due Days
pl	pmt_m1	Payments Month 1
pl	pmt_m10	Payments Month 10
pl	pmt_m11	Payments Month 11
pl	pmt_m12	Payments Month 12
pl	pmt_m2	Payments Month 2
pl	pmt_m3	Payments Month 3
pl	pmt_m4	Payments Month 4
pl	pmt_m5	Payments Month 5
pl	pmt_m6	Payments Month 6
pl	pmt_m7	Payments Month 7
pl	pmt_m8	Payments Month 8
pl	pmt_m9	Payments Month 9
pl	pmt_mode_id	Unique ID of the payment method used by this account
pl	priority	Priority
pl	r_disc	Discount Rate
pl	r_pwd	Password used to encrypt secure PDFs
pl	rep1	Analysis 1
pl	rep2	Analysis 2
pl	rep3	Analysis 3
pl	s_no	Status Number
pl	s_txt	Status Text
pl	said_pdt	Date on which the last promise to pay was made.
pl	said_pmt	Latest amount promised to be paid.
pl	stlm_days	Settlement Due Days to be eligible fro discount
pl	stlm_discr	Settlement Discount Rate
pl	tel	Telephone Number
pl	tel2	Telephone Number (2)
pl	terms	Terms
pl	to_mtd	Turnover Month To Date
pl	to_ytd	Turnover Year To Date
pl	trade_cnt	Trade Contact
pl	url	World Wide Web Address
pl	use_bacs	Flag to Use BACS Reference
pl	use_bsoc	Flag to Use Building Society Reference
pl	vat_reg_no	VAT Registration Number
pl	x_docs	Exchange documents electronically
po	ac_gross	Gross amount in alternative currency
po	ac_rate	Alternative currency (Euro) exchange rate
po	accref	Account reference
po	adr1	Address line 1
po	adr2	Address line 2
po	adr3	Address line 3
po	adr4	Address line 4
po	adr5	Address line 5
po	bnk_ref	Bank account used for payment
po	carr_dept_nm	delivery department name
po	carr_gross	delivery gross amount (delivery net + delivery tax)
po	carr_ncd	delivery nominal code
po	carr_net	delivery net amount
po	carr_tax	delivery tax amount
po	carr_taxcd	delivery tax code (T0 to T99)
po	cnt_nm	Contact name
po	created	Date and time when the record was created.
po	curr	Which foreign currency
po	curr_ty	Foreign or Euro currency
po	dadr1	Delivery address line 1
po	dadr2	Delivery address line 2
po	dadr3	Delivery address line 3
po	dadr4	Delivery address line 4
po	dadr5	Delivery address line 5
po	del_dt	Delivery date
po	del_nm	Delivery name
po	del_tax_rate	delivery tax rate
po	delco_nm	Courier Name
po	delco_no	Courier Number
po	deldept	delivery department number
po	delref	Consignment Reference
po	duns_no	DUNS Number
po	ex_rate	Foreign exchange rate
po	f_del	Flag denoting if the record has been deleted or not.
po	f_prn	Printed flag - y or blank
po	f_prn	Printed flag - 1/0
po	frgn_carr_gross	delivery gross amount (delivery net + delivery tax) - foreign currency
po	frgn_deltax	delivery tax amount - foreign currency
po	frgn_itmsgross	Gross amount (goods but not delivery) - foreign currency
po	frgn_itmsnet	Net amount (goods but not delivery) - foreign currency
po	frgn_itmstax	Tax amount (goods but not delivery) - foreign currency
po	frgn_net	delivery net amount - foreign currency
po	frgn_stlm_disc	Settlement discount amount (reduction) - foreign currency
po	frgn_stlm_tot	Invoice total after settlement discount - foreign currency
po	frgninv_gross	Invoice gross amount (goods and delivery gross) - foreign currency
po	frgninv_net	Invoice net amount (goods and delivery net) - foreign currency
po	frgninv_tax	Invoice tax amount (goods and delivery tax) - foreign currency
po	id	Purchase Orders record ID
po	inv_gross	Invoice gross amount (goods and delivery gross)
po	inv_net	Invoice net amount (goods and delivery net)
po	inv_tax	Invoice tax amount (goods and delivery tax)
po	itmsgross	Gross amount (goods but not delivery)
po	itmsnet	Net amount (goods but not delivery)
po	itmstax	Tax amount (goods but not delivery)
po	modified	Date and time when the record was modified.
po	net1	Net amount at highest tax rate
po	net2	Net amount at second highest tax rate
po	net3	Net amount at third highest tax rate
po	net4	Net amount at fourth highest tax rate
po	net5	Net amount at fifth highest tax rate
po	nm	Name
po	notes1	Notes 1
po	notes2	Notes 2
po	notes3	Notes 3
po	ord_dt	Order Date
po	ord_q	Order/Quote label
po	ordno	Order number
po	pmt_ref	Payment reference
po	pmt_ty	Payment Type: 0 - Already received. 3 - SR. 4 - SA.
po	post	Posted flag - y or blank
po	post_cd	Posted flag - 1/0
po	recur_ref	Recurring entry reference
po	ref	Reference
po	s_del	Delivery status description
po	s_inv	Invoice status description
po	s_ord	Order status description
po	sid_del	Delivery status code
po	sid_inv	Invoice status code
po	sid_ord	Order status code
po	sid_quote	Quote status Id
po	stlm_days	Early settlement period in days
po	stlm_disc	Settlement discount amount (reduction)
po	stlm_discr	Early settlement discount % rate
po	stlm_tot	Invoice total after settlement discount
po	su_discr	Supplier Discount
po	su_ord	Supplier's order number
po	su_tel	Supplier's telephone number
po	tax_amt1	Tax amount at highest tax rate
po	tax_amt2	Tax amount at second highest tax rate
po	tax_amt3	Tax amount at third highest tax rate
po	tax_amt4	Tax amount at fourth highest tax rate
po	tax_amt5	Tax amount at fifth highest tax rate
po	tax_rate1	Highest tax rate
po	tax_rate2	Second highest tax rate
po	tax_rate3	Third highest tax rate
po	tax_rate4	Fourth highest tax rate
po	tax_rate5	Fifth highest tax rate
po	usr	Order taken by
poe_itms	buy	This item is ready for purchasing. 1=Buy, 2=Has been ordered
poe_itms	cost	Unit cost price in base currency for selected supplier
poe_itms	dept	Department ID / number
poe_itms	id	PO Enquiery Items, record ID
poe_itms	itm	Item Number
poe_itms	lpdt	Last purchase date
poe_itms	lppr	Last purchase price, if none then user entered estimated cost
poe_itms	note	Any additional notes for each item
poe_itms	poeid	Purchase Order Enquiry ID, poenq.id
poe_itms	poid	Purchase order ID
poe_itms	qty	Quantity required
poe_itms	qty_ord	Quantity Ordered
poe_itms	status	Item status, 0=Not Ordered, 1=Part Ordered (added to PO), 3=Full or greater qty added to PO
poe_itms	stkdesc	Item description of item, stk.stk_desc
poe_itms	stkid	Stock ID, stk.id
poe_itms	stkref	Stock reference, stk.ref
poe_itms	sup	Reference of supplier that has been selected to supply the item, pl.accref
poe_itms	suplist	Ranked delimited list of suppliers
poe_pr	cost	Unit cost price in supplier curency (poe_sup.curr)
poe_pr	cost2	Unit cost price in base currency
poe_pr	curr	Currency code
poe_pr	id	PO Enquiry prices quoted by different suppliers
poe_pr	plid	Purchase Ledger / Supplier ID, pl.id
poe_pr	poeid	Purchase Order Enquiry ID, poenq.id
poe_pr	poeiid	PO Enquiry Items ID, poe_itms.id
poe_pr	qty	Quantity offered if different from requested
poe_pr	rank	Supplier rank, 1=lowest cost, 98=highest cost, 99=price not quoted
poe_sup	cost	Total cost of all items that have been quoted for plus delivery and insurance in system base currency
poe_sup	curr	Currency code
poe_sup	exch	Current exchange rate
poe_sup	id	PO Enquiry Suppliers, record ID
poe_sup	insu	Insurance charges
poe_sup	ltm	Lead time in days
poe_sup	part	Is the quote for only part of the requirement 0=No i.e. full requirement, 1=quoted all items, some lower qty, 2=quoted full qty but NOT all items, 3=quoted for some items but also not full qty
poe_sup	poeid	Purchase Order Enquiry ID, poenq.id
poe_sup	ship	Shipping charge
poe_sup	supref	Purchase Ledger / Supplier reference, pl.accref
poenq	cnt	Name of one or more people that suppliers can contact to discuss the enquiry
poenq	costmin	Minimum total cost if items ordered at the lowest offered price
poenq	costord	Cost of order based on items from selected suppliers
poenq	costsup	Minimum cost if items ordered from a single supplier
poenq	dt	POE Date
poenq	id	Purchase Order Enquiries, record ID
poenq	itms	Number of line items in the enquiry
poenq	losup	Supplier reference of the supplier with the cheapest order value, pl.ref
poenq	nm	More desciptive name / details about the enquiry
poenq	no	PO Enquiry number
poenq	nsup	Number of suppliers selected for the enquiry
poenq	ref	PO Enquiry reference
poenq	reqby	Goods required by / delivery date
poenq	shiphi	Highest shipping cost, including insurance
poenq	shiplo	Lowest shipping cost, including insurance
poenq	status	Status: 0=New / Open, 1=Sent / Exported, 2=Imported, 3=Closed / Finished
poenq	suplist	Comma separated list of suppliers that have been selected to submit prices
poenq	tmpl	Full pathname of MS Excel spreadsheet template file to be used for exporting / creating supplier enquiry
poenq	tot	Total value of the enquiry based on last cost price or item cost price set by user
pop_itm	ad_disr	Additional discount percentage rate
pop_itm	cost_cd_ref	Reference for associated cost code
pop_itm	created	Date and time when the record was created.
pop_itm	del_dt	Delivery date
pop_itm	dept_nm	Department name
pop_itm	deptno	Department number
pop_itm	discamt	Discount amount
pop_itm	due_dt	Due date
pop_itm	f_del	Flag denoting if the record has been deleted or not.
pop_itm	frgn_discamt	Discount amount - foreign currency
pop_itm	frgn_full_net	Full net amount (before discount) - foreign currency
pop_itm	frgn_gross	Gross amount (net after discount + tax) - foreign currency
pop_itm	frgn_net	Net amount (after discount) - foreign currency
pop_itm	frgn_tax	Tax amount - foreign currency
pop_itm	frgn_upr	Unit price - foreign currency
pop_itm	full_net	Full net amount (before discount)
pop_itm	gross	Gross amount (net after discount + tax)
pop_itm	id	Purchase Order Processing Items record ID
pop_itm	itm_no	Item number
pop_itm	job_no	Job number
pop_itm	modified	Date and time when the record was modified.
pop_itm	ncd	Nominal code
pop_itm	net	Net amount (after discount)
pop_itm	note1	Note / comment 1
pop_itm	note2	Note / comment 2
pop_itm	ordno	Order Reference number
pop_itm	qty_dlvrd	Quantity previously delivered for this order
pop_itm	qty_ord	Quantity ordered
pop_itm	qty_poinv	Quantity that has been invoiced (purchase invoice)
pop_itm	r_disc	Discount percentage rate
pop_itm	s_is	Intrastat status. 0=Not processes, 1=Ready for IS reporting, 2=Posted to table isaudit for reporting
pop_itm	s_pi	Purchase invoice status. 0=Not invoiced, 1=Part invoiced, 2=Complete
pop_itm	stk_desc	Item Description
pop_itm	stkcd	Stock code
pop_itm	tax_amt	Tax amount
pop_itm	tax_rate	Tax rate
pop_itm	taxcd	Tax code (T0 to T99)
pop_itm	taxcd_id	Tax code
pop_itm	units	Units that the items are sold in
pop_itm	upr	Unit price
remind	active	Is this event active (0=No, 1=Yes)
remind	done	Number of events that have already been repeated / done.
remind	end	End date and time of when the event no longer active
remind	freq	Frequency, number of intervals between events
remind	from	login ID of user that created the event / reminder
remind	id	List of reminders / events coming up in the future
remind	id1	ID of first repeated event
remind	id2	ID of last repeated event. For the 1st repeated event id1 = id2
remind	interval	Repeat interval: 1=Days, 2=Weeks, 3=Months, 4=Years
remind	itmid	ID of the item to be repeated
remind	left	Users that have not yet been reminded
remind	no	Number of times to repeat the event, zero = unlimited
remind	noend	1=The event does not have an end date and time
remind	notes	Free short text for notes / comments, for user information only
remind	nxt	Date and time of next event for this item; for invoices, time = 00:00
remind	past	Date and time of last event for this item
remind	start	Start date and time of when the event becomes effective
remind	to	Delimited list of Login IDs of users that the message is for, blank=all users
remind	ty	Reminder item type e.g. Invoice, Reminder
rinv	ac_gross	Gross amount in alternative currency (Euros)
rinv	ac_rate	Alternative currency (Euro) exchange rate
rinv	accref	Account reference
rinv	adr1	Address line 1
rinv	adr2	Address line 2
rinv	adr3	Address line 3
rinv	adr4	Address line 4
rinv	adr5	Address line 5
rinv	bnk_ref	Bank account used for payment
rinv	carr_dept_nm	Carriage department name
rinv	carr_deptno	Carriage department number
rinv	carr_gross	Carriage gross amount (carriage net + carriage tax)
rinv	carr_ncd	Carriage nominal code
rinv	carr_net	Carriage net amount
rinv	carr_tax	Carriage tax amount
rinv	carr_taxcd	Carriage tax code (T0 to T99)
rinv	cnt_nm	Contact name
rinv	conm	Name
rinv	created	Date and time when the record was created.
rinv	cu_rdisc	Customer Discount
rinv	cu_tel	Customer's telephone number
rinv	curr	Which foreign currency
rinv	curr_ty	Foreign or Euro currency
rinv	cust_ordno	Customer's order number
rinv	d_deptno	Global department number
rinv	dadr1	Delivery address line 1
rinv	dadr2	Delivery address line 2
rinv	dadr3	Delivery address line 3
rinv	dadr4	Delivery address line 4
rinv	dadr5	Delivery address line 5
rinv	del_nm	Delivery name
rinv	delco_nm	Courier Name
rinv	delco_no	Courier Number
rinv	delref	Consignment Reference
rinv	docnm	Invoice/Credit/Quote/Proforma label
rinv	eid	Event ID, events.id if this is a scheduled repeated invoice
rinv	eseq	Event sequence number i.e. if repeated, repeat sequence number, 1 onwards
rinv	f_del	Flag denoting if the record has been deleted or not.
rinv	f_prn	Printed flag: o = No, 1 = Yes
rinv	frgn_carr_gross	Carriage gross amount (carriage net + carriage tax) - foreign currency
rinv	frgn_deltax	Carriage tax amount - foreign currency
rinv	frgn_itmsgross	Gross amount (goods but not carriage) - foreign currency
rinv	frgn_itmsnet	Net amount (goods but not carriage) - foreign currency
rinv	frgn_itmstax	Tax amount (goods but not carriage) - foreign currency
rinv	frgn_net	Carriage net amount - foreign currency
rinv	frgn_prepaid	Amount prepaid - foreign currency
rinv	frgn_rate	Foreign exchange rate
rinv	frgn_stlm_disc	Settlement discount amount (reduction) - foreign currency
rinv	frgn_stlm_tot	Invoice total after settlement discount - foreign currency
rinv	frgninv_gross	Invoice gross amount (goods and carriage gross) - foreign currency
rinv	frgninv_net	Invoice net amount (goods and carriage net) - foreign currency
rinv	frgninv_tax	Invoice tax amount (goods and carriage tax) - foreign currency
rinv	g_dept	Global department name
rinv	g_dtls	Global details
rinv	g_ncd	Global nominal code
rinv	g_taxcd	Global tax code (T0 to T99)
rinv	id	Repeating invoices, record ID. 0=Default settings for new records
rinv	inv_dt	Invoice Date
rinv	inv_gross	Invoice gross amount (goods and carriage gross)
rinv	inv_net	Invoice net amount (goods and carriage net)
rinv	inv_no	Invoice number
rinv	inv_tax	Invoice tax amount (goods and carriage tax)
rinv	inv_ty	Invoice type description
rinv	inv_tycd	Invoice type code 1=Invoice, 2=Credit Note
rinv	itmsgross	Gross amount (goods but not carriage)
rinv	itmsnet	Net amount (goods but not carriage)
rinv	itmstax	Tax amount (goods but not carriage)
rinv	modified	Date and time when the record was modified.
rinv	net1	Net amount at highest tax rate
rinv	net2	Net amount at second highest tax rate
rinv	net3	Net amount at third highest tax rate
rinv	net4	Net amount at fourth highest tax rate
rinv	net5	Net amount at fifth highest tax rate
rinv	notes1	Notes 1
rinv	notes2	Notes 2
rinv	notes3	Notes 3
rinv	ntvd_desc	Net value discount description
rinv	ntvd_net	Net value discount value (foreign currency)
rinv	ntvd_net_base	Net value discount (base currency)
rinv	ntvd_note1	Net value discount comment 1
rinv	ntvd_note2	Net value discount comment 2
rinv	ntvd_rate	Net value discount percentage
rinv	ordno	Corresponding order number
rinv	pmt_ref	Payment reference
rinv	pmt_ty	Payment Type: 0 - Already received. 3 - SR. 4 - SA.
rinv	post	Posted flag - 1/0
rinv	prepaid	Amount prepaid
rinv	q_expdt	Quote expiry date
rinv	recur_ref	Recurring entry reference
rinv	s_quote	Quote status
rinv	sid_quote	Quote status Id
rinv	sop_dt	SOP Date
rinv	sop_sid	SOP status Id
rinv	sop_status	SOP status
rinv	stlm_days	Settlement days
rinv	stlm_disc	Settlement discount amount (reduction)
rinv	stlm_discr	Settlement discount % rate
rinv	stlm_tot	Invoice total after settlement discount
rinv	tax_amt1	Tax amount at highest tax rate
rinv	tax_amt2	Tax amount at second highest tax rate
rinv	tax_amt3	Tax amount at third highest tax rate
rinv	tax_amt4	Tax amount at fourth highest tax rate
rinv	tax_amt5	Tax amount at fifth highest tax rate
rinv	tax_rate1	Highest tax rate
rinv	tax_rate2	Second highest tax rate
rinv	tax_rate3	Third highest tax rate
rinv	tax_rate4	Fourth highest tax rate
rinv	tax_rate5	Fifth highest tax rate
rinv	taxcd1	Tax code (T0 to T99)
rinv	taxcd2	Tax code (T0 to T99)
rinv	taxcd3	Tax code (T0 to T99)
rinv	taxcd4	Tax code (T0 to T99)
rinv	taxcd5	Tax code (T0 to T99)
rinv	usr	Order taken by
rinvitm	ad_disr	Additional discount percentage rate
rinvitm	created	Date and time when the record was created.
rinvitm	del_dt	Delivery date
rinvitm	dept_nm	Department name
rinvitm	deptno	Department number
rinvitm	discamt	Discount amount
rinvitm	ec_vat_info_id	The unique ID of the EC VAT Description applied to this item line
rinvitm	ext_ord_line_ref	External Order Line Ref for SOP to Invoice Link
rinvitm	ext_ord_ref	External Order Ref for SOP to Invoice Link
rinvitm	f_automsg	True if this message was automatically generated
rinvitm	f_del	Flag denoting if the record has been deleted or not.
rinvitm	f_srv	Service invoice/credit flag
rinvitm	frgn_discamt	Discount amount - foreign currency
rinvitm	frgn_full_net	Full net amount (before discount) - foreign currency
rinvitm	frgn_gross	Gross amount (net after discount + tax) - foreign currency
rinvitm	frgn_net	Net amount (after discount) - foreign currency
rinvitm	frgn_tax	Tax amount - foreign currency
rinvitm	frgn_upr	Unit price - foreign currency
rinvitm	full_net	Full net amount (before discount)
rinvitm	gross	Gross amount (net after discount + tax)
rinvitm	id	Repeating invoices items, record ID.
rinvitm	ii_desc	Description
rinvitm	inv_no	Invoice reference number
rinvitm	itm_no	Item number
rinvitm	itmid	Item ID
rinvitm	job_no	Job number
rinvitm	modified	Date and time when the record was modified.
rinvitm	ncd	Nominal code
rinvitm	negotiation_disc_net	Negotiation discount net (foreign currency)
rinvitm	negotiation_disc_net_base	Negotiation discount net (base currency)
rinvitm	net	Net amount (after discount)
rinvitm	note1	Comment 1
rinvitm	note2	Comment 2
rinvitm	proj_id	ID of linked Project
rinvitm	qty	Quantity
rinvitm	r_disc	Discount percentage rate
rinvitm	stkcd	Stockcode
rinvitm	tax_amt	Tax amount
rinvitm	tax_rate	Tax rate
rinvitm	taxcd	Tax code (T0 to T99)
rinvitm	taxcd_id	Tax code
rinvitm	txt	Service invoice/credit text
rinvitm	upr	Unit price
rinvitm	usale	Unit of sale

Back to Top \| Suppliers Sales Ledger / Customer Details
Table	Field	Description
sl	acchold	Account On Hold
sl	accref	Account Reference
sl	adr1	Account Address Line1
sl	adr2	Account Address Line2
sl	adr3	Account Address Line3
sl	adr4	Account Address Line4
sl	adr5	Account Address Line5
sl	agnc_cd	Credit Bureau code
sl	ave_days	Average Time To Pay
sl	bacs_ref	BACS Reference for Electronic Transfer
sl	balance	Balance
sl	bnk_accn	Bank Account Number
sl	bnk_adr1	Bank Address Line1
sl	bnk_adr2	Bank Address Line2
sl	bnk_adr3	Bank Address Line3
sl	bnk_adr4	Bank Address Line4
sl	bnk_adr5	Bank Address Line5
sl	bnk_bic	BIC/SWIFT Code
sl	bnk_iban	IBAN Number
sl	bnk_nm	Bank Name
sl	bnk_nm	Bank Account Name
sl	bnk_ref1	Additional References
sl	bnk_ref2	Additional References
sl	bnk_ref3	Additional References
sl	bnk_rn	Roll number
sl	bnk_scd	Bank Sort Code
sl	ccd	Country Code
sl	cnt_nm	Contact Name
sl	conm	Account Name
sl	cr_bf	Credits Brought Forward
sl	cr_cf	Credits Carry Forward
sl	cr_limit	Credit Limit
sl	cr_m1	Credits Month 1
sl	cr_m10	Credits Month 10
sl	cr_m11	Credits Month 11
sl	cr_m12	Credits Month 12
sl	cr_m2	Credits Month 2
sl	cr_m3	Credits Month 3
sl	cr_m4	Credits Month 4
sl	cr_m5	Credits Month 5
sl	cr_m6	Credits Month 6
sl	cr_m7	Credits Month 7
sl	cr_m8	Credits Month 8
sl	cr_m9	Credits Month 9
sl	cr_pos	Credit Position
sl	cr_poscd	Credit Position Code
sl	cr_ref	Credit Reference
sl	created	Date and time when the record was created.
sl	curr	Currency
sl	dadr1	Delivery Address Line1
sl	dadr2	Delivery Address Line2
sl	dadr3	Delivery Address Line3
sl	dadr4	Delivery Address Line4
sl	dadr5	Delivery Address Line5
sl	def_fid	Default Fund Number
sl	def_ncd	Default Nominal Code
sl	def_taxcd	Default tax code (T0 to T99)
sl	del_cntnm	Delivery Contact Name
sl	del_fax	Delivery Fax Number
sl	del_nm	Delivery Name
sl	del_tel	Delivery Telephone Number
sl	dept_nm	Department Name
sl	deptno	Department Number
sl	disc_ty	Quantity break (A - E) from stock record
sl	dt_accnt_opn	Date Account Opened
sl	dt_cr_app	Date of Credit Application
sl	dt_cr_rcv	Date Credit Application Received
sl	dt_nrev	Date of Next Credit Review
sl	duns_no	DUNS Number
sl	e_mail	E-Mail Address
sl	edi_acc	Unique Mailbox ID / reference for Document Exchange - alpha numeric string, (converted to lower case)
sl	f_del	Flag denoting if the record has been deleted or not.
sl	f_nomail	Mail On Hold
sl	f_ovrncd	Override nominal code in invoicing
sl	f_termsok	Terms Agreed Flag
sl	fax	Fax Number
sl	gift_aid	Gift Aid is enabled
sl	hndp	Hircarra network delivery point ? 0=None, 1=email, 2=EDI
sl	i_e_mail	E-Mail Address for sending invoices
sl	id	Sales Ledger, record ID. 0=Default settings for new records
sl	inv_bf	Invoices Brought Forward
sl	inv_cf	Invoices Carry Forward
sl	inv_dt1	Date of First Invoice
sl	inv_m1	Invoices Month 1
sl	inv_m10	Invoices Month 10
sl	inv_m11	Invoices Month 11
sl	inv_m12	Invoices Month 12
sl	inv_m2	Invoices Month 2
sl	inv_m3	Invoices Month 3
sl	inv_m4	Invoices Month 4
sl	inv_m5	Invoices Month 5
sl	inv_m6	Invoices Month 6
sl	inv_m7	Invoices Month 7
sl	inv_m8	Invoices Month 8
sl	inv_m9	Invoices Month 9
sl	last_inv_dt	Last Invoice Date
sl	last_pmt_amt	Last payment anount received
sl	last_pmt_dt	Date of Last Payment
sl	lastyr	Turnover Last Year
sl	lrev_dt	Date of Last Credit Review
sl	modified	Date and time when the record was modified.
sl	notes	General text memo / notes
sl	ok2chrg	Can Apply Credit Charges to this Account
sl	override_taxcd	Override stock tax code in invoicing
sl	pdf_inv	Flag to indicate that invoices should be printed as PDF files
sl	pdf_stm	Flag to indicate that statements should be printed as PDF files
sl	pmt_bf	Payments Brought Forward
sl	pmt_cf	Payments Carry Forward
sl	pmt_due_days	Payment Due Days
sl	pmt_m1	Payments Month 1
sl	pmt_m10	Payments Month 10
sl	pmt_m11	Payments Month 11
sl	pmt_m12	Payments Month 12
sl	pmt_m2	Payments Month 2
sl	pmt_m3	Payments Month 3
sl	pmt_m4	Payments Month 4
sl	pmt_m5	Payments Month 5
sl	pmt_m6	Payments Month 6
sl	pmt_m7	Payments Month 7
sl	pmt_m8	Payments Month 8
sl	pmt_m9	Payments Month 9
sl	pmt_mode_id	Unique ID of the payment method used by this account
sl	pr_ref	Default Price List. prlst.id
sl	prband	Default price band to use (sell price 1 - 4) from stock record
sl	priority	Priority
sl	r_disc	Discount Rate
sl	r_pwd	Password used to encrypt secure PDFs
sl	reminder	Short reminder text message
sl	rep1	Report Analysis 1
sl	rep2	Report Analysis 2
sl	rep3	Report Analysis 3
sl	s_e_mail	E-Mail Address for sending statements
sl	s_no	Status Number
sl	s_txt	Status Text
sl	said_pdt	Date on which the last promise to pay was made.
sl	said_pmt	Latest amount promised to be paid.
sl	stlm_days	Settlement Due Days
sl	stlm_discr	Settlement Discount Rate
sl	tel	Telephone Number
sl	tel2	Telephone Number (2)
sl	terms	Terms
sl	to_mtd	Turnover Month To Date
sl	to_ytd	Turnover Year To Date
sl	trade_cnt	Trade Contact
sl	url	World Wide Web Address
sl	use_bacs	Flag to Use BACS Reference
sl	vat_reg_no	VAT Registration Number
sl	x_docs	Exchange documents electronically
sop	ac_gross	Gross amount in alternative currency (Euros)
sop	ac_rate	Alternative currency (Euro) exchange rate
sop	accref	Account reference
sop	adr1	Address line 1
sop	adr2	Address line 2
sop	adr3	Address line 3
sop	adr4	Address line 4
sop	adr5	Address line 5
sop	bnk_ref	Bank account used for payment
sop	carr_dept_nm	Carriage department name
sop	carr_deptno	Carriage department number
sop	carr_gross	Carriage gross amount (carriage net + carriage tax)
sop	carr_ncd	Carriage nominal code
sop	carr_net	Carriage net amount
sop	carr_tax	Carriage tax amount
sop	carr_taxcd	Carriage tax code (T0 to T99)
sop	cnt_nm	Contact name
sop	created	Date and time when the record was created.
sop	cu_rdisc	Customer Discount
sop	cu_tel	Customer's telephone number
sop	curr	Which foreign currency
sop	curr_ty	Foreign or Euro currency
sop	cust_disc_amt	Customer discount amount
sop	cust_ordno	Customer's order number
sop	d_deptno	Global department number
sop	dadr1	Delivery address line 1
sop	dadr2	Delivery address line 2
sop	dadr3	Delivery address line 3
sop	dadr4	Delivery address line 4
sop	dadr5	Delivery address line 5
sop	del_nm	Delivery name
sop	delco_nm	Courier Name
sop	delco_no	Courier Number
sop	delref	Consignment Reference
sop	desp_dt	Despatch date
sop	duns_no	DUNS Number
sop	f_del	Flag denoting if the record has been deleted or not.
sop	f_prn	Printed flag - y or blank
sop	f_prn	Printed flag - 1/0
sop	frgn_carr_gross	Carriage gross amount (carriage net + carriage tax) - foreign currency
sop	frgn_deltax	Carriage tax amount - foreign currency
sop	frgn_itmsgross	Gross amount (goods but not carriage) - foreign currency
sop	frgn_itmsnet	Net amount (goods but not carriage) - foreign currency
sop	frgn_itmstax	Tax amount (goods but not carriage) - foreign currency
sop	frgn_net	Carriage net amount - foreign currency
sop	frgn_prepaid	Amount prepaid - foreign currency
sop	frgn_rate	Foreign exchange rate
sop	frgn_stlm_disc	Settlement discount amount (reduction) - foreign currency
sop	frgn_stlm_tot	Invoice total after settlement discount - foreign currency
sop	frgninv_gross	Invoice gross amount (goods and carriage gross) - foreign currency
sop	frgninv_net	Invoice net amount (goods and carriage net) - foreign currency
sop	frgninv_tax	Invoice tax amount (goods and carriage tax) - foreign currency
sop	g_dept	Global department name
sop	g_dtls	Global details
sop	g_ncd	Global nominal code
sop	g_taxcd	Global tax code (T0 to T99)
sop	id	Sales Orders, record ID
sop	inv_gross	Invoice gross amount (goods and carriage gross)
sop	inv_net	Invoice net amount (goods and carriage net)
sop	inv_no	Numeric verison of INVOICE_NUMBER (NB Not always the corresponding invoice number)
sop	inv_tax	Invoice tax amount (goods and carriage tax)
sop	itmsgross	Gross amount (goods but not carriage)
sop	itmsnet	Net amount (goods but not carriage)
sop	itmstax	Tax amount (goods but not carriage)
sop	modified	Date and time when the record was modified.
sop	net1	Net amount at highest tax rate
sop	net2	Net amount at second highest tax rate
sop	net3	Net amount at third highest tax rate
sop	net4	Net amount at fourth highest tax rate
sop	net5	Net amount at fifth highest tax rate
sop	nm	Name
sop	notes	Notes
sop	notes2	Notes 2
sop	notes3	Notes 3
sop	ntvd_desc	Net value discount description
sop	ntvd_net	Net value discount value (foreign currency)
sop	ntvd_net_base	Net value discount (base currency)
sop	ntvd_note1	Net value discount comment 1
sop	ntvd_note2	Net value discount comment 2
sop	ntvd_rate	Net value discount percentage
sop	ord_dt	Order Date
sop	ord_q	Order/Quote/Proforma label
sop	ord_tycd	Type code. 1=Quote, 2=Proforma, 3=Sales Order
sop	ordno	Order number
sop	pmt_ref	Payment reference
sop	pmt_ty	Payment Type: 0 - Already received. 3 - SR. 4 - SA.
sop	prepaid	Amount prepaid
sop	proj_id	ID of linked Project
sop	q_expdt	Quote expiry date
sop	recur_ref	Recurring entry reference
sop	req_dt	Despatch date
sop	s_alloc	Allocated status description
sop	s_desp	Despatch status description
sop	s_quote	Quote status.
sop	sid_alloc	Allocated status code
sop	sid_desp	Despatch status code. 0=Nothing despatched, 1=Part despatched, 2=Fully despatched / complete
sop	sid_quote	Quote status Id. 1=Quote, 2=Proforma, 3=Sales Order, 4=Complete / Closed
sop	stlm_days	Settlement days
sop	stlm_disc	Settlement discount amount (reduction)
sop	stlm_discr	Settlement discount % rate
sop	stlm_tot	Invoice total after settlement discount
sop	tax_amt1	Tax amount at highest tax rate
sop	tax_amt2	Tax amount at second highest tax rate
sop	tax_amt3	Tax amount at third highest tax rate
sop	tax_amt4	Tax amount at fourth highest tax rate
sop	tax_amt5	Tax amount at fifth highest tax rate
sop	tax_rate1	Highest tax rate
sop	tax_rate2	Second highest tax rate
sop	tax_rate3	Third highest tax rate
sop	tax_rate4	Fourth highest tax rate
sop	tax_rate5	Fifth highest tax rate
sop	usr	Order taken by
sop	vlu_disc_amt	Value based discount amount
sop	vlu_disc_rate	Value based percentage discount rate
sop_itm	created	Date and time when the record was created.
sop_itm	del_dt	Delivery date
sop_itm	dept_nm	Department name
sop_itm	deptno	Department number
sop_itm	disc_op	Percentage discount given by operator
sop_itm	disc_qty	Percentage discount based on qty from stock record
sop_itm	discamt	Discount amount
sop_itm	due_dt	Due date
sop_itm	ext_ord_line_ref	External Order Line Ref for SOP to Invoice Link
sop_itm	ext_ord_ref	External Order Ref for SOP to Invoice Link
sop_itm	f_automsg	True if this message was automatically generated
sop_itm	f_del	Flag denoting if the record has been deleted or not.
sop_itm	f_srv	Product or Service item flag
sop_itm	frgn_discamt	Discount amount - foreign currency
sop_itm	frgn_full_net	Full net amount (before discount) - foreign currency
sop_itm	frgn_gross	Gross amount (net after discount + tax) - foreign currency
sop_itm	frgn_net	Net amount (after discount) - foreign currency
sop_itm	frgn_tax	Tax amount - foreign currency
sop_itm	frgn_upr	Unit price - foreign currency
sop_itm	full_net	Full net amount (before discount)
sop_itm	gross	Gross amount (net after discount + tax)
sop_itm	id	Sales Quotes / Sales Order Items
sop_itm	info	Description
sop_itm	is	Intrastat commodity code
sop_itm	itm_no	Item number
sop_itm	itmid	Item ID
sop_itm	job_no	Job number
sop_itm	modified	Date and time when the record was modified.
sop_itm	ncd	Nominal code
sop_itm	negotiation_disc_net	Negotiation discount net (foreign currency)
sop_itm	negotiation_disc_net_base	Negotiation discount net (base currency)
sop_itm	net	Net amount (after discount)
sop_itm	note1	Comment 1
sop_itm	note2	Comment 2
sop_itm	ordno	Order Reference number
sop_itm	pop_itm_id	Unique pop item identifier
sop_itm	proj_id	ID of linked Project
sop_itm	qty_allocated	Quantity allocated for this order
sop_itm	qty_desp	Quantity to despatch/despatched on this delivery
sop_itm	qty_dlvrd	Quantity previously delivered for this order
sop_itm	qty_last_desp	Quantity despatched on most recent delivery
sop_itm	qty_ord	Quantity ordered
sop_itm	r_disc	Discount percentage rate
sop_itm	stkcd	Stock code
sop_itm	tax_amt	Tax amount
sop_itm	tax_rate	Tax rate
sop_itm	taxcd	Tax code (T0 to T99)
sop_itm	txt	Service item text
sop_itm	upr	Unit price
sop_itm	usale	Unit of sale
Back to Top Stock Records / Details
Table	Field	Description
stk	average_cpr	Average cost price
stk	barcd	Stock Barcode
stk	bin	Bin / location
stk	buy_ncd	Purchase nominal code
stk	buy_ref	Preferred supplier's account reference
stk	created	Date and time when the record was created.
stk	dept_nm	Department name
stk	deptno	Department number
stk	docrefs	List of document references
stk	docs	List of relative file names of documents saved on the system, 1 per line
stk	exp_deldt	Qty on order expected delivery date
stk	f_bom	Y if has components, blank if not
stk	f_cc	EU Intrastat Commodity Code
stk	f_del	Flag denoting if the record has been deleted or not.
stk	f_desc	EU Intrastat Commodity Description
stk	f_ignstk	Ignore stock level flag
stk	f_nocom	1 if has no components, 0 if contains subcomponents
stk	fav	Part of the favorite list. 0=No, 1=Favorite
stk	id	Record ID. 0=Default settings for new records
stk	isstk	Is this a stocked item? Default is 1=Yes, 0=Non Stocked Item, 2=Service
stk	last_buy_dt	Last purchase date
stk	last_buy_pr	Last purchase price
stk	last_disc_buy_pr	Last discounted purchase price
stk	last_sale_dt	Last sale date
stk	max_cpr	Maximum cost price
stk	min_cpr	Minimum cost price
stk	modified	Date and time when the record was modified.
stk	ncd	Nominal code
stk	nesting	Nesting level i.e. sub-component level. 0=No sub-components, 1=1 level of sub-components, 2=2 levels etc..
stk	notes	General Notes
stk	param1	Customer specific item parameter 1 e.g. Length, height, width
stk	param2	Customer specific item parameter 2 e.g. Length, height, width
stk	param3	Customer specific item parameter 3 e.g. Length, height, width
stk	param4	Customer specific item parameter 4 e.g. colour, texture, shape
stk	param5	Customer specific item parameter 5 e.g. colour, texture, shape
stk	param6	Customer specific item parameter 6 e.g. colour, texture, shape
stk	qty_allocated	Quantity allocated
stk	qty_in_stk	Quantity in stock
stk	qty_last_ord	Last order quantity
stk	qty_last_stk_take	Last stock take quantity
stk	qty_makeup	Makeup from quantity in stock (ignore quantity on order)
stk	qty_on_ord	Quantity on order
stk	qty_reord	Reorder quantity
stk	qty_reord_level	Reorder level
stk	sellpr	Sale price
stk	sellpr2	Sale price 2
stk	sellpr3	Sale price 3
stk	sellpr4	Sale price 4
stk	stk_cat	Stock category number
stk	stk_cat_nm	Stock category name
stk	stk_desc	Description
stk	stk_take_dt	Stock take date
stk	stkcd	Stock code
stk	stkcd2	Stock sub-code for: variant (colour, size etc..) / configuration (brass cage, steel collar etc..) of main item.
stk	su_partnum	Supplier's part number
stk	su2_partnum	Alternative Supplier's part number
stk	su2_ref	Alternative Supplier's account reference
stk	taxcd	Tax code (T0 to T99)
stk	usale	Unit of sale
stk	usedin	Number of stock items that this component is used in their assembly
stk	uwt	Unit weight
stk	w_cat1	Web Category 1
stk	w_cat2	Web Category 2
stk	w_cat3	Web Category 3
stk	w_dtls	Web Details
stk	w_img	Web Image Filename
stk	w_listed	Is published on the web
stk	w_nm	Web Description
stk	w_offer	Is on special offer on the web
stk	w_ref	Stock reference for website
stk_albin	ccdid	Cost Code Number
stk_albin	cpr	Cost Price
stk_albin	created	Date and time when the record was created.
stk_albin	dt	Allocation Date
stk_albin	dtls	Allocation Details
stk_albin	f_del	Flag denoting if the record has been deleted or not.
stk_albin	modified	Date and time when the record was modified.
stk_albin	proj_id	Project Number
stk_albin	qty_allocated	Quantity Allocated
stk_albin	qty_issued	Quantity Issued
stk_albin	ref	Allocation Reference
stk_albin	stk_albin_id	Stock Allocation Number
stk_albin	stkcd	Stock Code
stk_cat	nm	Category name
stk_cat	no	Category number
stk_disc	disc_qty	Discount break quantity
stk_disc	disc_rate	Discount Rate
stk_disc	disc_ty	Discount types: A - E
stk_disc	id	Stock Discounts
stk_disc	no	Discount number (1 - 10) for current discount type (A - E)
stk_disc	stkid	Stock Code ID, stk.id
stk_stats	bugt_qty_sold	Total expected quantity to be sold in any one month
stk_stats	bugt_sales	Total expected sales in any one month
stk_stats	costs	Total cost of items sold in any one month
stk_stats	id	Stock budgets and monthly sales statistics
stk_stats	last_yr_cost	Total cost of items sold in any one month in the previous year
stk_stats	last_yr_qty_sold	Total quantity sold in any one month in the previous year
stk_stats	last_yr_sales	Total sales for any one month in the previous year
stk_stats	mth	Period / Month 0 (Brought forward) - 13 (Months 1 - 12, 13=Future)
stk_stats	qty_sold	Total quantity sold in any one month
stk_stats	sales	Total sales for any one month
stk_stats	stkid	Stock ID, stk.id
stk_tran	change	Quantity that the stock is adjusted / changed by
stk_tran	cpr	Cost price
stk_tran	created	Date and time when the record was created.
stk_tran	currstk	Current stock level / qty in stock
stk_tran	dt	Transaction date
stk_tran	dtls	Details
stk_tran	f_del	Flag denoting if the record has been deleted or not.
stk_tran	modified	Date and time when the record was modified.
stk_tran	ref	Transaction reference
stk_tran	ref_n	Numeric verison of transaction reference
stk_tran	sellpr	Sales price
stk_tran	stkcd	Stock code
stk_tran	tran_no	Transaction number
stk_tran	ty	Transaction type
stkmanuf	dtdel	Dete of next expected delivery
stkmanuf	id	Stock by Manufacturer record id
stkmanuf	idclass	Class reference (manuf.idclass) qty for records with same idstk, idmanuf and class are summed
stkmanuf	idmanuf	Manufacturer record id, manuf.id
stkmanuf	idstk	Stock record ID, stk.id
stkmanuf	loc	Storage location / bin
stkmanuf	manufref	Manufacturer stock reference
stkmanuf	qty	Qty in stock
stkmanuf	qty_aloc	Quantity allocated
stkmanuf	qty_onord	Quantity on order
taxcd	eu_buy	Tax code is EC Purchase Tax code
taxcd	eu_sales	Tax code is EC Sales Tax code
taxcd	f_revch	Reverse charge items posted to this tax code
taxcd	id	Tax Codes, record ID
taxcd	info	Tax code description
taxcd	related_cd	Related Tax code for EC Purchase Tax code
taxcd	related_rate	Related Tax code rate for EC Purchase Tax code
taxcd	tax_rate	Tax code rate
taxcd	taxcd	Tax code (T0 to T99)
taxcd	taxcd_id	Tax code number (0 to 99)
taxcd	vat_incl	Tax code included in VAT return
tftd	id	Thought for the day, record ID
tftd	txt	Quote text
www	id	Website record details record ID
www	stkid	Stock record ID