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