<taPMTransactionInsert>

Element name

Data type

Length

Required

Default

Description

BACHNUMB

string

15

Y

Not applicable

Batch number; batch for the cash receipt; created on the fly

VCHNUMWK

string

17

Y

Not applicable

Voucher number--must be unique

VENDORID

string

15

Y

Not applicable

Vendor ID

DOCNUMBR

string

20

Y

Not applicable

Document number--unique based on PM40100 setup option

DOCTYPE

i4

2

Y

Not applicable

Document type:

1=Invoice

2=Finance Charge

3=Miscellaneous Charge

4=Return

5=Credit Memo

DOCAMNT

number

21

Y

Not applicable

Document amount=MSCCHAMT + PRCHAMNT + TAXAMNT + FRTAMNT - TRDISAMT

DOCDATE

datetime

8 bytes

(19 to 23 chars)

Y

Not applicable

Document date

PSTGDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Posting date

VADCDTRO

string

15

N

<blank>

Remit to Address ID

VADDCDPR

string

15

N

<blank>

Primary address ID;

must exist if filled - use <taCreateVendorAddress> to create the master record

PYMTRMID

string

20

N

Default from setup

Payment terms ID; must exist if filled

TAXSCHID

string

15

N

<blank>

Tax schedule ID; must exist if filled and a tax amount is passed in

DUEDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Due date

DSCDLRAM

number

21

N

Default from setup

Discount dollar amount

DISCDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Discount date

PRCHAMNT

number

21

N

0

Purchases amount

CHRGAMNT

number

21

N

0

Charge amount=DOCAMNT - CASHAMNT -CHEKAMNT - CRCRDAMT - DISTKNAM (required if on account amount)

CASHAMNT

number

21

N

0

Cash amount

CAMCBKID

string

15

N

<blank>

Cash amount checkbook ID

CDOCNMBR

string

20

N

<blank>

Cash document number--required if cash amount is greater than 0

CAMTDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Cash amount date

CAMPMTNM

string

20

N

<blank>

Cash amount payment number

CHEKAMNT

number

21

N

0

Check amount

CHAMCBID

string

15

N

<blank>

Check amount checkbook ID

CHEKDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Check amount date

CAMPYNBR

string

20

N

<blank>

Check payment number

CRCRDAMT

number

21

N

0

Credit card amount

CCAMPYNM

string

20

N

<blank>

Credit card payment number

CHEKNMBR

string

20

N

<blank>

Check document number

CARDNAME

string

15

N

<blank>

Credit card name

CCRCTNUM

string

20

N

<blank>

Credit card receipt number

CRCARDDT

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Credit card amount date

CHEKBKID

string

15

N

<blank>

Checkbook ID

TRXDSCRN

string

30

N

<blank>

Transaction description

TRDISAMT

number

21

N

0

Trade discount amount

TAXAMNT

number

21

N

0

Tax amount

FRTAMNT

number

21

N

0

Freight amount

TEN99AMNT

number

21

N

0

1099 amount

MSCCHAMT

number

21

N

0

Miscellaneous charge amount

PORDNMBR

string

20

N

<blank>

Purchase order number

SHIPMTHD

string

15

N

<blank>

Shipping method

DISAMTAV

number

21

N

Default from setup

Discount amount available

DISTKNAM

number

21

N

0

Discount taken amount

APDSTKAM

number

21

N

0

Applied discount taken amount

MDFUSRID

string

15

N

<blank>

Modified user ID

POSTEDDT

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Posted date

PTDURID

string

15

N

<blank>

Posted user ID

PCHSCHID

string

15

N

<blank>

Purchase schedule ID

FRTSCHID

string

15

N

<blank>

Freight schedule ID

MSCSCHID

string

15

N

<blank>

Miscellaneous schedule ID

PRCTDISC

number

21

N

Default from setup

Percent discount

Tax_Date

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Tax date

CURNCYID

string

15

N

<blank>

Currency ID

XCHGRATE

number

21

N

0

Exchange rate

RATEPID

string

15

N

<blank>

Rate type ID

EXPNDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Expiration date

EXCHDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Exchange date

EXGTBDSC

string

30

N

<blank>

Exchange ID description

EXTBLSRC

string

50

N

<blank>

Exchange rate source

RATEEXPR

i4

2

N

Default from setup

Rate expiration:

0=None

1=Daily;

2=Weekly;

3=Biweekly;

4=Semimonthly;

5=Monthly;

6=Quarterly;

7=Annually;

8=Miscellaneous;

9=None;

DYSTINCR

i4

2

N

Default from setup

Days to increment--used only when RATEEXPR=8

RATEVARC

number

21

N

0

Rate variance

TRXDTDEF

i4

2

N

Default from setup

Transaction date default:

0=Exact date;

1=Next date;

2=Previous date

RTCLCMTD

i4

2

N

Default from setup

Rate calculation method:

0=Multiply;

1=Divide

PRVDSLMT

i4

2

N

0

Previous day's limits

DATELMTS

i4

2

N

0

Date limits

TIME1

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Time 1:

0=Unlimited;

1=Limited

BatchCHEKBKID

string

15

N

<blank>

Checkbook ID for the batch

CREATEDIST

i4

2

N

1

Flag to autocreate distributions:

0=Manual;

1=Automatic--use if not calling the <taPMDistribution> node

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.