Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Transaction Lines
Previous pageReturn to chapter overviewNext page

The Transaction Lines table stores the Transaction Line information for Invoices.

Relational Links

The Transaction Lines are linked relationally to their Transaction Header record using the idxFolio field which is in both tables. For each Transaction Header record there can be zero or more Transaction Line Records.

 

Field Name

Description

Type

Length

tlFolio

Folio Number

Integer

4

idxFolio

Folio Number

Integer

4

tlLinePos

Line Position

Integer

4

thRunNo

 

 

0

All current daybook transactions

>=1

Posted transactions

-1/-2

Automatic daybook transactions

-5

Paying in control identifier

-10

Member of a batch

-11

Poated batch header record

-30

Posted stock adjustment record

-35

TSH daybook posted

-40

SOP Daybook Unposted (Outstanding)

-41

SOP Daybook Auto(unposted)

-42

SOP Daybook Posted(History)

-50

POP Daybook Unposted (Outstanding)

-51

POP Daybook Auto(unposted)

-52

POP Daybook Auto(unposted)

-60

WOR Daybook Unposted

-62

WOR Daybook Posted

-115

JSA Daybook Unposted

-116

JSA Daybook Posted

-118

JPA Daybook Unposted

-119

JPA Daybook Posted

-125

SRN Daybook Unposted

-126

SRN Daybook Posted

-128

PRN Daybook Unposted

-129

PRN Daybook Posted

 

 

Run Number

Integer

4

tlGLCode

 

For ODBC reporting purposes this filed should

be type casted or converted to a string

For SOP/POP transactions

 

Integer

4

tlIdxNomPeriod

 

String

4

tlShowInGL

 

Logical

1

tlIdxCcyYrPr

 

String

3

tlCurrency

Line Currency

Integer

1

tlYear

 

Integer

1

tlPeriod

 

Integer

1

tlDepartment

Department

String

3

tlCostCentre

Cost Centre

String

3

tlStockCode

Stock Code

Lstring

21

IdxStockCode

 

On PPY/SRC type transactions this is the Pay In Ref

Stock Code

String

16

tlIdxStockCode

Stock Code

String

20

tlLineNo

Line Number in Record

Integer

4

idxLineNo

Line Number in Record

Integer

4

tlLineClass

 

String

1

tlDocType

Transaction type

Integer

1

tlQty

Quantity

Float

 

tlQtyMul

Quantity Multiplier

Float

 

tlNetVal

Net Total

Float

 

tlDiscount

Discount

Float

 

tlVATCode

VAT Code

String

1

tlVATAmt

Line VAT Amount

Float

 

tlPayStatus

Payment Line Flag

String

1

tlPrevGLBal

 

Integer

2

tlRecStatus

Line Status

Integer

1

tlDiscFlag

Discount Flag

String

1

tlQtyWOff

Qty Written Off

Float

 

tlQtyDel

Qty Delivered

Float

 

tlCost

Cost

Float

 

tlAcCode

Account Code

Lstring

11

tlIdxAcCode

Account Code

String

10

idxAcCode

Account Code

String

6

tlTransDate

Transaction Date

String

8

tlIdxTransDate

Transaction Date

String

8

tlItemNo

Item Number

Lstring

4

tlDescr

Description

Lstring

61

tlJobCode

Job Code

String

10

tlJobAnal

Analysis Code

String

10

tlCompanyRate

Company Exchange Rate

Float

 

tlDailyRate

Daily Exchange Rate

Float

 

tlUnitWeight

Weight

Float

 

tlStockDeductQty

 

Float

 

tlStockDeductQty_2

 

Integer

4

tlBOMKitLink

BOM Kit Link

Integer

4

tlOrderFolio

Order Folio Number

Integer

4

tlOrderLineNo

Order Line Number

Integer

4

tlLocation

Location Code

Lstring

4

IdxLocCode

Location Code

String

3

tlQtyPicked

Line Qty Picked

Float

 

tlQtyPickedWO

Line Quantity Written Off

Float

 

tlUseQtyMul

Use Quantity Multiplier Flag

Logical

1

tlNoSerialNos

Number of Serial Numbers 1

Float

 

tlCOSGL

General Ledger Code

Integer

4

tlOurRef

Our Ref

String

10

tlLineType

Line Type

Integer

1

tlPriceByPack

 

Logical

1

tlQtyInPack

 

Float

8

tlClearDate

 

String

8

tlUser1

User Defined Field 1

Lstring

31

tlUser2

User Defined Field 2

Lstring

31

tlUser3

User Defined Field 3

Lstring

31

tlUser4

User Defined Field 4

Lstring

31

tlB2BLinkFolio

Back-To-Back Order Folio

Integer

4

tlB2BLineNo

Back-To-Back Order Line No

Integer

4

tlUseLine

 

Logical

1

tlCOSConvRate

 

Float

8

tlIncNetValue

 

Float

8

tlAutoLineType

 

Integer

1

tlCISRateCode

 

String

1

tlCISRate

 

Float

8

tlCostApport

 

Float

8

tlNOMIOFlg

Vat Flag for Nominal Transfers

Integer

1

tlBinQty

 

Float

8

tlCISAdjustment

CIS Adjustment

Float

8

tlDeductType

Deduction Type

Integer

1

tlSerialReturnQty

Serial/Batch Returned Quantity

Float

8

tlBinReturnQty

Bin Returned Quantity

Float

8