BUSINESS_UNITCUST_DEPOSIT_IDDEPOSIT_SEQ_NUM1=Deposit Taken
2=Deposit Applied
3=Deposit Refunded
ORDDEPACT_TEO1(SQL Table) |
Index Back |
|---|---|
Sales Order Deposit ActivityCustomer Sales Order Deposit Activity |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CUST_DEPOSIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer Deposit ID |
| 3 | DEPOSIT_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Deposit Sequence Number |
| 4 | DEPOSIT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Action
1=Deposit Taken 2=Deposit Applied 3=Deposit Refunded |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | REFUND_FEE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Refund Fee Percent |
| 8 | REFUND_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Refund Fee Amount |
| 9 | REFUND_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Refund Amount |
| 10 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 11 | RECEIPT_NBR | Character(15) | VARCHAR2(15) NOT NULL | Receipt Number |
| 12 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 13 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 14 | AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | REFUND_FEE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Refund Fee Amount |
| 16 | REFUND_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Refund Amount |
| 17 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 18 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 19 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |