ORD_LN_PROMO_VW

(SQL View)
 Index Back

Order Line Promotional view


SELECT business_unit , order_no , order_int_line_no , product_id , prod_id_src , prod_id_entered , address_seq_num , addr_ovrd_level , aerp , allow_overpick_flg , bckordr_cncl_flag , csd_benefit_id , price_program , cancel_date , carrier_id , carrier_id_exp , cci_req_exp , cntrct_id , cntrct_line_nbr , cntrct_sched_nbr , config_code , coo_req_exp , country_loc_buyer , country_loc_seller , country_ship_from , country_ship_to , country_vat_billfr , country_vat_billto , cp_template_id , currency_cd , currency_cd_base , customer_item_nbr , customer_po , customer_po_line , cust_po_price , cust_po_prc_base , cust_net_price , cust_net_prc_base , cust_bill_back_all , cust_bback_all_bse , cust_off_inv_disc , cust_off_inv_base , drop_ship_flag , export , export_lic_req , export_lic_type , export_lic_appl , export_appl_dt , export_lic_rec , export_rec_dt , export_lic_nbr , export_lic_expire , export_lic_value , export_lic_qty , freight_terms , freight_terms_exp , import_lic_req , import_lic_appl , import_appl_dt , import_lic_rec , import_rec_dt , import_cert_nbr , import_lic_exp , ist_txn_flg , ord_line_status , list_price , list_price_base , list_price_orig , list_priceorig_bse , load_id , max_pick_tolerance , nafta_req_exp , ord_line_tag , order_grp , payment_method , physical_nature , pymnt_terms_cd , price , price_base , price_orig , price_orig_base , price_protected , product_id_orig , qty_ordered , qty_ordered_orig , replacement_flg , req_arrival_dttm , req_ship_dttm , sched_arrv_dttm , sched_ship_dttm , sed_req_exp , ship_from_bu , ship_partial_flag , ship_prior_flag , ship_priority_id , ship_priority_exp , ship_to_cust_id , ship_type_id , ship_type_id_exp , state_loc_buyer , state_loc_seller , state_ship_from , state_ship_to , state_vat_default , state_vat_perfrm , std_discount , store_number , tax_cd , tax_cust_group , trnspt_lead_days , trnspt_lead_hours , trnspt_lead_min , unit_cost , unit_of_measure , uom_orig , vat_applicability , vat_calc_gross_net , vat_dclrtn_point , vat_dst_acct_type , vat_entity , vat_excptn_certif , vat_excptn_type , vat_recalc_flg , vat_rgstrn_buyer , vat_round_rule , vat_treatment , vat_treatment_grp , vat_txn_type_cd , vat_service_type , vat_svc_supply_flg , tax_cd_vat , datetime_added , lastupddttm , last_maint_oprid , process_instance , exs_tax_txn_type FROM PS_ORD_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

2 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

Default Value: 1

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_NOTREJ_VW

5 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal

Default Value: S

6 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
9 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm
10 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
11 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

Y/N Table Edit

12 CSD_BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL India Customs Duty Benefit Identification
13 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
14 CANCEL_DATE Date(10) DATE Cancel Date
15 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
16 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
17 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
18 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
19 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
20 CNTRCT_SCHED_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Schedule
21 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
22 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
23 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
24 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
25 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
26 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
27 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
28 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
29 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
32 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
33 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
34 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
35 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price
36 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base
37 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price
38 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base
39 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance
40 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base
41 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount
42 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base
43 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

Y/N Table Edit

Default Value: N

44 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
45 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
46 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
47 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
48 EXPORT_APPL_DT Date(10) DATE Application Date
49 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
50 EXPORT_REC_DT Date(10) DATE Date Received
51 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
52 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
53 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value
54 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity
55 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
56 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
57 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
58 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
59 IMPORT_APPL_DT Date(10) DATE Application Date
60 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
61 IMPORT_REC_DT Date(10) DATE Date Received
62 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
63 IMPORT_LIC_EXP Date(10) DATE Expiration Date
64 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Default Value: N

65 ORD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled
66 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
67 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
68 LIST_PRICE_ORIG Signed Number(17,4) DECIMAL(15,4) NOT NULL Original List Price
69 LIST_PRICEORIG_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Orig List Price (base)
70 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
71 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
72 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
73 ORD_LINE_TAG Number(5,0) INTEGER NOT NULL Order Line tag line nbr
74 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
75 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
76 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
77 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.
78 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
79 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
80 PRICE_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Price
81 PRICE_ORIG_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Orig Net Unit Price (base)
82 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
83 PRODUCT_ID_ORIG Character(18) VARCHAR2(18) NOT NULL Original Product
84 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

Default Value: 1

85 QTY_ORDERED_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Quantity
86 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

Default Value: NA

87 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
88 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
89 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
90 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
91 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
92 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
93 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

Y/N Table Edit

94 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes

Y/N Table Edit

95 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
96 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
97 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
98 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
99 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
100 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
101 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner
102 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
103 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
104 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
105 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed
106 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
107 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
108 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
109 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group
110 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)
111 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)
112 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)
113 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
114 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: PROD_UOM

115 UOM_ORIG Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
116 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
117 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
118 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
119 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
120 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.
121 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.
122 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
123 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.
124 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
125 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
126 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
127 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
128 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.
129 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
130 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
131 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.
132 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
133 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.
134 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
135 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
136 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