| export_inovice_alloc_ 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 of the alex_invoice_export_header row that is parent to this line item. This field establishes foreign key relationship to the alpr_INVOICE table. |
| export_invoice_line_id |
alex_invoice_export_line - export_invoice_line_id |
Int |
N |
Foreign key to the alex_invoice_export_line table. More than one occurrence of this value is possible if the line item has multiple allocations. |
| line_allocation_source_id |
aler_line_allocation - line_allocation_id |
Int |
N |
Foreign key to the source table, aler_line_ allocation |
| percent_allotted |
aler_line_allocation - percent_allotted |
numeric (26, 16) |
Y |
Percentage accounted by this allocation for the parent expense line. |
| base_amount |
aler_line_allocation - base_amount |
numeric (20, 10) |
Y |
The base amount for the line allocation. This is the amount to be exported. |
| cost_center_name |
aler_line_allocation - cost_center_id/ alco_cost_center - cost_center_name |
varchar(255) |
Y |
The cost center name for the allocation, if any. Derived from the alco_cost_center table. |
| cost_center_code |
../aler_line_allocation - cost_center_id |
varchar(255) |
Y |
The cost center code for the allocation, if any. Derived from the alco_cost_center table. |
| cost_center_ekey |
aler_line_allocation- cost_center_id/ alco_cost_center |
varchar(255) |
Y |
External key that identifies the cost center. |
| Company_code |
aler_line_allocation- cost_center_id/ alco_cost_center - department_id/alco_company -company_code |
varchar(255) |
Y |
Company code of the cost center. |
| Company_name |
../alco_company -company_name |
varchar(255) |
Y |
Company name of the cost center. |
| division_code |
../alco_division - division_code |
varchar(255) |
Y |
Division code of the cost center. |
| division_name |
../alco_division - division_name |
varchar(255) |
Y |
Division name of cost center. |
| department_code |
aler_line_allocation- cost_center_id/ alco_cost_center - department_id/alco_ department - department_code |
varchar(255) |
Y |
Department code cost center. |
| department_name |
../alco_department - department_name |
varchar(255) |
Y |
Department name of cost Center. |
| project_code |
aler_line_allocation - project_number_id/ alco_project_number - project_code |
varchar(255) |
Y |
The project code for the allocation, if any. |
| parent_project_charge_ code |
../alco_project_number - parent_project_number_ id/ alco_project_number - project_charge_code |
varchar(255) |
Y |
The parent project charge code for the above project_code, if any. |
| project_charge_code |
../alco_project_number -project_charge_code |
varchar(255) |
Y |
The project charge code. |
| project_code_ekey |
aler_line_allocation - project_number_id/ alco_project_number |
varchar(255) |
Y |
External key that identifies the project for the allocation. |
| segment1_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 1 name of allocation cost center |
| segment1_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 1 code of allocation cost center |
| segment2_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 2 name of allocation cost center |
| segment2_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 2 code of allocation cost center |
| segment3_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 3 name of allocation cost center |
| segment3_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 3 code of allocation cost center |
| segment4_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 4 name of allocation cost center |
| segment4_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 4 code of allocation cost center |
| segment5_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 5 name of allocation cost center |
| segment5_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 5 code of allocation cost center |
| segment6_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 6 name of allocation cost center |
| segment6_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 6 code of allocation cost center |
| segment7_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 7 name of allocation cost center |
| segment7_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 7 code of allocation cost center |
| segment8_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 8 name of allocation cost center |
| segment8_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 8 code of allocation cost center |
| segment9_name |
alco_cost_center_segment - segment_name |
varchar(255) |
NULL |
Segment 9 name of allocation cost center |
| segment9_code |
alco_cost_center_segment - segment_code |
varchar(255) |
NULL |
Segment 9 code of allocation cost center |
| segment_count |
alco_cost_center_config - segment_count |
int |
NULL |
The number of segments in the cost center of this line item. |
| review_segment_name |
alco_cost_center_rev_segment - segment_name |
varchar(255) |
NULL |
The review segment name of the cost center of this line item. |
| review_segment_code |
alco_cost_center_rev_segment - segment_code |
varchar(255) |
NULL |
The review segment code of the cost center of this line item. |