Field Name

Description

Type

Length

thRunNo

Posting Run Number

Integer

4

thAcCode

Account Code

Lstring

11

idxAcCode

Account Code

String

6

thAutoNom

Logical

1

thOurRef

Our Ref

Lstring

11

thIdxDocCode

String

1

idxOurRef

Our Ref

String

10

thFolio

Folio Number

Integer

4

idxFolio

Folio Number (index)

Integer

4

thCurrency

Currency

Integer

1

thYear

Year 2 Digit

Integer

1

thIdxYearPeriod

String

2

thPeriod

Period

Integer

1

thDueDate

Due Date

Date

8

thIdxDueDate

Due Date

Date

8

thVATDate

Date of the last day the VAT return

VAT Date

Date

8

thIdxVATDate

VAT Date

Date

8

thTransDate

Transaction Date

Date

8

thIdxTransDate

Transaction Date

Date

8

thCustSupp

C/S

String

1

idxAcType

Account Type

String

1

thCompanyRate

Company Rate

Float

thDailyRate

Daily Rate

Float

2

thOLDYourRef

Your Reference (No longer used)

String

10

thIdxOLDYourRef

Your Reference (No longer used)

String

10

thBatchLink

Batch Entry Link

String

12

thIdxBatchLink

Batch Entry Link

String

12

thAllocStat

Allocated Status

String

1

thDoctype & tlDoctype

Transaction type

Integer

1

thVAT_Standard

VAT Amount (S)

Float

thVAT_Exempt

VAT Amount (E)

Float

thVAT_Zero

VAT Amount (Z)

Float

thVAT_Rate1

VAT Amount (1)

Float

thVAT_Rate2

VAT Amount (2)

Float

thVAT_Rate3

VAT Amount (3)

Float

thVAT_Rate4

VAT Amount (4)

Float

thVAT_Rate5

VAT Amount (5)

Float

thVAT_Rate6

VAT Amount (6)

Float

thVAT_Rate7

VAT Amount (7)

Float

thVAT_Rate8

VAT Amount (8)

Float

thVAT_Rate9

VAT Amount (9)

Float

thVAT_RateT

VAT Amount (T)

Float

thVAT_RateX

VAT Amount (X)

Float

thVATRate_B

VAT Amount (B)

Float

thVATRate_C

VAT Amount (C)

Float

thVATRate_F

VAT Amount (F)

Float

thVATRate_G

VAT Amount (G)

Float

thVATRate_R

VAT Amount (R)

Float

thVATRate_W

VAT Amount (W)

Float

thVATRate_Y

VAT Amount (Y)

Float

thNetValue

Net Value

Float

thTotalVAT

Total VAT

Float

thSettlePerc

Settlement Percentage

Float

thTotSettleDisc

Total Settlement Discount

Float

thTotLineDisc

Total Line Discount1

Float

thDiscDays

Discount Days also Timesheet week number

Integer

2

thDiscTaken

Settlement Discount Taken Y/N

Logical

1

thSettled

Amount Settled

Float

thAutoIncUnit

Integer

2

thAutoYear

Integer

1

thAutoPeriod

Integer

1

thSSDTransNat

A two digit code made up as follows:-

Digit 1

Digit2:-

Intrastat Transport Nature

Integer

1

thSSDTransMode

1 Sea. Road transport crossing by sea

2 Rail

3 Road

4 Air

5 Post

6 Not Allocated

7 Fixed Installation (ie channel Tunnel)

8 Inland Waterway

9 Own Propulsion

Intrastat Transport Mode

Integer

1

thRemitRef

Lstring

11

thAutoUnits

String

1

thHold

0    = No Hold

1    = Query

2    = Hold Until Allocated

3    = Authorise Payment

4    = Hold for any stock

5    = Hold for all stock

32  = Notes on Transaction

128 = Suspend  

Hold Status

Integer

1

thTotalWeight

Total Weight

Float

thDelAddr1

Delivery Address Line 1

Lstring

31

thDelAddr2

Delivery Address Line 2

Lstring

31

thDelAddr3

Delivery Address Line 3

Lstring

31

thDelAddr4

Delivery Address Line 4

Lstring

31

thDelAddr5

Delivery Address Line 5

Lstring

31

thCurrVar

Float

thTotal1

Float

thTotal2

Float

thTotalCost

Float

thTotalInvoiced

Float

thYourRefLong

Alt Your Reference

Float

20

thIdxYourRefLong

Alt Your Reference

String

20

thAutoUntil

Auto Daybook "repeat until"

Date

8

thExternal

External Transaction Flag

Logical

1

thPrinted

Printed Flag 0 yes 1 no

Logical

1

thCurrVariance

Float

thAmtSettled

Float

thSettledVAT

Float

thVATClaimed

Float

thBatchPayGL

Integer

4

thAutoPost

Logical

1

thManualVAT

Manual VAT Flag

Logical

1

thSSDDelTerms

EXW        = Ex Works

FOB        = Free On Board at port of departure

CIF        = Cost/Insurance/Freight at port of arrival

DDU        = Delivered Domicile(fully Delivered)

DDP        = Delivered Domicile(fully Delivered)

XXX        = Other

In Loc Transfer on ADJ

Lstring

4

thUser

Lstring

11

thNoLabels

Number of Labels

Integer

2

thTagged

Tagged (Y/N)

Logical

1

thPickRunNo

Pick Run Number

Integer

4

thOrderMatch

Logical

1

thDelivNote

Lstring

11

thVATCompRate

VAT Company Rate

Float

thVATDailyRate

VAT Daily Rate

Float

thOrigCompRate

Original Company Rate

Float

thOrigDailyRate

Original Daily Rate

Float

thPostDiscAmt

Posted Discount Amount

Float

thPostDiscTaken

Posted Discount Taken Flag

Logical

1

thDrCrGL

Integer

4

thJobCode

Job Code

Lstring

11

thJobAnal

Analysis Code

Lstring

11

thOutstOrder

Integer

2

thOutstOrder_2

Integer

4

thUser1

User Defined Field 1

Lstring

31

thUser2

User Defined Field 2

Lstring

31

thLineType1

Transaction Line Type 1 Total

Float

8

thLineType2

Transaction Line Type 2 Total

Float

8

thLineType3

Transaction Line Type 3 Total

Float

8

thLineType4

Transaction Line Type 4 Total

Float

8

thLineType5

Transaction Line Type 5 Total

Float

8

thLineType6

Transaction Line Type 6 Total

Float

8

thDebtChaseNo

Debt Chase Letter Number

Integer

1

thBatOwnSettl

Float

8

thBatPaySettl

Float

8

thBatUntagged

Logical

1

thUser3

User Defined Field 3

Lstring

31

thUser4

User Defined Field 4

Lstring

31

thProcess

String

1

thSource

Integer

1

thMainTriRate

Float

8

thMainTriEuro

Integer

1

thMainTriInvert

Logical

1

thMainTriFloat

Logical

1

thMainTriSpare

String

10

thVATTriRate

Float

8

thVATTriEuro

Integer

1

thVATTriInvert

Logical

1

thVATTriFloat

Logical

1

thVATTriSpare

String

10

thOrigTriRate

Float

8

thOrigTriEuro

Integer

1

thOrigTriInvert

Logical

1

thOrigTriFloat

Logical

1

thOrigTriSpare

String

10

thPreEuroTriRate

Float

8

thPreEuroTriEuro

Integer

1

thPreEuroTriInvert

Logical

1

thPreEuroTriFloat

Logical

1

thPreEuroTriSpare

String

10

thPostDate

Date Posted

Date

8

thPORPickSOR

Logical

1

thBatchDiscAmount

Float

8

thPrePost

Integer

1

thAuthorisedAmount

Float

8

thTimeChanged

Lstring

7

thTimeCreated

Lstring

7

thCISTaxDue

CIS Tax Due

Float

8

thCISTaxDeclared

CIS Tax declared on Voucher

Float

8

thCISManualTax

CIS Manual Tax

Logical

1

thCISDate

CIS Date

Date

8

thTotalCostApport

Float

8

thCISEmployee

CIS Employee code

Lstring

11

thCISTotalGross

CIS Gross Total

Float

8

thCISSource

CIS Source

Integer

1

thExported

Exported Flag

Logical

1

thCISGrossExclude

Float

8

thSpare

Future Use

String

64

thYourRefLB

Not Used

String

1

thYourRef

Your Reference (v6.00)

String

20

thIdxYourRef

Your Reference (v6.00)

String

20

thSpare3

Future Use

String

255

thSpare4

Future Use

String

255

thSpare5

Future Use

String

255

thSpare6

Future Use

String

35