Import Header - IAConnect - English - Foundation 22.1 - OnBase - external

IAConnect

Platform
OnBase
Product
IAConnect
Release
Foundation 22.1
License

Seq. No.

Input Field Name

Data Type

Length

Starting Position

Ending Position

Required or Optional

Notes

GL Coding Table Column

Keyword Type

1

Record Type

Alphanumeric

1

1

1

Required

Will always be "H" in the input file

----

----

2

Vendor ID

Alphanumeric

15

2

16

Required

     

3

Invoice Number

Alphanumeric

15

17

31

Required

 

InvoiceNumber

Invoice Number

4

Invoice Date

Date (MM/dd/yyyy)

10

32

41

Required

 

InvoiceDate

Invoice Date

5

Invoice Amount

Decimal (14,2)

16

42

57

Required

 

Amount

Invoice Amount

6

PO Number

Alphanumeric

10

58

67

Optional

 

----

PO Number

7

PO Release

Numeric

3

68

70

Optional

 

----

PO Release

8

Billing Period From

Date (MM/dd/yyyy)

10

71

80

Optional

 

----

Billing Start Date

9

Billing Period To

Date (MM/dd/yyyy)

10

81

90

Optional

 

----

Billing End Date