SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
TREE_NODEPrompt Table: CORP_NODE_AR
Prompt Table: SALES_PERSN_TBL
Prompt Table: COLLECTOR_TBL
Prompt Table: CR_ANALYST_TBL
CORP_NODE_AR(SQL Table) |
Index Back |
|---|---|
AR Corporate Cust Tree Nodes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: CORP_NODE_AR |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | SALES_PERSON | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
Prompt Table: SALES_PERSN_TBL |
| 6 | COLLECTOR | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table: COLLECTOR_TBL |
| 7 | CR_ANALYST | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table: CR_ANALYST_TBL |
| 8 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 9 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |