ORDHDR_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for ORD_HEADER Date Init. Issue # Description 102902 JJM 8.80 Converted to use ORD_HEADER_SBR 111506 dms 1576506002 Use ORD_LOCK_SBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 3 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Prompt Table: ORD_AN_VW |
| 4 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: CUST_SLD_VW |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_SLDBLL_VW |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 7 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: CUST_ADDRBLL_VW |
| 8 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL |
Primary Address - Ship To
Prompt Table: CUST_ADDRSHP_VW |
| 9 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL |
Primary Address - Sold To
Prompt Table: CUST_ADDRSLD_VW |
| 10 | ADDR_OVRD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line H=Header L=Line S=Schedule |
| 11 | ADDR_OVRDSD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Sold-to Override Level
Default Value: N |
| 12 | ADDTL_ADJUST_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment % |
| 13 | ADDTL_ADJUST_AMT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Adjustment Amount |
| 14 | ADDTL_ADJUST_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Adjustment Amount (base) |
| 15 | ADDTL_ADJ_BILLED | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Amount Billed
Default Value: N |
| 16 | AERP | Character(50) | VARCHAR2(50) NOT NULL | Automated Exporter Rptg Prgm |
| 17 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 18 | BCKORDR_CNCL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No Y=Cancel Backorder Yes |
| 19 | BILL_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Indicates a sales order is to be billed only, and not fulfilled through Inventory.
Y/N Table Edit Default Value: N |
| 20 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 21 | BROKER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Broker ID
Prompt Table: CUST_SLDBKR_VW |
| 22 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 23 | PRICE_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL | Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL |
| 24 | CANCEL_DATE | Date(10) | DATE | Cancel Date |
| 25 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
| 26 | CARRIER_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL |
Export Carrier ID
Prompt Table: CARRIER_ID |
| 27 | CC_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 28 | CC_ADDR_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Credit card address source
B=Bill To Address C=Credit Card Override H=Ship To Address O=Ship To Address Override |
| 29 | CCARD_APPROVAL_CD | Character(10) | VARCHAR2(10) NOT NULL | Approval Code |
| 30 | CCI_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Canadian Customs Invoice
N=No Y=Yes |
| 31 | CNTCT_SEQ_BILL | Number(5,0) | INTEGER NOT NULL |
Contact Sequence - Bill To
Prompt Table: OME_CNCT_BL_VW |
| 32 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: OME_CNCT_SL_VW |
| 33 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL |
Primary Contact - Ship To
Prompt Table: OME_CNCT_SH_VW |
| 34 | COMMSN_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Commissions Level
0=No Commissions 1=By Header 2=By Schedule |
| 35 | COMMSN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Commission Method
C=Commission Percent P=Pro-Rata Percent Default Value: C |
| 36 | CONFIRM_PO_RECVD | Character(1) | VARCHAR2(1) NOT NULL |
Confirming PO Received
N=No Y=Yes Default Value: N |
| 37 | COO_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Certificate of Origin
N=No Y=Yes |
| 38 | COUNTRY_LOC_BUYER | Character(3) | VARCHAR2(3) NOT NULL | Buyer's Location Country - May be either the VAT Entity or the Trading Partner |
| 39 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
| 40 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 41 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 42 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
| 43 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
| 44 | COUNTRY_VAT_PERFRM | Character(3) | VARCHAR2(3) NOT NULL | Country Where Service Physically Performed |
| 45 | COUNTRY_VAT_SUPPLY | Character(3) | VARCHAR2(3) NOT NULL | VAT Place of Supply Country |
| 46 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 47 | CNTRCT_PROTECTED | Character(1) | VARCHAR2(1) NOT NULL |
Contract Protected
Default Value: N |
| 48 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 49 | CR_CARD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
"See OM
01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute Prompt Table: ORDENT_CCTYP_VW |
| 50 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Processor Name |
| 51 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 52 | CR_CARD_AMT_BASE | Number(27,3) | DECIMAL(26,3) NOT NULL | Credit Card Base Amount |
| 53 | CR_CARD_AUTH_DT | Date(10) | DATE | Credit Card Authorization Date |
| 54 | CR_CARD_AUTH_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Auth Status
A=Authorized B=Billed C=Credited D=Denied E=Validation Errors F=Auth Reversal G=Validated H=Auth Reversal Denied J=Reauthorize K=No Action L=Credit Card Not In Group M=Manually Approved/Settled N=Change to Terms P=Authorized and Billed R=Processing T=Cancel Order U=Unprocessed/Retry V=Pending Approval W=Deleted after Settlement X=Deleted Y=Cancelled Z=Zero Payment for Maintenance Default Value: U |
| 55 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 56 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 57 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 58 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020 |
| 59 | CR_CARD_CVNUM | Character(44) | VARCHAR2(44) NOT NULL | Card Verification Number |
| 60 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 61 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 62 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 63 | CUST_CHANNEL | Character(15) | VARCHAR2(15) NOT NULL | Customer Channel |
| 64 | CUST_PICKUP | Character(1) | VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 65 | CUSTOMER_COMPANY | Character(10) | VARCHAR2(10) NOT NULL | Customer Company |
| 66 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
| 67 | DEL_ORD_RESTRICTED | Character(1) | VARCHAR2(1) NOT NULL |
Deliveries restricted to order
N=Deliveries Not Restricted Y=Deliveries Restricted to Order |
| 68 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL | Direct Invoicing |
| 69 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
| 70 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 71 | EOEP_ARB_ID | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Plan |
| 72 | EXPORT | Character(1) | VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No Y=Yes Y/N Table Edit Default Value: N |
| 73 | EXPORT_LIC_REQ | Character(3) | VARCHAR2(3) NOT NULL |
Export License Required
NO=No YES=Yes |
| 74 | EXPORT_LIC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
License Type
GDST=General SPEC=Specific |
| 75 | EXPORT_LIC_APPL | Character(3) | VARCHAR2(3) NOT NULL |
Applied For
NO=No YES=Yes |
| 76 | EXPORT_APPL_DT | Date(10) | DATE | Application Date |
| 77 | EXPORT_LIC_REC | Character(3) | VARCHAR2(3) NOT NULL |
License Received
NO=No YES=Yes |
| 78 | EXPORT_REC_DT | Date(10) | DATE | Date Received |
| 79 | EXPORT_LIC_NBR | Character(18) | VARCHAR2(18) NOT NULL | Export License Nbr |
| 80 | EXPORT_LIC_EXPIRE | Date(10) | DATE | Expiration Date |
| 81 | EXPORT_LIC_VALUE | Number(10,2) | DECIMAL(9,2) NOT NULL | License Value |
| 82 | EXPORT_LIC_QTY | Number(6,0) | INTEGER NOT NULL | License Quantity |
| 83 | 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 |
| 84 | FREIGHT_BILL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Order Entry SH=Shipping |
| 85 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 86 | FREIGHT_CHARGE_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 87 | FREIGHT_TAX_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount |
| 88 | FREIGHT_TAX_BASE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount Base |
| 89 | FREIGHT_TAX_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Freight Tax Percent |
| 90 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 91 | FREIGHT_TERMS_EXP | Character(10) | VARCHAR2(10) NOT NULL |
Export Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 92 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
| 93 | IMPORT_LIC_REQ | Character(3) | VARCHAR2(3) NOT NULL |
Import License Required
NO=No YES=Yes |
| 94 | IMPORT_LIC_APPL | Character(3) | VARCHAR2(3) NOT NULL |
Applied For
NO=No YES=Yes |
| 95 | IMPORT_APPL_DT | Date(10) | DATE | Application Date |
| 96 | IMPORT_LIC_REC | Character(3) | VARCHAR2(3) NOT NULL |
License Received
NO=No YES=Yes |
| 97 | IMPORT_REC_DT | Date(10) | DATE | Date Received |
| 98 | IMPORT_CERT_NBR | Character(18) | VARCHAR2(18) NOT NULL | Import License Nbr |
| 99 | IMPORT_LIC_EXP | Date(10) | DATE | Expiration Date |
| 100 | INITIATED_BY | Character(15) | VARCHAR2(15) NOT NULL | Ordered by |
| 101 | LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table: OMLC_HDR1_VW |
| 102 | LOAD_PRICE_RULE | Character(10) | VARCHAR2(10) NOT NULL | Load Arbitration Plan |
| 103 | NAFTA_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
North American Free Trade Agmt
N=No Y=Yes |
| 104 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 105 | OPRID_OWNER | Character(30) | VARCHAR2(30) NOT NULL |
Operator id of the owner of a document
Prompt Table: OPRID_VW |
| 106 | ORDER_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Order Category
0=Normal Sales Transactions 1=Counter Sale Default Value: 0 |
| 107 | ORDER_DATE | Date(10) | DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Default Value: %date |
| 108 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL |
Order Group
Prompt Table: ORD_GROUP |
| 109 | ORDER_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Order Status
C=Closed O=Open P=Pending X=Canceled Default Value: O |
| 110 | ORDER_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote SO=Sales Order |
| 111 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 112 | PHONE | Character(24) | VARCHAR2(24) NOT NULL |
Telephone
Prompt Table: CNTCT_CRCD_PHVW |
| 113 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 114 | PRC_ORDER_DATE | Date(10) | DATE | Pricing Order Date |
| 115 | PREF_CARRIER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Carrier flag
N=No Preferred Carrier Y=Preferred Carrier |
| 116 | PROD_ID_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Product Source
C=Customer P=UPC S=System U=Universal Default Value: S |
| 117 | PROD_SUBSTITUTE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Product Substitutions
N=No Y=Yes Default Value: Y |
| 118 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 119 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: ORDENT_ARTRM_VW |
| 120 | QUOTE_DUE_DATE | Date(10) | DATE | Quote Due Date |
| 121 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expiration Date |
| 122 | QUOTE_NBR | Character(15) | VARCHAR2(15) NOT NULL |
Quotation Number
Prompt Table: QUOTE_HEADER_VW |
| 123 | QUOTE_REQUESTOR | Character(15) | VARCHAR2(15) NOT NULL | Quote Requester |
| 124 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 125 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 126 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 127 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 128 | REF_ORDER_NBR | Character(15) | VARCHAR2(15) NOT NULL | Reference Order Number |
| 129 | REQ_ARRIVAL_DTTM | DateTime(26) | TIMESTAMP | Requested Arrival |
| 130 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 131 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 132 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 133 | REVISION_NUMBER | Number(3,0) | SMALLINT NOT NULL | Revision |
| 134 | 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.
Prompt Table: RT_TYPE_TBL |
| 135 | SED_REQ_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Shippers Export Declaration
N=No Y=Yes |
| 136 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 137 | SHIP_PARTIAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Schedules
N=Ship Partial No Y=Ship Partial Yes |
| 138 | SHIP_PARTIAL_ORD | Character(1) | VARCHAR2(1) NOT NULL |
Partial Order
N=Partial Order No Y=Partial Order Yes |
| 139 | SHIP_PRIOR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Ship Prior to Request Date
N=Ship Prior No Y=Ship Prior Yes |
| 140 | SHIP_PRIORITY_ID | Character(6) | VARCHAR2(6) NOT NULL |
Shipping Priority Code
Prompt Table: SHIP_PRIORITY |
| 141 | SHIP_PRIORITY_EXP | Character(6) | VARCHAR2(6) NOT NULL |
Export Shipping Priority
Prompt Table: SHIP_PRIORITY |
| 142 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUST_SLDSHP_VW |
| 143 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 144 | SHIP_TYPE_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL |
Export Shipping Method
Prompt Table: SHIP_METHOD |
| 145 | SINGLE_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No Y=Yes Default Value: N |
| 146 | STATE_LOC_BUYER | Character(6) | VARCHAR2(6) NOT NULL | Buyer's Location State - May be either the VAT Entity or the Trading Partner |
| 147 | STATE_LOC_SELLER | Character(6) | VARCHAR2(6) NOT NULL | Seller's Location State - May be either the VAT Entity or the Trading Partner |
| 148 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 149 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 150 | STATE_VAT_DEFAULT | Character(6) | VARCHAR2(6) NOT NULL | VAT Defaulting State |
| 151 | STATE_VAT_PERFRM | Character(6) | VARCHAR2(6) NOT NULL | State Where Service Physically Performed |
| 152 | STD_DISCOUNT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Standard Discount |
| 153 | STORE_NUMBER | Character(17) | VARCHAR2(17) NOT NULL | Store Number |
| 154 | SUBCUST_QUAL1 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 155 | SUBCUST_QUAL2 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 156 | SUCCESS_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Success Percent |
| 157 | SUPPORT_TEAM_CD | Character(6) | VARCHAR2(6) NOT NULL | Support Team Code |
| 158 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_HDR_TBL_VW |
| 159 | TAX_EXEMPT_CERT | Character(30) | VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table: CUST_SHEXMPT_VW |
| 160 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit Default Value: N |
| 161 | VAT_CALC_GROSS_NET | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross N=Calculate at Net |
| 162 | VAT_DCLRTN_POINT | Character(1) | VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time |
| 163 | VAT_DFLT_DONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting X=Do not default Y=Defaulting Done Default Value: N |
| 164 | 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. |
| 165 | VAT_EXCPTN_CERTIF | Character(20) | VARCHAR2(20) NOT NULL | Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT. |
| 166 | VAT_EXCPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None S=Suspended X=Exonerated |
| 167 | VAT_RECALC_FLG | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross. |
| 168 | VAT_RGSTRN_BUYER | Character(20) | VARCHAR2(20) NOT NULL | Specifies a customers VAT Registration ID for a particular country. |
| 169 | VAT_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down N=Natural Round U=Round Up |
| 170 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
| 171 | VAT_TREATMENT_GRP | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment Group |
| 172 | VAT_SERVICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport 2=Other 3=Electronics/Communication |
| 173 | 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 |
| 174 | VMI_DESTIN_SHIPTO | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: SP_BUVM_NONVW |
| 175 | CUSTOM_C10_A | Character(10) | VARCHAR2(10) NOT NULL | Custom Char 10A |
| 176 | CUSTOM_C10_B | Character(10) | VARCHAR2(10) NOT NULL | Custom Char 10B |
| 177 | CUSTOM_C20_A | Character(20) | VARCHAR2(20) NOT NULL | Custom Char 20A |
| 178 | CUSTOM_C20_B | Character(20) | VARCHAR2(20) NOT NULL | Custom Char 20B |
| 179 | CUSTOM_C30_A | Character(30) | VARCHAR2(30) NOT NULL | Custom Char 30A |
| 180 | CUSTOM_C30_B | Character(30) | VARCHAR2(30) NOT NULL | Custom Char 30B |
| 181 | CUSTOM_C40_A | Character(40) | VARCHAR2(40) NOT NULL | Custom Char 40A |
| 182 | CUSTOM_C40_B | Character(40) | VARCHAR2(40) NOT NULL | Custom Char 40B |
| 183 | CUSTOM_C80_A | Character(80) | VARCHAR2(80) NOT NULL | Custom Char 80A |
| 184 | CUSTOM_C80_B | Character(80) | VARCHAR2(80) NOT NULL | Custom Char 80B |
| 185 | CUSTOM_DTTM_A | DateTime(26) | TIMESTAMP | Custom DateTime A |
| 186 | CUSTOM_DTTM_B | DateTime(26) | TIMESTAMP | Custom DateTime B |
| 187 | CUSTOM_DTTM_C | DateTime(26) | TIMESTAMP | Custom DateTime C |
| 188 | CUSTOM_DTTM_D | DateTime(26) | TIMESTAMP | Custom DateTime D |
| 189 | CUSTOM_DTTM_E | DateTime(26) | TIMESTAMP | Custom DateTime E |
| 190 | CUSTOM_DTTM_F | DateTime(26) | TIMESTAMP | Custom DateTime F |
| 191 | CUSTOM_DTTM_G | DateTime(26) | TIMESTAMP | Custom DateTime G |
| 192 | CUSTOM_DTTM_H | DateTime(26) | TIMESTAMP | Custom DateTime H |
| 193 | CUSTOM_DTTM_I | DateTime(26) | TIMESTAMP | Custom DateTime I |
| 194 | CUSTOM_DTTM_J | DateTime(26) | TIMESTAMP | Custom DateTime J |
| 195 | CUSTOM_DTTM_K | DateTime(26) | TIMESTAMP | Custom DateTime K |
| 196 | CUSTOM_DTTM_L | DateTime(26) | TIMESTAMP | Custom DateTime L |
| 197 | CUSTOM_DTTM_M | DateTime(26) | TIMESTAMP | Custom DateTime M |
| 198 | CUSTOM_DTTM_N | DateTime(26) | TIMESTAMP | Custom DateTime N |
| 199 | CUSTOM_DTTM_O | DateTime(26) | TIMESTAMP | Custom DateTime O |
| 200 | CUSTOM_DTTM_P | DateTime(26) | TIMESTAMP | Custom DateTime P |
| 201 | CUSTOM_DTTM_Q | DateTime(26) | TIMESTAMP | Custom DateTime Q |
| 202 | CUSTOM_DTTM_R | DateTime(26) | TIMESTAMP | Custom DateTime R |
| 203 | CUSTOM_DTTM_S | DateTime(26) | TIMESTAMP | Custom DateTime S |
| 204 | CUSTOM_DTTM_T | DateTime(26) | TIMESTAMP | Custom DateTime T |
| 205 | CUSTOM_N12_A | Number(12,0) | DECIMAL(12) NOT NULL | Custom Number 12 A |
| 206 | CUSTOM_N12_B | Number(12,0) | DECIMAL(12) NOT NULL | Custom Number 12 B |
| 207 | CUSTOM_N12_C | Number(12,0) | DECIMAL(12) NOT NULL | Custom Number 12 C |
| 208 | CUSTOM_N12_D | Number(12,0) | DECIMAL(12) NOT NULL | Custom Number 12 D |
| 209 | CUSTOM_N12_E | Number(12,0) | DECIMAL(12) NOT NULL | Custom Number 12 E |
| 210 | CUSTOM_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | Custom Number 15 A |
| 211 | CUSTOM_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | Custom Number 15 B |
| 212 | CUSTOM_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | Custom Number 15 C |
| 213 | CUSTOM_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | Custom Number 15 D |
| 214 | CUSTOM_N15_E | Number(15,0) | DECIMAL(15) NOT NULL | Custom Number 15 E |
| 215 | LAST_EXP_CHK_DTTM | DateTime(26) | TIMESTAMP | Last Date/Time Export Comp Chk |
| 216 | BACKGROUND_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Background Process Required
E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes Default Value: N |
| 217 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Default Value: N |
| 218 | HOLD_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Hold Processing Required
Default Value: N |
| 219 | CREDIT_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Credit Check Required
Default Value: N |
| 220 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 221 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 222 | LAST_DTTM_ORD_UPD | DateTime(26) | TIMESTAMP | Last Order Change Date |
| 223 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 224 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
Default Value: 0 |
| 225 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 226 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 227 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |