General File Format - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

The following data can be imported with this Excel file:

Level

Name

Mandatory?

Field Name on P.50.07

Agreement Header

PO_NUMBER

Y

Agreement Number

SHORT_DESC

N

Short Desc

DESCRIPTION

N

Description

NLS_ID

N

Nls

ORDER_TYPE

Y

(Order Type)

PO_SUPP

N

Suppl

SUP_CODE

Y

Supplier

PO_CURRENCY

Y

Currency

PO_RM_CODE

Y

Routing Method

BUYER

Y

Buyer

ORIGIN

N

Origin

ISSUED_BY

N

Issued By

PO_COUNTRY

N

Country Code

CLIENT_PO_NUMBER

N

Client Agreement Number

POINT_OF_ORIGIN

N

Point of Origin

EXPED_ILV_CODE

N

ILV_CODE

N

EV_CODE

N

CCP_CODE

N

PO_ACCOUNT_CODE

N

Account Code

ORG_ETA_SITE_DATE

N

ETA Site

TECH_EVAL_COMP_DATE

N

Tech Eval Comp Date

EXPEDITER

N

Expediter

TRAFFIC

N

Traffic

READY_FOR_APPROVAL_IND

N

Ready For Approval

APPROVED_DATE

N

Approved Date

APPROVED_BY

N

Approved By

PARENT_ORDER

N

(Parent) Agreement

PARENT_PO_NUMBER

N

(Parent) Agreement Number

PARENT_PO_SUPP

N

(Parent) Suppl

PARENT_ORIGIN_CODE

N

(Parent) Origin

PARENT_ORDER_TYPE

N

(Parent Order Type)

Line Items

POLI_POS

Y

Pos

POLI_SUB_POS

Y

Sub

IDENT_CODE

Y

Ident Code

POLI_QTY

Y

Quantity

POLI_QTY_CODE

Y

Quantity Unit

POLI_CURRENCY

Y

Currency

POLI_UNIT_WEIGHT

Y

Unit Weight

POLI_WEIGHT_CODE

Y

Weight Unit

TAG_NUMBER

N

Tag Number

POLI_UNIT_PRICE

N

Unit Price

POLI_VOLUME

N

Volume

FRT_CODE

N

Incoterm

FREIGHT_VALUE

N

Delivery Place

PROM_CONTR_DATE

N

Prom Contract

POLI_UNIT_PRICE

N

Unit Price

SUPPLY_PRICE

N

Supply Price

INSTALL_PRICE

N

Install Price

PRICE_BASE

N

Price Base

POLI_VOL_CODE

N

Volume Unit

POLI_DIMENSIONS

N

Dimensions

POLI_COUNTRY

N

Country of Origin

MANUFACTURER

N

Manufacturer

CATALOG_NUMBER

N

Catalog Number

PERCENT_US_CONTENT

N

%Dom.Prod.

TEC_PASSED_IND

N

TE Passed

EXPORT_LICENSE_REQ_IND

N

Exp Lic Req

EXPORT_LICENSE_NUMBER

N

Exp Lic Number

EXPORT_LICENSE_RECEIVED_DATE

N

Exp Lic Recv

POLI_ACCOUNT_CODE

N

Account Code

ACCEPTED_IND

N

Accepted

ITY_CODE

N

Item Type

LAYOUT SHORT

N

Layout Short

LAYOUT LONG

N

Layout Long

PARENT_POLI

N

(Parent POLI)

PARENT_POLI_POS

N

(Parent POLI Pos)

PARENT_POLI_SUB_POS

N

(Parent POLI Sub Pos)

REQ_LINE_ITEM

N

Req Line Item

R_CODE

N

Engineering Requisition

R_SUPP

N

Suppl

R_ORIGIN_CODE

N

Origin

R_ACTUAL_IND

N

Purchase

RLI_POS

N

(RLI) Pos

RLI_SUB_POS

N

(RLI) Sub

POLI_SPLIT_TAG

N

Split Tag

Item Shipments

POLI_POS

Y

Pos

POLI_SUB_POS

Y

Sub

ITEM_SHIP_POS

Y

IS Pos

ITEM_SHIP_SUB_POS

Y

IS Sub

ITEM_SHIP_QTY

N

Quantity

ITEM_SHIP_QTY_CODE

N

Quantity Unit

ITEM_SHIP_WEIGHT

N

Item Ship Weight

ITEM_SHIP_WEIGHT_CODE

N

Unit Weight

ITEM_SHIP_VOLUME

N

Item Ship Volume

ITEM_SHIP_VOL_CODE

N

Unit Volume

ITEM_SHIP_DIMENSIONS

N

Item Ship Dimension

DD_CODE

N

Delivery Designation

ITEM_SHIP_RM_CODE

N

Routing Method

FAB_LOCATION

N

Fab Location

FAB_SHOP_CNTRL_NUMBER

N

Fab Ctrl Number

FAB_COMPLETE_PERCENT

N

Comp %

FIFTY_PERCENT_FAB_COMP

N

50% Comp

REV_PROM_SHIP_DATE

N

Rev Prom Ship

MAJ_MATL_ORDER_DATE

N

Maj Matl Order

MAJ_MATL_RECV_DATE

N

Maj Matl Recv

ACTUAL_FAB_START_DATE

N

Actual Fab Start

PROM_FAB_COMP_DATE

N

Prom Fab Comp

ACTUAL_FAB_COMP_DATE

N

Actual Fab Comp

ACTUAL_SHIP_DATE

N

Actual Ship

PRED_SHIP_DATE

N

Pred Ship

PRED_ON_SITE_DATE

N

Pred On Site

ACTUAL_ON_SITE_DATE

N

Actual On Site

ACTUAL_CONTRACT_DATE

N

PO Actual

PROM_INSPECT_DATE

N

Prom Inspect

FINAL_INSPECT_DATE

N

Final Inspect

READY_PREDICTED

N

Ready Predicted

READY_ACTUAL

N

Ready Actual

PROM_CONTRACT_DATE

N

Prom Contract

PROM_SHIP_DATE

N

Prom Ship

REQ_SITE_DATE

N

Req On Site

ISH_EXPORT_LICENSE_REQ_IND

N

Exp Lic Req

COMMENTS

N

Comments

ISH_SPLIT_TAG

N

Split Tag