VCHRLINE_TEO2(SQL Table) |
Index Back |
|---|---|
Voucher Line |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 3 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_FS |
| 5 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: VOUCHER |
| 6 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL |
Voucher Line Number
Default Value: 1 |
| 7 | TOTAL_DISTRIBS | Number(5,0) | INTEGER NOT NULL | Total Number of Distributions |
| 8 | MAX_DISTRIB_LINE | Number(5,0) | INTEGER NOT NULL | Highest Distribution Line |
| 9 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: SP_BUS_PM_NONVW |
| 10 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: %EDITTABLE14 |
| 11 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table: %EDITTABLE15 |
| 12 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL |
Schedule Number
Prompt Table: %EDITTABLE16 |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 15 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 16 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 17 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 18 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDITTABLE13 |
| 19 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 20 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
| 21 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 22 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 23 | FRGHT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Y/N Table Edit Default Value: Y |
| 24 | DSCNT_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Apply Discount
Y/N Table Edit Default Value: Y |
| 25 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit Default Value: N |
| 26 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 27 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: VENDOR.WTHD_SW |
| 28 | 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: VAT_HEADER_VW |
| 29 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 30 | FINAL_REF_IND | Character(1) | VARCHAR2(1) NOT NULL |
Final Reference Indicator
Y/N Table Edit Default Value: N |
| 31 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table: SP_BUS_PM_NONVW |
| 32 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table: %EDITTABLE12 |
| 33 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL |
Receipt Line
Prompt Table: %EDITTABLE8 |
| 34 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL |
Receiver Shipping Sequence
Prompt Table: %EDITTABLE9 |
| 35 | MATCH_LINE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS F=Full Match N=Don't Match Default Value: N |
| 36 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity Default Value: A |
| 37 | VCHR_AMT_FORCE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Force Unit Price
Y/N Table Edit Default Value: N |
| 38 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes Y/N Table Edit Default Value: N |
| 39 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 40 | 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. " |
| 41 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 42 | 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.
Prompt Table: VAT_TXN_CD |
| 43 | ECTRANSID | Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 44 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 45 | ECTRANSINOUTSW | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 46 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 47 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table: SHIPTO_TBL |
| 48 | TAX_CD_SUT | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
Prompt Table: TAX_SALE_VW |
| 49 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
| 50 | SUT_EXCPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay E=Exempt/Exonerated N=None |
| 51 | SUT_EXCPTN_CERTIF | Character(20) | VARCHAR2(20) NOT NULL | Sales/Use Tax Exception Certif |
| 52 | SUT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated Default Value: E |
| 53 | WTHD_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Setid for the Withholding Code
Prompt Table: SP_SETID_NONVW |
| 54 | WTHD_CD | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Code
Prompt Table: WTHD_CD_HDR |
| 55 | NATURE_OF_TXN1 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 1 |
| 56 | NATURE_OF_TXN2 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 2 |
| 57 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 58 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL |
VAT Use Type
Prompt Table: VAT_USE_TBL |
| 59 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 60 | BUSINESS_UNIT_RTV | Character(5) | VARCHAR2(5) NOT NULL | RTV Business Unit |
| 61 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 62 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 63 | FISCAL_REGIME | Character(6) | VARCHAR2(6) NOT NULL |
Fiscal Regime
Prompt Table: IST_FRGM_AP_VW |
| 64 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 65 | MATCH_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Match Line Status
E=Match Error M=Matched N=Not Matched |
| 66 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 67 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 68 | RELEASE_NBR | Number(5,0) | INTEGER NOT NULL | Release Number |
| 69 | BUS_UNIT_RELATED | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 70 | VOUCHER_ID_RELATED | Character(8) | VARCHAR2(8) NOT NULL | Related Voucher |
| 71 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 72 | SPEEDCHART_KEY | Character(10) | VARCHAR2(10) NOT NULL | SpeedChart Key |
| 73 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 74 | INSPECT_DT | Date(10) | DATE | Inspection Date |
| 75 | VAT_LN_ENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Line Entered Amount |
| 76 | VAT_LN_ENT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Line Entered Amt Base Curr |
| 77 | VAT_MBASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Basis Amount |
| 78 | VAT_MBASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Basis Amt Base Curr |
| 79 | USER_VCHR_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | User Character Field |
| 80 | USER_VCHR_CHAR2 | Character(1) | VARCHAR2(1) NOT NULL | User Character Field 2 |
| 81 | USER_VCHR_DEC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amount Field |
| 82 | USER_VCHR_DATE | Date(10) | DATE | User Date |
| 83 | USER_VCHR_NUM1 | Number(3,0) | SMALLINT NOT NULL | User Number field |
| 84 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 85 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 86 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 87 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 88 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 89 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 90 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 91 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 92 | USER_SCHED_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 93 | CUSTOM_C100_C1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 94 | CUSTOM_C100_C2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 95 | CUSTOM_C100_C3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 96 | CUSTOM_DATE_C1 | Date(10) | DATE | Custom Date 1 |
| 97 | CUSTOM_DATE_C2 | Date(10) | DATE | Custom Date 2 |
| 98 | CUSTOM_C1_C | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 99 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending Default Value: P |
| 100 | TAX_DSCNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Discount
Y/N Table Edit Default Value: N |
| 101 | TAX_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit Default Value: N |
| 102 | TAX_MISC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Misc Charges
Y/N Table Edit Default Value: N |
| 103 | TAX_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include VAT
N=No Y=Yes Y/N Table Edit Default Value: N |
| 104 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 105 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 106 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 107 | EXS_TAX_TXN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond DEWB=Direct Export Without Bond DIMP=Direct Import DOM=Domestic LEB=Local Export With Bond LEWB=Local Export Without Bond LIMP=Local Import |
| 108 | EXS_SERV_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax Y=Service Tax |
| 109 | EXD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
Y/N Table Edit Default Value: N |
| 110 | EXD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Excise Tax Calculation Code
Prompt Table: EXD_TAX_RATE_VW |
| 111 | EXD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Excise Cat |
| 112 | EXD_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Item Category Code |
| 113 | EXD_TAX_ITEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods F=Finished Goods R=Raw Material S=Service |
| 114 | EXD_CHAPTER_ID | Character(7) | VARCHAR2(7) NOT NULL | Excise Chapter ID |
| 115 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 116 | EXD_USE_AV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Use Av Flag |
| 117 | EXD_ASSESS_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Assessable Value |
| 118 | EXD_CONVERSION_RT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 119 | EXD_ASSESS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Amount - Transactio |
| 120 | EXD_ASSESS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Value - Base |
| 121 | EXD_ASSESS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Value - Reporting |
| 122 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
Y/N Table Edit Default Value: N |
| 123 | STX_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
Prompt Table: STX_TAX_RATE_VW |
| 124 | STX_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Tax Cat |
| 125 | STX_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Item Category Code |
| 126 | STX_TAX_AUTH_RATE | Character(8) | VARCHAR2(8) NOT NULL | Tax Authority Rate (India Sales Tax) |
| 127 | STX_TAX_AUTH_RPT | Character(8) | VARCHAR2(8) NOT NULL | Reporting Authority (India Sales Tax) |
| 128 | STX_FORM_CD | Character(8) | VARCHAR2(8) NOT NULL | Form Code |
| 129 | CSD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customs Duty applicable flag
Y/N Table Edit Default Value: N |
| 130 | CSD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Customs Tax Rate Code |
| 131 | CSD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Customs Duty Tax Category |
| 132 | CSD_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Customs Duty Item Category Code |
| 133 | CSD_BENEFIT_ID | Character(10) | VARCHAR2(10) NOT NULL | India Customs Duty Benefit Identification |
| 134 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 135 | RATE_MULT_EXS | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Excise Rt Multiplier |
| 136 | RATE_DIV_EXS | Number(16,8) | DECIMAL(15,8) NOT NULL | Excise Rt Divider |
| 137 | EXD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Tax Amount |
| 138 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 139 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 140 | EXD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amt |
| 141 | EXD_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amount - Base |
| 142 | EXD_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amount |
| 143 | EXD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 144 | EXD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 145 | EXD_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 146 | EXD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise NonRcvry Amount |
| 147 | EXD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non Recovery |
| 148 | EXD_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non-Recovery |
| 149 | STX_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 150 | STX_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN BASE CURR |
| 151 | STX_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN REPORT CURR |
| 152 | STX_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amount |
| 153 | STX_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amt in Base Curr |
| 154 | STX_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amt in Rpt Curr |
| 155 | STX_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amount |
| 156 | STX_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt in Base Curr |
| 157 | STX_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt in Rpt Curr |
| 158 | STX_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Nonrecovery |
| 159 | STX_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tx Amt NonRecovery in Bse Curr |
| 160 | STX_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax NonRecovery |
| 161 | CSD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Tax Amount |
| 162 | CSD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Amount Base |
| 163 | CSD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Amount Reporting |
| 164 | CSD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs duty and Sales Tax |
| 165 | CSD_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs Duty and Sales Tax in Base Currency |
| 166 | CSD_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs Duty and Sales Tax in Reporting Currency |
| 167 | CSD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 168 | CSD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 169 | CSD_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 170 | CSD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 171 | CSD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 172 | CSD_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 173 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 174 | TAX_CD_SUT_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Sales/Use Tax Code Percent |
| 175 | FREIGHT_SUT_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Rate |
| 176 | TITLE_PASSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Title Passage
B=Buyer's Destination-Ship To I=Intermediate Consignee S=Seller's Origination-Ship From |
| 177 | TAX_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return |
| 178 | TAX_TRANS_SUB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None |
| 179 | TAX_JOB_NUM | Character(10) | VARCHAR2(10) NOT NULL | Job Number |
| 180 | TAX_USER_AREA | Character(25) | VARCHAR2(25) NOT NULL | Used for tax calculation by tax vendor. |
| 181 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 182 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 183 | FREIGHT_SUT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SUT Amount on Freight |
| 184 | FRGT_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight SUT Basis Amount |
| 185 | MISC_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc Charge SUT Basis Amount |
| 186 | DSCN_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount SUT Basis Amount |
| 187 | SUT_PRODUCT_CD | Character(18) | VARCHAR2(18) NOT NULL | Product Alias |
| 188 | SUT_FREIGHT_CD | Character(18) | VARCHAR2(18) NOT NULL | Product Alias |
| 189 | SUT_CALC_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SUT Calculation Basis Amount |
| 190 | SALETX_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Calculated Sales Tax Amount |
| 191 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 192 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 193 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 194 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
| 195 | VAT_RCRD_INPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
Y/N Table Edit |
| 196 | VAT_RCRD_OUTPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
Y/N Table Edit |
| 197 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 198 | COUNTRY_LOC_BUYER | Character(3) | VARCHAR2(3) NOT NULL | Buyer's Location Country - May be either the VAT Entity or the Trading Partner |
| 199 | STATE_LOC_BUYER | Character(6) | VARCHAR2(6) NOT NULL | Buyer's Location State - May be either the VAT Entity or the Trading Partner |
| 200 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
| 201 | STATE_LOC_SELLER | Character(6) | VARCHAR2(6) NOT NULL | Seller's Location State - May be either the VAT Entity or the Trading Partner |
| 202 | VAT_SVC_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries 2=Buyer's Countries 3=Where Physically Performed |
| 203 | VAT_SERVICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport 2=Other 3=Electronics/Communication |
| 204 | COUNTRY_VAT_PERFRM | Character(3) | VARCHAR2(3) NOT NULL | Country Where Service Physically Performed |
| 205 | STATE_VAT_PERFRM | Character(6) | VARCHAR2(6) NOT NULL | State Where Service Physically Performed |
| 206 | COUNTRY_VAT_SUPPLY | Character(3) | VARCHAR2(3) NOT NULL | VAT Place of Supply Country |
| 207 | STATE_VAT_SUPPLY | Character(6) | VARCHAR2(6) NOT NULL | VAT Place of Supply State |
| 208 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 209 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 210 | STATE_VAT_DEFAULT | Character(6) | VARCHAR2(6) NOT NULL | VAT Defaulting State |
| 211 | VAT_DFLT_DONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting X=Do not default Y=Defaulting Done Y/N Table Edit Default Value: N |
| 212 | FORM_DISTRIB_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed I=Ignore N=Not Distributed U=Undefined Default Value: N |
| 213 | VAT_RECEIPT | Character(1) | VARCHAR2(1) NOT NULL |
No VAT Receipt
Y/N Table Edit Default Value: Y |
| 214 | VAT_RGSTRN_SELLER | Character(20) | VARCHAR2(20) NOT NULL | Seller's VAT Registration |
| 215 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 216 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 217 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes |
| 218 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 219 | VAT_RVRSE_CHG_GDS | Character(1) | VARCHAR2(1) NOT NULL | VAT Reverse Charge goods flag |
| 220 | PACKSLIP_NO | Character(22) | VARCHAR2(22) NOT NULL | Packing Slip Number |
| 221 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 222 | BI_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Billing Invoice number |
| 223 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |