ALEX_IMPORT_PR_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
item_number VARCHAR(255) No No alpr_invoice_line_item.item_number line item element
item_ description VARCHAR(255) No No alpr_invoice_line_item.expense.item_description line item element
invoiced_ quantity INTEGER No No alpr_invoice_line_item.invoiced_quantity line item element
unit_of_

measure_id

_ekey

VARCHAR(255) No No alpr_invoice_line_item.unit_of_measure_id line item element
unit_price_ amount NUMERIC(28,10) No No alpr_invoice_line_item.unit_price_amount line item element
unit_price_

amount_id

_ekey

VARCHAR(255) No No alpr_invoice_line_item.unit_price_amount_id line item element
check_request _type_id_ekey VARCHAR(255) No No alpr_invoice_line_item.check_request_type_id line item element
guest_count INTEGER No No alpr_invoice_line_item.guest_count line item element
td_gl_account _override VARCHAR(255) No No alpr_invoice_line_item.td_gl_account_override line item element
td_gl_

subaccount_

override

VARCHAR(255) No No alpr_invoice_line_item.td_gl_subaccount_override line item element
guest_entry _mode SMALLINT Yes No alpr_invoice_line_item.guest_entry_mode line item element
guest_amount _equal SMALLINT Yes No alpr_invoice_line_item.guest_amount_equal line item element
guest_no _show_count INTEGER No No alpr_invoice_line_item.guest_no_show_count line item element
keyword_

alloc_cost_

center_ekey

VARCHAR(255) No No The line item allocation cost center
keyword_alloc

_project_num

_ekey

VARCHAR(255) No No The line item allocation project
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 alpr_invoice_line_item.imported_read_only Holds the read only status of imported line items