<taRMSchedPmnts>
Element name |
Datatype |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
ORIG_DOC_NUMBER |
string |
21 |
Y |
Not applicable |
Original document number |
ORIG_DOC_TYPE |
i4 |
2 |
Y |
Not applicable |
Original document type: 1=Sales/invoice; 3=Debit memos; 5=Service/repairs |
REC_OFFSET_ACCT_IDX |
i4 |
4 |
N |
0 |
Receivables offset account index; either an index or a string is required |
RecOffsetAcct |
string |
75 |
N |
<blank> |
Receivables offset account string (The account string is checked first; if it is populated, the account index is set based on the string. If the account string is not populated, the account index is used.) |
FIRST_INV_DOC_DATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
First invoice document date; required if the payment frequency is 1=Semimonthly and the day must be either the first or fifteenth (day requirement for semimonthly only) |
FIRST_INV_DUE_DATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
First invoice due date; required if the payment frequency is 1=Semi-monthly and the day must be either the first or fifteenth (day requirement for semimonthly only) |
INT_INCOME_ACCT_IDX |
i4 |
4 |
N |
0 |
Interest income account index; either the index or the string is required if the interest rate is entered |
IntIncomeAccount |
string |
75 |
N |
<blank> |
Interest income account string; either the index or the string is required if the interest rate is entered |
PAYMENT_AMOUNT |
number |
21 |
N |
0 |
Payment amount; if both PAYMENT_AMOUNT and NUM_PAYMENTS are passed in, the number of payments are recalculated |
NUM_PAYMENTS |
i4 |
2 |
N |
0 |
Number of payments; either the number of payments or the payment amount must be>0 (both cannot be zero); if payment amount is entered, the number of payments must hold a value of 1 (minimum) to 999(maximum) |
SCHEDULE_NUMBER |
string |
21 |
N |
<blank> |
Schedule number |
PYMNT_FREQUENCY |
i4 |
2 |
N |
2 |
Payment frequency: 1=Semimonthly; 2=Monthly; 3=Quarterly; 4=Semiannually; 5=Annually |
REC_ACCT_IDX |
i4 |
4 |
N |
0 |
Receivables account index |
RecAccount |
string |
75 |
N |
<blank> |
Receivables account string |
SCH_DOC_DATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Schedule document date |
SCHEDULE_AMOUNT |
number |
21 |
N |
0 |
Schedule amount |
SCHEDULE_DESC |
string |
31 |
N |
<blank> |
Schedule description |
SCHEDULE_INT_RATE |
number |
21 |
N |
0 |
Schedule interest rate; front end allows negative interest but this element will not |
SCHEDULE_INT_TYPE1 |
i4 |
2 |
N |
0 |
Schedule interest type: 0=Compound; 1=Simple |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates the requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.