LIBRARY INVOICE TYPE Table
Lists the codes and descriptions for the type of "invoice" document being processed (e.g., REG for Regular, PAR for Partial, CRE for Credit). Use this table to limit your report to a specific kind of invoice document. Data in this table is taken from the Z77 table in Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_INVOICE_TYPE |
Description of the LIBRARY_INVOICE_TYPE_CODE (e.g, Regular, Partial, Credit, etc.) codes. |
VARCHAR2 |
30 |
LIBRARY_INVOICE_TYPE_CODE |
Used tolimit queries by invoice type. (E.g., REG, PAR, CRE, etc.) (Z77-I-Type or Invoice Type in the client) |
VARCHAR2 |
3 |
LIBRARY_INVOICE_TYPE_KEY |
Key used to join to the LIBRARY_INVOICE_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |