General Journal Fields (Import/Export)
The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export). The Required column shows those fields that must be provided.
|
Field Name |
Import? |
Required |
Description of Field |
Limit |
|---|---|---|---|---|
|
Date |
Y |
Y |
Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format. |
|
|
Reference |
Y |
N |
Alphanumeric - Reference for the transaction. |
Up to 20 characters |
|
Date Cleared in Bank Rec |
Y |
N |
Date - If the transaction used a cash account and was cleared in the bank reconciliation, then this is the date it cleared. Otherwise, leave blank or don't include as a field. Must be in ##/##/## (month/day/yr) format. |
|
|
Number of Distributions |
Y |
Y |
Numeric (Whole) - Number of distributions in the transaction; valid numbers are 2 to 560. |
|
|
G/L Account |
Y |
Y |
Alphanumeric - G/L account number for a line of distribution. |
Up to 15 characters |
|
Description |
Y |
N |
Alphanumeric - Description for a line of distribution. |
Up to 160 characters |
|
Amount |
Y |
Y |
Numeric (Real) - Amount for a line of distribution. A positive amount denotes a debit, while a negative amount denotes a credit. |
|
|
Job ID |
Y |
N |
Alphanumeric - Job ID for a line of distribution. (Sage 50 Premium Accounting and higher) When importing any combination of jobs, phases, or cost codes, you must separate the items with commas and enclose the entire string with quotes. For example: "jobid,phase,costcode". |
Up to 20 characters |
|
Used for Reimbursable Expense |
Y |
N |
Boolean - Used for reimbursable expenses on Sales/Invoicing task, valid choices are [True] or [False]. |
|
|
Transaction Period |
N |
<N/A> |
Numeric (Whole) - Period number for the transaction. Used in conjunction with the Transaction Number to identify where a transaction (which is composed of several lines of distribution) begins and ends. |
|
|
Transaction Number |
N |
<N/A> |
Numeric (Whole) - Transaction number for the transaction. Used in conjunction with the period number to identify where a transaction (which is composed of several lines of distribution) begins and ends. |
|
|
Consolidated Transaction |
Y |
N |
Boolean - Used for transactions of consolidated companies; valid choices are [True] or [False], where True=consolidated transaction, False=not a consolidated transaction (i.e., regular General Journal entry). |
|
|
Recur Number |
Y |
Y |
This field identifies the recurring entry and the group it belongs to. 0 value indicates it is not a recurring entry. Recurring entry values are >0. |
|
|
Recur Frequency |
Y |
Y |
This field identifies how often the entry recurs. Valid numbers are: 0=Does not recur 1=Weekly 2=Bi-weekly 3=Monthly 4=Per period 5=Quarterly 6=Yearly 7=Every four weeks 8=Twice a year |