DR_TYPE_ACT_WS1(SQL Table) |
Index Back |
|---|---|
Draft Type Acctg Work ScrollThis is a work scroll table used by Draft Type Maintenance to display accounting entries. It is defined as a Table purely to get around the tools restriction that a scroll must be a "table". There will be no data on the actual database. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DRAFT_BUSN_EVENT | Character(2) | VARCHAR2(2) NOT NULL | Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft. |
| 2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | DR_DST_USE_CR | Character(3) | VARCHAR2(3) NOT NULL |
Distribution Type
AR=Accounts Receivable CDD=Contra Discounted Draft CSC=Cash Control CSH=Cash DCC=Draft Cash Control DDC=Discount Draft Cash Control DDI=Deferred Discount DIS=Discount DMD=Discounted Draft Receivable DMJ=Dishonored Draft Receivable DML=Discounted Draft Liability DMR=Draft Receivable DRV=Deferred Revenue DSU=Deferred Surcharge GST=Canadian GST IUP=Interunit Payables IUR=Interunit Receivables REV=Revenue RFD=Refund Control RL=Realized Gain / Loss SUR=Surcharge SUT=Sales/Use Tax UAR=Unbilled Accounts Receivable URL=Unrealized Gain / Loss |
| 4 | DR_DST_USE_DR | Character(3) | VARCHAR2(3) NOT NULL |
Distribution Type
AR=Accounts Receivable CDD=Contra Discounted Draft CSC=Cash Control CSH=Cash DCC=Draft Cash Control DDC=Discount Draft Cash Control DDI=Deferred Discount DIS=Discount DMD=Discounted Draft Receivable DMJ=Dishonored Draft Receivable DML=Discounted Draft Liability DMR=Draft Receivable DRV=Deferred Revenue DSU=Deferred Surcharge GST=Canadian GST IUP=Interunit Payables IUR=Interunit Receivables REV=Revenue RFD=Refund Control RL=Realized Gain / Loss SUR=Surcharge SUT=Sales/Use Tax UAR=Unbilled Accounts Receivable URL=Unrealized Gain / Loss |