Difference between revisions of "Information Systems:UWD Tables"
| (2 intermediate revisions by one other user not shown) | |||
| 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 -- Structure of tables) - contains a record for table name, and defines |
+ | 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. |
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. |
TBAU01 (Tables -- Audit Trail for Table/Elemend Changes) - who added or updated a table or element, and when. |
||
| Line 155: | Line 155: | ||
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. |
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]] |
||
Latest revision as of 10:15, 30 June 2016
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.