Rice Lake TransAct 3.5 User Manual

Page 66

Advertising
background image

Admin

Importing and Exporting Data

Version 3.5

67

Available Export/Import Fields

The following is a list of fields from the

Transaction Table

that can be used in the export/import definition

files.

NOTE:

Only the category description in which rates are attached can be exported.

Table 4. Transaction Table Available Export/Import Fields

Field Keyword

Description

Export

Import

Site

X

X

Charge Type

Regular Charge, Finance Charge, Payment or
Credit

X

X

Ticket Number

Sequential number assigned to each transaction.

X

X

Ticket Sequence

Item Number when multiple items per ticket are
used.

X

X

Statement Number

X

X

Hauler Account

Hauler account number

X

X

Hauler Name

X

Hauler Contact

X

Account

Bill To account number

X

X

Account Name

X

Account Contact

X

Daily Note

X

Job

Job Code

X

X

Job Name

Job Description

X

Job PO

Job PO

X

Permit

Permit Number

X

X

Tare1 Number

Replace Tare1 with user assigned name

X

X

Tare1 Tare Weight

X

Tare1 Tare Setdate

X

Tare1 Tare Expdate

X

Tare2 Number

Replace Tare2 with user assigned name

X

X

Tare2 Tare Weight

X

Tare2 Tare Setdate

X

Tare2 Tare Expdate

X

Tare3 Number

Replace Tare3 with user assigned name

X

X

Tare3 Tare Weight

Tare3 Tare Setdate

Tare3 Tare Expdate

Category1 Code

Replace Category1 with user assigned name

X

X

Category1
Description

Export Only - Replace Category1 with user
assigned name

X

Advertising