Assemblies Journal Fields (Import/Export)

How Do I...

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.

Note: Inventory assembly fields are exported using ASSEMBLY.CSV as the default file name.

Field Name

Import?

Required

Description of Field

Limit

Assembly Item ID

Y

Y

Alphanumeric – Assembly's item ID for the transaction.

Up to 20 characters

Reference

Y

N

Alphanumeric – Reference for the transaction.

Up to 20 characters

Date

Y

Y

Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format.

Reason to Build

Y

N

Alphanumeric - Reason to build for the transaction.

Up to 30 characters

Inventory Account

N

<N/A>

Alphanumeric - The Assembly's Inventory account number for the transaction retrieved from the Inventory item list during the import process. This field is used for exporting only.

Up to 15 characters

Amount Adjusted

N

<N/A>

Numeric (Real) - Net inventory amount for the transaction; calculated during the import process. This field is used for exporting only.

Quantity Built

Y

Y

Numeric (Real) – Quantity built for the transaction.

Inv Acnt Date Cleared in Bank Rec

Y

N

Date - If the transaction used an inventory account and was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Number of Distributions

Y

Y

Numeric (Whole) – Number of distributions (in this case, it's the number of components) in the transaction.

G/L Account

N

<N/A>

Alphanumeric - G/L account number for the line of distribution; retrieved from the Inventory item list during the import process. This field is used for exporting only.

Up to 15 characters

GL Date Cleared in Bank Rec

Y

N

Date - If the General Ledger account used on a chosen distribution was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Amount

N

<N/A>

Numeric (Real) – Amount for the line of distribution calculated during the import process. A positive amount denotes a debit, while a negative amount denotes a credit. This field is used for exporting only.

Quantity

N

<N/A>

Numeric (Real) – Component and assembly quantities used in the transaction calculated during the import process. This field is used for exporting only.

Component Item ID

N

<N/A>

Alphanumeric – Component's item ID for the transaction retrieved from the Inventory item list during the import process. This field is used for exporting only.

Up to 20 characters

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.

Supervisor ID

Y

Alphanumeric - The employee ID of the supervisor named on the work ticket for an assembly

Up to 20 characters

Supervisor Name

Y

Alphanumeric - The employee name of the supervisor named on the work ticket for an assembly

Up to 30 characters

Revision Number Used

N

Numeric (Real) - Revision numbers are assigned by the system based on system date and effective date

Assembly Serial Number

Y

Y

Alphanumeric - Serial number for a line of distribution. Note: Each serial number will be listed on a separate line.

Up to 30 characters