<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.