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

16

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

16

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

16

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