BUS_UNIT_TYPEAR=Accounts Receivable
OM=Order Management
BUSINESS_UNITDRAWER_IDDEPOSIT_BURECEIPT_NBRRECEIPT_NBR_SEQCDR_RECEIPT_VW(SQL View) |
Index Back |
|---|---|
Used to obtain totalsUsed to obtain totals such as total payments, total paid out, non-cash/check payments, non-cash/check paid bout |
| SELECT RECPT.BUS_UNIT_TYPE , RECPT.BUSINESS_UNIT , RECPT.DRAWER_ID , RECPT.DEPOSIT_BU , RECPT.RECEIPT_NBR , PMT.RECEIPT_NBR_SEQ , RECPT.ADD_DTTM , PMT.CHECK_NBR , PMT.PAYMENT_AMT , PMT.CURRENCY_CD FROM PS_CDR_RECEIPT RECPT , PS_CDR_RECEIPT_PMT PMT WHERE RECPT.DEPOSIT_BU = PMT.DEPOSIT_BU AND RECPT.RECEIPT_NBR = PMT.RECEIPT_NBR AND PMT.PAYMENT_METHOD_CDR = 'CHK' AND RECPT.RECEIPT_STATUS = 'PRT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUS_UNIT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Unit Type
AR=Accounts Receivable OM=Order Management |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DRAWER_ID |
Character(5) | VARCHAR2(5) NOT NULL | Drawer Identificaion |
| 4 | DEPOSIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 5 | RECEIPT_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Receipt Number |
| 6 | RECEIPT_NBR_SEQ |
Number(3,0) | SMALLINT NOT NULL | Receipt Number Sequence |
| 7 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 8 | CHECK_NBR | Character(30) | VARCHAR2(30) NOT NULL | Check Number |
| 9 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |