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