BUSINESS_UNIT_ARINVOICEBILL_TO_CUST_IDCRCARD_PAY_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , %Substring(A.ITEM,1, 22) , A.CUST_ID , B.BUSINESS_UNIT_BI , B.BAL_AMT , B.BAL_CURRENCY , A.ITEM_LINE , A.AMOUNT , A.CURRENCY_CD , C.CR_CARD_AUTH_DT FROM PS_CRCARD_PAYMENT A , PS_ITEM B , PS_CRCARD_AR_HST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CUST_ID = B.CUST_ID AND A.ITEM = B.ITEM AND A.ITEM_LINE = B.ITEM_LINE AND A.HIST_SEQ = C.HIST_SEQ AND C.CR_CARD_AUTH_STAT IN ('B', 'P') AND %Sql(AR_CCPAY_PEND_WHERE, A., A.) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AR |
Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 6 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 7 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 8 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | CR_CARD_AUTH_DT | Date(10) | DATE | Credit Card Authorization Date |