CSV import: Items
Related information
Related topics
You can import the following types of items by uploading a CSV file.
-
Inventory
-
Non-inventory
-
Non-inventory (purchase only)
-
Non-inventory (sales only)
-
Standard kit (non-stockable)
-
Stockable kit
Download a template
We recommend downloading a new blank template from either the Items list page or the Company Setup Checklist whenever you import information into Sage Intacct. This is important because:
- Templates are automatically customized based on your company configuration, including dimensions and custom fields you created.
- Templates can be updated by Intacct at any time, especially when a new version of Intacct is released. This means that an older template might not work.
To download an items template from the Items page:
| Subscription |
Inventory Control, Order Entry, or Purchasing |
|---|---|
| User type |
|
| Permissions |
Inventory Control, Order Entry, or Purchasing:
|
| Restrictions |
Employee, Project Manager, and Warehouse users can only list and view items. |
| Configuration |
Enable advanced workflow to import advanced workflow item details. See Advanced item upload fields: Required |
| Notes |
If you are also subscribed to Contracts or Projects, you can see Items in your menu if you have permissions to Items in Order Entry. |
-
Go to Inventory Control, Purchasing, or Order Entry > Setup > Items.
- Select Import. An Import dialog box opens.
- Select the Download template link.
To download a template from the Company setup checklist:
| Subscription |
Company |
|---|---|
| User type |
Business user with admin privileges |
| Permissions |
Company setup checklist: Run |
-
Go to Company > Setup > Configuration > Import data.
A list of information that you can import appears.
- Decide on a type of information to upload, and select the Template link associated with that information.
Prepare a CSV file for import
When you download a template, the correct headers are in the template already. All you have to do is fill in the columns with your data, save it as a CSV file, and upload the file.
The header titles in the template you download correlate to fields in Intacct. Incorrect header titles will cause an upload error.
For more information about the CSV upload process, including best practices, common errors, and how to upload your CSV file, see Prepare your file for CSV import.
Best practices
The following best practices will help you prepare your CSV file for upload.
Download a template from the Company setup checklist or an object list page.
- Use the latest template, especially following a product release.
- Use the correct template for the area in which you want to upload information. Different templates organize different types of information. Use a template specifically for the information that you need to upload.
- Don’t change the titles in the header row. The header titles correlate to fields in Intacct. Incorrect header titles will cause an upload error. When you download a template from the Company setup checklist, the correct headers are in the template.
- Read the header descriptions in the template. The header description is the cell under the header row that explains what type of information is accepted for each column. If you enter information in the wrong format, or with an incorrect accepted value, it will cause an error in your upload. The header descriptions in the template show you how the information should look. For example, the header in the GL Journal Entries template for JOURNAL shows that allows up to four characters, is required, and has no default values. The header in the Reporting Periods template shows that the STATUS only allows the values 1 or 2, which correlates to True and False, and is not a required field.
- Enter required information. Some data is required, while other data is not. Read the description field to determine which information is required. Required information is necessary for your upload to succeed.
Save the file as a comma-separated value, or CSV, file. If saving from Excel, you could choose the comma-delimited file type.
The file will have the file extension .csv after you save it. Leave the file open until your import is successful. Excel can sometimes reformat the file if you close it before the import is successful.
Avoid common import errors
Intacct recommends following these guidelines to avoid import errors.
In Microsoft Excel:
- Select all cells.
- Right-click the cells and select Format Cells.
- On the Number tab, select Text and then select OK.
- Save the file.
The short date format is formatted like this: 3/15/2021
In Microsoft Excel:
- Select a column of dates.
- Right-click the column and select Format Cells.
- On the Number tab, select Date and select the short date format.
- Save the file.
While spaces within memo fields are allowed, make sure that there are no leading or trailing spaces in any field (not just memos). Leading and trailing spaces might cause import errors. For all other fields, remove unnecessary spaces at the start or end of the data.
In Microsoft Excel:
- Select a range of cells.
- On the Home tab, in the Editing group, select Find & Select and select Replace.
- In the Find what box, enter one space. Leave the Replace with box blank.
- Select Replace All. A prompt opens telling you how many spaces have been removed.
- Save the file.
Commas are used to separate fields in CSV files.
To prevent data from shifting into the wrong columns, avoid using commas in numeric and text fields.
If you must include a comma in a text field, always surround the field with double quotes, for example "Smith, John".
Headers in your CSV file must match the template exactly, including spelling, capitalization, and spacing. Even small changes (such as adding a space or changing a letter’s case) will cause the import to fail. Always use the official template provided by Sage Intacct.
ID fields must contain exact references to customers or vendors.
ID fields must match exactly, including capitalization. For example, ven100 and VEN100 do not match.
Enter the ID exactly as it appears in Intacct or you run the risk of matching transactions to the wrong vendor or customer, or having the upload fail.
If you reference a vendor, customer, term, budget, etc., in a CSV file, whatever you’re referencing must already exist in Intacct.
For example, if you’re uploading transactions for a vendor, that vendor must already exist in Intacct before you start the upload. If the vendor does not exist, the upload will fail.
This does not apply when creating new customers or vendors using the import process.
For more information about to correctly number line items, see CSV import: Line number examples.
For fields with predefined valid entries (such as True/False), use initial capitalization. For example True, not TRUE or true. IDs require exact case matches, while predefined entries require initial capitalization.
If your import template contains a country field, for example for an address, make sure that this field has an entry.
If your company has enabled ISO country codes, you must specify the country code in the country field for each record. If you’re unsure whether ISO codes are enabled, check with your administrator or test a sample import to confirm the required format.
Format dates
When uploading your CSV file, you can select a Date Format for the dates in your file.
| Date sequence | Date format |
| Day, month, year |
|
| Month, day, year |
|
| Year, month, day |
|
| Day, month, year |
|
| Month, day, year |
|
| Year, month, day |
|
When you select a date format here, Intacct attempts to import your file using the selected date format. If Intacct can’t import your file with the selected date format, it attempts to discover the date format used in your file and import the data using that date format.
Import a CSV file
You can import items from either your Items list or your Company Setup Checklist.
- When you are ready to import the file, do either of the following:
Go to Company > Setup > Configuration > Import data.
Then, scroll down to Inventory Items and select the Import link.
Go to Inventory Control, Purchasing, or Order Entry > Setup > Items.
Then, select Import at the top of the list.
- In the Importdialog, set the following options and select Import.If errors are found in your upload file, the valid records in the file are imported by default. If you want the import to fail without any records being imported, select If errors occur, roll back the import option.Import Company Information options
Import company information option descriptions Option Description Choose file Select the CSV file that you want to import. Date format When you select a date format here, Intacct attempts to import your file using the selected date format. If Intacct cannot import your file with the selected date format, it attempts to discover the date format used in your file and import the data using that date format. File encoding Leave this option set to "auto-detect" unless you're unable to import your file. Depending on your operating system, you might need to select a different type of file encoding. If errors occur Use the radios buttons to select how the import will react if errors are found in your upload file: - If errors occur, roll back the import. The entire file is rejected and no entries are imported into Intacct.
- If errors occur, import successful records only. The entries with no errors are imported into Intacct. When the Import Company Information dialog opens, this is selected by default.
For either option, a CSV file is created with the rows containing errors along with an error message for each row. The import results and error details are sent to the email address that you specify.
Process offline Some imports can take considerable time, depending on their size and how much processing Intacct must do on the uploaded data. If you're not sure how much time your upload will take, select Process offline. When Intacct completes the process, it sends an email to the address you provide in the Email results to this address field. Intacct also sends you any errors that might have occurred in the process. If you prefer to wait until the upload process is complete, do not select the Process offline checkbox. Email results to this address Email address to which import results and errors should be sent. You can enter multiple email addresses, separated by a semicolon (;) or comma (,). Intacct highly recommends entering an email address.
After an import, Intacct informs you if the import was successful and how many records were imported.
In a completely successful import, the confirmation page lets you verify all the records in your original file were, in fact, successfully imported without having to manually verify them.
Offline CSV imports
Some imports can take considerable time, depending on their size and how much processing Intacct must do to the data. When in doubt, select Process offline on the import utility page.
When the offline process is complete, Intacct sends an email to the address you entered in the Import Company Information dialog (where you imported your file).
Intacct recommends that you select Process offline when importing CSV files, and provide your email address. If your import fails, you’ll always be notified, and the failed records are sent to your email.
Handle errors
If you experience import errors, review the importing tips and common errors.
Import errors occur when you try to import information that doesn’t match the requirements of the template. Each template has a set of required information you must enter to import the file successfully, and formats to follow for certain kinds of information. Read the descriptions in the template to determine the most accurate way to enter your data.
If individual transactions are in error, the rows in the transaction that are in error are saved in a CSV file for you along with an error code for each row. Check your email for information about specific errors. See Find and fix CSV import errors for more information.
For more information about the CSV upload process, read Prepare your file for CSV import.
Field descriptions
You can upload beginning balances for both warehouse quantity and price using the CSV template. This is different from the Intacct user interface: these fields are not present in the user interface.
The field definitions in your template explain what type of information is required for each field, and how to enter valid information. It's always a good idea to read the field definitions before making entries.
You can reorder the columns of your CSV file for ease of use. However, the column header must contain the field name exactly as it appears in the original template.
If you downloaded a template from the Company Setup Checklist or an object list page, your template contains the headers and dimensions that are specific to your company. The headers in a standard template might not contain field definitions specific to your company.
To import dimension values, enter information in the appropriate dimension column of the import spreadsheet. Otherwise, no information appears for that dimension.
If you relabeled any dimensions (see Terminology for more information), your dimension name does not appear in the CSV template, but the original Intacct dimension name does.
When importing data, names in the FIELD column may differ from terminology used in your location. For information on terms that may differ in your location, see Terminology across locales.
The template has three tabs:
- Simple Item Upload: contains field information for a simple item upload if your organization uses the standard, preconfigured workflows in Order Entry, Purchasing, and Inventory Control.
- Example of Simple Item Upload: contains an example of a simple item upload, with fields filled in.
- Advanced Item Upload: contains field information for an advanced item upload if your organization uses the advanced workflows in Order Entry, Purchasing, and Inventory Control.
Simple item upload fields: Required
Back to Field descriptions
| Field Name: | DONOTIMPORT |
|---|---|
|
# |
Any row that starts with # is ignored during import. |
| Field Name: | ITEM_ID |
|
UI Field Name: |
Item ID |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
No |
| Field Name: | NAME |
|
UI Field Name: |
Name |
|
Type: |
Character |
|
Length: |
100 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | ITEM_TYPE |
|
UI Field Name: |
Item Type |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
Inventory |
|
Valid Values: |
Inventory, Non-Inventory, Non-Inventory (Purchase only), Non-Inventory (Sales only) , Kit, or Stockable Kit. |
|
Dependencies: |
No |
|
Required: |
Yes |
|
Editable: |
No |
| Field Name: | COST_METHOD |
|
UI Field Name: |
Cost method |
|
Type: |
Character |
|
Length: |
N/A |
|
Default Value: |
None |
|
Valid Values: |
Standard, Average, FIFO, LIFO |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
No |
| Field Name: | V_VENDOR_ID |
|
UI Field Name: |
Vendor ID |
|
Type: |
Character |
|
Length: |
20 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
A valid Vendor |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | W_WAREHOUSE_ID |
|
UI Field Name: |
Warehouse ID |
|
Type: |
Character |
|
Length: |
40 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
A valid Warehouse |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | IC_COMPONENTKEY |
|
UI Field Name: |
Component ID |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
None |
|
Valid Values: |
A valid Item |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | IC_QUANTITY |
|
UI Field Name: |
Number of units |
|
Type: |
Number |
|
Length: |
10 |
|
Default Value: |
None |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | WEIGHTUOM |
|
UI Field Name: |
UOM for weight |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify NETWEIGHT |
|
Editable: |
No |
|
Description: |
UOM for weight |
| Field Name: | NETWEIGHT |
|
UI Field Name: |
Net weight |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
New weight |
| Field Name: | LWHUOM |
|
UI Field Name: |
UOM for length, width, and height |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify LENGTH, WIDTH, or HEIGHT |
|
Editable: |
No |
|
Description: |
UOM for length, width, and height |
| Field Name: | LENGTH |
|
UI Field Name: |
Length |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Length |
| Field Name: | WIDTH |
|
UI Field Name: |
Width |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Width |
| Field Name: | HEIGHT |
|
UI Field Name: |
Height |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Height |
| Field Name: | THICKNESSUOM |
|
UI Field Name: |
UOM for thickness |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify THICKNESS, MINIMUMTHICKNESS, or MAXIMUMTHICKNESS |
|
Editable: |
No |
|
Description: |
UOM for thickness |
| Field Name: | THICKNESS |
|
UI Field Name: |
Thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Thickness |
| Field Name: | MINIMUMTHICKNESS |
|
UI Field Name: |
Minimum thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Minimum thickness |
| Field Name: | MAXIMUMTHICKNESS |
|
UI Field Name: |
Maximum thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Maximum thickness |
| Field Name: | AREAUOM |
|
UI Field Name: |
UOM for area |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify AREA |
|
Editable: |
No |
|
Description: |
UOM for area |
| Field Name: | AREA |
|
UI Field Name: |
Area |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Area |
| Field Name: | VOLUMEUOM |
|
UI Field Name: |
UOM for volume |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify VOLUME |
|
Editable: |
No |
|
Description: |
UOM for volume |
| Field Name: | VOLUME |
|
UI Field Name: |
Volume |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Volume |
| Field Name: | DIAMETERUOM |
|
UI Field Name: |
UOM for diameter |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify INNERDIAMETER or OUTERDIAMETER |
|
Editable: |
No |
|
Description: |
UOM for diameter |
| Field Name: | INNERDIAMETER |
|
UI Field Name: |
Inner diameter |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Inner diameter |
| Field Name: | OUTERDIAMETER |
|
UI Field Name: |
Outer diameter |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Outer diameter |
| Field Name: | DENSITYUOM |
|
UI Field Name: |
UOM for density |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify DENSITY |
|
Editable: |
No |
|
Description: |
UOM for density |
| Field Name: | DENSITY |
|
UI Field Name: |
Density |
|
Type: |
Character |
|
Length: |
40 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
Area |
| Field Name: | DEFAULT_conversiontype |
|
UI Field Name: |
Default conversion type |
|
Type: |
Character |
|
Default value: |
Quantity |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
No |
Advanced item upload fields: Required
Back to Field descriptions
| Field Name: | DONOTIMPORT |
|---|---|
|
# |
Any row that starts with # is ignored during import. |
| Field Name: | ITEM_ID |
|
UI Field Name: |
Item ID |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
No |
| Field Name: | NAME |
|
UI Field Name: |
Name |
|
Type: |
Character |
|
Length: |
100 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | ITEM_TYPE |
|
UI Field Name: |
Item type |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
Inventory |
|
Valid Values: |
Inventory, Non-Inventory, Non-Inventory (Purchase only), Non-Inventory (Sales only) , Kit, or Stockable Kit. |
|
Dependencies: |
No |
|
Required: |
Yes |
|
Editable: |
No |
| Field Name: | ENABLEFULFILLMENT |
|
UI Field Name: |
Fulfillment |
|
Type: |
Boolean |
|
Default Value: |
false |
|
Valid Values: |
true, false |
|
Dependencies: |
No |
|
Required: |
No |
|
Editable: |
Yes |
|
Notes: |
Applicable only if item type is 'Non-Inventory' or 'Non-Inventory (Sales only)' and Inventory Control is configured for fulfillment. |
| Field Name: | COST_METHOD |
|
UI Field Name: |
Cost Method |
|
Type: |
Character |
|
Default Value: |
None |
|
Valid Values: |
Standard, Average, LIFO, FIFO |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | HAS_START_AND_ENDDATES |
|
UI Field Name: |
Enable start and end dates |
|
Type: |
Character |
|
Length: |
N/A |
|
Default Value: |
F |
|
Valid Values: |
T (True), F (False) |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
| Field Name: | TERM_PERIOD |
|
UI Field Name: |
Term period |
|
Type: |
Character |
|
Length: |
N/A |
|
Default Value: |
Days |
|
Valid Values: |
Days, Weeks, Months, Years |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | DEFAULT_NO_OF_PERIODS |
|
UI Field Name: |
Default no. of periods |
|
Type: |
Numeric |
|
Length: |
4 |
|
Default Value: |
None |
|
Valid Values: |
Positive integers up to 1,500 |
|
Dependencies: |
None |
|
Required: |
Yes, if HAS_START_AND_ENDDATES is true |
|
Editable: |
Yes |
| Field Name: | V_LINE_NO |
|
UI Field Name: |
None |
|
Type: |
Numeric |
|
Length: |
Any |
|
Default Value: |
None |
|
Valid Values: |
Positive integer |
|
Dependencies: |
Use 1 for the first line item, and increment by 1 for each subsequent line. |
|
Required: |
Yes |
|
Editable: |
No |
| Notes: | These are the line numbers on the Vendor history tab. |
| Field Name: | V_VENDOR_ID |
|
UI Field Name: |
Vendor ID |
|
Type: |
Character |
|
Length: |
20 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
Must refer to a valid vendor |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | W_LINE_NO |
|
UI Field Name: |
None |
|
Type: |
Numeric |
|
Length: |
Any |
|
Default Value: |
None |
|
Valid Values: |
Positive integer |
|
Dependencies: |
Start with 1 for the first line item, and increment by one for each subsequent line. |
|
Required: |
Yes |
|
Editable: |
No |
| Notes | These are the line numbers in the Warehouse section in the General tab. |
| Field Name: | W_WAREHOUSE_ID |
|
UI Field Name: |
Warehouse ID |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
Must refer to a valid warehouse |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | W_REORDER_METHOD |
|
UI Field Name: |
Reorder Method |
|
Type: |
Character |
|
Length: |
N/A |
|
Default Value: |
None |
|
Valid Values: |
Economic Qty, Max Stock Level or Reorder Point |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
Yes |
| Field Name: | IC_LINENO (applicable ONLY for kits) |
|
UI Field Name: |
None |
|
Type: |
Numeric |
|
Length: |
Any |
|
Default Value: |
None |
|
Valid Values: |
Positive integer |
|
Dependencies: |
Use 1 for the first line item and increment by 1 for each subsequent line. |
|
Required: |
Yes (if kits) |
|
Editable: |
No |
| Field Name: | IC_COMPONENTKEY (applicable ONLY for kits) |
|
UI Field Name: |
Item ID (on kits components tab) |
|
Type: |
Character |
|
Length: |
30 |
|
Default Value: |
None |
|
Valid Values: |
Alphanumeric and underscore |
|
Dependencies: |
None |
|
Required: |
Yes (if kits) |
|
Editable: |
Yes |
| Field Name: | WEIGHTUOM |
|
UI Field Name: |
UOM for weight |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify NETWEIGHT |
|
Editable: |
No |
|
Description: |
UOM for weight |
| Field Name: | NETWEIGHT |
|
UI Field Name: |
Net weight |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
New weight |
| Field Name: | LWHUOM |
|
UI Field Name: |
UOM for length, width, and height |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify LENGTH, WIDTH, or HEIGHT |
|
Editable: |
No |
|
Description: |
UOM for length, width, and height |
| Field Name: | LENGTH |
|
UI Field Name: |
Length |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Length |
| Field Name: | WIDTH |
|
UI Field Name: |
Width |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Width |
| Field Name: | HEIGHT |
|
UI Field Name: |
Height |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Height |
| Field Name: | THICKNESSUOM |
|
UI Field Name: |
UOM for thickness |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify THICKNESS, MINIMUMTHICKNESS, or MAXIMUMTHICKNESS |
|
Editable: |
No |
|
Description: |
UOM for thickness |
| Field Name: | THICKNESS |
|
UI Field Name: |
Thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Thickness |
| Field Name: | MINIMUMTHICKNESS |
|
UI Field Name: |
Minimum thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Minimum thickness |
| Field Name: | MAXIMUMTHICKNESS |
|
UI Field Name: |
Maximum thickness |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Yes |
|
Description: |
Maximum thickness |
| Field Name: | AREAUOM |
|
UI Field Name: |
UOM for area |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify AREA |
|
Editable: |
No |
|
Description: |
UOM for area |
| Field Name: | AREA |
|
UI Field Name: |
Area |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
Area |
| Field Name: | VOLUMEUOM |
|
UI Field Name: |
UOM for volume |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify VOLUME |
|
Editable: |
No |
|
Description: |
UOM for volume |
| Field Name: | VOLUME |
|
UI Field Name: |
Volume |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
Volume |
| Field Name: | DIAMETERUOM |
|
UI Field Name: |
UOM for diameter |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify INNERDIAMETER or OUTERDIAMETER |
|
Editable: |
No |
|
Description: |
UOM for diameter |
| Field Name: | INNERDIAMETER |
|
UI Field Name: |
Inner diameter |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
Np |
|
Description: |
Inner diameter |
| Field Name: | OUTERDIAMETER |
|
UI Field Name: |
Outer diameter |
|
Type: |
Number |
|
Length: |
13 |
|
Valid Values: |
Digits 0-9 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
Outer diameter |
| Field Name: | DENSITYUOM |
|
UI Field Name: |
UOM for density |
|
Type: |
Character |
|
Length: |
50 |
|
Dependencies |
A valid unit of measure detail |
|
Required: |
Yes, if you specify DENSITY |
|
Editable: |
No |
|
Description: |
UOM for density |
| Field Name: | DENSITY |
|
UI Field Name: |
Density |
|
Type: |
Character |
|
Length: |
40 |
|
Dependencies: |
None |
|
Required: |
No |
|
Editable: |
No |
|
Description: |
Area |
| Field Name: | DEFAULT_conversiontype |
|
UI Field Name: |
Default conversion type |
|
Type: |
Character |
|
Default value: |
Quantity |
|
Dependencies: |
None |
|
Required: |
Yes |
|
Editable: |
No |
