Purchase Order Line Item Information Table Formats (PODetail)

Follow Vision specifications for preparing a file containing purchase order line item information.

Field Name Data Type Length Notes

PONumber

varchar 13 Required field; must exist in POMaster

Seq

int 4 Required field

RequisitionNo

decimal 9

RequestedBy

varchar 20 Null or must exist in EM

Item

varchar 30 Required field; must exist in CompanyItem

Category

varchar 20 Null or must exist in CFGPOCategory (Category/Description)

Description

varcjar 100

Qty

decimal 9

ReceivedQTY

decimal 9

UOM

varchar 10 Null or must exist in CFGPOUOM (UOM/Description)

UnitPrice

decimal 9

DiscountAmount

decimal 9

NetAmount

decimal 9

ReceivedAmount

decimal 9

DueDate

datetime 8

ExtraNotes

text 16

InternalNotes

text 16

ShipTo

varchar 20 Default CFGPOmain.ShipTO or must exist in CFGPOShipTo

FirmName

varchar 100

Address1

varchar 50

Address2

varchar 50

Address3

varchar 50

Address4

varchar 50

City

varchar 30

State

varchar 10 The state must exist in CFGStates. If you import both state and country, that combination must already be a valid combination in Vision. If you import a state but not a country, the state must be a valid state for the United States.

Zip

varchar 10

Country

varchar 40

Phone

varchar 24

Fax

varchar 24

Email

varchar 50

ContactName

varchar 100

ShipVia

varchar 20 Null or must exist in CFGPOShipVia (Code/Description)

ReceiveStatus

varchar 1 Null or must exist in CFGPOStatus (Screen = 'POL')

VendorItem

varchar 30