ALEX_IMPORT_TP_LINE_ITEM (Staging Table)

Column name Data type Required Default update table Data target Comments
external_key** VARCHAR (255) Yes* No aler_invoice_line_item.exp_line_item_id The external key -- Primary Key
user_ekey VARCHAR(255) Yes* No The user the entry belongs to
import_status SMALLINT Yes* Yes The import command/status (0=dont import, 1=do import, 2=success, 100+=re-process, -1=failed)
import_error_ message VARCHAR(255) No No The import error message
import_change_ timestamp DATETIME No No The import timestamp
parent_type SMALLINT Yes No The type of parent to attach the line item to (0=document whose ekey is in parent_ekey, 1=line item whose ekey is in parent_ekey, 2=document whose tracking number is in parent_ekey, 3=unattached... no parent, 4=current active document, 5=current active document and create if necessary)
parent_ekey VARCHAR(255) No No The parents ekey
tr_item_type_id_ ekey VARCHAR(255) Yes No altr_line_item.tr_item_type_id line item element
tax_cost_id_ekey VARCHAR(255) No No altr_line_item.tax_cost_id line item element
tax_cost NUMERIC(28,10) No No line item element
purpose_ekey VARCHAR(255) No No altr_line_item.purpose line item element
vendor_ekey VARCHAR(255) No No altr_line_item.vendor line item element
from_location_ ekey VARCHAR(255) No No altr_line_item.from_location line item element
from_date DATETIME No No altr_line_item.from_date line item element
from_time DATETIME No No altr_line_item.from_time line item element
to_location_ekey VARCHAR(255) No No altr_line_item.to_location line item element
to_date DATETIME No No altr_line_item.to_date line item element
to_time DATETIME No No altr_line_item.to_time line item element
class_of_service_ ekey VARCHAR(255) No No altr_line_item.class_of_service line item element
cust_def_1 VARCHAR(255) No No altr_line_item.cust_def_1 line item element
cust_def_2 VARCHAR(255) No No altr_line_item.cust_def_2 line item element
cust_def_3 VARHCHAR(255) No No altr_line_item.cust_def_3 line item element
daily_rate_native_ id_ekey VARCHAR(255) No No altr_line_item.daily_rate_native_id line item element
daily_rate_native NUMERIC(28, 10) No No altr_line_item.daily_rate_native line item element
currency_fmt_defn _id_ekey VARCHAR(255) No No altr_line_item.currency_fmt_defn_id line item element
exch_rate NUMERIC(26,16) No No altr_line_item.exch_rate line item element
miles NUMERIC(15,5) No No altr_line_item.miles line item element
reimburse_rate NUMERIC(18,7) No No altr_line_item.reimburse_rate line item element
guest_count INTEGER No No altr_line_item.guest_counjt line item element
guest_entry_mode SMALLINT Yes No altr_line_item.guest_entry_mode line item element
guest_amount_ equal SMALLINT Yes No altr_line_item.guest_amount_equal line item element
guest_no_show_ count INTEGER No No altr_line_item.guest_no_show_count line item element
keyword_guest_ ekeys TEXT No No The line item guests
keyword_note TEXT No No The line item note
imported_read_only NUMERIC(5) No Yes altr_line_item.imported_read_only Holds the read only status of imported line items.