GLRCN_AR_DRAFT(SQL View) |
Index Back |
|---|---|
GLRCN - Draft Control |
| SELECT ACCOUNTING_DT , DRAFT_BU , DRAFT_ID , CUST_ID , BUSINESS_UNIT_GL , DRAFT_AMT , DRAFT_CURRENCY , DRAFT_AMT_BASE , CURRENCY_CD FROM PS_DRAFT_CONTROL WHERE DRAFT_STATUS IN ('I','A','P','N') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 2 | 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. |
| 3 | 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. |
| 4 | 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. |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | DRAFT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a draft payment. This field is maintained by the Draft Creation process. |
| 7 | DRAFT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft. |
| 8 | DRAFT_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a draft payment in the business unit's base currency. This field is maintained by the Draft Creation process. |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |