Credit Task Management Database Information
Click here to see this page in full context

Credit Task Management Database Information

Data for Credit Task Management is stored in multiple tables.

Select Tab Fields

Field

Field Name/Table

Customer Code

credit-customer-key in ar-credit-tasks

Team

credit-team-key in customer-ar

From (Order)

order-num in ar-credit-tasks

To (Order)

order-num in ar-credit-tasks

From (Customer Purchase Order)

cust-po-number in oe-header

To (Customer Purchase Order)

cust-po-number in oe-header

From (Reminder Date)

tickler-date in ar-credit-tasks

To (Reminder Date)

tickler-date in ar-credit-tasks

Credit Hold

task-code in ar-credit-tasks

Credit Alert

task-code in ar-credit-tasks

Review Date

task-code in ar-credit-tasks

Over Limit

task-code in ar-credit-tasks

Credit Tasks

status-cd in ar-credit-tasks

Reviewed

reviewed in ar-credit-tasks

Results Tab Fields

Field

Field Name/Table

Credit Tasks

This grid includes the following columns:

  • Reviewed Date - reviewed-date in ar-credit-tasks

  • Reviewed Time - reviewed-time in ar-credit-tasks

  • Created Date - created-date in ar-credit-tasks

  • Created Time - created-time in ar-credit-tasks

  • Created by User - created-by in ar-credit-tasks

  • Status Note - status-note in ar-credit-tasks

  • User Defined 1-10 - user-defined-01 to user-defined-10 in ar-credit-tasks

  • Order Number - order-num in ar-credit-tasks

  • Reviewed by - reviewed-by in ar-credit-tasks

  • Credit Status - credit-status-key in ar-credit-tasks

  • Order Class - order-class in oe-header

  • Required Date - required-date in oe-header

  • Credit Team - credit-team-key in customer-ar

  • Credit Customer Code - credit-customer-key in ar-credit-tasks

  • Closed by - closed-by in ar-credit-tasks

  • Closed Date - closed-date in ar-credit-tasks

  • Closed Time - closed-time in ar-credit-tasks

  • Priority - priority in ar-credit-tasks

  • Reviewed - reviewed in ar-credit-tasks

  • Task Status - status-cd in ar-credit-tasks

  • Credit Task - task-code in ar-credit-tasks

  • Task Date - task-date in ar-credit-tasks

  • Task Reason - task-reason in ar-credit-tasks

  • Reminder Date - tickler-date in ar-credit-tasks

  • Terms - internal-terms-key in oe-header

  • Preferred Shipper - preferred-shipper in oe-header

  • Customer Code - cust-key in oe-header

  • Order Amount - order-total in oe-header