# | Column Name | Nullable | Data Type | Max Length | Description |
---|---|---|---|---|---|
1 | non_gl_stock_detail_id | bigint | 0 | The primary key of this table. | |
2 | sales_tax_detail_id | integer | 0 | Foreign key to the table core.state_sales_taxes | |
3 | state_sales_tax_id | integer | 0 | Foreign key to the table core.county_sales_taxes. | |
4 | county_sales_tax_id | integer | 0 | Foreign key to the table core.county_sales_taxes | |
5 | principal | money_strict | 0 | ||
6 | rate | decimal_strict | 0 | ||
7 | tax | money_strict | 0 |
# | Column Name | Key Name | References |
---|---|---|---|
1 | non_gl_stock_detail_id | non_gl_stock_tax_details_non_gl_stock_detail_id_fkey | transactions.non_gl_stock_details.non_gl_stock_detail_id |
2 | sales_tax_detail_id | non_gl_stock_tax_details_sales_tax_detail_id_fkey | core.sales_tax_details.sales_tax_detail_id |
3 | state_sales_tax_id | non_gl_stock_tax_details_state_sales_tax_id_fkey | core.state_sales_taxes.state_sales_tax_id |
4 | county_sales_tax_id | non_gl_stock_tax_details_county_sales_tax_id_fkey | core.county_sales_taxes.county_sales_tax_id |
Index Name | Owner | Access Method | Definition | Description |
---|
Constraint Name | Description |
---|
# | Column Name | Default |
---|
Trigger Name | Targets | On Event | Timing | Condition | Order | Orientation | Description |
---|