Transactions and Journals

Comprehensive GLT Transaction Reference Tables

These comprehensive reference tables map the details within the general ledger transaction file (GLT.DBF)

Payroll Transactions

PAYROLL Expense transaction for each detail line Payroll payable for each detail line Makeup pay expense transaction Payroll payable for makeup pay
Rec Type Pe PE PM Pm
G/L Account pytmdet->gl_code Payroll Payable pytm->makeup_pay Payroll Payable
Date Line Date Line Date Pay period Pay period
REF1 Pay period Pay period Pay period Pay period
REF2 Work code Work code    
REF2 Flag   W assigned in post    
Source PYT PYT PYT PYT
Description Employee name Employee name Employee name Employee name
Amount Pay for line Pay for line Makeup pay Makeup pay
DC D C D C
ID Employee ID Employee ID Employee ID Employee ID
Printed        
Status   FALSE FALSE FALSE
Track1 Hours Hours    
Track2 (JC) "SO" + Date Pay level    
Flag1 "H" or "U" (hours or units) "H" or "U" (hours or units)    
Job Job ID      
Stage Job Stage      
Job Trans E      
PAYROLL Check pay for net pay Direct deposit of net pay Payroll payable for take home tips Payroll payable for payment
Rec Type PC PD PA PB
G/L Account Bank account or cash Bank account or cash Payroll payable Payroll payable
Date Pay date Pay date Pay date Pay date
REF1      Pay period Pay period
REF2 Check# + Timestamp Check# + Timestamp Work code Check# + Timestamp
REF2 Flag C C W assigned in post C
Source PYP PYP PYT PYP
Description Employee name "Payroll direct deposit" Employee name Employee name
Amount Net pay Net pay Pay for line Gross pay
DC C C C D
ID Employee ID   Employee ID Employee ID
Printed Date Check Register was printed Date Check Register was printed    
Status FALSE FALSE FALSE FALSE
Track1       Work weeks
Track2     Pay level Bank GL Account
Flag1        
Job        
Stage        
Job Trans        
PAYROLL Payroll payable for gross ups Liability transaction for taxes Liability transaction for gross up Expense transaction for company taxes
Rec Type PU PT Pt PV
G/L Account Payroll Payable Payroll tax/deduction Payroll tax/deduction pyemptx->exp_gl
Date Pay date Pay date Pay date Pay date
REF1 Pay period Pay period Pay period Pay period
REF2 Gross up ID Tax ID Gross up ID Tax ID
REF2 Flag   T T  
Source PYT PYT PYT PYT
Description Employee name Employee name Employee name Employee name
Amount Gross up amount Tax amount Gross up amount Tax amount
DC C C D D
ID Employee ID Employee ID Employee ID Employee ID
Printed        
Status FALSE FALSE FALSE  
Track1 Taxable Gross Taxable Gross Taxable Gross  
Track2 Gross pay Gross pay Gross pay  
Flag1 "E" or "C" "E" or "C" "E" or "C"  
Job        
Stage        
Job Trans        

Sales Transactions

SALES Void deposit transaction Void deposit transaction Cash transaction for voided check Void deposit transaction
Rec Type Gr GR SV GV
G/L Account GL Code GL Code Bank account GL Code
Date Process date Process date Void date Original date
REF1       Original REF1
REF2     Check number + timestamp Original REF2
REF2 Flag     D Original
Source ARD ARD ARP ARD
Description   Voided deposit Customer name Voided deposit
Amount - Amount - Amount Previous amount Original amount
DC D C D Original
ID     ID  
Printed        
Track1       Original Track1
Track2       Original Track2
Flag1        
Job        
Job Trans        
SALES Dummy transaction for dummy header line Transaction for invoice detail Error correction for materials list Sales tax for invoice
Rec Type Si SI Sm SS
G/L Account Inventory->asset Account on line Account from materials artax->liab_gl
Date Invoice date Invoice date Invoice date Invoice date
REF1 Invoice Invoice Invoice Invoice
REF2 Inventory Item Inventory Item   Tax ID
REF2 Flag Maybe O Maybe O   S
Source ARI ARI ARI ARI
Description Descr. Descr. "Price Distribution Remainder" Sales Tax->name
Amount   Selling price Error amount Tax amount
DC C C C C
ID ID ID ID ID
Printed        
Track1 Shipped amount Shipped amount   Taxable amount
Track2 Price Price   Subtotal
Flag1   V (if track count and periodic inventory)   E or I
Job   Job ID Job ID  
Job Trans   I I  
SALES Freight for invoice Damage waiver amount for invoice (Rental) Transferring payments from down payment Transferring payments to A/R trade account
Rec Type SF SW St ST
G/L Account arinv->freight_gl arinv->dam_waiv_gl arinv->down_pay arinv->ar_trade
Date Invoice date Invoice date Invoice date Invoice date
REF1 Invoice Invoice Invoice Invoice
REF2        
REF2 Flag        
Source ARI ARI ARI ARI
Description Freight chg-> name Damage waiver->name Customer name Customer name
Amount Freight amount Damage waiver amount Total paid Total paid
DC C C D C
ID ID ID ID ID
Printed        
Track1        
Track2        
Flag1        
Job        
Job Trans        
SALES Trade account debit for entire invoice Job retainage for the invoice Invoice finance charge AR Trade credit for finance charge
Rec Type SM SJ SO SX
G/L Account arinv->ar_trade jcjb->custret_gl arinv->finance arinv->ar_trade
Date Invoice date Invoice date Pay date Pay date
REF1 Invoice Invoice Invoice Invoice
REF2     Check# + timestamp Check#
REF2 Flag     D D
Source ARI ARI ARI ARI
Description Customer name Customer name Customer name Customer name
Amount Total w/discount and overdue Total retainage overdue -1.0 * overdue
DC D D C C
ID ID ID ID ID
Printed        
Track1        
Track2        
Flag1        
Job   Job ID    
Job Trans   I    
SALES Invoice discount AR Trade credit for discount Down payment credit Trade account credit
Rec Type SD SY Sp SP
G/L Account arinv->cust_disc arinv->ar_trade arinv->down_pay arinv->ar_trade
Date Pay date Pay date Pay date Pay date
REF1 Invoice Invoice Invoice Invoice
REF2 Check# + timestamp Check number Check# + timestamp Check# + timestamp
REF2 Flag D D D D
Source ARI ARI ARP ARP
Description Customer name Customer name Customer name Customer name
Amount Discount Overdue Payment amount Payment amount
DC D C C C
ID ID ID ID ID
Printed        
Track1     Payment days Payment days
Track2     Generic parameter Generic parameter
Flag1        
Job        
Job Trans        
SALES Payment cash transaction for multiple invoices Job retainage change AR Job retainage change - retainage
Rec Type SC Js JS
G/L Account Bank account (BANK, BACC, or CASH) arinv->ar_trade jcjb->custret_gl
Date Pay date change date change date
REF1 Must be blank Invoice Invoice
REF2 Check# + timestamp    
REF2 Flag D    
Source ARP ARI ARI
Description Customer name Customer name Customer name
Amount Payment total -1.0 * total retainage -1.0 * total retainage
DC D C D
ID ID ID ID
Printed Date or web sale capture    
Track1      
Track2 Deposit Hex timestamp    
Flag1      
Job     Job ID
Job Trans     I

Salesperson Commission Transactions

SALESPERSON COMMISSIONS Salesperson commission payable Salesperson commission expense Correct redo - commission payable Correct redo - commission expense
Rec Type C5 C6 C1 C2
G/L Account Commission payable account Expense account Commission payable account Commission payable account
Date Invoice date Invoice date Invoice date Invoice date
REF1 Invoice Invoice Invoice Invoice
REF2 Salesperson Salesperson Salesperson Salesperson
REF2 Flag s   s s
Source ARI ARI ARI ARI
Description Line description Line description Line description Line description
Amount Commission amount Commission amount Old amount New amount
DC C D C C
ID Customer ID Customer ID Customer ID Customer ID
Printed Date paid Date paid Date paid Date paid
Status FALSE FALSE FALSE FALSE
STAT DEP FALSE FALSE FALSE FALSE
Track1 Original price Original price Original price Original price
Track2 Commission ID Commission ID Commission ID Commission ID
SALESPERSON COMMISSIONS Correct redo - commission expense Correct redo - commission expense Correct undo - commission payable Correct redo - commission payable
Rec Type C3 C4 C7 C8
G/L Account Expense account Expense account Commission payable account Commission payable account
Date Invoice date Invoice date Invoice date Invoice date
REF1 Invoice Invoice Invoice Invoice
REF2 Salesperson Salesperson Salesperson Salesperson
REF2 Flag     s s
Source ARI ARI ARI ARI
Description Line description Line description Line description Line description
Amount Old amount New amount Old amount New amount
DC D D C C
ID Customer ID Customer ID Customer ID Customer ID
Printed Date paid Date paid Date paid Date paid
Status FALSE FALSE FALSE FALSE
STAT DEP FALSE FALSE FALSE FALSE
Track1 Original price Original price Original price Original price
Track2 Commission ID Commission ID Commission ID Commission ID
SALESPERSON COMMISSION Correct undo - commission expense Correct redo - commission expense    
Rec Type C9 CA    
G/L Account Expense account Expense account    
Date Invoice date Invoice date    
REF1 Invoice Invoice    
REF2 Salesperson Salesperson    
REF2 Flag        
Source ARI ARI    
Description Line description Line description    
Amount Old amount New Amount    
DC D D    
ID Customer ID Customer ID    
Printed Date paid Date paid    
Status FALSE FALSE    
STAT DEP FALSE FALSE    
Track1 Original price Original price    
Track2 Commission ID Commission ID    

Expense Transactions

EXPENSE Expense transaction for invoice detail Sales tax for expense invoice Freight for expense invoice Main credit to accounts payable
Rec Type EI ES EF EM
G/L Account apinvdet->account apinv->csales_tax apinv->cfreight apinv->cpay_trade (APAP)
Date Invoice date Invoice date Invoice date Invoice date
REF1 Invoice Invoice Invoice Invoice
REF2 Inventory item      
REF2 Flag Maybe I      
Source API API API API
Description Description Sales Tax -> vendor name Freight Chg -> vendor name Vendor name
Amount Cost Sales tax Freight amount Total
DC D D D C
ID Vendor ID Vendor ID Vendor ID Vendor ID
Printed        
Status FALSE FALSE FALSE FALSE
STAT DEP        
Track1 Ship amount 0 0 0
Track2 (JC) "SO" + Date 0 0 0
Flag1 V (if track count and periodic inventory)      
Job Job ID      
Stage Job stage      
Job Trans E      
EXPENSE Transfer from down payment... ...to AP trade Bank, credit card, cash entry paying invoice(s) Discount, FC, final AP entry
Rec Type Et ET EC Et
G/L Account apinv->cdown_pay (APDP) apinv->cpay_trade (APAP) apinv->check_acnt (BANK, BACC, or CASH) apinv->cpay_trade (APAP)
Date Invoice date Invoice date Payment date Final payment date
REF1 Invoice Invoice   Invoice
REF2     Check# + timestamp Check# + timestamp
REF2 Flag       C
Source API API APP APP
Description Vendor name Vendor name Vendor name Vendor name
Amount Total paid so far Total paid so far  Payment Discount - overdue
DC C D C with exceptions D
ID Vendor ID Vendor ID Vendor ID Vendor ID
Printed FALSE FALSE Date check register was printed FALSE
Status     FALSE  
STAT DEP 0 0    
Track1 0 0    
Track2     0  
Flag1        
Job        
State        
Job Trans        
EXPENSE AP debit for 1099 Finance charges Discount on payment Payment entry (each invoice) Whole check void
Rec Type ET EF ED EP EV
G/L Account apinv->cpay_trade (APAP) apinv->cfinance apinv->cvndr_disc apinv->cpay_trade (or cdown_pay) Checking account
Date Payment date Payment date Payment date Payment date Check date
REF1 Invoice Invoice Invoice Invoice  
REF2 Check# + Timestamp Check# + Timestamp Check# + Timestamp Check# + Timestamp Original check number
REF2 Flag C C C C C
Source APP API API APP APP
Description Vendor name Finance Chg-> Vendor name Discount-> Vendor name Vendor name Description
Amount 0 Finance charge Discount amount Payment Total amount
DC D D C D C
ID Vendor ID Vendor ID Vendor ID Vendor ID Vendor ID
Printed FALSE FALSE FALSE   FALSE
Status       FALSE  
STAT DEP   0 0    
Track1   0 0   0
Track2       0  
Flag1       bank or credit card account  
Job          
Stage          
Job Trans          

