XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PayTermDtl in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
due_days |
number3 |
1 |
1 |
The number of days until payment is due. |
terms_detail |
duedays |
null |
null |
Yes |
The number of days until payment is due. |
due_max_amount |
number12_4 |
1 |
1 |
Maximum payment amount due by a certain date. |
terms_detail |
due_max_amount |
number |
12 |
Yes |
Maximum payment amount due by a certain date. |
due_dom |
number2 |
1 |
1 |
Day of month used to calculate due date. |
terms_detail |
due_dom |
null |
null |
Yes |
Day of month used to calculate due date. |
discdays |
number3 |
1 |
1 |
Number of days in which payment must be made to get the discount. |
terms_detail |
discdays |
null |
null |
Yes |
Number of days in which payment must be made to get the discount. |
percent |
number12_4 |
1 |
1 |
Percentage used to calculate discount available. |
terms_detail |
percent |
null |
null |
Yes |
Percentage used to calculate discount available. |
disc_dom |
number2 |
1 |
1 |
Day of month used to calculate discount date. |
terms_detail |
disc_dom |
null |
null |
Yes |
Day of month used to calculate discount date. |
disc_mm_fwd |
number3 |
1 |
1 |
Number of months ahead to calculate discount date. |
terms_detail |
disc_mm_fwd |
null |
null |
Yes |
Number of months ahead to calculate discount date. |
fixed_date |
xs:dateTime |
0 |
1 |
Fixed due date. |
terms_detail |
fixed_date |
null |
null |
No |
Fixed due date. |
enabled_flag |
varchar21 |
1 |
1 |
Indicates whether the Payment terms are valid or invalid within the respective application. The values would be either (Y)es or (N)o. |
terms_detail |
enabled_flag |
null |
null |
Yes |
Indicates whether payment terms are valid within the respective application. Valid values are Y and N. |
start_date_active |
xs:dateTime |
0 |
1 |
Start date terms are in effect. |
terms_detail |
start_date_active |
null |
null |
No |
First day on which terms are in effect. |
end_date_active |
xs:dateTime |
0 |
1 |
End date terms are in effect. |
terms_detail |
end_date_active |
RIBDate |
|
No |
Last day on which terms are in effect. |
terms_seq |
number10 |
1 |
1 |
Sequence for the discount percent and part of unique identifier for the detail line. |
terms_detail |
terms_seq |
null |
null |
No |
Sequence for the discount percent and part of the unique identifier for the detail line. |
due_mm_fwd |
number3 |
1 |
1 |
Number of months ahead to calculate due date. |
terms_detail |
due_mm_fwd |
null |
null |
Yes |
Number of months ahead to calculate due date. |
cutoff_day |
number2 |
1 |
1 |
Day of month after which the following month will be used for calculations. |
terms_detail |
cutoff_day |
null |
null |
No |
Day of month after which the following month will be used for calculations. |
ExtOfPayTermDesc:ExtOfPayTermDtl
|
*
|
0
|
1
|
Provide an extension hook to customize PayTermDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfPayTermDesc:LocOfPayTermDtl
|
*
|
0
|
unbounded
|
Provide an extension hook to localize PayTermDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|