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. |