Query "Cust. Ledger Entries"
ID 262
Namespace: Microsoft.Sales.Receivables
Properties
| Name | Value |
|---|---|
| Caption | Cust. Ledger Entries |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Entry_No | Cust_Ledger_Entry | Integer | |
| Transaction_No | Cust_Ledger_Entry | Integer | |
| Customer_No | Cust_Ledger_Entry | Code[20] | |
| Posting_Date | Cust_Ledger_Entry | Date | |
| Due_Date | Cust_Ledger_Entry | Date | |
| Pmt_Discount_Date | Cust_Ledger_Entry | Date | |
| Document_Date | Cust_Ledger_Entry | Date | |
| Document_Type | Cust_Ledger_Entry | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | |
| Document_No | Cust_Ledger_Entry | Code[20] | |
| Salesperson_Code | Cust_Ledger_Entry | Code[20] | |
| Source_Code | Cust_Ledger_Entry | Code[10] | |
| Reason_Code | Cust_Ledger_Entry | Code[10] | |
| IC_Partner_Code | Cust_Ledger_Entry | Code[20] | |
| Open | Cust_Ledger_Entry | Boolean | |
| Currency_Code | Cust_Ledger_Entry | Code[10] | |
| Amount | Cust_Ledger_Entry | Decimal | |
| Debit_Amount | Cust_Ledger_Entry | Decimal | |
| Credit_Amount | Cust_Ledger_Entry | Decimal | |
| Remaining_Amount | Cust_Ledger_Entry | Decimal | |
| Amount_LCY | Cust_Ledger_Entry | Decimal | |
| Debit_Amount_LCY | Cust_Ledger_Entry | Decimal | |
| Credit_Amount_LCY | Cust_Ledger_Entry | Decimal | |
| Remaining_Amt_LCY | Cust_Ledger_Entry | Decimal | |
| Original_Amt_LCY | Cust_Ledger_Entry | Decimal | |
| Dimension_Set_ID | Cust_Ledger_Entry | Integer | |
| Customer_Name | Customer | Text[100] |