Tag Name
|
Data Type
|
Description
|
Important Fields:
|
TLStock^
|
Text 30 O
|
Stock Code In Cell Searching values in table ProdCodeNoDesc
|
TLDesc
|
Text 60 IO
|
Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
|
TLQty^
|
Double O
|
Quantity. PRO - If switch `Iignore ZERO qty` ignores any lines with zero qty. This allows a long product list to be listed, and user simply edit a qty to book IN/OUT Changes in this cell will recalc other cells. Delete ^ to disable this calculation.
|
TLQtyAlloc^
|
Text 20 O
|
Qty to Allocate on Sales Order. Overrides 'Allocate Available Stock' switch in system settings, if not blank. If not enough Free stock then Allocates max amount allowed. Changes in this cell will recalc other cells. Delete ^ to disable this calculation.
|
TLUnitPrice^
|
Currency IO
|
Unit Price for each item. If cell is blank then PostTrans will lookup customer price on change of Qty, or adding a product. System switches can control if this value is used and how it is updated. PRO - If multi-currency is ON will be in account currency. Changes in this cell will recalc other cells. Delete ^ to disable this calculation.
|
TLFulfilment^
|
Integer SO
|
Fulfilment from stock by default. SOP Only In Cell Searching values:Fulfilment from 0, Stock 1, Supplier via Stock 2, Supplier Direct
|
Other:
|
TLDiscPerc^
|
Double O
|
Sales:Additional Discount Percent to be applied to TLUnitPrice. Note TLUnitPrice has already had any system discount applied on account record. Changes in this cell will recalc other cells. Delete ^ to disable this calculation.
|
TLLoc^
|
Text 20 O
|
Location. Ignored if warehouses are off In Cell Searching values in table Loc
|
Nom Analysis:
|
TLNomCode^
|
Text 16 IO
|
Line Nominal, set to stock or account defaults if obmitted. Can be NOM/CC/DEP In Cell Searching values in table Nom
|
UOM:
|
TLQtyMul^
|
Double O
|
Qty Multiplier set by unit of meaure In Cell Searching values in table 0, Stock, 1, Supplier via Stock, 2, Supplier Direct
|
TLUOM^
|
Text 20 O
|
Unit of Measure for Stock Item. SOP Only In Cell Searching values in table 0, Stock, 1, Supplier via Stock, 2, Supplier Direct
|
Other Values:
|
TLCostPrice
|
Currency O
|
Stock Cost Price. Standard, Average Cost. If Serial Batch/FIFO then returns Average.
|
TLTotCost
|
Currency O
|
Total Cost Price, TLQty * PrCostPrice calculated with discount. Allows formula to cost Transaction to get Margin. PRO - If multi-currency is ON will be in account currency.
|
TLTotIncluOfTax
|
Currency IO
|
Line Total inclusive of Tax (Only SO,SI,SC,PI,PC). PostTrans will calculate Tax and Unit Price back from Inclusive Tax Total for Line given Qty and overcome rounding problems. Best choice when importing data as reduces rounding problems. Sage V17 onwards
|
Line Type:
|
TLAddChType^
|
Text 20 O
|
Additional Charge Type, if not specified then set to "Carriage" In Cell Searching values in table OPAddCharge
|
TLLineType^
|
Text 2 O
|
Line Type. This controls the Line type, which defaults to Standard item if stock, else FreeText Default specified in system settings, if line has a value, but no TLStock. If line has no value, then the TLDesc will be imported as INV/Order Comment.
If Transaction is a "Service" transaction then line type is FreeTextConfirmationNotRequired In Cell Searching values:Line Type ST, Standard FG, FreeTextWithGoods FS, FreeTextAsService FN, FreeTextConfirmationNotRequired AC, AdditionalChargeLine CI, Comment INV/ORD CO, Comment Picking
|
TLPickListComment
|
Text 160 O
|
Comment on Picking List
|
TLDispatchListComment
|
Text 160 O
|
Comment on Dispatch
|
Tax:
|
TLTaxManTotAmount
|
Currency I
|
Tax Amount, for line, if calculated manually. Use with Caution as you are responsible for calculating Tax correctly.
|
TLTaxCode^
|
Text 2 IO
|
Tax Code:0=0%,1=Standard Rate, etc In Cell Searching values in table Tax
|
Serial Batch:
|
TLBatSerial^
|
Text 30 O
|
Batch Ref or for Serial then a comma seperated list or list with each on new line. SO only In Cell Searching values in table TranTLBatSerial
|
TLSellByDate
|
Date O
|
Sell by date of Batch
|
TLUseByDate
|
Date O
|
Use by date of Batch
|
TLBatSerRef
|
Text 30 O
|
Additional ref for Batch
|
Important Header Fields:
|
THTransType^
|
Text 3 Head IO
|
Transaction Type. Make sure the format of the cell is “General” else search may not work properly. Must be specified on each line. Service orders allow simple free text Orders to be imported with not dispatch confirmation needed. In Cell Searching values:Transaction Type SQ, Sales Quote SP, Proforma SO, Sales Order SSO, Sales Service Order SI, Sales Invoice SIM, Sales Invoice Module SIA, Sales Invoice And Adj OUT SSI, Sales Service Invoice SC, Sales Credit SCM, Sales Credit Module SOB, Sales Opening Bal SOC, Sales Opening Bal Credit SR, Sales Receipt PO, Purchase Order PSO, Purchase Service Order PI, Purchase Invoice PIA, Purchase Invoice and Adj OUT PC, Purchase Credit POB, Purchase Open Balance POC, Purchase Open Balance
|
THManDocRef
|
Text 30 Head O
|
Manual ref if manual Reference in sage 200 is ON
|
THAccCode^
|
Text 8 Head IO
|
Transaction Account Code. Customer or Supplier depending on Transaction Type. DOUBLE CLICK to see ledger In Cell Searching values in table THAccCode
|
THTransDate
|
Date Head IO
|
Transaction Date
|
THDueDelDate
|
Date Head IO
|
Delivery Date on Order, Expire Date on Quote.
|
THPromDelDate
|
Date Head IO
|
Promised Delivery date on SO,SQ, SP
|
THRoundToGross
|
Double Head I
|
When importing Financial Invoice/Credits (SI/SC/PI/PC). Round highest VAT figure to make Transaction this Gross value, with 5p limit
|
Header Text:
|
THCustRef
|
Text 30 Head IO
|
Suppliers/Customer`s Order Number, 10 chars long on PI/SI
|
THCustRef2
|
Text 30 Head I
|
Customer`s Order Number, 10 chars long on PI/SI
|
THDefaultLoc^
|
Text 20 Head O
|
Default Location for all entered lines. Ignored if warehouses are off In Cell Searching values in table Loc
|
THOrderPriority
|
Text 1 Head O
|
Order Priority A-Z
|
CASH Invoice Address:
|
THInvName
|
Text 60 Head O
|
Invoice name if Cash account
|
THInvAdd1
|
Text 60 Head O
|
Invoice Add1 if Cash account
|
THInvAdd2
|
Text 60 Head O
|
Invoice Add2 if Cash account
|
THInvAdd3
|
Text 60 Head O
|
Invoice Add3 if Cash account
|
THInvAdd4
|
Text 60 Head O
|
Invoice Add4 if Cash account
|
THInvPostcode^
|
Text 60 Head O
|
Invoice Postcode if Cash account In Cell Searching values in table SimplyPostcode
|
CASH Segmented Address:
|
THInvCity
|
Text 60 Head O
|
Invoice City if Cash account
|
THInvCounty
|
Text 60 Head O
|
Invoice County if Cash account
|
THInvCountry^
|
Text 60 Head O
|
Invoice Country if Cash account In Cell Searching values in table CountryCode
|
Currency:
|
THCurExch
|
Double Head IO
|
Currency Exchange Rate. Normally uses System Exchange Rate, unless option changed in PostTrans system settins
|
THSetDisc
|
Double Head IO
|
Settlement Disc
|
THSetDays
|
Integer Head IO
|
Settlement Days
|
Delivery Address:
|
THDelContact
|
Text 60 Head O
|
Delivery Address Contact Name. Double click to change delivery address
|
THPostalName
|
Text 60 Head O
|
Delivery PostalName
|
THDelAdd1
|
Text 60 Head O
|
Delivery Address Line 1. Double click to change delivery address. On PO is the direct delivery address
|
THDelAdd2
|
Text 60 Head O
|
Delivery Address Line 2. Double click to change delivery address
|
THDelAdd3
|
Text 60 Head O
|
Delivery Address Line 3. Double click to change delivery address. On PO is the direct delivery address
|
THDelAdd4
|
Text 60 Head O
|
Delivery Address Line 4. Double click to change delivery address
|
THDelPostcode^
|
Text 60 Head O
|
Delivery Postcode. PRO -If Postcode Search is enabled in ‘Setup >> Lookup >> Address Lookup’ then enter Space or Space + Postcode to search for an address. In Cell Searching values in table SimplyPostcode
|
THDelEmail
|
Text 255 Head O
|
Delivery email address. PRO - Can be mapped it e-mail Quote/Invoice or Order.
|
THDelTelNo
|
Text 60 Head O
|
Delivery email address. PRO - Can be mapped it e-mail Quote/Invoice or Order.
|
THDelFaxNo
|
Text 60 Head O
|
Delivery email address. PRO - Can be mapped it e-mail Quote/Invoice or Order.
|
Delivery Address Segmented Address:
|
THDelCountry^
|
Text 60 Head O
|
Delivery email address. PRO - Can be mapped it e-mail Quote/Invoice or Order. In Cell Searching values in table CountryCode
|
THDelCity
|
Text 60 Head O
|
Delivery Address City. Double click to change delivery address
|
THDelCounty
|
Text 60 Head O
|
Delivery Address County. Double click to change delivery address
|
Project on Line:
|
TLProject^
|
Text 20 IO
|
Project code, overides THProject Can also be Project"/"Phase to book to specific Project Item In Cell Searching values in table ProjectCode
|
TLPhaseFilter^
|
Text 30
|
Phase Filter. If project has duplicate Project items in different phases, this can direct to correct Phase Sage V21 onwards In Cell Searching values in table PROJECTPHASE
|
TLCostCode^
|
Text 20 IO
|
Cost Code, overides THCostCode In Cell Searching values in table ProjectCostCode
|
Header Discount:
|
Header Payment:
|
THPayAmt
|
Double Head IO
|
Amount Prepaid. If used in lines then Sum is posted. Option in `Setup >> Switches’, can stop posting if UNDER or OVER paid
|
THPayRef
|
Text 30 Head IO
|
Payment Reference
|
THBankAccList
|
Text HeadOnly
|
When posting Payments a List of Currency Code, Bank Account to use. E.g ‘GBP,1,EUR,2,USD,3’
|
THPayMethod^
|
Text 30 Head IO
|
Payment Method In Cell Searching values in table PaymentMethod
|
Header Analysis:
|
THAnal1^
|
Text 60 Head IO
|
Header Analysis 1 for SO, PO and Invoice Module Sage V2015 onwards In Cell Searching values in table AnalTrans01
|
THAnal2^
|
Text 60 Head IO
|
Header Analysis 2 Sage V2015 onwards In Cell Searching values in table AnalTrans02
|
THAnal3^
|
Text 60 Head IO
|
Header Analysis 3 Sage V2015 onwards In Cell Searching values in table AnalTrans03
|
THAnal4^
|
Text 60 Head IO
|
Header Analysis 4 Sage V2015 onwards In Cell Searching values in table AnalTrans04
|
THAnal5^
|
Text 60 Head IO
|
Header Analysis 5 Sage V2015 onwards In Cell Searching values in table AnalTrans05
|
THAnal6^
|
Text 60 Head IO
|
Header Analysis 6 Sage V2015 onwards In Cell Searching values in table AnalTrans06
|
THAnal7^
|
Text 60 Head IO
|
Header Analysis 7 Sage V2015 onwards In Cell Searching values in table AnalTrans07
|
THAnal8^
|
Text 60 Head IO
|
Header Analysis 8 Sage V2015 onwards In Cell Searching values in table AnalTrans08
|
THAnal9^
|
Text 60 Head IO
|
Header Analysis 9 Sage V2015 onwards In Cell Searching values in table AnalTrans09
|
THAnal10^
|
Text 60 Head IO
|
Header Analysis 10 Sage V2015 onwards In Cell Searching values in table AnalTrans10
|
THAnal11^
|
Text 60 Head IO
|
Header Analysis 11 Sage V2015 onwards In Cell Searching values in table AnalTrans11
|
THAnal12^
|
Text 60 Head IO
|
Header Analysis 12 Sage V2015 onwards In Cell Searching values in table AnalTrans12
|
THAnal13^
|
Text 60 Head IO
|
Header Analysis 13 Sage V2015 onwards In Cell Searching values in table AnalTrans13
|
THAnal14^
|
Text 60 Head IO
|
Header Analysis 14 Sage V2015 onwards In Cell Searching values in table AnalTrans14
|
THAnal15^
|
Text 60 Head IO
|
Header Analysis 15 Sage V2015 onwards In Cell Searching values in table AnalTrans15
|
THAnal16^
|
Text 60 Head IO
|
Header Analysis 16 Sage V2015 onwards In Cell Searching values in table AnalTrans16
|
THAnal17^
|
Text 60 Head IO
|
Header Analysis 17 Sage V2015 onwards In Cell Searching values in table AnalTrans17
|
THAnal18^
|
Text 60 Head IO
|
Header Analysis 18 Sage V2015 onwards In Cell Searching values in table AnalTrans18
|
THAnal19^
|
Text 60 Head IO
|
Header Analysis 19 Sage V2015 onwards In Cell Searching values in table AnalTrans19
|
THAnal20^
|
Text 60 Head IO
|
Header Analysis 20 Sage V2015 onwards In Cell Searching values in table AnalTrans20
|
Spare:
|
THSpareTxt1
|
Text 60 Head IO
|
SpareTxt1
|
THSpareTxt2
|
Text 60 Head IO
|
SpareTxt2
|
THSpareTxt3
|
Text 60 Head IO
|
SpareTxt3
|
THSpareBit1
|
Yes/NoTF Head IO
|
SpareBit1
|
THSpareBit2
|
Yes/NoTF Head IO
|
SpareBit2
|
THSpareBit3
|
Yes/NoTF Head IO
|
SpareBit3
|
THSpareNo1
|
Integer Head IO
|
SpareNo1
|
THSpareNo2
|
Integer Head IO
|
SpareNo2
|
THSpareNo3
|
Integer Head IO
|
SpareNo3
|
THSpareDate1
|
Date Head IO
|
SpareDate1
|
THSpareDate2
|
Date Head IO
|
SpareDate2
|
THSpareDate3
|
Date Head IO
|
SpareDate3
|
Line Analysis:
|
TLAnal1
|
Text 60 IO
|
Header Analysis 1 Sage V2015 onwards
|
TLAnal2
|
Text 60 IO
|
Header Analysis 2 Sage V2015 onwards
|
TLAnal3
|
Text 60 IO
|
Header Analysis 3 Sage V2015 onwards
|
TLAnal4
|
Text 60 IO
|
Header Analysis 4 Sage V2015 onwards
|
TLAnal5
|
Text 60 IO
|
Header Analysis 5 Sage V2015 onwards
|
TLAnal6
|
Text 60 IO
|
Header Analysis 6 Sage V2015 onwards
|
TLAnal7
|
Text 60 IO
|
Header Analysis 7 Sage V2015 onwards
|
TLAnal8
|
Text 60 IO
|
Header Analysis 8 Sage V2015 onwards
|
TLAnal9
|
Text 60 IO
|
Header Analysis 9 Sage V2015 onwards
|
TLAnal10
|
Text 60 IO
|
Header Analysis 10 Sage V2015 onwards
|
TLAnal11
|
Text 60 IO
|
Header Analysis 11 Sage V2015 onwards
|
TLAnal12
|
Text 60 IO
|
Header Analysis 12 Sage V2015 onwards
|
TLAnal13
|
Text 60 IO
|
Header Analysis 13 Sage V2015 onwards
|
TLAnal14
|
Text 60 IO
|
Header Analysis 14 Sage V2015 onwards
|
TLAnal15
|
Text 60 IO
|
Header Analysis 15 Sage V2015 onwards
|
TLAnal16
|
Text 60 IO
|
Header Analysis 16 Sage V2015 onwards
|
TLAnal17
|
Text 60 IO
|
Header Analysis 17 Sage V2015 onwards
|
TLAnal18
|
Text 60 IO
|
Header Analysis 18 Sage V2015 onwards
|
TLAnal19
|
Text 60 IO
|
Header Analysis 19 Sage V2015 onwards
|
TLAnal20
|
Text 60 IO
|
Header Analysis 20 Sage V2015 onwards
|
Line Spare:
|
TLSpareTxt1
|
Text 60 IO
|
SpareTxt1
|
TLSpareTxt2
|
Text 60 IO
|
SpareTxt2
|
TLSpareTxt3
|
Text 60 IO
|
SpareTxt3
|
TLSpareBit1
|
Yes/NoTF IO
|
SpareBit1
|
TLSpareBit2
|
Yes/NoTF IO
|
SpareBit2
|
TLSpareBit3
|
Yes/NoTF IO
|
SpareBit3
|
TLSpareNo1
|
Integer IO
|
SpareNo1
|
TLSpareNo2
|
Integer IO
|
SpareNo2
|
TLSpareNo3
|
Integer IO
|
SpareNo3
|
TLSpareDate1
|
Date IO
|
SpareDate1
|
TLSpareDate2
|
Date IO
|
SpareDate2
|
TLSpareDate3
|
Date IO
|
SpareDate3
|
ObjectStore Mappings Lines:
|
ObjectStore Mappings:
|
THUser1
|
Text 30 Head IO
|
10 user defined fields which can be mapped to Sage ObjectStore Builder customisations
|
THUser2
|
Text 30 Head IO
|
User2
|
THUser3
|
Text 30 Head IO
|
User3
|
THUser4
|
Text 30 Head IO
|
User4
|
THUser5
|
Text 30 Head IO
|
User5
|
THUser6
|
Text 30 Head IO
|
User6
|
THUser7
|
Text 30 Head IO
|
User7
|
THUser8
|
Text 30 Head IO
|
User8
|
THUser9
|
Text 30 Head IO
|
User9
|
THUser10
|
Text 30 Head IO
|
User10
|
TLUser1
|
Text 30 IO
|
10 user defined fields which can be mapped to Sage ObjectStore Builder customisations for SO/PO Standard Lines and SI/PI lines
|
TLUser2
|
Text 30 IO
|
User2
|
TLUser3
|
Text 30 IO
|
User3
|
TLUser4
|
Text 30 IO
|
User4
|
TLUser5
|
Text 30 IO
|
User5
|
TLUser6
|
Text 30 IO
|
User6
|
TLUser7
|
Text 30 IO
|
User7
|
TLUser8
|
Text 30 IO
|
User8
|
TLUser9
|
Text 30 IO
|
User9
|
TLUser10
|
Text 30 IO
|
User10
|
TLUser11
|
Text 30 IO
|
10 user defined fields which can be mapped to Sage ObjectStore Builder customisations for SO/PO Free Text Lines
|
TLUser12
|
Text 30 IO
|
TLUser12
|
TLUser13
|
Text 30 IO
|
TLUser13
|
TLUser14
|
Text 30 IO
|
TLUser14
|
TLUser15
|
Text 30 IO
|
TLUser15
|
TLUser16
|
Text 30 IO
|
TLUser16
|
TLUser17
|
Text 30 IO
|
TLUser17
|
TLUser18
|
Text 30 IO
|
TLUser18
|
TLUser19
|
Text 30 IO
|
TLUser19
|
TLUser20
|
Text 30 IO
|
TLUser20
|
TLUser21
|
Text 30 IO
|
10 user defined fields which can be mapped to Sage ObjectStore Builder customisations for SO/PO Aditional Charge
|
TLUser22
|
Text 30 IO
|
TLUser22
|
TLUser23
|
Text 30 IO
|
TLUser23
|
TLUser24
|
Text 30 IO
|
TLUser24
|
TLUser25
|
Text 30 IO
|
TLUser25
|
TLUser26
|
Text 30 IO
|
TLUser26
|
TLUser27
|
Text 30 IO
|
TLUser27
|
TLUser28
|
Text 30 IO
|
TLUser28
|
TLUser29
|
Text 30 IO
|
TLUser29
|
TLUser30
|
Text 30 IO
|
TLUser30
|
TLUser31
|
Text 30 IO
|
10 user defined fields which can be mapped to Sage ObjectStore Builder customisations for SO/PO Comment Line
|
TLUser32
|
Text 30 IO
|
TLUser32
|
TLUser33
|
Text 30 IO
|
TLUser33
|
TLUser34
|
Text 30 IO
|
TLUser34
|
TLUser35
|
Text 30 IO
|
TLUser35
|
TLUser36
|
Text 30 IO
|
TLUser36
|
TLUser37
|
Text 30 IO
|
TLUser37
|
TLUser38
|
Text 30 IO
|
TLUser38
|
TLUser39
|
Text 30 IO
|
TLUser39
|
TLUser40
|
Text 30 IO
|
TLUser40
|
All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.