InvoiceDetails
Generated schema file.
Columns
| Name | Type | References | |
| Id [KEY] | Integer |
Invoices.Id | |
| CompanyId | Integer | ||
| InvoiceNumber | String | ||
| Subject | String | ||
| TemplateId | Integer | ||
| BillingDate | Date | ||
| PaymentDate | Date | ||
| PaymentType | String | ||
| Memo | String | ||
| SendingStatus | String | ||
| PaymentStatus | String | ||
| CancelStatus | String | ||
| DealStatus | String | ||
| DealId | Integer | ||
| TotalAmount | Decimal | ||
| AmountWithholdingTax | Decimal | ||
| AmountIncludingTax | Decimal | ||
| AmountExcludingTax | Decimal | ||
| AmountTax | Decimal | ||
| PartnerId | Integer | ||
| PartnerName | String | ||
| PartnerDisplayName | String | ||
| BranchNo | String | ||
| InvoiceNote | String | ||
| TaxEntryMethod | String | ||
| TaxFraction | String | ||
| WithholdingTaxEntryMethod | String | ||
| CreatedAt | Datetime | ||
| AmountIncludingTax10 | Decimal | ||
| AmountExcludingTax10 | Decimal | ||
| AmountTax10 | Decimal | ||
| AmountIncludingTax8 | Decimal | ||
| AmountExcludingTax8 | Decimal | ||
| AmountTax8 | Decimal | ||
| AmountIncludingTax8Reduced | Decimal | ||
| AmountExcludingTax8Reduced | Decimal | ||
| AmountTax8Reduced | Decimal | ||
| AmountIncludingTax0 | Decimal | ||
| AmountExcludingTax0 | Decimal | ||
| AmountTax0 | Decimal | ||
| PartnerTitle | String | ||
| PartnerBankAccount | String | ||
| PartnerAddressZipcode | String | ||
| PartnerAddressPrefectureCode | Integer | ||
| PartnerAddressStreetName1 | String | ||
| PartnerAddressStreetName2 | String | ||
| PartnerContactDepartment | String | ||
| PartnerContactName | String | ||
| CompanyContactName | String | ||
| TemplateTitle | String | ||
| TemplateInvoiceRegistrationNumber | String | ||
| TemplateCompanyName | String | ||
| TemplateCompanyDescription | String | ||
| TemplateBankAccountToTransfer | String | ||
| TemplateMessage | String | ||
| TemplateName | String | ||
| Lines | String |