Comprehensive Transaction Reference GLT
Click here to see this page in full context

Comprehensive GLT Transaction Reference

This comprehensive reference table maps the details within the general ledger transaction file (GLT.DBF)

Payroll

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

 Ware house Job Stage Job Trans

Expense transaction for each detail line

Pe

pytmdet->gl_code

Line Date

Pay period

Work code

 

PYT

Employee name

Pay for line

D

Employee ID

 

 

 

Hours

(JC) "SO "+ Date

"H" or "U" - hours or units

   Job ID Job Stage E

Payroll payable for each detail line

PE

Payroll payable

Line date

Pay period

Work code

W  
assigned in post

PYT

Employee name

Pay for line

C

Employee ID

 

False

 

Hours

Pay level

"H" or "U" - hours or units

        

Makeup pay expense transaction

PM

pytm-> makeup_pay

Pay period

Pay period

 

 

PYT

Employee name

Makeup pay

D

Employee ID

 

False

 

 

 

 

        

Payroll payable for Makeup pay

Pm

Payroll payable

Pay period

Pay period

 

 

PYT

Employee name

Makeup pay

C

Employee ID

 

False

 

 

 

 

        

Check pay for net pay

PC

Bank acnt or cash

Pay date

 

Check# + timestamp

C

PYP

Employee name

Net pay

C

Employee ID

Date Check Register was printed

False

 

 

 

 

        

Direct deposit of net pay

PD

Bank acnt or cash

Pay date

 

Check# + timestamp

C

PYP

"Payroll direct deposit"

Net pay

C

 

Date Check Register was printed

False

 

 

 

 

        

Payroll payable for take home tips

PA

Payroll payable

Pay date

Pay period

Work code

W

 assigned in post

PYT

Employee name

Pay for line

C

Employee ID

 

False

 

 

Pay level

 

        

Payroll payable for payment

PB

Payroll payable

Pay date

Pay period

Check# + timestamp

C

PYP

Employee name

Gross pay

D

Employee ID

 

False

 

Work weeks

Bank GL Account

 

        

Payroll payable for gross ups

PU

Payroll payable

Pay date

Pay period

Gross up ID

 

PYT

Employee name

Gross up amt

C

Employee ID

 

False

 

Taxable Gross

Gross pay

"E" or "C"

        

Liability transaction for taxes

PT

Payroll tax/deduction

Pay date

Pay period

Tax ID

T

PYT

Employee name

Tax amount

C

Employee ID

 

False

 

Taxable Gross

Gross pay

"E" or "C"

        

liability transaction for gross up

Pt

Payroll tax/deduction

Pay date

Pay period

Gross up ID

T

PYT

Employee name

Gross up amt

D

Employee ID

 

False

 

Taxable Gross

Gross pay

"E" or "C"

        

Expense Transaction for company taxes

PV

pyemptx->exp_gl

Pay date

Pay period

Tax ID

 

PYT

Employee name

Tax amount

D

Employee ID

 

 

 

 

 

 

        

 

Sales

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Void deposit transaction

Gr

GL Code

Process date

 

 

 

ARD

Voided deposit

-Amt

D

 

 

 

 

 

 

 

 

 

 

 

Void deposit transaction

GR

GL Code

Process date

 

 

 

ARD

Voided deposit

-Amt

C

 

 

 

 

 

 

 

 

 

 

 

Cash transaction for voided check

SV

Bank account

Void date

 

Check number + timestamp

D

ARP

Customer name

Previous amount

D

ID

 

 

 

 

 

 

 

 

 

 

Void deposit transaction

GV

GL Code

Original date

Original REF1

Original REF2

Original

ARD

Voided deposit

Original amount

Original

 

 

 

 

Original Track1

Original

Track2

 

 

 

 

 

Dummy trans. for dummy header line

Si

Inventory->asset

Invoice date

Invoice

Inventory item

maybe O