Financials Transactions

FINANCIALS Journal Transaction Bank Account Transaction Bank Account Transaction
Rec Type GJ GA Ga
G/L Account Account glcode1 glcode2
Date Date Date Date
REF1 Journal ID First G/L Account First G/L Account
REF2 xxjrn->ref2 Second G/L Account Second G/L Account
REF2 Flag   G G
Source xxJ ARD/APA ARD/APA
Description Description Description Description
Amount Amount Amount Amount
DC C either either
ID xxjrn->id    
Printed FALSE    
Status   FALSE FALSE
STAT DEP 0    
Track1 0 Type Type
Track2   Deposit Hex Timestamp Deposit Hex Timestamp
Job Job ID    
Stage Stage ID    

Inventory Transactions

INVENTORY Warehouse Transfer No Value Items Perpetual Entry - Variance Perpetual Entry - Asset No Count - Variance Entries
Rec Type IT IV IA I1
G/L Account inventry->purchase inventry->adjust(INVE) + dept inventry->ASSET inventry->adjust
Date Process date Process date Process date Process date
REF1 Document Document Document Document
REF2 Inventory ID Inventory ID Inventory ID Inventory ID
REF2 Flag     I/O I/O/Blank
Source INW From doc From doc From doc
Description Description Description Description inventry->descr_1
Amount Cost Amount Amount Cost
DC D C/D D/C D/C
ID ($)WHTRAN From document From document From document
Printed       FALSE
STAT DEP   Quantity Quantity Quantity
Track1 Quantity Depends   Price/"SOYYYYMMDD"
Track2   (JC) "SO" + Date    
Warehouse Warehouse Warehouse Warehouse Warehouse
Job   From document From document Job ID
Stage   From document From document Stage ID
Job Trans   E E E
INVENTORY Transfer P&L Entries - Variance Transfer P&L Entries - Purchase No Count - Variance Entries
Rec Type I2 I3 I4
G/L Account inventry->adjust inventry->pur_acc inventry->variance
Date Process date Process date Invoice date
REF1 Warehouse transfer Warehouse transfer Document
REF2 Inventory ID Inventory ID Inventory ID
REF2 Flag   O/I  
Source From doc From doc From doc
Description inventry->descr_1 inventry->descr_1 "Change P.O. value- " +inventry->id
Amount Cost Cost Adjustment
DC C/D C C
ID From document From document From document
Printed FALSE FALSE FALSE
STAT DEP   Quantity (maybe)  
Track1      
Track2      
Warehouse      Warehouse
Job     Job ID
Stage     Stage ID
Job Trans     E

Job Costing Transactions

JOB COSTING Job Transfer Work in Process - Cost in excess of billing Work in Process - Cost in excess of billing Work in process - Billing in excess of cost
 Rec Type Job transfer transaction uses the Rec Types: IV, IA, I1 described in the previous Inventory transaction section. J1 J2 J3
