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