LINE_NBRSCHED_NBRDefault Value: 1
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
Default Value: A
C=Changed
U=Unchanged
Default Value: U
A=Amount
Q=Quantity
Default Value: Q
Default Value: SHIPTO_TBL.BUSINESS_UNIT_IN
SAC_SS_SHIP_OUT(SQL View) |
Index Back |
|---|---|
PO SHIP ViewPO SHIP View |
| SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.LINE_NBR ,A.SCHED_NBR ,A.CANCEL_STATUS ,A.CHANGE_STATUS ,A.CHNG_ORD_SEQ ,A.PRICE_PO ,A.DUE_DT ,A.DUE_TIME ,A.SHIPTO_SETID ,A.SHIPTO_ID ,A.QTY_PO ,A.CURRENCY_CD ,A.CURRENCY_CD_BASE ,A.CONVERSION_RATE ,A.FREIGHT_TERMS ,A.SHIP_TYPE_ID ,A.DISTRIB_MTHD_FLG ,A.BUSINESS_UNIT_OM ,A.SCHED_LINE_NBR ,A.SHIP_TO_CUST_ID ,A.BUSINESS_UNIT_IN ,A.CARRIER_ID ,A.VAT_TREATMENT_GRP ,A.VAT_TREATMENT ,A.COUNTRY_VAT_SHIPTO ,A.COUNTRY_VAT_BILLTO ,A.COUNTRY_VAT_BILLFR ,A.VAT_TXN_TYPE_CD ,A.TAX_CD_VAT ,A.SHIP_DATE ,A.SHIPTO_DESCR ,A.SHIPTO_COUNTRY ,A.SHIPTO_ADDRESS1 ,A.SHIPTO_ADDRESS2 ,A.SHIPTO_ADDRESS3 ,A.SHIPTO_CITY ,A.SHIPTO_STATE ,A.SHIPTO_POSTAL ,A.ATTN_TO ,A.SHIP_COUNTRY_CODE ,A.SHIPTO_PHONE ,A.SHIPTO_EXTENSION ,A.SHIPTO_FAX FROM PS_SAC_SS_ERP_SH_V A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL |
Schedule Number
Default Value: 1 |
| 5 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled Default Value: A |
| 6 | CHANGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Change Order Status
C=Changed U=Unchanged Default Value: U |
| 7 | CHNG_ORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Change Order Sequence Number |
| 8 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 9 | DUE_DT | Date(10) | DATE NOT NULL | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 10 | DUE_TIME | Time(15) | TIMESTAMP | Due Time |
| 11 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 12 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 13 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 16 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 17 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 18 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 19 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity Default Value: Q |
| 20 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 21 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 22 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 23 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Default Value: SHIPTO_TBL.BUSINESS_UNIT_IN |
| 24 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 25 | VAT_TREATMENT_GRP | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment Group |
| 26 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
| 27 | COUNTRY_VAT_SHIPTO | Character(3) | VARCHAR2(3) NOT NULL | Ship To VAT Rgstrn Country |
| 28 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
| 29 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
| 30 | 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. |
| 31 | 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. |
| 32 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 33 | SHIPTO_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Recepient Party Name1 |
| 34 | SHIPTO_COUNTRY | Character(30) | VARCHAR2(30) NOT NULL | Recepient Country |
| 35 | SHIPTO_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street |
| 36 | SHIPTO_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 1 |
| 37 | SHIPTO_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 2 |
| 38 | SHIPTO_CITY | Character(30) | VARCHAR2(30) NOT NULL | Recepient City |
| 39 | SHIPTO_STATE | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 40 | SHIPTO_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Recepient POSTAL |
| 41 | ATTN_TO | Character(30) | VARCHAR2(30) NOT NULL | Attention |
| 42 | SHIP_COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
| 43 | SHIPTO_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Buyer Phone |
| 44 | SHIPTO_EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 45 | SHIPTO_FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |