BUSINESS_UNITLINE_NBRDefault Value: 1
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
AUC_AWD_REQ_VW2(SQL View) |
Index Back |
|---|
| SELECT c.business_unit , c.auc_id , c.auc_round , c.auc_version , c.line_nbr , b.business_unit , b.req_id , b.line_nbr , b.distrib_ln_status , SUM(b.qty_open) FROM PS_REQ_LN_DISTRIB b , ps_auc_copy_xref c WHERE b.business_unit = c.auc_source_busetid AND b.req_id = c.auc_source_id AND b.line_nbr = c.auc_source_line AND b.sched_nbr = c.auc_source_sched AND b.distrib_line_num = c.auc_source_distrib GROUP BY b.business_unit , b.req_id , b.line_nbr , c.business_unit , c.auc_id , c.auc_round , c.auc_version , c.line_nbr, b.distrib_ln_status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 6 | AUC_SOURCE_BUSETID | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Setid |
| 7 | AUC_SOURCE_ID | Character(25) | VARCHAR2(25) NOT NULL | Source ID |
| 8 | AUC_SOURCE_LINE | Number(5,0) | INTEGER NOT NULL | Source Line Number |
| 9 | DISTRIB_LN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Line Status
C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled |
| 10 | QTY_OPEN | Number(16,4) | DECIMAL(15,4) NOT NULL | Open Quantity |