ALEX_INVOICE_EXPORT_HEADER (Attributes)

Column Source Data type Null Description
export_invoice_hdr_id N/A Int N A unique number (Bob ID) that serves as the primary key for the row.
export_hdr_status N/A Int N Status of the export document. Export system used values are 1, 2, 4 and 5. User defined values range is 100 or higher.
export_hdr_status_ datetime N/A Datetime N The date and time when the status is updated. When this row is initially inserted, this field is same as the export_create_date. The Document Purge process uses this to determine if the document can be purged uses this column.
export_create_date N/A Datetime N The date and time when this row is created. This is not to be confused with the document created date.
work_item_id alwf_work_item - work_item_id Int N ID of the work item associated with the document. This has a foreign key reference back to the alwf_work_item table.
document_id alpr_invoice - envelope_id varchar(255) N Tracking number of the payment request.
Title alpr_invoice - title varchar(255) Y Payment request title.
date_created alpr_invoice - date_created Datetime Y The time and date when this payment request is created.
date_submitted alpr_invoice - date_submitted Datetime Y The time and date when the creator submitted this payment request.
date_approved alpr_invoice - date_approved Datetime Y The time and date when this payment request is approved.
invoice_number alpr_invoice - invoice_number Varchar(255) Y The invoice number provided by the vendor.
invoice_date alpr_invoice - invoice_date Datetime Y The date of the invoice
invoice_due_date alpr_invoice - invoice_due_date Datetime Y The date of the payment for this invoice is due.
invoice_currency_iso alpr_invoice - total_amount_id char(3) N The ISO code for the currency used for the amount fields used by the payment request. All amount columns in this table are in the currency that corresponds to this ISO code.
invoice_currency_ekey alpr_invoice -total_amount_id varchar(255) Y External key identifying the currency used for the amount fields.
total_amount alpr_invoice - total_amount numeric (20,10) Y The total amount of the payment request
total_calculated_amount alpr_invoice - total_calculated_ amount numeric (20,10) Y The total amount of the payment request calculated by summing all line items
total_discounted_amount alpr_invoice - total_discounted_ amount numeric (20,10) Y The total amount with discount applied
pr_vendor_type_ext_ sys_id alpr_invoice -pr_vendor_id/ alpr_vendor- vendor_type_id/ alpr_vendor_type - external_sys_id varchar(255) Y External system ID of the vendor. External_sys_id field of Alco_address table. Go to alco_address table based on alpr_vendor.address_id
pr_vendor_type_name ../alpr_vendor_ type - vendor type_name varchar(255) Y Vendor type name of the vendor.
pr_vendor_type_ekey alpr_invoice -pr_vendor_id/ alpr_vendor- vendor_type_id varchar(255) Y External key identifying the vendor type.
pr_vendor_terms_name alpr_invoice -pr_vendor_id/ alpr_vendor- vendor_type_id/ alpr_vendor_type - payment_term_id /alpr_vendor_terms - term_name varchar(255) Y Description of the vendor terms with discount, Example 2/10 Net 30 means 2 percent discount if paid within 10 days, otherwise net 30 days
pr_vendor_terms_days ../alpr_vendor_ terms - term_days Int Y How many days after receipt of an invoice is the amount due. Using the example 2/10 Net 30, this value would be 30
pr_vendor_terms_ekey alpr_invoice -pr_vendor_id/ alpr_vendor- vendor_type_id/ alpr_vendor_type - payment_term_id varchar(255) Y External key identifying the vendor terms.
pr_vendor_address_ekey alpr_invoice -pr_vendor_id/ alpr_vendor- address_id varchar(255) Y External key identifying the vendor address.
pr_vendor_address_ name alpr_invoice -pr_vendor_id/ alpr_vendor- address_id/ alco_address address_name - varchar(255) Y Address name of the vendor. Address_name field of alco_address table. Go to alco_address table based on alpr_vendor.address_id.
pr_vendor_location_ name ../alco_address -location_name varchar(255) Y Location name of vendor. location_name field of Alco_address table. Go to alco_address table based on alpr_vendor.address_id
pr_vendor_addr_line_1 ../alco_address -addr_line_1 varchar(255) Y Address line 1 of vendor. Address_line_1 field of Alco_address table. Go to alco_address table based on alpr_vendor.address_id
pr_vendor_addr_line_2 ../alco_address -addr_line2 varchar(255) Y Address line 2 of vendor. Address_line2 field of Alco_address table. Go to alco_address table based on alpr_vendor.address_id
pr_vendor_city_name ../alco_address -city_name varchar(255) Y City of vendor. City_name field of Alco_address table. Go to alco_address table based on alpr_vendor.address_id
pr_vendor_state_name ../alco_address -state_id/alco_state -state_name varchar(255) Y State of vendor.
pr_vendor_zip_code ../alco_address -zip_code varchar(20) Y Zip code of vendor.
pr_vendor_country_name ../alco_address -country_id/alco_ country - country_name varchar(255) Y Country of vendor.
pr_vendor_phone_number ../alco_address -phone_nbr varchar(255) Y Vendor phone number.
pr_vendor_contact_name ../alco_address -contact_name varchar(255) Y Contact person name at the vendor company.
pr_vendor_contact_email ../alco_address -contact_email_ address varchar(255) Y Contact person (at the vendor company) Email address.
pr_vendor_contact_ phone ../alco_address -contact_phone_ number varchar(255) Y Contact person (at the vendor company) phone number.
pr_vendor_fax_number ../alco_address -fax_phone_nbr varchar(255) Y Contact person (at the vendor company) fax phone number.
send_to_id alpr_invoice - send_to_id smallint Y The value of this send to. Valid values are: 1- Send to vendor 2 - Send to me 3 - Hold for pickup
discount_pay_by_date alpr_invoice - discount_pay_by_date datetime Y The date to be paid by in order to get the discount
pr_purpose alpr_invoice - pr_vendor_id/ varchar(255) Y Purpose of the Payment Request.
pr_purpose_ekey alpr_invoice - pr_vendor_id varchar(255) Y External key identifying purpose.
owner_user_id alwf_work_item/ owner_id int Y User ID for the owner of the Payment Request.
owner_login ../alco_user - user_login varchar(255) Y User login of the owner of the Payment Request.
owner_full_name ../alco_user - user_full_name varchar(255) Y User full name.
owner_employee_ number ../alco_user - employee_number varchar(255) Y User employee number.
owner_location ../alco_user - user_location varchar(255) Y User location.
owner_email_address ../alco_user - user_email_address varchar(255) Y User email address.
owner_payroll_system_ code ../alco_user - payroll_system_ code varchar(255) Y User payroll system code.
owner_ssn ../alco_user - user_ssn varchar(255) Y User Social Security Number.
owner_cost_center_name ../alco_user - cost_center_name varchar(255) Y User default cost center name.
owner_cost_center_code ../alco_user - cost_center_code varchar(255) Y User default cost center code.
owner_dept_name ../alco_user - department_name varchar(255) Y Department name of user's default cost center.
owner_division_name ../alco_user - division_name varchar(255) Y Division name of user's default cost center.
owner_dept_code ../alco_user - department_code varchar(255) Y Department code of user's default cost center.
owner_division_code ../alco_user - division_code varchar(255) Y Division Code of user's default cost center.
owner_company_name ../alco_user - company_name varchar(255) Y Company Name of user's default cost center.
owner_company_code ../alco_user - company_code varchar(255) Y Company Code of user's default cost center.
ower_user_ekey alwf_work_item/ owner_id/alco_user - varchar(255) Y External key identifying the user who is the owner of the payment request.
pr_vendor_vendor_id alpr_invoice - pr_vendor_id varchar (255) Y A foreign key to alpr_vendor table identifying the vendor who is being paid.
pr_vendor_is_payment_ taxable alpr_vendor_ type - is_payment_ taxable smallint Y Does any payment made to this vendor require notification to the government as taxable. In US this is 1099 and in Canada it is T4 code
pr_vendor_tax_code alpr_vendor_ type - tax_code varchar (255) Y If the payment is taxable, to what code should it be reported
pr_vendor_tax_id alpr_vendor_ type - tax_id varchar (255) Y The vendor identifier to the government as a tax id
pr_vendor_system_code1 alpr_vendor_ type - system_code_1 varchar (255) Y Implementation specific
pr_vendor_system_code2 alpr_vendor_ type - system_code_2 varchar (255) Y Implementation specific
pr_vendor_system_code3 alpr_vendor_ type - system_code_3 varchar (255) Y Implementation specific
pr_vendor_system_code4 alpr_vendor_ type - system_code_4 varchar (255) Y Implementation specific
pr_vendor_system_code5 alpr_vendor_ type - system_code_5 varchar (255) Y Implementation specific
pr_vendor_system_code6 alpr_vendor_ type - system_code_6 varchar (255) Y Implementation specific
pr_vendor_system_code7 alpr_vendor_ type - system_code_7 varchar (255) Y Implementation specific
pr_vendor_system_code8 alpr_vendor_ type - system_code_8 varchar (255) Y Implementation specific
requested_payment_date alpr_invoice - requested_ payment_date datetime Y The date the creator is requesting a payment for
voucher_number alpr_invoice - voucher_number varchar (255) Y An identifying value defined by an external system, but not the external system id
special_handling alpr_invoice - special_handling varchar (255) Y Any special handling note
pr_vendor_is_one_time_only alpr_vendor_ type - is_one_time_only smallint Y Is this a one time only vendor or is it a frequently used vendor?
owner_segment1_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 1 name of owner cost center
owner_segment1_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 1 code of owner cost center
owner_segment2_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 2 name of owner cost center
owner_segment2_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 2 code of owner cost center
owner_segment3_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 3 name of owner cost center
owner_segment3_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 3 code of owner cost center
owner_segment4_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 4 name of owner cost center
owner_segment4_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 4 code of owner cost center
owner_segment5_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 5 name of owner cost center
owner_segment5_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 5 code of owner cost center
owner_segment6_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 6 name of owner cost center
owner_segment6_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 6 code of owner cost center
owner_segment7_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 7 name of owner cost center
owner_segment7_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 7 code of owner cost center
owner_segment8_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 8 name of owner cost center
owner_segment8_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 8 code of owner cost center
owner_segment9_name alco_cost_center_segment - segment_name varchar(255) NULL Segment 9 name of owner cost center
owner_segment9_code alco_cost_center_segment - segment_code varchar(255) NULL Segment 9 code of owner cost center
segment_count alco_cost_center_config - segment_count int NULL The number of segments in owner cost center.
owner_review_segment_name alco_cost_center_rev_segment - segment_name varchar(255) NULL The review segment name of owner cost center.
owner_review_segment_code alco_cost_center_rev_segment - segment_code varchar(255) NULL The review segment code of owner cost center.