Importing Codes and Tax Types

When importing transactions, how do I know what transaction source code to use?

Some transaction source codes are reserved for transactions that are processed by the system. Therefore, if these transactions are being imported, an alternate transaction source must be used. The following table displays all transaction codes, determines if a code is importable, and if it is not, the code that should be used is listed in the Alternate column:

Code Transaction Type Import Alternate

APC

A/P Manual Checks

Y

  

API

A/P Invoices

Y

  

APM

A/P Credits

Y

  

APS

A/P System Generated Checks/Vouchers

N

APC

APV

A/P Void Checks/Vouchers/Invoices

N

APC

ARB

A/R Invoices

Y

  

ARC

A/R Receipts

Y

  

ARM

A/R Credits

Y

  
ARP A/R Prepayment (Note that ARP does not require a TETRANS_MATCH_DOCNUM.) Y  

ARS

A/R System Generated Invoices

N

ARB

ARV

A/R Void Invoices

N

ARB

BD

Budget

Y

  

CD

Cash Disbursements

Y

  

CDS

Write Checks

N

CD

CR

Cash Receipts

Y

  

CRS

Receipt Writing

N

CR

ENC

Encumbrances

Y

  

ENL

Encumbrance Liquidations

Y

  

JV

Journal Vouchers

Y

  

JVA

Journal Vouchers - Allocation Management

N

JV

JVD

Journal Vouchers - Depreciation/Disposal

N

JV

PRC

Payroll Manual Checks

N

CD

PRS

Payroll System Generated Checks/Vouchers

N

CD

PRV

Payroll Void Checks/Vouchers

N

CD

VCK

Void Checks

N

CD
What codes are used for the Accounts Receivable, Fixed Assets, and Payroll calculation methods?

See the following table:

Accounts Receivable Charge Codes Code

Fixed Amount

FA

Fixed Price per Unit

FP

Variable Price per Customer

VC

Variable Price per Unit

VP

Alternative Variable Price/Unit

AV

Percent of Account Activity

PA
Fixed Asset Custom Depreciation Codes Code

Fixed Amount

FA

Fixed Percentage of Depreciable Base

PD

Fixed Percentage of Net Book Value

PN

MACRS - 31 Years

TD

Percentage Table of Depreciable Base

TD

Percentage Table of Net Book Value

TN
Payroll Earning Codes Code

Employee Pay Rate

ER

Rate Multiplier

RM

Fixed Hourly Amount

FH

Fixed Amount

FA

Amount on Timesheet

AT

Rate on Timesheet

RT
Payroll Benefit and Deduction Codes Code

Fixed Percentage of Earnings

FP

Fixed Hourly Amount

FH

Fixed Amount

FA

Amount on Timesheet

AT

Percentage on Timesheet

PT
Payroll Workers' Compensation Codes Code

Rate per $100 Earnings

RE

Rate per Workers' Compensation Hours

RH

Rate per Hours Worked

RW
Payroll Leave Codes Code

Fixed Number of Hours

FN

Fixed Percentage of Hours Worked

FP

Amount on Timesheet

AT

Percentage on Timesheet

PT
Payroll State and Other Taxes Code

Year-to-Date

Y

Current

C
What are all the possible depreciation methods and codes that can be imported into Fixed Assets?

See the following table:

Depreciation Method

Code

Straight Line

SL

Sum of the Years Digits

SYD

150 Percent Declining Balance

DB150

200 Percent Declining Balance

DB200

No Depreciation Calculated

NO

Custom Depreciation Method

User Defined
What distribution methods can be imported into Benefit Codes, Workers' Compensation Codes, and State Taxes?

See the following table:

Distribution Method

Code

Follow Earnings on Timesheet

AE

Following Earnings Used to Calculate

CE

Use Distribution Code Specified

DC
What tax types can be imported into Payroll?

See the following table:

Taxes

Code

Federal Income Tax

FIT

Social Security Tax

SS

Medicare

MC

Federal Unemployment Tax

FUTA

Earned Income Credit-no longer applies after Year 2011

EIC

State Withholding Tax

SWT

State Withholding Tax-only applies to the Commonwealth of the Northern Marianas Islands

SWT2

State Unemployment Tax

SUTA

Other Taxes Employee Paid Tax

LWT

Other Taxes Employer Paid Tax

LER