PROCESS_INSTANCECOUNTRYREGISTRATION_TYPESTD_ID_NUM1=None
2=Unbalanced
3=CF Combo Error
4=No Exchange Rate
5=Acct Not Specified
6=IU Processor Error
7=Document Sequencing Error
VAT_REG_ID_TMP(SQL Table) |
Index Back |
|---|---|
Validate VAT Reg ID temp table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | REGISTRATION_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Registration Type |
| 4 | STD_ID_NUM |
Character(35) | VARCHAR2(35) NOT NULL | ID Number |
| 5 | ERROR_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Error Status
1=None 2=Unbalanced 3=CF Combo Error 4=No Exchange Rate 5=Acct Not Specified 6=IU Processor Error 7=Document Sequencing Error |