DRAFT_BUDefault Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDS_NONVW
DRAFT_IDDefault Value: NEXT
Prompt Table: DRAFT_CONTROL
ARDFTITLE_FL_VW(SQL View) |
Index Back |
|---|---|
Draft Writeoff Title ViewDraft Writeoff Title View |
| SELECT DISTINCT D.DRAFT_BU , D.DRAFT_ID , D.GROUP_ID , D.WO_ITEM_AMT , D.DRAFT_CURRENCY , D.HDR_DETAIL5 , D.DRAFT_DOC_REF FROM PS_ARDFWOHD_FL_VW D |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DRAFT_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW |
| 2 | DRAFT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
Default Value: NEXT Prompt Table: DRAFT_CONTROL |
| 3 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 4 | WO_ITEM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Write Off Item |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | HDR_DETAIL5 | Character(50) | VARCHAR2(50) NOT NULL | Header Detail 5 |
| 7 | DRAFT_DOC_REF | Character(20) | VARCHAR2(20) NOT NULL | Draft Reference |