Analyses
Generated schema file.
Columns
| Name | Type | References | |
| Id | Integer | ||
| AnalysisDataKbn | Integer | ||
| AnalysisDataKbnName | String | ||
| ProjectId | Integer | ||
| ProjectName | String | ||
| ProjectProjectNo | Integer | ||
| ProjectManagementNo | String | ||
| Expenditure | String | ||
| ProjectCost | String | ||
| Total | String | ||
| Tax | String | ||
| TaxWithholding | String | ||
| OrderStatus | Integer | ||
| OrderStatusName | String | ||
| InvoiceStatus | Integer | ||
| InvoiceStatusName | String | ||
| DeliveryStatus | Integer | ||
| DeliveryStatusName | String | ||
| ExpenditureStatus | String | ||
| ExpenditureStatusName | String | ||
| PaymentStatus | String | ||
| PaymentStatusName | String | ||
| ReportDate | Date | ||
| ClientId | Integer | ||
| ClientName | String | ||
| ClientNameDisp | String | ||
| ClientCustomNo | String | ||
| Payee | String | ||
| CompanyBranchId | Integer | ||
| CompanyBranchName | String | ||
| GroupId | Integer | ||
| GroupName | String | ||
| UserId | Integer | ||
| UserLastName | String | ||
| UserFirstName | String | ||
| ProjectTypeId | Integer | ||
| ProjectTypeName | String | ||
| ProjectType2Id | Integer | ||
| ProjectType2Name | String | ||
| ProjectType3Id | Integer | ||
| ProjectType3Name | String | ||
| ExpenditureTypeId | String | ||
| ExpenditureTypeName | String | ||
| ExpenditureType2Id | String | ||
| ExpenditureType2Name | String | ||
| ExpenditureType3Id | String | ||
| ExpenditureType3Name | String | ||
| AccountingTypeId | Integer | ||
| AccountingTypeName | String | ||
| AccountingType2Id | Integer | ||
| AccountingType2Name | String | ||
| AccountingType3Id | Integer | ||
| AccountingType3Name | String | ||
| Tags | String | ||
| AutoFlg | Integer | ||
| AutoRenewalSimulationFlg | Integer | ||
| Currency | String | ||
| TotalJpy | Integer | ||
| TaxJpy | Integer | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime |