This process will create and replace product information in BusinessPlus from a comma-delimited flat file data. Free form product text can also be loaded by this utility from a comma-delimited file.
The user will be prompted for the following information:
-
The type of data trying to be imported (Product Information or Free Form Text).
-
How to handle duplicate data (Replace or Report Duplicates on the tail sheet).
-
The name of the input file.
The product flat file must be comma-delimited in the same format as if it were exported from Excel. The bolded fields cannot be blank.
Common code SIUT/PROD is required for the SIUTLP interface. It controls the Text Type (field from the text input file) that can be imported into the BusinessPlus pe_desc_dtl. There is a limit of 24 types that can be defined in the long description. Each type must be separated by a comma and no spaces.
Product File Format
|
Col |
Contents |
Format (Max Length, Decimals) |
Database Column Name |
|---|---|---|---|
|
A |
Product ID |
CHAR(16) |
PE_PROD_ID |
|
B |
Description |
CHAR(30) |
PE_DESC |
|
C |
Status (AC/IN/OB) |
CHAR(2) |
PE_STATUS |
|
D |
Unit |
CHAR(8) |
PE_UNIT |
|
E |
Product Class |
CHAR(6) |
PE_PROD_CLASS |
|
F |
Stocked in Stores (Y/N) |
CHAR(2) |
PE_STOCK_Q |
|
G |
Stock Class (A/B/C) |
CHAR(2) |
PE_CLASS |
|
H |
Require Lot # |
CHAR(1) |
PE_FLAG_1 |
|
I |
Serial # |
CHAR(1) |
PE_FLAG_2 |
|
J |
Expiration Date |
CHAR(1) |
PE_FLAG_3 |
|
K |
Flag 4 |
CHAR(1) |
PE_FLAG_4 |
|
L |
Commodity |
CHAR(16) |
PE_COM |
|
M |
Primary Vendor |
CHAR(12) |
PE_PRI_VENDOR |
|
N |
Secondary Vendor |
CHAR(12) |
PE_SCND_VENDOR |
|
O |
Buyer |
CHAR(12) |
PE_BUYER |
|
P |
Size |
NUMBER(10,1) |
PE_UNIT_SZ |
|
Q |
Weight |
NUMBER(10,1) |
PE_UNIT_WT |
|
R |
Miscellaneous Code |
CHAR(4) |
PE_MISC |
|
S |
Carrying Cost |
NUMBER(10,2) |
PE_CARRY_CST |
|
T |
Ordering Cost |
NUMBER(10,2) |
PE_ORDER_CST |
|
U |
Retail Price |
NUMBER(20,5) |
PE_RETAIL_PR |
|
V |
Internal Ledger Code |
CHAR(2) |
PE_GR1 |
|
W |
Internal Object Code |
CHAR(8) |
PE_OBJ1 |
|
X |
External Ledger Code |
CHAR(2) |
PE_GR2 |
|
Y |
External Object Code |
CHAR(8) |
PE_OBJ2 |
|
Z |
Price Code 1 |
CHAR(2) |
PE_PRICE_CD01 |
|
AA |
Price Code 2 |
CHAR(2) |
PE_PRICE_CD02 |
|
AB |
Price Code 3 |
CHAR(2) |
PE_PRICE_CD03 |
|
AC |
Price Code 4 |
CHAR(2) |
PE_PRICE_CD04 |
|
AD |
Price Code 5 |
CHAR(2) |
PE_PRICE_CD05 |
|
AE |
Price Code 6 |
CHAR(2) |
PE_PRICE_CD06 |
|
AF |
Price Calculation 1 |
CHAR(30) |
PE_PRICE_CALC01 |
|
AG |
Price Calculation 2 |
CHAR(30) |
PE_PRICE_CALC02 |
|
AH |
Price Calculation 3 |
CHAR(30) |
PE_PRICE_CALC03 |
|
AI |
Price Calculation 4 |
CHAR(30) |
PE_PRICE_CALC04 |
|
AJ |
Price Calculation 5 |
CHAR(30) |
PE_PRICE_CALC05 |
|
AK |
Price Calculation 6 |
CHAR(30) |
PE_PRICE_CALC06 |
|
AL |
Discount Quantity 1 |
NUMBER(10) |
PE_DISC_QTY01 |
|
AM |
Discount Quantity 2 |
NUMBER(10) |
PE_DISC_QTY02 |
|
AN |
Discount Quantity 3 |
NUMBER(10) |
PE_DISC_QTY03 |
|
AO |
Discount Quantity 4 |
NUMBER(10) |
PE_DISC_QTY04 |
|
AP |
Discount Quantity 5 |
NUMBER(10) |
PE_DISC_QTY05 |
|
AQ |
Discount Quantity 6 |
NUMBER(10) |
PE_DISC_QTY06 |
|
AR |
Discount Terms 1 |
NUMBER(5,2) |
PE_DISC_TERMS01 |
|
AS |
Discount Terms 2 |
NUMBER(5,2) |
PE_DISC_TERMS02 |
|
AT |
Discount Terms 3 |
NUMBER(5,2) |
PE_DISC_TERMS03 |
|
AU |
Discount Terms 4 |
NUMBER(5,2) |
PE_DISC_TERMS04 |
|
AV |
Discount Terms 5 |
NUMBER(5,2) |
PE_DISC_TERMS05 |
|
AW |
Discount Terms 6 |
NUMBER(5,2) |
PE_DISC_TERMS06 |
|
AX |
Discount Amount 1 |
NUMBER(10,2) |
PE_DISC_AMT01 |
|
AY |
Discount Amount 2 |
NUMBER(10,2) |
PE_DISC_AMT02 |
|
AZ |
Discount Amount 3 |
NUMBER(10,2) |
PE_DISC_AMT03 |
|
BA |
Discount Amount 4 |
NUMBER(10,2) |
PE_DISC_AMT04 |
|
BB |
Discount Amount 5 |
NUMBER(10,2) |
PE_DISC_AMT05 |
|
BC |
Discount Amount 6 |
NUMBER(10,2) |
PE_DISC_AMT06 |
|
BD |
Commodity Type |
CHAR(8) |
PE_COM_TYPE |
|
BE |
User 1 |
CHAR(16) |
PE_USER_1 |
|
BF |
User 2 |
CHAR(16) |
PE_USER_2 |
Product Free Form Text File
|
Col |
Contents |
Format (Max Length, Decimals) |
Database Column Name |
|---|---|---|---|
|
A |
Product ID |
CHAR(16) |
PE_PROD_ID |
|
B |
Description |
CHAR(50) |
PED_DESC |
|
C |
Type & Sequence (e.g., IT01, CT01, CA01, PO01, AR01, WD01, WP01) |
CHAR(4) |
PED_SEQ_NO |