AM_VATRCVR_RQST(SQL Table) |
Index Back |
|---|---|
AM VAT Recovery Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default Value: N |
| 5 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 8 | YEAR_OF_REG | Number(4,0) | SMALLINT NOT NULL | Year of Regularization |
| 9 | 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 |
| 10 | DRAFT_RCVRY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Run Mode
D=Draft F=Final Default Value: D |
| 11 | VAT_TRANS_TYPE_POS | Character(4) | VARCHAR2(4) NOT NULL |
Positive Adjustment
Prompt Table: AM_VAT_TXNCD_VW |
| 12 | VAT_TRANS_TYPE_NEG | Character(4) | VARCHAR2(4) NOT NULL |
Negative Adjustment
Prompt Table: AM_VAT_TXNCD_VW |
| 13 | AM_MIN_VAT_VAR | Number(6,2) | DECIMAL(5,2) NOT NULL | VAT Adjust Variance |
| 14 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 15 | AM_VAT_UPDT_COE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Update Final Coefficients
Y/N Table Edit |
| 16 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table: TAX_HEADER_TBL |
| 17 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table: JRNLGEN_APPL_ID |