BUSINESS_UNITDELIVERY_IDDEMAND_SOURCEIN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
SOURCE_BUS_UNITORDER_NOTAX_AUTHORITY_CDSEQ_NBR_5ORD_ESTTXDT_VW(SQL View) |
Index Back |
|---|---|
Estimate Shippment Tax DetailEstimate Shippment Tax Detail |
| SELECT E.SHIP_FROM_BU , E.DELIVERY_ID , 'OM' , E.BUSINESS_UNIT , E.ORDER_NO , E.TAX_AUTHORITY_CD , E.SEQ_NBR_5 , E.CURRENCY_CD , E.CURRENCY_CD_BASE , %subrec(ORD_ESTTXDT_SBR, E) FROM PS_ORD_EST_TAX_DTL E |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 3 | DEMAND_SOURCE |
Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 4 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 5 | 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 |
| 6 | TAX_AUTHORITY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |
| 7 | SEQ_NBR_5 |
Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 10 | MAX_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL | max_tax_flg = 'Y' implies that max taxes were applied |
| 11 | TAX_JUR_NAME | Character(60) | VARCHAR2(60) NOT NULL | Tax Jurisdiction Name |
| 12 | TAX_EXEMPT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Exempt Amount |
| 13 | NON_TAXABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Non Taxable Amount |
| 14 | TAX_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amount |
| 15 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 16 | TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount (base) |
| 17 | TAX_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Tax Percent |
| 18 | BI_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billing Tax Amount |
| 19 | BI_CURRENCY_BSE | Character(3) | VARCHAR2(3) NOT NULL | BI Base Currency |