Query "G/L Entries"
ID 261
Namespace: Microsoft.Finance.GeneralLedger.Ledger
Properties
| Name | Value |
|---|---|
| Caption | G/L Entries |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Entry_No | G_L_Entry | Integer | |
| Transaction_No | G_L_Entry | Integer | |
| G_L_Account_No | G_L_Entry | Code[20] | |
| Posting_Date | G_L_Entry | Date | |
| Document_Date | G_L_Entry | Date | |
| Document_Type | G_L_Entry | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | |
| Document_No | G_L_Entry | Code[20] | |
| Source_Code | G_L_Entry | Code[10] | |
| Job_No | G_L_Entry | Code[20] | |
| Business_Unit_Code | G_L_Entry | Code[20] | |
| Reason_Code | G_L_Entry | Code[10] | |
| Gen_Posting_Type | G_L_Entry | Enum Microsoft.Foundation.Enums."General Posting Type" | |
| Gen_Bus_Posting_Group | G_L_Entry | Code[20] | |
| Gen_Prod_Posting_Group | G_L_Entry | Code[20] | |
| Tax_Area_Code | G_L_Entry | Code[20] | |
| Tax_Liable | G_L_Entry | Boolean | |
| Tax_Group_Code | G_L_Entry | Code[20] | |
| Use_Tax | G_L_Entry | Boolean | |
| VAT_Bus_Posting_Group | G_L_Entry | Code[20] | |
| VAT_Prod_Posting_Group | G_L_Entry | Code[20] | |
| IC_Partner_Code | G_L_Entry | Code[20] | |
| Amount | G_L_Entry | Decimal | |
| Debit_Amount | G_L_Entry | Decimal | |
| Credit_Amount | G_L_Entry | Decimal | |
| VAT_Amount | G_L_Entry | Decimal | |
| Additional_Currency_Amount | G_L_Entry | Decimal | |
| Add_Currency_Debit_Amount | G_L_Entry | Decimal | |
| Add_Currency_Credit_Amount | G_L_Entry | Decimal | |
| Dimension_Set_ID | G_L_Entry | Integer | |
| G_L_Account_Name | G_L_Entry | Text[100] |