ARI

Descr.

 

C

ID

 

 

 

Shipped amount

Price

 

 

 

 

 

Transaction for invoice detail

SI

Account on line

Invoice date

Invoice

Inventory item

Maybe O

ARI

Descr

Selling price

C

ID

 

 

 

Shipped

amount

Price

V (if track count and periodic inventory)

 

Job ID

 

I

Error correction for materials list

Sm

Account from materials

Invoice date

Invoice

 

 

ARI

"Price Distribution Remainder"

Error amount

C

ID

 

 

 

 

 

 

 

Job ID

 

I

Sales tax for invoice

SS

artax->liab_gl

Invoice date

Invoice

Tax ID

S

ARI

Sales Tax->name

Tax amount

C

ID

 

 

 

Taxable amount

subtotal

E or I

 

 

 

 

Freight for invoice

SF

arinv->freight_gl

Invoice date

Invoice

 

 

ARI

Freight chg->name

Freight amount

C

ID

 

 

 

 

 

 

 

 

 

 

Damage waiver amount for invoice (Rental)

SW

arinv->dam_waiv_g

Invoice date

Invoice

 

 

ARI

Damage waiver->name

Damage waiver amount

C

ID

 

 

 

 

 

 

 

 

 

 

Transferring payments from down payment

St

arinv->down_pay

Invoice date

Invoice

 

 

ARI

Customer name

Total paid

D

ID

 

 

 

 

 

 

 

 

 

 

Transferring payments to A/R trade account

ST

arinv->ar_trade

Invoice date

Invoice

 

 

ARI

Customer name

Total paid

C

ID

 

 

 

 

 

 

 

 

 

 

Trade account debit for entire invoice

SM

arinv->ar_trade

Invoice date

Invoice

 

 

ARI

Customer name

Total w/discount and overdue

D

ID

 

 

 

 

 

 

 

 

 

 

Job retainage for the invoice

SJ

jcjb->custret_gl

Invoice date

Invoice

 

 

ARI

Customer name

Total retainage

D

ID

 

 

 

 

 

 

 

Job ID

 

I

Invoice finance charge

SO

arinv->finance

Pay date

Invoice

Check number + Timestamp

D

ARI

Customer name

overdue

C

ID

 

 

 

 

 

 

 

 

 

 

AR Trade credit for finance charge

SX

arinv->ar_trade

Pay date

Invoice

Check number

D

ARI

Customer name

-1.0 * overdue

C

ID

 

 

 

 

 

 

 

 

 

 

Invoice discount

SD

arinv->cust_disc

Pay date

Invoice

Check number + Timestamp

D

ARI

Customer name

Discount

D

ID

 

 

 

 

 

 

 

 

 

 

AR Trade credit for discount

SY

arinv->ar_trade

Pay date

Invoice

Check number

D

ARI

Customer name

Overdue

C

ID

 

 

 

 

 

 

 

 

 

 

Down payment credit

Sp

arinv->down_pay

Pay date

Invoice

Check number + Timestamp

D

ARP

Customer name

Payment amount

C

ID

 

 

 

Payment days

Generic parameter

 

 

 

 

 

Trade account credit

SP

arinv->ar_trade

Pay date

Invoice

Check number + Timestamp

D

ARP

Customer name

Payment amount

C

ID

 

 

 

Payment days

Generic parameter

 

 

 

 

 

Payment cash transaction for multiple invoices

SC

Bank account (BANK, BACC, or CASH)

Pay date

Must be blank

Check number + Timestamp

D

ARP

Customer name

Payment total

D

ID

Date of web sale capture

 

 

 

Deposit Hex timestamp

 

 

 

 

 

Job retainage change AR

Js

arinv->ar_trade

change date

Invoice

 

 

ARI

Customer name

-1.0* total retainage

C

ID

 

 

 

 

 

 

 

 

 

 

Job retainage change - retainage

JS

jcjb->custret_gl

change date

Invoice

 

 

ARI

Customer name

-1.0* total retainage

D

ID

 

 

 

 

 

 

 

Job ID

 

I

 

Salesperson Commissions

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Salesperson commission payable

C5

Commission payable account

Invoice date

Invoice

Salesperson

s

ARI

Line description

Commission amount

C

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Salesperson commission expense

C6

Expense account

Invoice date

Invoice

Salesperson

 

ARI

Line description

Commission amount

D

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct undo - commission payable

C1

Commission payable account

Invoice date

Invoice

Salesperson

s

ARI

Line description

Old amount

C

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct redo - commission payable

C2

Commission payable account

Invoice date

Invoice

Salesperson

s

ARI

Line description

New Amount

C

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct redo - commission expense

C3

Expense account

Invoice date

Invoice

Salesperson

 

ARI

Line description

Old Amount

D

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct redo - commission expense

C4

Expense account

Invoice date

Invoice

Salesperson

 

ARI

Line description

New Amount

D

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct undo - commission payable

C7

Commission payable account

Invoice date

Invoice

Salesperson

s

ARI

Line description

Old Amount

C

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct redo - commission payable

C8

Commission payable account

Invoice date

Invoice

Salesperson

s

ARI

Line description

New Amount

C

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct undo - commission expense

C9

Expense account

Invoice date

Invoice

Salesperson

 

ARI

Line description

Old Amount

D

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

Correct redo - commission expense

CA

Expense account

Invoice date

Invoice

Salesperson

 

ARI

Line description

New Amount

D

Customer ID

Date paid

False

False

Original price

Commission ID

 

 

 

 

 

 

Expense

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

 Ware house Job Stage Job Trans

Expense transaction for invoice detail

EI

apinvdet->account

 Invoice date Invoice Inventory item Maybe I

API

 Description Cost D

Vendor ID

  

False

 

 Ship amount

(JC) "SO "+ Date

V (if track count and periodic inventory)

   Job ID Job stage E

Sales tax for expense invoice

ES

apinv->csales_tax

 Invoice date   Invoice    

API

Sales Tax->vendor name

 Sales tax D

Vendor ID

   False

 

 0 0          

Freight for expense invoice

EF

apinv->cfreight

 Invoice date   Invoice    

API

Freight Chg->vendor name

 Freight amount D

Vendor ID

   False

 

 0 0          

Main credit to accounts payable

EM

apinv->cpay_trade (APAP)

 Invoice date   Invoice    

API

Vendor name

 Total C

Vendor ID

   False

 

 0 0          

Transfer from down payment...

Et

apinv->cdown_pay

(APDP)

 Invoice date   Invoice    

API

 Vendor name Total paid so far C

Vendor ID

 False  

0

 0            

... to AP trade

ET

 apinv->cpay_trade (APAP) Invoice date   Invoice    

API

 Vendor name Total paid so far D

Vendor ID

 False  

0

 0            

Bank, credit card, cash entry paying invoice(s)

EC

apinv->check_acnt (BANK, BACC, or CASH)

 Payment date  

Check Number + Timestamp

  

APP

 Vendor name Payment C w/exceptions

Vendor ID

 Date check register was printed False

 

   0          

Discount, FC, final A.P. entry

Et

 apinv->cpay_trade (APAP) Final payment date Invoice

Check Number + Timestamp

 C

APP

 Vendor name Discount - overdue D

Vendor ID

 False  

 

              

AP debit for 1099

ET

 apinv->cpay_trade (APAP) Payment date Invoice

Check Number + Timestamp

 C

APP

 Vendor name

0

 D

Vendor ID

 False  

 

              

Finance charges

EF

apinv->cfinance

 Payment date Invoice

Check Number + Timestamp

 C

API

Finance Chg->Vendor name

Finance charge

 D

Vendor ID

 False  

0

 0            

