VAT_SOURCE_DEFNSII_VAT_SRC_DEF(SQL Table) |
Index Back |
|---|---|
VAT Update Source DefinitionSource products using the VAT Transaction Loader |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_SOURCE_DEFN |
Character(10) | VARCHAR2(10) NOT NULL | Update VAT Source Definition |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SII_REC_HDR_TMP | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 4 | SII_REC_LN_TMP | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 5 | SII_REC_PAY_TMP | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 6 | SII_HDR_SQL | Character(100) | VARCHAR2(100) NOT NULL | Header SQL |
| 7 | SII_LN_SQL | Character(100) | VARCHAR2(100) NOT NULL | Header SQL |
| 8 | SII_PAY_SQL | Character(100) | VARCHAR2(100) NOT NULL | Header SQL |
| 9 | RECNAME_BU | Character(15) | VARCHAR2(15) NOT NULL | Business Unit Recname |