Invoice Data Mapping Guide

Invoice Records
Aleph Field	Alma Field	Additional Information
Aleph General Invoice
Total Amount Gen. Invoice	Total Amount
Total Amount Line Items	Total invoice lines amount
Vendor Code	Vendor Code
Invoice Number	Invoice Number
Net Amount	n/a
Shipment Amount	Shipment
Overhead Amount	not in use in Aleph
Insurance Amount	not in use in Aleph
Discount Amount	not in use in Aleph
Total Amount	Total amount
Total Amount incl. VAT	not in use in Aleph
Local Amount	n/a
Refers to Invoice	Invoice Reference #
Type	Notes
Status	Status	After the final fiscal rollover process in Aleph, few invoices at Not Approved (N), Preliminary approval (A), or Approved and printed (B) remained in Aleph. All invoices at statuses Frozen (ADJ)– for internal adjustment invoices (F) and Released (REG) – for AP feed invoices (R) where updated to Aleph status Paid (P) for conversion to Alma as status Closed invoices.
Currency	Included in Total invoice lines amount
Explicit Ratio	n/a
Debit	Total invoice lines amount does not include a minus sign.
Credit	Total invoice lines amount includes a minus sign.
Invoice Date	Invoice Date
Received Date	n/a
Shipment Date	n/a
VAT Recipient	n/a
VAT Percent	n/a
VAT Amount	n/a
VAT per Line Item	n/a
Add VAT to Amount	n/a
Note:	Notes Tab
Payment Date	Payment Date
Check Number	Payment Identifier
Amount	Payment Amount
Status	Payment Status
Approval Dep.	Payment method
Approval Number	Notes Tab
Aleph Line Item Form
Vendor Code	Vendor
Invoice Number	In banner at top of screen
Net Amount	Price
Estimated Price	n/a
Added Amount	n/a
Currency	Included in Amount
Total Amount	Total Price
Object Code	Reporting Code
Total, Incl. VAT	n/a
VAT Percent	n/a
Local Amount	n/a
VAT Amount	n/a
Number of Units	Quantity
Debit	Invoice line amount does not include a minus sign. No - in Total invoice lines amount
Credit	Invoice line amount does not include a minus sign.
Note:	Note
Aleph Invoice Line Items columns
Seq.	Line #
Order No.	PO Line #
Net Amt.	Price
Total Amt.	Total Price
Note:	Note
Budget	Funds
Object Code	Reporting Code
Local Amt.	Allocated Fund Transaction - Amount
Units in Ord	Available in invoice line view
Units in Inv	Available in invoice line view