Discount on payment

ED

apinv->cvndr_disc

 Payment date Invoice

Check Number + Timestamp

 C

API

 Discount ->vendor name

Discount amount

 C

Vendor ID

 False  

0

 0            

Payment entry (each invoice)

EP

apinv->cpay_trade

(or cdown_pay)

 Payment date Invoice

Check Number + Timestamp

 C

APP

 Vendor name Payment D

Vendor ID

 

 False

 

 

0

bank or credit card account

        

Whole check void

EV

checking account

 Check date  

Original check number

 C

APP

Description

 Total amount C

Vendor ID

False

  

 

0

 

 

        

 

Financials

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Journal transaction

GJ

Account

Date

Journal ID

xxjrn->ref2

 

xxJ

Description

Amount

C

xxjrn->id

False

 

0

0

 

 

 

Job ID

Stage ID

 

Bank account transaction

GA

glcode1

 Date

First G/L account

Second G/L account

 G ARD/APA

Description

Amount

 either    

False

  

Type

Deposit Hex Timestamp

          

Bank account transaction

Ga

glcode2

 Date

First G/L account

Second G/L account

 G ARD/APA

Description

Amount

 either    

False

  

Type

 Deposit Hex Timestamp          

 

Inventory

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Warehouse Transfer No Value Items

IT

inventry->purchase

Process date

Document

Inventory ID

 

INW

Description

Cost

D

($)WHTRAN

 

 

 

Quantity

 

 

Warehouse

 

 

 

Perpetual Entry – Variance

IV

inventry->adjust(INVE) + dept

Process date

Document

Inventory ID

 

From doc

Description

Amount

C/D

From document

 

 

Quantity

Depends

(JC) "SO "+ Date

 

Warehouse

From document

From document

E

Perpetual Entry – Asset

IA

Inventry->ASSET

Process date

Document

Inventory ID

I/O

From doc

Description

Amount

D/C

From document

 

 

Quantity

 

 

 

Warehouse

From document

From document

E

No Count - Variance Entries

I1

inventry->adjust

Process date

Document

Inventory ID

I/O/Blank

From doc

inventry->descr_1

Cost

D/C

From document

False

 

Quantity

Price/"SO YYYYMMDD"

 

 

Warehouse

Job ID

Stage ID

E

Transfer P&L Entries - Variance

I2

inventry->adjust

Process date

Warehouse transfer

Inventory ID

 

From doc

inventry->descr_1

Cost

C/D

From document

False

 

 

 

 

 

 

 

 

 

Transfer P&L Entries - Purchase

I3

inventry->pur_acc

Process date

Warehouse transfer

Inventory ID

O/I

From doc

inventry->descr_1

Cost

C

From document

False

 

Quantity

(maybe)

 

 

 

 

 

 

 

No Count - Variance Entries

I4

inventry->variance  

Invoice date

Document

Inventory ID

 

From doc

"Change P.O. value - " + inventry->id

Adjustment

C

From document

False

 

 

 

 

 

Warehouse

Job ID

Stage ID

E

 

Job costing

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Job Transfer

Job transfer transaction uses the Rec Types: IV, IA, I1 described in the previous Inventory transaction section.

            

Work in process - Cost in excess of billing

J1

jcjb->cstbill_gl

Process date

 

 

 

JCW

Work in process - 'job id'

Amount

D

 

 

 

 

% complete

 

 

 

Job ID

 

W

Work in process - Cost in excess of billing

J2

jcjb->wrkproc_gl

Process date

 

 

 

JCW

Work in process - 'job id'

Amount

C

 

 

 

 

% complete

 

 

 

Job ID

 

W

Work in process - Billing in excess of cost

J3

jcjb->billcst_gl

Process date

 

 

 

JCW

Work in process - 'job id'

Amount

C

 

 

 

 

% complete

 

 

 

Job ID

 

W

Work in process - Billing in excess of cost

J4

jcjb->wrkproc_gl

Process date

 

 

 

JCW

Work in process - 'job id'

Amount

D

 

 

 

 

% complete

 

 

 

Job ID

 

W

Paying Use Tax

SU

Inventry->UseTax_ACC

Date

document ID

Document description

 

from doc

Document description

Total use tax

D

($)JCIT

 

    

Total taxable

total gross for document

 

        

Collecting Use Tax

JU

artax->Usetax_gl

Date

document ID

artax->ID

U

from doc

"Use Tax"

tax amount

C

($)JCIT

tax payment date

 

 

Taxable amount per line

total gross per line

U

 

 

 

 

 

Depreciation

Rec

Type

G/L Account

Date

REF1

REF2

REF2 Flag

Source

Description

Amount

DC

ID

Printed

Status

STAT DEP

Track1

Track2

Flag1

Ware house

Job

Stage

Job Trans

Monthly process - asset

DP

dpasset->accum

Monthly date

 

dpasset->id

A

DPI

dpasset->descr

Amount for the month

C

 

 

 

 

 

dpasset->primary

 

 

 

 

 

Monthly process - expense

Dp

dpasset->expense

Monthly date

 

dpasset->id

 

DPI

dpasset->descr

Amount for the month

D

 

 

 

 

 

dpasset->primary

 

 

 

 

 

Manual costs - asset account

DD

GLCLS_DEPREC_ASSET

Date

 

dpasset->id

 

DPI

Description

Cost change

D

 

 

 

 

 

 

 

 

 

 

 

Manual costs - offset expense

Dd

Expense account

Date

 

dpasset->id

 

DPI

Description

Cost change

C

 

 

 

 

 

 

 

 

 

 

 

Transfer out of asset

Da

dpasset->asset

Transfer date

 

Inventory item

 

DPT

dpasset->descr

Purchase cost

D

 

 

 

 

-1 (if inventory)

 

 

Old warehouse

 

 

 

Transfer into asset

DA

dpasset->asset

Transfer date

 

Inventory item

 

DPT

dpasset->descr

Purchase cost

D

 

 

 

 

-1 (if inventory)

 

 

New warehouse

 

 

 

Transfer - Out of accumulated

Dc

dpasset->asset

Transfer date

 

 

 

DPT

dpasset->descr

Accumulated amount

C

 

 

 

 

 

 

 

 

 

 

 

Transfer - Into accumulated

DC

dpasset->asset

Transfer date

 

 

 

DPT

dpasset->descr

Accumulated depreciation

C

 

 

 

 

 

 

 

 

 

 

 

Disposal -  asset disposal

D1

dpasset->asset_dis

Disposal date

Invoice

dpasset->id

 

DPI

dpasset->descr

dpasset->cost

D

Customer

 

 

 

 

 

 

 

 

 

 

Disposal  asset

D2

dpasset->asset

Disposal date

Invoice

dpasset->id

 

DPI

dpasset->descr

dpasset->cost

C

Customer

 

 

 

 

 

 

 

 

 

 

Disposal - accumulated expense

D3

dpasset->accum

Disposal date

Invoice

dpasset->id

 

DPI

dpasset->descr

accumulated depreciation

D

Customer

 

 

 

 

 

 

 

 

 

 

Disposal - accumulated asset

D4

dpasset->accum_dep

Disposal date

Invoice

dpasset->id

 

DPI

dpasset->descr

accumulated depreciation

C

Customer

 

 

 

 

 

 

 

 

 

 

Variance entry serialized item transfer to depr asset

IS

Variance G/L

Date

Batch

Inventory item

O (maybe)

INS

Some descr

Cost

C

 

 

 

 

Quantity

 

 

Warehouse

 

 

 

Depr asset serialized item transfer entry

ID

Depr asset

Date

Batch

Depreciable asset

 

INS

Some descr

Batch total

D