| export_invoice_line_id |
N/A |
INT |
N |
A unique number (Bob ID) that serves as the primary key for the row. |
| export_invoice_hdr_id |
alex_invoice_export_header - export_invoice_hdr_id |
INT |
N |
The BOb ID (PK) of the alex_invoice_export_header row that is parent to the line items in this table. |
| invoice_line_item_id |
alpr_invoice_line_item - invoice_line_item_id |
INT |
N |
Foreign key back to the source table, alpr_invoice_line_item |
| item_number |
alpr_invoice_line_item - item_number |
varchar (255) |
Y |
The unique item number identifying this item to the vendor |
| item_description |
alpr_invoice_line_item - item_description |
varchar(255) |
Y |
Description of line item. |
| item_quantity |
alpr_invoice_line_item - invoiced_quantity |
numeric(15,5) |
Y |
The number of items ordered |
| unit_of_measure_code |
alpr_invoice_line_item - unit_of_measure_id/ alco_unit_of_measure- uom_code |
varchar(255) |
Y |
Unit of measure code of the item being ordered. |
| unit_of_measure_ekey |
alpr_invoice_line_item - unit_of_measure_id/ alco_unit_of_measure |
varchar(255) |
Y |
External key identifying the unit of measure. |
| unit_price |
alpr_invoice_line_item - unit_price_amount |
numeric (20,10) |
Y |
Cost of each unit of line item. |
| total_price |
alpr_invoice_line_item - total_price_amount |
numeric (20,10) |
Y |
Total cost of the line items. Equal to Quantity multiplied by Approved Unit Price. |
| check_request_type_ name |
alpr_invoice_line_item - check_request_type_id/ alco_check_request_type - name |
varchar(255) |
Y |
The name of this payment request type |
| check_request_type_ ekey |
alpr_invoice_line_item - check_request_type_id/ alco_check_request_type |
varchar(255) |
Y |
External key identifying the payment request type. |
| check_request_type |
alco_check_request_type.type |
smallint |
Y |
Check request type as defined in alco_check_request_ type_type column in the transactional database. |
| guest_count |
alpr_invoice_line_item - guest_count |
INT |
Y |
Line item total guest count |
| guest_entry_mode |
alpr_invoice_line_item - guest_entry_mode |
smallint |
Y |
The guest entry mode (Count, Guests, or Both) |
| guest_amounts_equal |
alpr_invoice_line_item - guest_amounts_equal |
smallint |
Y |
Whether the line item amount is equally split across guests |
| guest_no_show_count |
alpr_invoice_line_item - guest_no_show_count |
INT |
Y |
The guest no-show count |
| export_line_status |
|
smallint |
Y |
status of the export document 0 to 99 are used by extensity 100 or higher can be user defined 1 new 2 completed 3 error 4 comlete verified 5 error verified |
| export_line_status_datetime |
|
datetime |
Y |
The date and time, the line status was updated |
| export_status |
alpr_invoice_line_item – export_status |
int |
Y |
the export status (0=not exported, 1=exported, 2=marked for re-export) |
| void_status |
alpr_invoice_line_item – void_status |
int |
Y |
the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a voided line item) |
| reversal_line_item_Id |
alpr_invoice_line_item – reversal_line_item_id |
int |
Y |
for voided/reversal line items, this is the matching reversal/voided line item |
| export_date |
alpr_invoice_line_item – export_date |
datetime |
Y |
The date the item was first exported to the financial system |