Shipto account number lookup: <tpid>_O_SHIPTO
Cross-reference lookup for a shipto account based on shipto + vendor + purchase from + company.
- Cross-reference
- Conditional - Required if Purchasing Vendor Shipto Account numbers are not defined
- Default behavior: If record does not exist, <shipto>+<vendor>+<purchaseFrom>+<company> lookup string will be mapped to N1ST04
- Related: <tpid>_O_N104_REQLOC,MAP_SHIPTO_ACCOUNT
| Field | Value | Example | Comment |
|---|---|---|---|
| List Name | <tpid>_O_SHIPTO | JT_O_SHIPTO | n/a |
| Your Value | <shipto>+<vendor>+<purchaseFrom>+<company> | WHSE+47++1021 | For POs without a PurchaseFrom, include the plus with no value. |
| Partner Value | <N1ST04 value> | 293084752 | N1^ST^SHIPTO NAME^91^293084752 |
Usage
If Purchasing Vendor Shipto Account Number is not used, then the _O_SHIPTO record is the key data substitution record required for Purchase Order 850 transactions. It is also one that people sometimes struggle with. There are four keys for the Your Value field <shipto>+<vendor>+<purchaseFrom>+<company>. The values inside < > are placeholders for the values on the purchase order. The + is a literal plus sign. Every PO contains a shipto, a vendor, and a company. If you do not use purchasing locations, the value is empty but the plus sign is still required. If a cross-reference value is not found, then Your Value is written to N1ST04
Example with purchase from: WHSE+963+LUM+1021
Example without purchase from: WHSE+47++1021
A <tpid>_O_SHIPTO record is required for every valid combination of <shipto>+<vendor>+<purchaseFrom>+<company> that is on a PO that sent using EDI.
N1^BY^ <N102 value>^92^<_O_SHIPTO Partner Value>
Usage
You can define ship to account numbers on a purchasing vendor. The vendor shipto account number is written to PurchaseOrderEDIOutput when the Purchase Order is issued.
The Partner Value indicates how Vendor Shipto Account numbers in PurchaseOrderEDIOutput are used.
- If a MAP_SHIPTO_ACCOUNT record is not found, then the <tpid>_O_SHIPTO lookup is performed.
- If a MAP_SHIPTO_ACCOUNT record contains a Partner Value of O and the PurchaseOrderEDIOutput Purchasing Vendor Shipto Account is empty, then N1ST04 is empty.