Fintech Invoice Extract Format

The following table lists the format for exporting invoice data in Fintech Invoice Extract.

Column

Position

Field

Format

Required

Description

A

1

Division_ID

Numeric, 999999999

Yes

This is the Fintech division ID entered in the Fintech Division ID field in Fintech Invoice Extract when exporting the file.

B

2

Invoice_number

Alphanumeric

Yes

This is arinvhdr.ref-num, which is displayed in the Reference # field in Invoice Entry.

C

3

Invoice_date

MM/DD/YYYY

Yes

This is arinvhdr.ref-date, which is displayed in the Reference Date field in Invoice Entry.

D

4

Supplier_store_id

Alphanumeric

Yes

This is custname.cust-code, based on arinvhdr.cust-key. This is displayed in the Customer Code field in Invoice Entry.

E

5

Invoice_due_date

MM/DD/YYYY

No

This is arinvhdr.due-date, which is displayed in the Due Date field in Invoice Entry.

F

6

Po_number

Alphanumeric

No

This is arinvhdr.cust-po-num, which is displayed in the Cust PO # field in Invoice Entry.

G

7

Po_date

MM/DD/YYYY

No

This is oe-header.order-date, which is displayed in the Order Date field in Order Entry.

H

8

Ref_invoice_number

Alphanumeric

No

This is blank if ref-type = "IN." This is oe-header.return-order-associated-ref-num from the originating return order if ref-type = "CM," which is displayed in the Associated Invoice field in Order Entry.

I

9

Quantity_shipped

Decimal

Yes

This is arinvitm.qty, which is displayed in the Qty field on the Items tab in Invoice Entry.

J

10

Quantity_uom

Alphanumeric

Yes

This is um-udf.user-defined-01 for arinvitm.um-key, which is displayed in the first user-defined field on the Other Information tab in Unit of Measure Maintenance.

K

11

Item_number

Alphanumeric

Yes

This is product.product-code, which is displayed in the Product Code field on the Items tab in Invoice Entry.

L

12

Upc_pack

Alphanumeric

No

This is product.upc-code (first 15 characters only), which is displayed in the UPC Code field on the General tab in Product Maintenance.

M

13

Upc_case

Alphanumeric

No

This is product-um.upc-code for arinvitm.um-key (first 15 characters only), which is displayed in the UPC column in the Product Units of Measure grid on the Unit of Measure tab in Product Maintenance.

N

14

Gtin_id

Alphanumeric

No

This field is blank.

O

15

Product_description

Alphanumeric

Yes

This is product.product-name, which is displayed in the Product Name field on the Items tab in Invoice Entry.

P

16

Unit_price

Decimal

Yes

This is arinvitm.unit-price, which is displayed in the Unit Price field on the Items tab in Invoice Entry.

Q

17

Promotional_discount

Decimal

No

This is arinvitm.price-adjustment, which is displayed in the Price Adjustment field on the Items tab in Invoice Entry.

R

18

State_tax

Decimal

No

This is arinvitm.tax-amount (per unit quantity), which is the amount in the Tax Amount field on the Items tab in Invoice Entry divided by the quantity in the Qty field on the Items tab in Invoice Entry.

S

19

Deposit_amount

Decimal

No

N/A

T

20

Miscellaneous_charge

Decimal

No

This is the total of any arinvmsc associated with this line item (per unit quantity).

U

21

Extended_price

Decimal

No

This is arinvitm.extended-price + arinvitm.tax-amount, which is displayed in the Total field on the Items tab in Invoice Entry.