CUSTCREDIT_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CUST_CREDIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 4 | EFFDT | Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | CR_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Credit Limit |
| 7 | CR_LIMIT_RANGE | Number(3,0) | SMALLINT NOT NULL | Limit Range % |
| 8 | CR_LIMIT_DT | Date(10) | DATE | Credit Limit Date |
| 9 | CR_LIMIT_CORP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Corporate Credit Limit |
| 10 | CR_LIM_CORP_RANGE | Number(3,0) | SMALLINT NOT NULL | Limit Range % |
| 11 | CR_LIMIT_CORP_DT | Date(10) | DATE | Corporate Credit Limit Date |
| 12 | CR_LIMIT_REV_DT | Date(10) | DATE | Credit Limit Review Date |
| 13 | DISPUTE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
Prompt Table: DISPUTE_TBL |
| 14 | DISPUTE_DT | Date(10) | DATE | Specifies the date that an item was placed in dispute status. |
| 15 | DISPUTE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item. |
| 16 | COLLECTION_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
Prompt Table: COLLECTION_TBL |
| 17 | COLLECTION_DT | Date(10) | DATE | Specifies the date that a customer or invoice was put in collection status. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due. |
| 18 | RISK_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Risk Code
H=High L=Low M=Medium Default Value: M |
| 19 | RISK_SCORE | Number(3,0) | SMALLINT NOT NULL | Risk Score used in Receivables Collections Workbench |
| 20 | CREDIT_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Credit Class
A=Class A B=Class B C=Class C |
| 21 | CREDIT_CHECK | Character(1) | VARCHAR2(1) NOT NULL |
Credit Check
N=Credit Check No Y=Credit Check Yes Y/N Table Edit Default Value: N |
| 22 | CR_CHK_ALG_PROFILE | Character(1) | VARCHAR2(1) NOT NULL |
Corporate Cr. Check Algorithm
A=Advanced B=Basic I=Installation Default Default Value: I |
| 23 | CR_SUM_PROFILE | Character(1) | VARCHAR2(1) NOT NULL |
Use Corporate Summary Table
I=Installation Default N=No Y=Yes Default Value: I |
| 24 | MAX_ORDER_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Order Amount |
| 25 | CUSTCR_PCT_OVR | Number(3,0) | SMALLINT NOT NULL | % Over Limit |
| 26 | CORPCR_PCT_OVR | Number(3,0) | SMALLINT NOT NULL | % Over Limit |
| 27 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 28 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 29 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 30 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |
| 31 | AGING_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Aging Category
Prompt Table: AGING_CATEG_TBL |
| 32 | AGING_ID | Character(5) | VARCHAR2(5) NOT NULL |
Aging ID
Prompt Table: AGING_TBL |
| 33 | BACKLOG_DAYS | Number(4,0) | SMALLINT NOT NULL | Backlog Days |
| 34 | AR_1099C | Character(1) | VARCHAR2(1) NOT NULL |
1099-c Reporting
Default Value: N |
| 35 | BANKRUPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bankrupt
Default Value: N |
| 36 | MARKET_VALUE | Number(27,3) | DECIMAL(26,3) NOT NULL | Market Value |
| 37 | AR_1099C_BU | Character(5) | VARCHAR2(5) NOT NULL |
AR Business Unit - ICE 2013730000
Prompt Table: SP_BUARDS_NONVW |
| 38 | PERSONALLY_LIABLE | Character(1) | VARCHAR2(1) NOT NULL |
ICE 2013730000
Y/N Table Edit Default Value: N |
| 39 | DESCRLONG | Long Character | CLOB | Long Description |
| 40 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |