POTYPE

i4

2

N

1

1=Standard (items shipped to 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

VENDORID

string

15

Y

Not applicable

ID of the vendor you are purchasing from

VENDNAME

string

64

N

Default from setup

Name of the vendor

DOCDATE

datetime

16

N

Default is current date

Document date; date of the purchase order

BUYERID

string

15

N

Default from setup

Buyer who is responsible for the purchase order

ALLOWSOCMTS

i4

1

N

Default from setup

Allow sales commitments: 1=Allow PO to be committed to SOP line items

TRDISAMT

number

21

N

Default from setup

Trade discount amount

FRTAMNT

number

21

N

Default from setup

Freight amount

MSCCHAMT

number

21

N

Default from setup

Miscellaneous charge amount

TAXAMNT

number

21

N

Default from setup

Tax amount

SUBTOTAL

number

21

Y

Default from setup

Subtotal=Total before taxes

CUSTNMBR

string

15

N

Default from setup

Customer ID to which the vendor is shipping the items on a drop ship

PRSTADCD

string

15

N

Default from setup

Address ID to which the order is being sent

CMPNYNAM

string

64

N

Default from setup

Company associated with the ship to address ID

CONTACT

string

30

N

Default from setup

Contact person for the ship to address ID

ADDRESS1

string

30

N

Default from setup

Address line 1 of the ship to address ID

ADDRESS2

string

30

N

Default from setup

Address line 2 of the ship to address ID

ADDRESS3

string

30

N

Default from setup

Address line 3 of the ship to address ID

CITY

string

30

N

Default from setup

City of the ship to address ID

STATE

string

29

N

Default from setup

State of the ship to address ID

ZIPCODE

string

10

N

Default from setup

ZIP Code/postal code of the ship to address ID

CCode

string

6

N

Default from setup

Country code

COUNTRY

string

20

N

Default from setup

Country of the ship to address ID

PHONE1

string

21

N

Default from setup

Phone number at the ship to address ID

PHONE2

string

21

N

Default from setup

Additional phone number at the ship to address ID

PHONE3

string

21

N

Default from setup

Additional phone number at the ship to address ID

FAX

string

21

N

Default from setup

Fax number at the ship to address ID

VADCDPAD

string

15

N

Default from setup

Vendor address code

PURCHCMPNYNAM

string

64

N

Default from setup

Purchase company name

PURCHCONTACT

string

30

N

Default from setup

Purchase contact

PURCHADDRESS1

string

30

N

Default from setup

Purchase address 1

PURCHADDRESS2

string

30

N

Default from setup

Purchase address 2

PURCHADDRESS3

string

30

N

Default from setup

Purchase address 3

PURCHCITY

string

30

N

Default from setup

Purchase city

PURCHSTATE

string

29

N

Default from setup

Purchase state

PURCHZIPCODE

string

10

N

Default from setup

Purchase zip code

PURCHCCode

string

6

N

Default from setup

Purchase country code

PURCHCOUNTRY

string

20

N

Default from setup

Purchase country

PURCHPHONE1

string

21

N

Default from setup

Purchase phone 1

PURCHPHONE2

string

21

N

Default from setup

Purchase phone 2

PURCHPHONE3

string

21

N

Default from setup

Purchase phone 3

PURCHFAX

string

21

N

Default from setup

Purchase fax

PRBTADCD

string

15

N

Default from setup

Bill to address ID

SHIPMTHD

string

15

N

Default from setup

Shipping method

PYMTRMID

string

20

N

Default from setup

Payment terms extended to your company by the vendor

DSCPCTAM

number

21

N

Default from setup

Discount percent amount

DSCDLRAM

number

21

N

Default from setup

Discount dollar amount

DISAMTAV

number

21

N

Default from setup

Discount available amount

DUEDATE

datetime

16

N

Default from setup

Due date

DISCDATE

datetime

16

N

Default from setup

Discount date

TXRGNNUM

string

25

N

Default from setup

Vendor’s tax registration number

CONFIRM1

string

20

N

Default from setup

Name of the person the order should be approved by

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

HOLD

i4

1

N

0

0=Not on hold; 1=On hold

TAXSCHID

string

15

N

Default from setup

Tax schedule ID

Purchase_Freight_Taxable

i4

2

N

Default from setup

Purchase freight taxable:

1=Taxable;

2=Nontaxable;

3=Based on vendor

Purchase_Misc_Taxable

i4

2

N

Default from setup

Purchase miscellaneous taxable:

1=Taxable;

2=Nontaxable;

3=Based on vendor

FRTSCHID

string

15

N

Default from setup

Freight tax schedule ID

MSCSCHID

string

15

N

Default from setup

Miscellaneous tax schedule ID

FRTTXAMT

number

21

N

Default from setup

Freight tax amount

MSCTXAMT

number

21

N

Default from setup

Miscellaneous tax amount

BCKTXAMT

number

21

N

Default from setup

Back tax amount

BackoutFreightTaxAmt

number

21

N

Default from setup

Back out freight tax amount

BackoutMiscTaxAmt

number

21

N

Default from setup

Back out miscellaneous tax amount

BackoutTradeDiscTax

number

21

N

Default from setup

Back out trade discount tax amount

USINGHEADERLEVELTAXES

i4

2

N

Default from setup

Using header level taxes

CURNCYID

string

15

N

Default from setup

Currency ID

XCHGRATE

number

21

N

Default from setup

Exchange rate

RATETPID

string

15

N

Default from setup

Rate type ID

EXPNDATE

datetime

16

N

Default from setup

Expiration date

EXCHDATE

datetime

16

N

Default from setup

Exchange date

EXGTBDSC

string

30

N

Default from setup

Exchange ID description

EXTBLSRC

string

50

N

Default from setup

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

Default from setup

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=Method;

1=Divide

PRVDSLMT

i4

2

N

Default from setup

Previous day's limits

DATELMTS

i4

2

N

Default from setup

Date limits:

0=Unlimited;

1=Limited

TIME1

datetime

16

N

Default from setup

Time1

USERID

string

15

N

Default from setup

User to enter (USER2ENT)

POSTATUS

i4

2

N

Default from setup

PO status:

1=New;

2=Released;

3=Change order;

4=Received;

5=Closed;

6=Cancelled

CMMTTEXT

string

500

N

Default from setup

Comment text; use only if not utilizing COMMENT_1 through COMMENT_4

PRMDATE

datetime

16

N

Default from setup

Promise date

PRMSHPDTE

datetime

16

N

Default from setup

Promise ship date

REQDATE

datetime

16

N

Default from setup

Required date

CONTENDDTE

datetime

16

N

Default from setup

Contract expiration date

CNTRLBLKTBY

i4

2

N

Default from setup

Control Blanket By:

0=Quantity

1=Value

REQTNDT

datetime

16

N

Default from setup

Requisition Date

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

Default from setup

Notes field

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