PROCESS_INSTANCEAB=House Boat
WW=Trailer
D=Default from Entity Definition
S=Specify at this Level
N=Don't withholding
Y=Withholdeable
I=Invoicing Supplier
R=Remit to Supplier
N=No
Y=Yes
N=No
Y=Yes
UPG_APF01_AET(SQL Table) |
Index Back |
|---|---|
AP Upgrade 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 7 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 8 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 9 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 10 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 13 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 14 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 15 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 16 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 17 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 18 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 19 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 20 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 21 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 22 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL | In City Limit |
| 23 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 24 | EFFDT | Date(10) | DATE | Effective Date |
| 25 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 26 | WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 27 | WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 28 | MINIMUM_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Minimum Amount to Report |
| 29 | WTHD_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Apply VAT |
| 30 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 31 | PRCNT_WTHHLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Withheld |
| 32 | WTHD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Withhold Rule Indicator
D=Default from Entity Definition S=Specify at this Level |
| 33 | WTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding Y=Withholdeable |
| 34 | FREIGHT_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Apply Freight |
| 35 | WTHD_SUT_APPL | Character(1) | VARCHAR2(1) NOT NULL | Apply Sales/Use Tax |
| 36 | WHTD_DSCNT_APPL | Character(1) | VARCHAR2(1) NOT NULL | Apply Discount |
| 37 | DECIMAL_POS | Number(2,0) | SMALLINT NOT NULL | Decimal Position |
| 38 | APPLY_BALANCE | Character(1) | VARCHAR2(1) NOT NULL |
Specifies whether we apply withholding on the invoicing vendor
or the remit_to vendor
I=Invoicing Supplier R=Remit to Supplier |
| 39 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 40 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 41 | TIN | Character(20) | VARCHAR2(20) NOT NULL | Taxpayer Identification Number |
| 42 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 43 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 44 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 45 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 46 | TEMP_NBR1 | Number(7,0) | INTEGER NOT NULL | Temporary Number |
| 47 | UA_ROW_COUNT1 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 48 | UA_ROW_COUNT2 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 49 | UA_ROW_COUNT3 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 50 | UA_ROW_COUNT4 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 51 | UA_ROW_COUNT5 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 52 | UA_ROW_COUNT6 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 53 | UA_ROW_COUNT7 | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 54 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 55 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
| 56 | UA_CUR_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID |
| 57 | UA_CUR_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Supplier Location |
| 58 | UA_PRV_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID |
| 59 | UA_PRV_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Supplier Location |
| 60 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 61 | UA_CUR_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 62 | UA_PRV_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 63 | UA_PRV_EFFDT | Date(10) | DATE | Effective Date |
| 64 | UA_CUR_EFFDT | Date(10) | DATE | Effective Date |
| 65 | UA_URL_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 66 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 67 | UA_VLOC_EFFDT | Date(10) | DATE | Effective Date |
| 68 | UA_VLOC_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 69 | UA_VLOC_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID |
| 70 | UA_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Supplier Location |
| 71 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 72 | VAT_TRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount in base currency against which the VAT is applicable |
| 73 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 74 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 75 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 76 | BANK_ACCT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Bank Account Sequence Number |
| 77 | DEFAULT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Default Election
N=No Y=Yes |
| 78 | WTHD_CD | Character(5) | VARCHAR2(5) NOT NULL | Withholding Code |
| 79 | LAST_PAY_SCHED_NBR | Number(7,0) | INTEGER NOT NULL | Last schedule ID number |
| 80 | DUMMY_FLD | Character(1) | VARCHAR2(1) NOT NULL | TEST DUMMY |
| 81 | NUMBER_PAGES | Number(8,0) | INTEGER NOT NULL | Number of Pages |
| 82 | ALC | Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 83 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 84 | PREV_VENDOR | Character(15) | VARCHAR2(15) NOT NULL | Previous vendor processed in 1099 Reporting AE. |
| 85 | PREV_SETID | Character(5) | VARCHAR2(5) NOT NULL | Previous Setid |
| 86 | ALC_NON_DISBRSD | Character(1) | VARCHAR2(1) NOT NULL | PMC-21 requirement for JFMIP - allow override of ALC 8 digit numeric edit |
| 87 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 88 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 89 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 90 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 91 | COUNTRY_LOC_BUYER | Character(3) | VARCHAR2(3) NOT NULL | Buyer's Location Country - May be either the VAT Entity or the Trading Partner |
| 92 | STATE_LOC_BUYER | Character(6) | VARCHAR2(6) NOT NULL | Buyer's Location State - May be either the VAT Entity or the Trading Partner |
| 93 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
| 94 | STATE_LOC_SELLER | Character(6) | VARCHAR2(6) NOT NULL | Seller's Location State - May be either the VAT Entity or the Trading Partner |
| 95 | COUNTRY_VAT_PERFRM | Character(3) | VARCHAR2(3) NOT NULL | Country Where Service Physically Performed |
| 96 | STATE_VAT_PERFRM | Character(6) | VARCHAR2(6) NOT NULL | State Where Service Physically Performed |
| 97 | LAST_BU | Character(5) | VARCHAR2(5) NOT NULL | Last Business unit tagged |
| 98 | 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". |
| 99 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 100 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 101 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 102 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 103 | 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. |
| 104 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 105 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |