Query "Vendor Ledger Entries"
ID 263
Namespace: Microsoft.Purchases.Payables
Properties
| Name | Value |
|---|---|
| Caption | Vendor Ledger Entries |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Entry_No | Vendor_Ledger_Entry | Integer | |
| Transaction_No | Vendor_Ledger_Entry | Integer | |
| Vendor_No | Vendor_Ledger_Entry | Code[20] | |
| Posting_Date | Vendor_Ledger_Entry | Date | |
| Due_Date | Vendor_Ledger_Entry | Date | |
| Pmt_Discount_Date | Vendor_Ledger_Entry | Date | |
| Document_Date | Vendor_Ledger_Entry | Date | |
| Document_Type | Vendor_Ledger_Entry | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | |
| Document_No | Vendor_Ledger_Entry | Code[20] | |
| Purchaser_Code | Vendor_Ledger_Entry | Code[20] | |
| Source_Code | Vendor_Ledger_Entry | Code[10] | |
| Reason_Code | Vendor_Ledger_Entry | Code[10] | |
| IC_Partner_Code | Vendor_Ledger_Entry | Code[20] | |
| Open | Vendor_Ledger_Entry | Boolean | |
| Currency_Code | Vendor_Ledger_Entry | Code[10] | |
| Amount | Vendor_Ledger_Entry | Decimal | |
| Debit_Amount | Vendor_Ledger_Entry | Decimal | |
| Credit_Amount | Vendor_Ledger_Entry | Decimal | |
| Remaining_Amount | Vendor_Ledger_Entry | Decimal | |
| Amount_LCY | Vendor_Ledger_Entry | Decimal | |
| Debit_Amount_LCY | Vendor_Ledger_Entry | Decimal | |
| Credit_Amount_LCY | Vendor_Ledger_Entry | Decimal | |
| Remaining_Amt_LCY | Vendor_Ledger_Entry | Decimal | |
| Original_Amt_LCY | Vendor_Ledger_Entry | Decimal | |
| Dimension_Set_ID | Vendor_Ledger_Entry | Integer | |
| Vendor_Name | Vendor | Text[100] |