XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for CodeDtlDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
code_type |
varchar24 |
1 |
1 |
This field will contain a valid code type for the row. the valid code types are defined on the CODE_HEAD table. |
NA |
NA |
varchar2 |
4 |
Yes |
Valid code type is 'PCLA' |
code |
varchar26 |
1 |
1 |
This field contains the code used in Retek which must be decoded for display in the on-line forms. |
combinability_code |
comb_code |
varchar2 |
24 |
Yes |
Item Combinability Code Definition |
code_desc |
varchar2250 |
1 |
1 |
This field contains the description associated with the code and the code type. |
combinability_code |
comb_code_desc |
varchar2 |
1000 |
No |
Item Combinability Code Description |
required_ind |
varchar21 |
1 |
1 |
This field indicates whether or not the code is required. If the code is specified as required, then the user will not be able to delete the rows in the table for that code. |
NA |
NA |
RIB or/and RSB |
Fill column length. |
Yes |
Not used in RWMS |
code_seq |
number4 |
1 |
1 |
This is a number used to order the elements so that they appear consistently when using them to populate a list. |
NA |
NA |
RIB or/and RSB |
Fill column length. |
No |
Not used in RWMS |