TransactionDetails
Generated schema file.
Columns
| Name | Type | References | Description |
| TransactionHeadId [KEY] | Integer |
Transactions.TransactionHeadId | |
| TransactionDetailId [KEY] | Integer | ||
| ApplyBargainDiscountPrice | Integer | ||
| ApplyBargainValue | String | ||
| ApplyStaffDiscountPrice | Integer | ||
| ApplyStaffDiscountRate | Integer | ||
| BargainDiscountProportional | Integer | ||
| BargainDivision | String | ||
| BargainId | Integer | ||
| BargainName | String | ||
| BargainValue | Integer | ||
| CalcDiscount | String | ||
| CategoryId | Integer | ||
| CategoryName | String | ||
| Color | String | ||
| Cost | Decimal | ||
| CostSum | Decimal | ||
| DiscountCouponProportional | Integer | ||
| DiscountPointProportional | Integer | ||
| DiscountPriceProportional | Integer | ||
| DiscriminationNo | String | ||
| GroupCode | String | ||
| InventoryReservationDivision | String | ||
| Memo | String | ||
| ModifiedTaxRate | Decimal | ||
| ParentTransactionDetailId | Integer | ||
| PointNotApplicable | String | ||
| Price | Integer | ||
| PrintReceiptProductName | String | ||
| ProductBundleGroupId | Integer | ||
| ProductBundleProportional | Integer | ||
| ProductCode | String | ||
| ProductDivision | String | ||
| ProductId | Long |
Products.ProductId | |
| ProductName | String | ||
| ProductStaffDiscountRate | Integer | ||
| Quantity | Integer | ||
| ReduceTaxId | Integer | ||
| ReduceTaxMemberPrice | Integer | ||
| ReduceTaxName | String | ||
| ReduceTaxPrice | Integer | ||
| ReduceTaxRate | Decimal | ||
| RfidTags | String | ||
| RoundingPriceProportional | Integer | ||
| SalesDivision | String | ||
| SalesPrice | Integer | ||
| Size | String | ||
| StaffDiscountDivision | String | ||
| StaffDiscountProportional | Integer | ||
| StaffDiscountRate | Integer | ||
| StaffRank | String | ||
| StaffRankName | String | ||
| StandardTaxRate | String | ||
| TaxDivision | String | ||
| TaxExcludeProportional | Integer | ||
| TaxFree | String | ||
| TaxFreeCommodityPrice | Integer | ||
| TaxFreeDivision | String | ||
| TaxIncludeProportional | Integer | ||
| TaxRate | Decimal | ||
| TransactionDetailDivision | String | ||
| UnitDiscountDivision | String | ||
| UnitDiscountedSum | Integer | ||
| UnitDiscountPrice | Integer | ||
| UnitDiscountRate | Integer | ||
| UnitDiscountSum | Integer | ||
| UnitNonDiscountSum | Integer | ||
| Discounts | String | ||
| ProductAttributesunts | String | ||
| WithDiscounts | String | ||
| WithDetailProductAttributes | String |