Import Detail - IAConnect - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

IAConnect

Platform: OnBase
Product: IAConnect
Release: Foundation 23.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 "D" in the input file	----	n/a
2	PO Line Number	Numeric	4	2	5	Optional	Optional for non-PO invoices	PO_LN_NO	n/a
3	Invoice Quantity	Decimal (14,4)	14	6	19	Optional		Quantity	n/a
4	Unit Cost	Decimal (14,4)	16	20	35	Optional		UnitCost	n/a
5	Vendor Hours	Decimal (14,2)	16	36	51	Required	If no vendor labor hours, "0" must be used.	Hours	n/a
6	Line Notes	Alphanumeric	254	52	305	Optional		Notes	n/a
7	Account	Alphanumeric	15	306	320	Required	Not required if account does not require a project.	Account	n/a
8	Project	Alphanumeric	30	321	350	Required		Project	n/a
9	Organization	Alphanumeric	20	351	370	Required		Org	n/a
10	Vendor Empl ID	Alphanumeric	12	371	382	Optional		VendorEmpl	n/a
11	General Labor Category	Alphanumeric	6	383	388	Optional	Required if Vendor Hours is greater than 0.	GLCCode	n/a
12	Project Labor Category	Alphanumeric	6	389	394	Optional		PLCCode	n/a
13	Description	Alphanumeric	30	395	424	Optional		PLCCode	n/a
14	Amount	Decimal (14,2)	16	425	440	Optional	Field is right justified with leading zeros or spaces.	Amount	n/a
15	Effective Bill Date	Date (MM/dd/yyyy)	10	441	450	Optional	Required if Vendor Hours is greater than 0. Must leave spaces to ending position if Effective Bill Date is not populated.	Effective Bil Date	n/a
16	Taxable	Alphanumeric	1	450	450	Optional		TaxableCode	n/a
17	Taxable Code	Alphanumeric	1	451	451	Optional		TaxableCode1	n/a
18	Tax Code	Alphanumeric	17	452	468	Optional		TaxCode	n/a
19	Tax Amount	Alphanumeric	15	469	484	Optional		TaxAmount	n/a