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 |
|
REQUISITION ATTRIBUTES ATTR CODE <<->> ATTR VALUE |
N |
Attribute Name |
|
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 |
|
REQ LINE AC INFORMATION ACCOUNT CODE <<->> QTY <<->> QTY UNIT <<->> BUDGET <<->> CURRENCY |
N |
Account Code |
|
REQ LINE CCL CC LAYOUT SHORT |
N |
Layout Short |
|
TAG DEF COMMODITY GROUP |
Y |
Commodity Group |