Import from Excel File - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

For the import from Microsoft Excel, you must provide an Excel file with a structure corresponding to the template delivered with the software. You can find the template Requisitions_Template.xls in the ..\others\excel_templates folder on the application server.

If there is hint text available in the template, it is displayed if you click in the header field.

Dropdown lists are available for the check box fields. The available values are Y (check box selected) and N (check box cleared).

The following data can be imported with this Excel file:

Level

Name

Mandatory?

Field Name on R.30.01

Requisition Header

NODE PATH

Y

Req Node Path

REQUISTION CODE

Y

Engineering Requisition

REQUISITION SUPPLEMENT

Y

Suppl

ORIGIN

Y

Origin

PURCHASE

Y

Purchase (check box)

REQUISITION STATUS

Y

Status

TECH EVAL REQUIRED

Y

TE Rqd (check box)

READY FOR APPROVAL

Y

RfA (check box)

ORIGINATOR

Y

Originator

BUY CYCLE SEQUENCE

N

Buy Cycle

ACCOUNT CODE

N

Account Code

MILESTONE SET

N

Milestone Set

BLANKET ORDER NUMBER

N

Blanket Order

BLANKET ORDER SUPPLEMENT

N

./.

BLANKET ORDER DESIGN

N

./.

MATERIAL GROUP

N

Matl/Work Group

REQUISITION CATEGORY

N

Category

NLS INFORMATION

NLS <<->> SHORT DESC <<->> DESCRIPTION

N

Nls
Short Desc
Description

REQUISITION ATTRIBUTES

ATTR CODE <<->> ATTR VALUE

N

Attribute Name
Attribute Value

Requisition Line Items

POS

Y

Pos

SUBPOS

Y

Sub

TOTAL RELEASE QTY

Y

Released Quantity

RELEASE QTY UNIT

Y

Quantity Unit

BUDGET

Y

Budget

CURRENCY

Y

Currency

WEIGHT

Y

Unit Weight

WEIGHT UNIT

Y

Weight Unit

TECH EVAL REQUIRED

Y

TE Rqd (check box)

TAG NUMBER

Y

Tag Number

ITEM TYPE

Y

Item Type

IDENT CODE

Y

Ident Code

ALLOW RTP

Y

Allow RTP (check box)

FORCE RTP

Y

Force RTP (check box)

ACCOUNT CODE

N

Account Code

DELIVERY DESIGNATION

N

Delivery Designation

ROS DATE

N

ROS Date

PROCURE CHANNEL

N

Procure Channel

REQ LINE ATTRIBUTES

ATTR CODE <<->> ATTR VALUE

N

Attribute Name
Attribute Value

REQ LINE AC INFORMATION

ACCOUNT CODE <<->> QTY <<->> QTY UNIT <<->> BUDGET <<->> CURRENCY

N

Account Code
Released Quantity
Quantity Unit
Budget
Currency

REQ LINE CCL

CC LAYOUT SHORT
CC LAYOUT LONG

N

Layout Short
Layout Long

TAG DEF

COMMODITY GROUP
COMMODITY GROUP DISCIPLINE
COMMODITY PART
COMMODITY PART DISCIPLINE

Y

Commodity Group
Discipline
Commodity Part
Discipline