BU_AP_GL_OPT(SQL Table) |
Index Back |
|---|---|
GL AP Business Unit Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | DOC_TYPE_ACCR | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Accrual
Prompt Table: DOC_TYPE_TBL |
| 3 | DOC_TYPE_VOID | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Cancel
Prompt Table: DOC_TYPE_TBL |
| 4 | DOC_TYPE_CLOSE | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Close
Prompt Table: DOC_TYPE_TBL |
| 5 | DOC_TYPE_PREPAY | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Prepayments
Prompt Table: DOC_TYPE_TBL |
| 6 | DOC_TYPE_REVAL | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Revaluation
Prompt Table: DOC_TYPE_TBL |
| 7 | DOC_TYPE_UNPOST | Character(8) | VARCHAR2(8) NOT NULL |
Document Type for Unposted Journals
Prompt Table: DOC_TYPE_TBL |
| 8 | DOC_TYPE_CSHCL | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Cash Clearing
Prompt Table: DOC_TYPE_TBL |
| 9 | DOC_TYPE_DRAFT | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Drafts
Prompt Table: DOC_TYPE_TBL |
| 10 | DOC_TYPE_DFT_WO | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Draft Write Off
Prompt Table: DOC_TYPE_TBL |
| 11 | DOC_TYPE_VCHR_IU | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Interunit Vchr
Prompt Table: DOC_TYPE_TBL |
| 12 | DOC_TYPE_PYMNT_IU | Character(8) | VARCHAR2(8) NOT NULL |
Document Type Interunit Pymt
Prompt Table: DOC_TYPE_TBL |