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

16

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

16

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

16

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