This section describes how the customer purchase order information from a sales order is carried into the invoices that are created from the sales order. This information applies to both the StreamV and the StreamII applications and it applies to all order types (i.e. Sales Orders and Shipper or Loaner orders), except for IFT orders, and to all programs that create invoice records from sales order information (this includes Order Completion, Vendor Ship Invoicing)
Type S Orders: The following logic is used when a Type S sales order is processed in the StreamV or StreamII Systems. This logic applies to all fulfillment methods (warehouse, special order, vendor shipments).
|
Field Name |
Field |
Field Name |
Field |
|
SOHEAD.PO_NO |
60:28 (A30) |
INVOICES.PO_NO |
56:18 (A30) |
|
SOHEAD.FULFILLMENT_PO |
60:109 (A30) |
INVOICES.FULFILLMENT_PO |
56:133 (A30) |
|
SOHEAD.PO_DATE |
60:84 (Date) |
INVOICES.PO_DATE |
56:118 (Date) |
|
SOLINE.PO_NO |
61:121 (A30) |
TRANSACT.PO_NO |
58:74 (A30) |
|
SOLINE.PO_LINE _NO |
61:113 (N14.4) |
TRANSACT.PO_LINE |
58:122 (N14.4) |
|
SOLINE.PO_PRICE |
61:114 (N14.4) |
TRANSACT.PO_PRICE |
58:121 (N14.4) |
|
SOLINE.PO_ITEM_NO |
61:122 (A30) |
TRANSACT.PO_ITEM_NO |
58:110 (A30) |
|
POLINE.PO_NO |
101:6 (N8) |
TRANSACT.HOUSE_PO_NO (internal use only – vendor shipment lines only) |
58:50 (N8) |
|
POLINE.LINE |
101:7 (N4) |
TRANSACT.HOUSE_PO_LINE (internal use only – vendor shipment lines only). |
58:51 (N4) |
Type L (Non-IFT) Orders: The following logic is used when a Type L (Loaner or Shipper) sales order is completed in the StreamV or StreamII Systems. This logic applies to all fulfillment methods (warehouse, special order, vendor shipments), and type L orders EXCEPT for IFT orders which are described in a following section.
The primary difference between type S and Type L orders is that completing a type L order does not result in a sale. When a type L order is completed, records are created in the Pending file for the items and quantities shipped to the customer and the customer is not charged for the items. The Pending records are used to record the shipment of the goods to the customer and track the outstanding items until the goods are returned by the customer, written off, or actually invoiced to the customer from the Pending file.
|
Field Name |
Field |
Field Name |
Field |
|
SOHEAD.PO_NO |
60:28 (A30) |
INVOICES.PO_NO |
56:18 (A30) |
|
SOHEAD.FULFILLMENT_PO |
60:109 (A30) |
INVOICES.FULFILLMENT_PO |
56:133 (A30) |
|
SOHEAD.PO_DATE |
60:84 (Date) |
INVOICES.PO_DATE |
56:118 (Date) |
|
SOLINE.PO_NO |
61:121 (A30) |
TRANSACT.PO_NO |
58:74 (A30) |
|
SOLINE.PO_LINE _NO |
61:113 (N14.4) |
TRANSACT.PO_LINE |
58:122 (N14.4) |
|
SOLINE.PO_PRICE |
61:114 (N14.4) |
TRANSACT.PO_PRICE |
58:121 (N14.4) |
|
SOLINE.PO_ITEM_NO |
61:122 (A30) |
TRANSACT.PO_ITEM_NO |
58:110 (A30) |
|
POLINE.PO_NO |
101:6 (N8) |
TRANSACT.HOUSE_PO_NO (internal use only – vendor shipment lines only) |
58:50 (N8) |
|
POLINE.LINE |
101:7 (N4) |
TRANSACT.HOUSE_PO_LINE (internal use only – vendor shipment lines only). |
58:51 (N4) |
|
POLINE.PO_NO |
101:6 (N8) |
PENDING.PO_NO (internal use only – vendor shipment lines only). |
161:9 (A25) |
|
POLINE.LINE |
101:7 (N4) |
PENDING.PO_LINE (internal use only – vendor shipment lines only). |
161:39 (N8) |
Note: Up until 7/27/06 the Transact PO_LINE field was being used both for internal and external PO line information (internal on vendor shipment orders, external on edi or manual orders). It was being loaded with customer information on normal or warehouse orders and with internal information (system generated purchase order information) when an order line for a vendor shipment or an interfacility transfer was processed.
As of 8/15/06, the StreamV and StreamII systems use the house PO fields in each transact record to store the PO number of any internal purchase orders that are tied to the invoice line. The transact house fields are loaded when Vendor Shipment orders, and Interfacility Transfers are processed by the invoicing programs. The House PO information is not carried in the sales order lines as more than one internal purchase order line can point to a single sales order line.
Type L IFT Orders: The following logic is used when a Type L IFT (Interfacility Transfer) sales order is completed in the StreamV or StreamII Systems. The Logic for an IFT order differs from other order types as IFT orders are used only for internal transfers of on hand inventory quantities between physically separate inventory locations.
|
Field Name |
Field |
Field Name |
Field |
|
SOHEAD.PO_NO (Field is automatically loaded with PO used to create the SO by the IFT system) |
60:28 (A30) |
INVOICES.PO_NO |
56:18 (A30) |
|
Not supported (IFT SO is created from PO and FF PO field is not supported in PO entry |
60:109 (A30) |
INVOICES.FULFILLMENT_PO |
56:133 (A30) |
|
Not supported (see above). |
60:84 (Date) |
INVOICES.PO_DATE |
56:118 (Date) |
|
SOLINE.PO_NO (Field is automatically loaded with PO used to create SO by IFT) |
61:121 (A30) |
TRANSACT.PO_NO |
58:74 (A30) |
|
SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT) |
61:113 (N14.4) |
TRANSACT.PO_LINE |
58:122 (N14.4) |
|
Not supported |
61:114 (N14.4) |
TRANSACT.PO_PRICE |
58:121 (N14.4) |
|
Not supported |
61:122 (A30) |
TRANSACT.PO_ITEM_NO |
58:110 (A30) |
|
SOLINE.PO_NO (Field is automatically loaded with PO used to create SO by IFT) |
101:6 (N8) |
TRANSACT.HOUSE_PO_NO (internal use only) |
58:50 (N8) |
|
SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT) |
101:7 (N4) |
TRANSACT.HOUSE_PO_LINE (internal use only). |
58:51 (N4) |
|
SOLINE.PO_NO (Field is automatically loaded with PO used to create SO by IFT) |
101:6 (N8) |
PENDING.PO_NO (internal use only. |
161:9 (A25) |
|
SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT) |
101:7 (N4) |
PENDING.PO_LINE (internal use only). |
161:39 (N8) |