Load Products and Product Text - SIUTLP
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 |