VCHR_UNPOST_AET(SQL Table) |
Index Back |
|---|---|
Voucher UnPost AE State Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | VCHR_MNT_PROC_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Processing Source
1=Single Voucher 2=Mass Maintenance |
| 4 | SELECT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Select Count |
| 5 | ERROR_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Error Count |
| 6 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 10 | ACCOUNTING_DT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Date Indicator
C=Use Current Date D=Business Unit Default P=Use Payment Date S=Use Specific Date |
| 11 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 12 | ACCOUNTING_DT_RVRL | Date(10) | DATE | Reversal Accounting Date |
| 13 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 14 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 15 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 16 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 17 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |
| 18 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 19 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 20 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 21 | COMMITMENT_CNTL_AP | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on AP |
| 22 | TEMP_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Temporary Query Value |