PARENT_SETIDPARENT_CUST_IDDefault Value: N
PARENT_HIER_BAL(SQL Table) |
Index Back |
|---|---|
Customer Credit InformationDATE INIT ISSUE DESCR 051101 MC 7304301 Deleted defaults for cur cd & rate type 072401 JJM DI-EDWONG-17 Created Rel Lang Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PARENT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Parent SetID |
| 2 | PARENT_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Parent Cust ID |
| 3 | CR_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Credit Currency Code |
| 4 | CUST_DRAFTS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Actual Draft Debt |
| 5 | TOTAL_AGED_AR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Aged AR |
| 6 | AMOUNT_TOTBKLG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Backlog Amount |
| 7 | DEPOSIT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deposit Amount |
| 8 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 9 | BILLING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Resource Billing Amount |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 11 | PROCESS_DTTM | DateTime(26) | TIMESTAMP | Process Date Time |
| 12 | PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Processing Flag
Default Value: N |