XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjHdrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
adjustment_id |
number12 |
1 |
1 |
Unique identifier |
INV_ADJUST |
ID |
NUMER |
12,0 |
Yes |
Adjustment identifier. |
status |
str_adj_status |
1 |
1 |
Current status Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. |
INV_ADJUST |
STATUS |
NUMBER |
2,0 |
Yes |
Indicates the current status of the adjustment. Possible values
1- In Progress, 2- Completed, 3- Canceled |
create_date |
xs:dateTime |
1 |
1 |
Date the adjustment was created |
INV_ADJUST |
CREATE_DATE |
DATE |
|
Yes |
The date the adjustment was created. |
create_user_name |
varchar2128 |
1 |
1 |
User that created the adjustment |
INV_ADJUST |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the adjustment. |
template_id |
number12 |
0 |
1 |
Identifier of a template used to create the adjustment |
INV_ADJUST |
INV_ADJUST_TEMPLATE_ID |
NUMBER |
12,0 |
No |
Template used to create the adjustment. |
item_count |
number10 |
1 |
1 |
Number of line items on the adjustment |
|
|
|
|
Yes |
Number of line items on the adjustment |