Assemblies
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.
Note: Inventory assembly
fields are exported using ASSEMBLY.CSV
as the default file name.
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
|