Information Systems:UWD Tables - Revision history

Norwinu at 17:15, 30 June 2016

2016-06-30T17:15:37Z

New page

=UWD Tables=

Instead of building individual files for each set of options for data fields that can be entered or selected by a maintenance or inquiry program (for example, substitution classes, or price types), the extensions use one data file that can contain multiple tables.

To find out the name of the table a program is using for a particular field, key a question mark (?) into that field and press enter.

10/26/15 10:15:27 uniPHARM --Volume test ISRIQ100/LISTCTL
ISS - Show Item Substitution Master Records VOLUME 1.00
Display Order Field Test Value
DATED By Eff Date Descending, I
Limit to: AND
'''Class Status''' Date Range AND
'''?''' AD 00 00 00 00 Curr
Source Item Containing Target Items(s) Usage Generic
_________________________________________________
MA=Main Info | TBRIQ120/SELECT |
CP=Copy | Start at '''UX ISSCLASS''' |
Item | ISS Substitution Class | EFF END
00162800 | 1=Select | DEC 31 50
02400588 | Element Description/Data | DEC 31 50
02052793 | BONUS Bonus | DEC 31 50
02430056 | GENER Generic | DEC 31 50
02430064 | REPLC Replacement | DEC 31 50
02430072 | SUGG Suggestion | DEC 31 50
02430080 | --END-- | DEC 31 50
02071066 | | DEC 31 50
02349819 | F5=Refresh F12=Previous | DEC 31 50 +
|_______________________________________________| 21=Srcn Reset
F3=Exit F5=Refresh F6=Add Substitution F12=Previous F24=Srcn Save

This shows that the table (UX ISSCLASS) is used for item substitution class.

==List==

Go to -

Unity / Start uniPharm Extensions / VA Company / UWD Tables Menu

This menu shows multiple table types that were set up by the contractors that wrote the Extensions, but we are only using the UX extension tables.

Go into Work with UX Extension Tables. Key in 'ISSC' for 'Start display at', and make sure 'Limit to system' is 'UX'. then press enter.

10/26/15 10:14:32 uniPHARM --Volume test TBRUP002/TABLECTL
(C) 2004 RCS Ltd. CSU -- Show List of Tables CSU Release 6.0
Display Order Table Library: RCSUTILVOL
A By application,then table
'''Start display at''' '''Limit to: Sys''' Search for Secure Type
'''ISSC''' '''UX'''

1=Display Layout 5=Elements C=Copy R=Rename W=Programs Use
2=Change Layout 9=Purge table H=HELP Z=Clear elements
A=Audit Info P=Print M=Merge table
Ty Sy Table Name Description # Password
_ U UX ISSCLASS ISS Substitution Class 4
_ U UX ISSEXCPTYP Substitution Exception Type Codes 2
_ U UX ISSOSRCINV Only if Source Inventory Codes 3
_ U UX ISSOTGTINV Only if Target Inventory Codes 3
_ U UX ISSSTATUS Substitution Status Codes 3
_ U UX ISSTYPE Type of System or Application Issue 5
_ U UX ISSUSAGE ISS - Substitution Usage Codes 2
_ R UX ISSVIEWSUG Item Suggestion View Type 3 +

P next to an application indicates a table which requires a password
F3=Exit F12=Previous F15=Copy a Table
F5=Refresh F6=Add a New Table F17=Rename Table

==Layout==

Option 1 (display layout) will show the fields defined for the table. (This example shows a table with multiple fields defined, not the one from the above example).

10/26/15 10:27:33 uniPHARM --Volume test TBRUP022/TABLEAUP
DISPLAY CSU -- Enter/Update a Table Layout CSU Release 6.0
Application System Table Library: RCSUTILVOL
UX UniPHARM Extensions
Table Name Description Type Secure ? Password
ORDTYEXTRA Order Type Extra Data U N
Argument Description Length Dec.
Order Type 2

Field Description Length Decimals Start End
1 Valid for Online O/E 1 1 1
2 Valid for Promo Orders 1 2 2
3 Description 30 3 32
4 Perform availability chk? 1 33 33
5 Control deletion 1 34 34
6 Type R-regular S-special 1 35 35
7
8
9
10

F3=Exit F4=Show Data F6=Add Table F12=Previous
PAGE UP/PAGE DOWN

The Argument length can be a maximum of ten. The lengths of the individual fields must add up to 40 or less.

==Elements==

Option 5 (elements) will show the valued defined for the table.

10/26/15 10:31:57 uniPHARM --Volume test TBRUP001/HEADER
CSU -- Show Table Entries CSU Release 6.0
UX ORDTYEXTRA TABLE Table Library: RCSUTILVOL
UniPHARM Extensions Type
Order Type Extra Data U USER CONTROLLED

Start Display at Display Order
N By Element Name

2=Update 4=Cancel 5=Display A=Audit Info

Element Description/Data Sort
_ AD YNInvoice Adjustments N
_ AR YNAccounts Receivable U
_ A2 YNA/R credit N
_ CA YNCustomer Invoice Adj-Overship N
_ CC YNCustomer Credit - Short Ship N
_ CM YNCredit Memo N
_ DO YNDetail Order U R
_ DS YNDrop Ship U

F5=Refresh F6=Add new elements F12=Previous

To see an individual element formatted, use option 5 (display).

10/26/15 10:36:18 uniPHARM --Volume test TBRUP001/HEADER
CSU -- Enter/Update Table Entries CSU Release 6.0
UX ORDTYEXTRA TABLE Table Library: RCSUTILVOL
UniPHARM Extensions Type
Order Type Extra Data U USER CONTROLLED

DISPLAY
Len/Dec Sort
Order Type SP ( 2 )
1 2 3 4
1 0 0 0 0
Valid for Online O/E Y ( 1 )
Valid for Promo Orders N ( 1 )
Description Special Order (Category 900) ( 30 )
Perform availability chk? Y ( 1 )
Control deletion Y ( 1 )
Type R-regular S-special S ( 1 )

F3=Exit F12=Previous

==Files==

The files are in production library RCSUTILPRD or development library RCSUTILVOL.

TBHD01 (Tables -- Structure of tables) - contains a record for table name, and defines its layout.
TBDT01 (Tables -- Table Elements) - contains a record for every data element in every table.
TBAU01 (Tables -- Audit Trail for Table/Elemend Changes) - who added or updated a table or element, and when.

==Programs==

TBRIQ120 (TABLES - Pop-up Select a Table Element by Argument) - display a window of the elements of the requested table. Allow the user to select one, then return it to the calling program.

[[Category: Extensions]]

Sheilav: /* Files */

2015-10-26T19:26:58Z

Files

Sheilav at 19:26, 26 October 2015

2015-10-26T19:26:27Z

Sheilav at 18:51, 26 October 2015

2015-10-26T18:51:19Z

Sheilav at 18:03, 26 October 2015

2015-10-26T18:03:22Z

Sheilav at 17:49, 26 October 2015

2015-10-26T17:49:25Z

Sheilav at 17:38, 26 October 2015

2015-10-26T17:38:52Z

Sheilav at 17:32, 26 October 2015

2015-10-26T17:32:28Z

Sheilav at 17:23, 26 October 2015

2015-10-26T17:23:46Z

Sheilav: Created page with "=UWD Tables= Instead of building individual files for each set of options for data fields that can be entered or selected by a maintenance or inquiry program (for example, su..."

2015-10-26T17:22:34Z

Created page with "=UWD Tables= Instead of building individual files for each set of options for data fields that can be entered or selected by a maintenance or inquiry program (for example, su..."

New page

← Older revision		Revision as of 19:26, 26 October 2015
Line 153:		Line 153:

	==Programs==		==Programs==
		+
		+	TBRIQ120 (TABLES - Pop-up Select a Table Element by Argument) - display a window of the elements of the requested table. Allow the user to select one, then return it to the calling program.

← Older revision		Revision as of 18:03, 26 October 2015
Line 148:		Line 148:
	The files are in production library RCSUTILPRD or development library RCSUTILVOL.		The files are in production library RCSUTILPRD or development library RCSUTILVOL.

−	TBHD01 (Tables -- ~~Struture~~ of tables) -	+	TBHD01 (Tables -- Structure of tables) - contains a record for table name, and defines it's layout.
		+	TBDT01 () - contains a record for every data element in every table.

← Older revision		Revision as of 17:49, 26 October 2015
Line 143:		Line 143:

	F3=Exit F12=Previous		F3=Exit F12=Previous
		+
		+	==Files Used==
		+
		+	The files are in production library RCSUTILPRD or development library RCSUTILVOL.
		+
		+	TBHD01 (Tables -- Struture of tables) -

@@ Line 148: / Line 148: @@
 The files are in production library RCSUTILPRD or development library RCSUTILVOL.
- TBHD01 (Tables -- Structure of tables) - contains a record for table name, and defines it's layout.
+ TBHD01 (Tables -- Structure of tables) - contains a record for table name, and defines its layout.
  TBDT01 (Tables -- Table Elements) - contains a record for every data element in every table.
  TBAU01 (Tables -- Audit Trail for Table/Elemend Changes) - who added or updated a table or element, and when.

@@ Line 144: / Line 144: @@
  F3=Exit       F12=Previous
-==Files Used==
+==Files==
 The files are in production library RCSUTILPRD or development library RCSUTILVOL.
  TBHD01 (Tables -- Structure of tables) - contains a record for table name, and defines it's layout.
- TBDT01 () - contains a record for every data element in every table.
+ TBDT01 (Tables -- Table Elements) - contains a record for every data element in every table.

@@ Line 29: / Line 29: @@
   F3=Exit   F5=Refresh   F6=Add Substitution       F12=Previous   F24=Srcn Save
-This show that the table (UX ISSCLASS) is used for item substitution class.
+This shows that the table (UX ISSCLASS) is used for item substitution class.
 Go to -
@@ Line 62: / Line 64: @@
       F3=Exit                              F12=Previous     F15=Copy a Table
       F5=Refresh      F6=Add a New Table                    F17=Rename Table
 Option 1 (display layout) will show the fields defined for the table.  (This example shows a table with multiple fields defined, not the one from the above example).
@@ Line 90: / Line 94: @@
 The Argument length can be a maximum of ten.  The lengths of the individual fields must add up to 40 or less.
 Option 5 (elements) will show the valued defined for the table.
@@ Line 105: / Line 111: @@
         Element    Description/Data                         Sort
-        AD         YNInvoice Adjustments           N
+   _    AD         YNInvoice Adjustments           N
-        AR         YNAccounts Receivable           U
+   _    AR         YNAccounts Receivable           U
-        A2         YNA/R credit                    N
+   _    A2         YNA/R credit                    N
-        CA         YNCustomer Invoice Adj-Overship N
+   _    CA         YNCustomer Invoice Adj-Overship N
-        CC         YNCustomer Credit - Short Ship  N
+   _    CC         YNCustomer Credit - Short Ship  N
-        CM         YNCredit Memo                   N
+   _    CM         YNCredit Memo                   N
-        DO         YNDetail Order                  U R
+   _    DO         YNDetail Order                  U R
-        DS         YNDrop Ship                     U                          +
+   _    DS         YNDrop Ship                     U
         F5=Refresh     F6=Add new elements        F12=Previous

@@ Line 37: / Line 37: @@
 This menu shows multiple table types that were set up by the contractors that wrote the Extensions, but we are only using the UX extension tables.
-Go into . Key in 'ISSC' for 'Start display at', and make sure 'Limit to system' is 'UX'. then press enter.
+Go into Work with UX Extension Tables. Key in 'ISSC' for 'Start display at', and make sure 'Limit to system' is 'UX'. then press enter.
 /26/15  10:14:32    uniPHARM --Volume test               TBRUP002/TABLECTL
@@ Line 43: / Line 43: @@
  Display Order                                        Table Library: RCSUTILVOL
  A By application,then table
- Start display at   Limit to:   Sys  Search for                    Secure Type
+ '''Start display at'''   '''Limit to:   Sys'''  Search for                    Secure Type
-     ISSC                       UX
+     '''ISSC'''                       '''UX'''
 =Display Layout   5=Elements      C=Copy    R=Rename    W=Programs Use
@@ Line 50: / Line 50: @@
                      A=Audit Info    P=Print   M=Merge table
      Ty Sy Table Name  Description                               #   Password
-      U UX ISSCLASS    ISS Substitution Class                     4
+    _ U UX ISSCLASS    ISS Substitution Class                     4
-      U UX ISSEXCPTYP  Substitution Exception Type Codes          2
+    _ U UX ISSEXCPTYP  Substitution Exception Type Codes          2
-      U UX ISSOSRCINV  Only if Source Inventory Codes             3
+    _ U UX ISSOSRCINV  Only if Source Inventory Codes             3
-      U UX ISSOTGTINV  Only if Target Inventory Codes             3
+    _ U UX ISSOTGTINV  Only if Target Inventory Codes             3
-      U UX ISSSTATUS   Substitution Status Codes                  3
+    _ U UX ISSSTATUS   Substitution Status Codes                  3
-      U UX ISSTYPE     Type of System or Application Issue        5
+    _ U UX ISSTYPE     Type of System or Application Issue        5
-      U UX ISSUSAGE    ISS - Substitution Usage Codes             2
+    _ U UX ISSUSAGE    ISS - Substitution Usage Codes             2
-      R UX ISSVIEWSUG  Item Suggestion View Type                  3           +
+    _ R UX ISSVIEWSUG  Item Suggestion View Type                  3           +
     P next to an application indicates a table which requires a password
       F3=Exit                              F12=Previous     F15=Copy a Table
       F5=Refresh      F6=Add a New Table                    F17=Rename Table

@@ Line 10: / Line 10: @@
  DATED By Eff Date Descending, I
  Limit to:                                AND
- Class Status Date Range                  AND
+ '''Class Status''' Date Range                  AND
- ?            AD     00 00     00 00                                    Curr
+ '''?'''            AD     00 00     00 00                                    Curr
  Source Item     Containing Target Items(s)                      Usage Generic
                _________________________________________________
  MA=Main Info  |                             TBRIQ120/SELECT   |
- CP=Copy       |   Start at                   UX ISSCLASS      |
+ CP=Copy       |   Start at                   '''UX ISSCLASS'''      |
     Item       |              ISS Substitution Class           |    EFF END
     00162800   |   1=Select                                    |    DEC 31 50
@@ Line 29: / Line 29: @@
   F3=Exit   F5=Refresh   F6=Add Substitution       F12=Previous   F24=Srcn Save
-This show the table (UX ISSCLASS) is used for item substitution class.
+This show that the table (UX ISSCLASS) is used for item substitution class.
 Go to -