Table: dbo.Import_Template_Column_AR_Transaction_Item_Data | |||
Specifies information about user defined template columns for spreadsheet import of AR Transactions invoice items. Only import template column rows of type Item, Shipping will have an associated rows in this table. | |||
Columns | |||
Name | Type | Constraints | Description |
import_template_column_KEY | int (4) | NOT NULL | Primary key for this table. |
spreadsheet_import_ar_transaction_item_selection_KEY | int (4) | Specifies the key of selected option for import template column of type Item. NULL - when "Item" is not mapped but "Shipping" is mapped. | |
spreadsheet_import_ar_transaction_shipping_item_selection_KEY | int (4) | Specifies the key of selected option for import template column of type Shipping. NULL - when "Shipping" is not mapped but "Item" is mapped. |
Primary key | |||
Name | Columns | Description | |
PK_Import_Template_Column_AR_Transaction_Item_Data$import_template_column_KEY | import_template_column_KEY |