Invoices
Generated schema file.
Columns
Name | Type | References | |
AccountingTypeId | Integer | ||
AccountingTypeName | String | ||
AccountingType2Id | Integer | ||
AccountingType2Name | String | ||
AccountingType3Id | Integer | ||
AccountingType3Name | String | ||
ClientId | Integer | ||
ClientName | String | ||
ClientNameDisp | String | ||
ClientBranchId | Integer | ||
ClientBranchName | String | ||
CompanyBranchId | Integer | ||
CompanyBranchName | String | ||
ContactFirstName | String | ||
ContactId | Integer | ||
ContactLastName | String | ||
CreatedAt | Datetime | ||
Currency | String | ||
ExchangeRate | Integer | ||
Id | Integer | ||
InvoiceDate | Date | ||
InvoiceStatus | Integer | ||
InvoiceStatusName | String | ||
LangKbn | Integer | ||
LangKbnName | String | ||
LockFlg | Integer | ||
ManagementNo | String | ||
Name | String | ||
OrderStatus | Integer | ||
OrderStatusName | String | ||
PaidDate | String | ||
PaymentLimitDate | Date | ||
ProjectId | Integer | ||
ProjectNo | Integer | ||
ProjectTypeId | Integer | ||
ProjectTypeName | String | ||
ProjectType2Id | Integer | ||
ProjectType2Name | String | ||
ProjectType3Id | Integer | ||
ProjectType3Name | String | ||
Tags | String | ||
Tax | Integer | ||
TaxJpy | Integer | ||
Total | Integer | ||
TotalJpy | Integer | ||
UpdatedAt | Datetime | ||
UserFirstName | String | ||
UserId | Integer | ||
UserLastName | String |