PROCESS_INSTANCEA=All Business Units
B=Business Unit
VAT_UPD_AP_AET(SQL Table) |
Index Back |
|---|---|
AP VAT Txn Update Cache |
| # | 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 | PROCESS_VAT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process VAT Option
A=All Business Units B=Business Unit |
| 4 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 5 | LAST_VAT_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last VAT Document ID Assigned |
| 6 | VAT_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | VAT Document ID |
| 7 | VAT_DCMNT_CNT | Number(8,0) | INTEGER NOT NULL | VAT Document Count |
| 8 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 9 | VAT_LINE_CNT | Number(5,0) | INTEGER NOT NULL | VAT Transaction Line Count |
| 10 | VAT_DCMNT_LN_MAX | Number(5,0) | INTEGER NOT NULL | VAT Document Max Ln Count |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 13 | 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". |
| 14 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 15 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 16 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 17 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 18 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 19 | CF_BAL_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |
| 20 | SYSTEM_DATE | Date(10) | DATE | System Date |
| 21 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |