<taSopHdrIvcInsert>*
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
SOPTYPE |
i4 |
2 |
Y |
Not applicable |
1=Quote; 2=Order; 3=Invoice; 4=Return; 5=Back order; 6=Fulfillment orders |
DOCID |
string |
15 |
Y |
Not applicable |
Document ID |
SOPNUMBE |
string |
21 |
Y |
Not applicable |
Invoice number |
ORIGNUMB |
string |
20 |
N |
<blank> |
Order number |
ORIGTYPE |
i4 |
2 |
N |
0 |
Document type of the originating SOP number |
TAXSCHID |
string |
15 |
N |
<blank> |
Tax schedule |
FRTSCHID |
string |
15 |
N |
<blank> |
Freight tax schedule |
MSCSCHID |
string |
15 |
N |
<blank> |
Miscellaneous tax schedule |
SHIPMTHD |
string |
15 |
N |
Default from setup |
Shipping method |
TAXAMNT |
number |
21 |
N |
0 |
Tax amount |
LOCNCODE |
string |
10 |
N |
<blank> |
Location code |
DOCDATE |
datetime |
8 bytes (19 to 23 chars) |
Y |
Not applicable |
Document date |
FREIGHT |
number |
21 |
N |
0 |
Freight amount |
MISCAMNT |
number |
21 |
N |
0 |
Miscellaneous amount |
TRDISAMT |
number |
21 |
N |
Default from setup |
Trade discount amount |
TRADEPCT |
number |
21 |
N |
Default from setup |
Trade discount percentage |
DISTKNAM |
number |
21 |
N |
0 |
Discount taken amount--cannot be larger then discount available amount |
MRKDNAMT |
number |
21 |
N |
0 |
Markdown amount |
CUSTNMBR |
string |
15 |
Y |
Not applicable |
Customer number |
CUSTNAME |
string |
64 |
N |
<blank> |
Customer name |
CSTPONBR |
string |
20 |
N |
<blank> |
Customer purchase order number |
ShipToName |
string |
64 |
N |
<blank> |
Ship to name: The default gets the ship to name from the customer ship to address |
ADDRESS1 |
string |
60 |
N |
<blank> |
Customer address one |
ADDRESS2 |
string |
60 |
N |
<blank> |
Customer address two |
ADDRESS3 |
string |
60 |
N |
<blank> |
Customer address three |
CNTCPRSN |
string |
60 |
N |
<blank> |
Contact person |
FAXNUMBR |
string |
21 |
N |
<blank> |
Fax number |
CITY |
string |
35 |
N |
<blank> |
Customer city |
STATE |
string |
29 |
N |
<blank> |
Customer state |
ZIPCODE |
string |
10 |
N |
<blank> |
Customer ZIP Code |
COUNTRY |
string |
60 |
N |
<blank> |
Customer country |
PHNUMBR1 |
string |
21 |
N |
<blank> |
Phone one |
PHNUMBR2 |
string |
21 |
N |
<blank> |
Phone two |
PHNUMBR3 |
string |
21 |
N |
<blank> |
Phone three |
Print_Phone_NumberGB |
i4 |
2 |
N |
Default from setup |
Print phone number: 0=Do not print; 1=Phone 1; 2=Phone 2; 3=Phone 3; 4=Fax |
SUBTOTAL |
number |
21 |
N |
0 |
Subtotal=Total before taxes |
DOCAMNT |
number |
21 |
N |
0 |
Document amount/total |
PYMTRCVD |
number |
21 |
N |
0 |
Total of all payments and deposits |
SALSTERR |
string |
15 |
N |
<blank> |
Sales territory |
SLPRSNID |
string |
15 |
N |
<blank> |
Salesperson ID |
UPSZONE |
string |
3 |
N |
Default from setup |
UPS zone |
USER2ENT |
string |
15 |
N |
<blank> |
User who entered |
BACHNUMB |
string |
15 |
Y |
Not applicable |
Batch number |
PRBTADCD |
string |
15 |
N |
<blank> |
Primary bill to address code |
PRSTADCD |
string |
15 |
N |
Default from setup |
Primary ship to address code |
FRTTXAMT |
number |
21 |
N |
0 |
Freight tax amount |
MSCTXAMT |
number |
21 |
N |
0 |
Miscellaneous tax amount |
ORDRDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Order date |
MSTRNUMB |
i4 |
4 |
N |
0 |
Master Number--default is next number if 0 |
PYMTRMID |
string |
20 |
N |
Default from setup |
Payment terms ID--default is from customer if not passed in |
DUEDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Due date |
DISCDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Discount date |
REFRENCE |
string |
30 |
N |
<blank> |
GL reference |
USINGHEADERLEVELTAXES |
i4 |
4 |
N |
0 |
Header level taxes |
BatchCHEKBKID |
string |
15 |
N |
<blank> |
Checkbook ID for the batch |
CREATECOMM |
i4 |
2 |
N |
0 |
Flag to autocreate commissions: 0=Manual; 1=Automatic--use if not calling <taSopCommissions> node |
COMMAMNT |
number |
21 |
N |
0 |
Total amount of commissions for this document--used only with manual commissions |
COMPRCNT |
number |
21 |
N |
0 |
Used for all salespeople if passed in and CREATECOMM=1; leave blank to use default percentages |
CREATEDIST |
i4 |
2 |
N |
1 |
Flag to autocreate distributions: 0=Manual; 1=Automatic--use if not calling <taSopDistribution> node |
CREATETAXES |
i4 |
2 |
N |
0 |
Flag to autocreate taxes with tax engine; leave at 0 if integrating your own |
DEFTAXSCHDS |
i4 |
2 |
N |
0 |
Flag to default tax schedules based on setup if incoming tax schedules empty |
CURNCYID |
string |
15 |
N |
<blank> |
Currency ID |
XCHGRATE |
number |
21 |
N |
0 |
Exchange rate |
RATETPID |
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: 0=Unlimited; 1=Limited |
TIME1 |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
MC exchange time=Time 1 |
DISAVAMT |
number |
21 |
N |
Default from setup |
Discount available amount; cannot be larger than document amount |
DSCDLRAM |
number |
21 |
N |
Default from setup |
Discount dollar amount |
DSCPCTAM |
number |
21 |
N |
Default from setup |
Discount percent amount |
FREIGTBLE |
i4 |
4 |
N |
0 |
Freight taxable: 0=Default from SOP setup; 1=Taxable; 2=Nontaxable; 3=Base on customers |
MISCTBLE |
i4 |
4 |
N |
0 |
Miscellaneous amount taxable: 0=Default from SOP setup; 1=Taxable; 2=Nontaxable; 3=Base on customers |
COMMNTID |
string |
15 |
N |
Default from setup |
Comment ID |
COMMENT_1 |
string |
50 |
N |
<blank> |
Comment 1 |
COMMENT_2 |
string |
50 |
N |
<blank> |
Comment 2 |
COMMENT_3 |
string |
50 |
N |
<blank> |
Comment 3 |
COMMENT_4 |
string |
50 |
N |
<blank> |
Comment 4 |
GPSFOINTEGRATIONID |
string |
30 |
N |
<blank> |
Front office integration ID |
INTEGRATIONSOURCE |
i4 |
2 |
N |
0 |
Integration source |
INTEGRATIONID |
string |
30 |
N |
<blank> |
Integration ID |
ReqShipDate |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Requested ship date |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates requester shadow table) |
CKCreditLimit |
i4 |
1 |
N |
0 |
Flag to allow check on credit limits before transaction is processed: 0=Does not check credit limit; 1=Checks credit limit |
CKHOLD |
i4 |
1 |
N |
0 |
Flag to allow check on hold status: 0=Does not check hold status; 1=Checks hold status |
UpdateExisting |
i4 |
1 |
N |
0 |
Used to modify header: 0=New transaction; 1=Update header--used to update after transaction exists |
QUOEXPDA |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Quote expiration date; defaults based on setup if not filled in |
QUOTEDAT |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Quote date; used for SOPTYPE <> 1; if SOPTYPE=1, DOCDATE is used |
INVODATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Invoice date; used for SOPTYPE <> 3; if SOPTYPE=3, DOCDATE is used |
BACKDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Back order date; used for SOPTYPE <> 4; if SOPTYPE=4, DOCDATE is used |
RETUDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Return date; used for SOPTYPE <> 5; if SOPTYPE=5, DOCDATE is used |
CMMTTEXT |
string |
500 |
N |
<blank> |
Comment text; used only if not using COMMENT_1 through COMMENT_4 |
PRCLEVEL |
string |
10 |
N |
<blank> |
Price level |
DEFPRICING |
i4 |
1 |
N |
0 |
1=Subtotal will be calculated from SOP line or lines |
TAXEXMT1 |
string |
25 |
N |
Default from setup |
Tax exempt 1; default is from customer if not supplied |
TAXEXMT2 |
string |
25 |
N |
Default from setup |
Tax exempt 2; default is from customer if not supplied |
TXRGNNUM |
string |
25 |
N |
Default from setup |
Tax registration number; default is from customer if not supplied |
REPTING |
i4 |
1 |
N |
0 |
Repeating: 0=False; 1=True Only valid for SOPTYPE=1 or 2 |
TRXFREQU |
i4 |
2 |
N |
0 |
Frequency: 1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Bi-Monthly; 6=Quarterly; 7=Misc. Only valid for SOPTYPE=1 or 2 |
TIMETREP |
i4 |
2 |
N |
0 |
Times Repeating; Only valid for SOPTYPE=1 or 2 |
QUOTEDYSTINCR |
|
2 |
N |
0 |
Days to Increment; Only valid for SOPTYPE=1 or 2 |
NOTETEXT |
string |
8000 |
N |
Default from setup |
Notes field |
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 |
* The default action for the <taSopHdrIvcInsert> node is to use document exchange to provide update functionality. To use field level updates, set UpdateIfExists to 1.