CNTRCT_RFQ_XREF(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
3 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
4 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
5 | PRCR_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Document Type
CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order |
6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
7 | DOC_ID | Character(50) | VARCHAR2(50) NOT NULL | ID |
8 | DOC_LINE | Number(5,0) | INTEGER NOT NULL | Document Line Number |
9 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
10 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
11 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
12 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
13 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
14 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
15 | REQ_DISTRIB_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
16 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
17 | LIQUIDATE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Liquidate by
A=Amount Q=Quantity Default Value: A |
18 | DISTRIB_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Distribution Percentage |
19 | QTY_REQ_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Requested Stand. UOM |
20 | QTY_OPEN_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Open Standard UOM |
21 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 0 |