CORP_CREDIT_AR(SQL Table) |
Index Back |
|---|---|
AR Corporate Cust Credit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: CORP_NODE_AR.SETID |
| 2 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Default Value: CORP_NODE_AR.TREE_NODE |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | CR_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Credit Limit |
| 6 | CR_LIMIT_RANGE | Number(3,0) | SMALLINT NOT NULL | Limit Range % |
| 7 | CORPCR_PCT_OVR | Number(3,0) | SMALLINT NOT NULL | % Over Limit |
| 8 | CR_LIMIT_DT | Date(10) | DATE | Credit Limit Date |
| 9 | CR_LIMIT_REV_DT | Date(10) | DATE | Credit Limit Review Date |
| 10 | 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 |
| 11 | DISPUTE_DT | Date(10) | DATE | Specifies the date that an item was placed in dispute status. |
| 12 | 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. |
| 13 | 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 |
| 14 | 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. |
| 15 | RISK_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Risk Code
H=High L=Low M=Medium Default Value: M |
| 16 | CREDIT_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Credit Class
A=Class A B=Class B C=Class C Default Value: A |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CUSTOMER.CURRENCY_CD |
| 18 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 19 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |