BUSINESS_UNITCUST_IDITEMITEM_LINEAR_PYMNT_ITEM2(SQL View) |
Index Back |
|---|
| SELECT I.BUSINESS_UNIT , I.CUST_ID , I.ITEM , I.ITEM_LINE , P.DEPOSIT_BU , P.DEPOSIT_ID , P.PAYMENT_SEQ_NUM , P.ID_SEQ_NUM , P.REF_QUALIFIER_CODE , P.FIELDNAME , P.REF_VALUE , P.PAY_AMT , P.ITEM_AMT , P.BAL_AMT , P.BAL_CURRENCY , P.PAY_AMT_BASE , P.CURRENCY_CD FROM PS_AR_PYMNT_ITEM P , PS_ITEM I WHERE I.PO_REF = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'P' OR (I.ITEM = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'I') OR (I.ORDER_NO = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'O') OR (I.BILL_OF_LADING = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'L') OR (I.DOCUMENT = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'D') OR (I.LC_ID = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'LC') OR (I.USER1 = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'S') OR (I.ORDER_NO = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'O') OR (I.SUBCUST_QUAL1 = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'S1') OR (I.SUBCUST_QUAL2 = P.REF_VALUE AND P.REF_QUALIFIER_CODE = 'S2') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 4 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 5 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 6 | DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 7 | PAYMENT_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 8 | ID_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Identification Sequence number |
| 9 | REF_QUALIFIER_CODE | Character(2) | VARCHAR2(2) NOT NULL | Reference Qualifier Code |
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 11 | REF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Reference |
| 12 | PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 13 | ITEM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 14 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 15 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 16 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |