Requisition Import

 

Requisitions may be imported into K212 Finance (refer to the requisition section of this document for full details). 

 

The following fields may be imported:

 

Field Name

Size

Mandatory

Comments

Delivery Date

8

 

The date by which  the goods are expected to be delivered

Vendor Number

10

 

The vendor number to which the order is to be Generated

Requested By

30

 

The end user who requested the goods

Buyer Code

4

 

The buyer to whom the requisition will be directed for processing

Ship To Building

30

Y

The building to which the purchase order will be shipped

Ship To Department

30

 

The department to which the purchase order will be shipped

Room

30

 

The room to which the purchase order will be shipped

Ship To Attention To

30

 

The name to be associated with the shipped order

Ship To Location

10

 

The location to which the purchase order will be shipped

AddressLine1

50

Y

The address to which the purchase order will be shipped

AddressLine2

50

 

The address to which the purchase order will be shipped

City

50

Y

The city to which the purchase order will be shipped

Postal Code

9

 

The postal code to which the purchase order will be shipped

Postal Code Ext

4

 

The postal code extension to which the purchase order will be shipped

Country

50

Y

The country to which the purchase order will be shipped

Province

30

Y

The province to which the purchase order will be shipped

Business Note Type

10

 

The note type if a note is included below

Business Note

960

 

The note to attach to the requisition

Line Item Stock Number

20

 

The stock number being ordered

Line Item Unit Price

13

 

The price of the item being ordered

Line Item Unit Of Measure

10

 

The unit of measure of the item being ordered

Line Item Quantity

13

Y

The quantity being ordered

Line Item Description

900

 

The description of the item being ordered

Line Item Sales Tax Code

1

 

The tax code for the purchase

Line Item GL Account

25

Y

The general ledger account code whose budget will be used for this order