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
|