<taPMSchedPmnts>
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
ORIG_VOUCHER_NUM |
string |
21 |
Y |
Not applicable |
Original voucher number |
ORIG_DOC_TYPE |
i4 |
2 |
Y |
Not applicable |
Original document type: 1=Invoice; 3=Miscellaneous charge |
PAY_OFFSET_ACCT_IDX |
i4 |
2 |
Y/N |
0 |
Payables offset account index; either the index or string is required |
PayOffsetAccount |
string |
75 |
Y/N |
<blank> |
Payable 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, account index is used.) |
FIRST_INV_DOC_DATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
First invoice document date; required if payment frequency is 1=semimonthly and the day must be either the first or the 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 payment frequency is 1=semimonthly and the day must be either the first or the fifteenth (day requirement for semimonthly only) |
INT_EXP_ACCT_IDX |
i4 |
4 |
N |
0 |
Interest expense account index; either the index or the string is required if interest rate entered |
IntExpenseAccount |
string |
75 |
N |
<blank> |
Interest expense account string; either the index or the string is required if interest rate entered |
PAYMENT_AMOUNT |
number |
21 |
N |
0 |
Payment amount; if both PAYMENT_AMOUNT and NUM_PAYMENTS are passed in, the number of payments will be recalculated |
NUM_PAYMENTS |
i4 |
2 |
N |
0 |
Number of payments; either the number of payments or the payment amount must be greater than 0 (both cannot be zero); if payment amount is entered, the number of payments must hold a value of 1 (minimum) through 999 (maximum) |
SCHEDULE_NUMBER |
string |
21 |
N |
<blank> |
Schedule number; will get next number optional to pass in |
PYMNT_FREQUENCY |
i4 |
2 |
N |
2 |
Payment frequency: 1=Semimonthly; 2=Monthly; 3=Quarterly; 4=Semiannually; 5=Annually |
PAY_ACCT_IDX |
i4 |
4 |
N |
0 |
Accounts payable account index |
PayAccount |
string |
75 |
N |
<blank> |
Account payable account string; use if want to override the default |
SCH_DOC_DATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Schedule document date; will get from original document |
SCHEDULE_AMOUNT |
number |
21 |
N |
0 |
Schedule amount; will get from original document |
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 will not; interest rate can range from 0.0001 through 99.9999 |
SCHEDULE_INT_TYPE1 |
i4 |
2 |
N |
0 |
Schedule interest type: 0=Compound; 1=Simple |
USERID |
string |
15 |
N |
eConnect |
User ID used to update the PM keys |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates 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.