<taPoLine>*
Element name |
Data type |
Length |
Required |
Default |
Description |
---|---|---|---|---|---|
POTYPE |
i4 |
2 |
N |
Default from setup |
1=Standard (items shipped to your business); 2=Drop ship (items shipped direct to customer) 3=Blanket 4=Drop Ship Blanket |
PONUMBER |
string |
17 |
Y |
Not applicable |
Unique identifier for the PO |
DOCDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Document Date: The date of the purchase order Required by PA |
VENDORID |
string |
15 |
Y |
Not applicable |
ID of the vendor you're purchasing items from |
LOCNCODE |
string |
10 |
N |
Default from setup |
ID of the site for which you're purchasing the items |
VNDITNUM |
string |
30 |
N |
Default from setup |
Vendor item number |
ITEMNMBR |
string |
30 |
N |
Default from setup |
Item number |
QUANTITY |
number |
21 |
N |
Default from setup |
Total quantity for the line item |
QTYCANCE |
number |
21 |
N |
Default from setup |
Quantity that is to be canceled |
FREEONBOARD |
i4 |
2 |
N |
Default from setup |
Terms of sale that identify the point at which ownership of goods passes to the buyer: 1=None; 2=Origin; 3=Destination |
REQSTDBY |
string |
20 |
N |
Default from setup |
Person or department who requested this line item |
COMMNTID |
string |
15 |
N |
Default from setup |
Comment ID |
COMMENT_1 |
string |
50 |
N |
Default from setup |
Comment part 1 |
COMMENT_2 |
string |
50 |
N |
Default from setup |
Comment part 2 |
COMMENT_3 |
string |
50 |
N |
Default from setup |
Comment part 3 |
COMMENT_4 |
string |
50 |
N |
Default from setup |
Comment part 4 |
REQDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Required date by which the items must be received |
RELEASEBYDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Date PO line needs to be released to vendor in order to receive the item by the required date |
PRMDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Date the vendor promised you would receive merchandise or services |
PRMSHPDTE |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Date the vendor promised the merchandise would be shipped |
NONINVEN |
i4 |
2 |
N |
0 |
0=Inventory item; 1=Non-inventory item |
IVIVINDX |
i4 |
4 |
N |
Default from setup |
Inventory account |
InventoryAccount |
string |
75 |
N |
<blank> |
Inventory account number string |
ITEMDESC |
string |
100 |
N |
Default from setup |
Description for line item |
UNITCOST |
number |
21 |
N |
Default from setup |
Cost for item in specified unit of measure |
VNDITDSC |
string |
100 |
N |
Default from setup |
Vendor's description for line item |
UOFM |
string |
8 |
N |
Default from setup |
Unit of measure in which this item is being purchased |
Purchase_IV_Item_Taxable |
i4 |
2 |
N |
Default from setup |
Purchase inventory item taxable: 1=Taxable; 2=Nontaxable; 3=Base on vendor |
Purchase_Item_Tax_Schedu |
string |
15 |
N |
Default from setup |
Purchase item tax schedule--blank unless Purchase_IV_Item_Taxable=1 |
Purchase_Site_Tax_Schedu |
string |
15 |
N |
Default from setup |
Purchase site tax schedule |
BSIVCTTL |
i4 |
2 |
N |
Default from setup |
Based on invoice total |
TAXAMNT |
number |
21 |
N |
Default from setup |
Tax amount |
BCKTXAMT |
number |
21 |
N |
Default from setup |
Back tax amount |
Landed_Cost_Group_ID |
string |
15 |
N |
Default from setup |
Landed cost group ID |
PLNNDSPPLID |
i4 |
2 |
N |
Default from setup |
Planned supplier ID |
SHIPMTHD |
string |
15 |
N |
Default from setup |
Shipping method |
BackoutTradeDiscTax |
number |
21 |
N |
Default from setup |
Back out trade discount amount |
POLNESTA |
i4 |
2 |
N |
Default from setup |
PO line status: 1=New; 2=Released; 3=Change order; 4=Received; 5=Closed; 6=Cancelled |
CMMTTEXT |
string |
500 |
N |
Default from setup |
Comment text; used only if utilizing COMMENT_1 through COMMENT_4 |
ORD |
i4 |
4 |
N |
Default from setup |
Sequence number used to track each item; must be unique per PO line. |
CUSTNMBR |
string |
15 |
N |
Default from setup |
Customer number |
ADRSCODE |
string |
15 |
N |
Default from setup |
Address code |
CMPNYNAM |
string |
64 |
N |
Default from setup |
Name |
CONTACT |
string |
30 |
N |
Default from setup |
Contact |
ADDRESS1 |
string |
30 |
N |
Default from setup |
Address line 1 |
ADDRESS2 |
string |
30 |
N |
Default from setup |
Address line 2 |
ADDRESS3 |
string |
30 |
N |
Default from setup |
Address line 3 |
CITY |
string |
30 |
N |
Default from setup |
City |
STATE |
string |
29 |
N |
Default from setup |
State |
ZIPCODE |
string |
10 |
N |
Default from setup |
ZIP Code/postal code |
Ccode |
string |
6 |
N |
Default from setup |
Country code |
COUNTRY |
string |
20 |
N |
Default from setup |
Country |
PHONE1 |
string |
21 |
N |
Default from setup |
Phone 1 |
PHONE2 |
string |
21 |
N |
Default from setup |
Phone 2 |
PHONE3 |
string |
21 |
N |
Default from setup |
Phone 3 |
FAX |
string |
21 |
N |
Default from setup |
Fax |
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 |
CURNCYID |
string |
15 |
N |
Default from setup |
Currency ID |
ProjNum |
string |
15 |
N |
Default from setup |
Project number; for use with Project Accounting only |
CostCatID |
string |
15 |
N |
Default from setup |
Cost category ID; for use with Project Accounting only |
LineNumber |
i4 |
4 |
N |
Default from setup |
Line number: Use 0 for a master line of a Blanket PO |
UpdateIfExists |
i4 |
2 |
N |
0 |
Flag to allow data to be updated, if it exists: 0=No; 1=Yes Partial updates allowed |
NOTETEXT |
string |
8000 |
N |
<blank> |
Notes: In an update, an empty NOTETEXT element leaves existing notes unchanged. |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, 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 |
* The default action for the <taPoLine> node is to use document exchange to provide update functionality. To use field level updates, set UpdateIfExists to 1.