Current Mailing Address
Description
Retrieve either the current or as-of-a-date mailing address for an Address Book Number.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Address Number | Column or Literal | ✔ |
| As of Date | Column or Literal - Default set to Today's Date | ✔ |
| Add name | Check Box | |
| Add Country | Check Box |
Remarks
- This calculation will always use the mailing name for line ID zero in the F0111.
- Mailing address (stored in the F0116) is formatted in a region-specific format using values from the CTR column in the F0116 (UDC 00/CN). Current specified formats: US, EU, UK, ZH (China), RU, CA, GB, CN, TW, SG, UZ. The US format will be used for undefined formats.
- Language specific addresses will attempt to be retrieved from the F0116D and F0111D tables matching the signed-on user's language preference (specified in user preferences). This is supported starting with JDE Applications 9.2 Update 7.
Example
- Input: 1001
- Quick Calculations > JDE > Current Mailing Address
Output: (Format using the US format with line breaks)
J.D. Edwards & Company (<NAME> skipped if Name is unchecked)
8055 Tufts Avenue (<ADDR>)
Suite 1331 Denver, CO 80237 (<CITY>, <STATE> <ZIP>)
(<COUNTRY> skipped if Country is unchecked)