Define the export format of data to the Demand Solutions third-party forecasting package.
Demand Solutions is a third-party package that interfaces with Apprise®. It is used to calculate purchasing requirements based on existing inventory availability and future expected demand. Apprise can export the following data in the following format to Demand Solutions for On-Hand Inventory Balance (ONHAND.DAT).
The following table lists the format for exporting to ONHAND.DAT.
|
Position |
Field |
Length |
Format |
|
1-32 |
Item |
32 |
A/N |
|
33-35 |
Company |
3 |
A/N |
|
36-43 |
Division |
8 |
A/N |
|
44-55 |
Corporation |
12 |
A/N |
|
56-63 |
Sold |
8 |
A/N |
|
64-66 |
Department |
3 |
A/N |
|
67-78 |
Ship-to |
12 |
A/N |
|
79-86 |
Quantity |
8 |
N |
|
87-98 |
Weight |
12 |
NFloatingDecimal |
|
99-110 |
Cube |
12 |
NFloating Decimal |
|
111-118 |
MTD Sales |
8 |
N |
|
119-126 |
Minimum Order Quantity |
8 |
N |
|
127-134 |
Multiple |
8 |
N |
|
135-137 |
Safety Time |
3 |
N |
|
138 |
No Buy Flag |
1 |
A/N Y= NoBuy |
|
139-141 |
Lead Time |
3 |
N |
|
142-157 |
Remark |
16 |
A/N |
|
158 |
Remark Indicator |
1 |
A/N |
|
159 |
Carriage Return (Hex 0D) |
1 |
A/N |
|
160 |
Linefeed (Hex 0A) |
1 |
A/N |
Note Italicized items are the primary key, or the unique item identifier.
Positions 86-160 are optional; the file can be limited to only positions 1-85.
You can choose to set up your Primary Key (1-78) as an abbreviated key with item in positions 1-17 and location in positions 18-20. All three DRP files must be set up in the same Primary Key format.
The following table lists the format for exporting to CUSTORDS.DAT.
|
Position |
Field |
Length |
Format |
|
1-32 |
Item |
32 |
A/N |
|
33-35 |
Company |
3 |
A/N |
|
36-43 |
Division |
8 |
A/N |
|
44-55 |
Corporation |
12 |
A/N |
|
56-63 |
Sold |
8 |
A/N |
|
64-66 |
Department |
3 |
A/N |
|
67-78 |
Ship-to |
12 |
A/N |
|
79-86 |
Quantity |
8 |
N |
|
87* |
Filler |
1 |
A/N |
|
88-100 |
PO Number |
13 |
A/N |
|
101-108 |
Customer Number |
8 |
A/N |
|
109-138 |
Remarks |
30 |
A/N |
|
139-142 |
Status |
4 |
A/N |
|
143-152 |
Due Date (YYYYMMDD) |
8 |
N |
|
153 |
Carriage Return (Hex 0D) |
1 |
A/N |
|
154 |
Linefeed (Hex 0A) |
1 |
A/N |
Note Italicized fields are the primary key, or the unique item identifier.
* A "D" in position 87 indicates that this order is to be posted as Dependent Demand.
You can choose to set up your Primary Key (1-78) as an abbreviated key with item in positions 1-17 and location in positions 18-20. All three DRP files must be set up in the same Primary Key format.
The following table lists the format for exporting to RECEIPTS.DAT.
|
Position |
Field |
Length |
Format |
|
1-32 |
Item |
32 |
A/N |
|
33-35 |
Company |
3 |
A/N |
|
36-43 |
Division |
8 |
A/N |
|
44-55 |
Corporation |
12 |
A/N |
|
56-63 |
Sold |
8 |
A/N |
|
64-66 |
Department |
3 |
A/N |
|
67-78 |
Ship-to |
12 |
A/N |
|
79-86 |
Quantity |
8 |
N |
|
87* |
Filler |
1 |
A/N |
|
88-96 |
P.O. Number |
9 |
A/N |
|
97-147 |
Remarks |
51 |
A/N |
|
148-157 |
Due Date (YYYYMMDD) |
8 |
N |
|
158 |
Carriage Return (Hex 0D) |
1 |
A/N |
|
159 |
Linefeed (Hex 0A) |
1 |
A/N |
Note Italicized fields are the primary key, or the unique item identifier.
*A "W" in position 87 indicates that the receipt is a Work Order.It is important to distinguish work orders so that component (child) usage is calculated properly.You can choose to set up your Primary Key (1-78) as an abbreviated key with item in positions 1-17 and location in positions 18-20. All three DRP files must be set up in the same Primary Key format.
The following table lists the format for exporting to ORDPLAN.TXT
|
Position |
Field |
Length |
Format |
Required |
|
1-12 |
Vendor |
12 |
A/N |
Y |
|
13-24 |
Ship-To (Location/DC) |
12 |
A/N |
Y |
|
25-26 |
Order Period |
2 |
N |
Y |
|
27 |
Supplier Type |
1 |
A/N |
Y |
|
28-93 |
Primary Key (Partial) |
66 |
A/N |
Y |
|
94 |
Priority |
1 |
N |
N |
|
95-102 |
Order Quantity |
8 |
N |
N |
|
103-110 |
Fixed Minimum |
8 |
N |
N |
|
111-118 |
Computed Minimum |
8 |
N |
N |
|
119-126 |
Multiple (Lot Size) |
8 |
N |
N |
|
127-138 |
Unit Weight |
12 |
NFloatingDecimal |
N |
|
139-150 |
Unit Cube |
12 |
NFloatingDecimal |
N |
|
151-160 |
Unit Cost |
10 |
N |
N |
|
161-172 |
Equivalent Unit |
12 |
N |
N |
|
173-180 |
Extended Weight |
8 |
N |
N |
|
181-188 |
Extended Cube |
8 |
N |
N |
|
189-198 |
Extended Cost |
10 |
N |
N |
|
199-206 |
Extended Eqv. Unit |
8 |
N |
N |
|
207-215 |
Required Date (DDMMMYYYY) |
9 |
A/N |
Y |
|
216 |
Carriage Return (Hex 0D) |
1 |
A/N |
N |
|
217 |
Linefeed (Hex 0A) |
1 |
A/N |
N |
Note Italicized fields are required by your system.
Vendor: Source of supply for requiring DC/warehouse/location
Ship-To: DC/warehouse/location
Primary Key (Partial): The part number to be ordered
Required Date: The date the DC/warehouse/Location needs the products available in inventory