BU_AP_GL_OPT(SQL Table) |
Index Back |
---|---|
GL AP Business Unit Options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | 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 |