G/L Account   jcjb->cstbill_gl jcjb->wrkproc_gl jcjb->billcst_gl
Date   Process date Process date Process date
REF1        
REF2        
REF2 Flag        
Source   JCW JCW JCW
Description   Work in process - "job id" Work in process - "job id" Work in process - "job id"
Amount   Amount Amount Amount
DC   D C C
ID        
Printed        
Track1   % complete % complete % complete
Track2        
Flag1        
Job   Job ID Job ID Job ID
Job Trans   W W W
JOB COSTING Work in process - Billing in excess of cost Paying Use Tax Collecting Use Tax
 Rec Type J4 SU JU
G/L Account jcjb->wrkproc_gl inventry->UseTax_ACC artax->UseTax_gl
Date Process date Date Date
REF1   Document ID Document ID
REF2   Document description artax->ID
REF2 Flag     U
Source JCW From doc From doc
Description Work in process - "job id" Document description "Use Tax"
Amount Amount Total use tax Tax amount
DC D D C
ID   ($)JCIT ($)JCIT
Printed     Tax payment date
Track1 % complete Total taxable Taxable amount per line
Track2   Total gross for document Total gross per line
Flag1     U
Job Job ID    
Job Trans W    

Depreciation Transactions

DEPRECIATION Monthly process - asset Monthly process - expense Manual costs - asset account Manual costs - offset expense
Rec Type DP Dp DD Dd
G/L Account dpasset->accum dpasset->expense GLCLS_DEP REC_ASSET Expense account
Date Monthly date Monthly date Date Date
REF1        
REF2 dpasset->id dpasset->id dpasset->id dpasset->id
REF2 Flag A      
Source DPI DPI DPI DPI
Description dpasset->descr dpasset->descr Description Description
Amount Amount for the month Amount for the month Cost change Cost change
DC C D D C
ID        
Track1        
Track2 dpasset->primary dpasset->primary    
Warehouse        
DEPRECIATION Transfer out of asset Transfer into asset Transfer - Out of accumulated Transfer - Into accumulated
Rec Type Da DA Dc DC
G/L Account dpasset->asset dpasset->asset dpasset->asset dpasset->asset
Date Transfer date Transfer date Transfer date Transfer date
REF1        
REF2 Inventory item Inventory item    
REF2 Flag        
Source DPT DPT DPT DPT
Description dpasset->descr dpasset->descr dpasset->descr dpasset->descr
Amount Purchase cost Purchase cost Accumulated amount Accumulated depreciation
DC D D C C
ID        
Track1 -1 (if inventory) -1 (if inventory)    
Track2        
Warehouse Old warehouse New warehouse    
DEPRECIATION Disposal - asset disposal Disposal asset Disposal - accumulated expense Disposal - accumulated asset
 Rec Type D1 D2 D3 D4
G/L Account dpasset->asset_dis dpasset->asset dpasset->accum dpasset->accum_dep
Date Disposal date Disposal date Disposal date Disposal date
REF1 Invoice Invoice Invoice Invoice
REF2 dpasset->ud dpasset->id dpasset->id dpasset->id
REF2 Flag        
Source DPI DPI DPI DPI
Description dpasset->descr dpasset->descr dpasset->descr dpasset->descr
Amount dpasset->cost dpasset->cost accumulated depreciation accumulated depreciation
DC D C D C
ID Customer Customer Customer Customer
Track1        
Track2        
Warehouse        
DEPRECIATION Variance entry serialized item transfer to depreciable asset Depreciable asset serialized item transfer entry  
Rec Type IS ID  
G/L Account Variance G/L Depr asset  
Date Date Date  
REF1 Batch Batch  
REF2 Inventory Item Depreciable asset  
REF2 Flag O (maybe)    
Source INS INS  
Description Some descr Some descr  
Amount Cost Batch total  
DC C D  
ID      
Track1 Quantity    
Track2      
Warehouse Warehouse