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 |