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. |