PYMNT_ID_REFA=Approved
C=Created
D=Due
N=Non-Draft Payment
R=Reconciled
W=Write Off
X=Write Off Posted
Prompt Table: GL_ACCT_ALL_VW
N=Payment Not Applied
P=Posted
U=Unposted
APD_DRAFTID_VW2(SQL View) |
Index Back |
|---|---|
Selection View for AP Draft ID |
| SELECT PYMNT_ID_REF , DFT_CONTROL_ID , PYMNT_ID , REMIT_SETID , REMIT_VENDOR , PYMNT_AMT , CURRENCY_PYMNT , BANK_SETID , BANK_CD , BANK_ACCT_KEY , DFT_MASTER_ID , BANK_ACCOUNT_NUM , CREATION_DT , PYMNT_DT , DFT_STATUS , DFT_WO_ACCT , DFT_WO_DT , BUSINESS_UNIT_GL , POST_STATUS_AP , DESCRLONG FROM PS_PAYMENT_TBL WHERE PYMNT_METHOD IN ('BOO', 'BEF', 'DFT') AND POST_STATUS_AP = 'P' AND PYMNT_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PYMNT_ID_REF |
Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 2 | DFT_CONTROL_ID | Character(20) | VARCHAR2(20) NOT NULL | Draft Control ID |
| 3 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 4 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 5 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 6 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 7 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 8 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 9 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 10 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 11 | DFT_MASTER_ID | Character(10) | VARCHAR2(10) NOT NULL | Draft Master ID |
| 12 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 13 | CREATION_DT | Date(10) | DATE | Creation Date |
| 14 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 15 | DFT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Payment Status
A=Approved C=Created D=Due N=Non-Draft Payment R=Reconciled W=Write Off X=Write Off Posted |
| 16 | DFT_WO_ACCT | Character(10) | VARCHAR2(10) NOT NULL |
Draft writeOff Account
Prompt Table: GL_ACCT_ALL_VW |
| 17 | DFT_WO_DT | Date(10) | DATE | Draft Write-Off Date |
| 18 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 19 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |
| 20 | DESCRLONG | Long Character | CLOB | Long Description |