BSFN: ValidateAccountNumber (XX0901)

BSFN: ValidateAccountNumber

Account Number (alias=ANI) were very frequent used field in G/L side, unlike the other common alias out there ... ANI is a bit different.

ANI can be in any form and any length, most commonly setting were the "MCU.OBJ.SUB" combination.

So when comes to validation of Account Number, things were a bit complex.

I found this Business Function were quite handy in doing this job:
XX0901 (ValidateAccountNumber)

However it's a bit tricky to use, after looking at the parameter notes, I able to figure out how to make use of it for validation.

Example ER:

ValidateAccountNumber
[FC Account Number] -> [BF mnAccountNumber]
[VA evt_mnF0901_AID] <- [BF mnAccountID]
"7" -> [BF cBaseCode]
"1" -> [BF cFormatCode]

F0901.FetchSingle
[VA evt_mnF0901_AID] = [BF mnAccountID]
[VA evt_szF0901_OBJ] <- [BF ObjectAccount]

If [SV File_Status] equal to [CO_SUCCESS]
MDDebug
"Valid Account Number" -> [BF szComment]
[VA evt_mnF0901_AID] -> [BF String1]
Else
MDDebug
"Invalid Account Number" -> [BF szComment]
[VA evt_mnF0901_AID] -> [BF String1]
End If


by Avatar Ng
2008/06/19

EnterpriseOne(R) object types

EnterpriseOne(R) object types:
- APPL - Applications, including Vocabulary Overrides, Bitmaps and Icons
- APPLVER - Application Versions, including Processing Options
- BL - Parent Libraries - definition only, the DLL is not copied
- BSFN - Business Functions, all types: C, NER and Java (SBF)
- BSVW - Business Views
- DD - Data Dictionary Items, including any Language Translations
- DSTR - Data Structures, including GT Object Type
- TBLE - Tables
- UBE - Batch Applications, including Vocabulary Overrides
- UBEVER - Batch Versions, including Processing Options, Data Selections, etc.
- UDC - User Defined Codes, including any Language Translations
- MENU/ACTIVERATASK - Menu / Task Items
- USEROVERRIDE - User Overrides
- WORKFLOW - Workflow Processes
- XMLP
- SVCT
- RPDF
- And some others: CLASS, DATASET, AUTOPILOTSCRIPT, ACTIVERARELATION,
ACTIVERARULE, ACTIVERACROSSREF, ACTIVERAVARIANT, USER, GENERIC,
PROJECTOBJECT, PROJECTUSER


by Avatar Ng

JDE - database independent platform

Found some interesting to share here ...

"JDE uses these APIs to dynamically generate platform-specific SQL statements. Thus, this middleware provides workstation-to-server and server-to-server database access. To accomplish this, both the legacy JDE OneWorld middleware as well as the newer JDE EnterpriseOne middleware incorporate database driver support for a variety of third-party database drivers including ODBC, for connection to Microsoft SQL server, OCI, for connection to Oracle database and Client Access 400 drivers for connectivity to IBM DB2."

As refer to above statement (from wiki), I think it clears lots of doubts that frequently raised by JDE developer: "why can't I just go to the lower level and write my own SQL statement ...?"

Well a lot of us might ask that due to some performance issues that JDE developer frequently faces.

JDE is meant to design in such a way so that it is so generic. However, it is common to the software developer that you have to sacrifice something in exchange for something else.
E.g.: you trade off performance OR h/w requirement for graphics in games.
In this case, JDE decided to trade off some-level of performance for greater database-support-range.

That reminds me a common quote that I often uses: "there is no best software, anything above average is good enough ..." (:P perfectionism might not totally agree with me, but hey ... at least that kills over-budget, behind-schedule or even worst project-dropping).


by Avatar Ng

RDA - the World version

Report Design Aid (RDA), in the World version (code in RPG language).

First complete report design aid in J.D.Edwards ever, recapturing the green screen century.

By Avatar Ng.

JD Edwards - Introduction

J.D. Edwards, also called JDE, is a software company founded in March 1977 in Denver, Colorado by Jack Thompson, C.T.P."Chuck" Hintze, Dan Gregory and Ed McVaney.

The company made its name building accounting software for IBM minicomputers, beginning with the System/34 and /36, focusing from the mid 1980s on System/38 minicomputers, switching to the AS/400 when it became available.

Their main AS/400 offering was called JDEdwards WorldSoftware and is popularly called World.

In 1996, J.D. Edwards also launched a client-server version of their software called OneWorld.

The company's official name was J.D. Edwards World Source Company and it is located at One Technology Way, in Denver, CO 80237. JDE was bought out by PeopleSoft in 2003.

PeopleSoft, in turn, was purchased by Oracle Corporation in 2005.

[picked from wikipedia]