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

16

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

16

N

Default from setup

Required date by which the items must be received

RELEASEBYDATE

datetime

16

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

16

N

Default from setup

Date the vendor promised you would receive merchandise or services

PRMSHPDTE

datetime

16

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

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)

CURNCYID

string

15

N

Default from setup

Currency ID

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