LIBRARY INVOICE STATUS Table
Lists the codes and descriptions for the method of payment for "invoice" documents (e.g., CHK for Check, DRT for Foreign Draft VIS for Visa). Also lists the codes and descriptions for the Payment Status for "invoice" documents (e.g., N for Not Ready to be Paid, P for Paid)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_INVOICE_STATUS_KEY |
Key used to join to the LIBRARY_INVOICE_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
PAYMENT_METHOD |
Description of the PAYMENT-METHOD_CODE (e.g, Check, Foreign Draft, etc.) codes. |
VARCHAR2 |
30 |
PAYMENT_METHOD_CODE |
Code showing how the ""invoice"" will be paid or processed (e.g., CHK, DRT, etc.) (Z77-I-STATUS or Invoice Status in the client) |
VARCHAR2 |
3 |
PAYMENT_STATUS |
Description of the PAYMENT_STATUS_CODE (e.g, Not Ready to be Paid, Paid, etc.) codes. (Z77-P-STATUS) |
VARCHAR2 |
30 |
PAYMENT_STATUS_CODE |
Code showing at what stage the invoice is in the payment process. (e.g, N, P, etc.) (Z77-P-STATUS) |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |