PROCESS_INSTANCEO=Other
R=Requisition
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
EXS_AECALC_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 3 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 4 | EXS_CURRENCY_TRC | Character(3) | VARCHAR2(3) NOT NULL | Curreny Tax Rate |
| 5 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 6 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 7 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 8 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 9 | TAX_CALC_DT | Date(10) | DATE | Tax Calc Date |
| 10 | EXS_UOM_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 11 | EXS_TAX_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 12 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 13 | EXS_TXC_LN_STATUS | Character(2) | VARCHAR2(2) NOT NULL | |
| 14 | EXS_TXC_DTL_STATUS | Character(2) | VARCHAR2(2) NOT NULL | |
| 15 | EXS_TXN_LINE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Line Amount |
| 16 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 17 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 18 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 19 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 20 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 21 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 22 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 23 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 24 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 25 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 26 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 27 | PO_STG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other R=Requisition |
| 28 | PO_STG_ID | Character(10) | VARCHAR2(10) NOT NULL | Uniqye key to the PO Staging table |
| 29 | EXS_TAX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Type
C=Custom Duty E=Excise Duty G=Goods and Services Tax S=Sales Tax / VAT |
| 30 | EXS_TAX_RATE_SEQ | Number(3,0) | SMALLINT NOT NULL | Tax Rate Sequence |
| 31 | EXS_CALC_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Base Flag |
| 32 | EXS_CALC_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Freight Flag |
| 33 | EXS_CALC_MISC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Miscellaneous Flag |
| 34 | EXD_USE_AV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Use Av Flag |
| 35 | EXS_TAX_DEP_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Dependency Code |
| 36 | EXS_TAX_CMPNT_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Component Code |
| 37 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 38 | SETID2 | Character(5) | VARCHAR2(5) NOT NULL | 2nd SetId |
| 39 | EXS_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 40 | EXS_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Basis Amount |
| 41 | EXS_LINE_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Line Amount in Tax Locn |
| 42 | EXD_LINE_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Excise Line Amount in Tax Locn |
| 43 | STX_LINE_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | SalesTx Line Amount in Tax Loc |
| 44 | CSD_LINE_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | CstDuty Line Amount in Tax Loc |
| 45 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 46 | MISC_CHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc Charge Amount |
| 47 | EXS_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount |
| 48 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 49 | RECNAME_TXWORK1 | Character(15) | VARCHAR2(15) NOT NULL | RECNAME_TXWORK1 |
| 50 | SELECT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Select Count |