CM_RMATCH_COST(SQL Table) |
Index Back |
---|---|
RTV Matched Costs01/2000 GMG CN800-9.0; Returns to Vendor. This record holds the actual cost credits given and fees paid for Return To Vendor (Supplier) transactions. Rows here are from AP matching of Vendor Invoices. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID | |
3 | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line | |
4 | Number(5,0) | INTEGER NOT NULL | RTV Distribution Number | |
5 | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement | |
6 | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. | |
7 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
8 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
9 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
10 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
11 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
12 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
13 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
14 | CM_UNIT_COST_PO | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | 07/99 GMG CN800-9.0: |
15 | CM_UNIT_COST_POVO | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | 07/99 GMG CN800-9.0: |
16 | CM_UNIT_COST_VO | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | 07/99 GMG CN800-9.0: |
17 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
18 | POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted X=Don't Post Y=Posted |
19 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
20 | CM_DTTM_IN_EFFECT | DateTime(26) | TIMESTAMP | Date Timestamp |
21 | CM_DTTM_STAMP | DateTime(26) | TIMESTAMP | Date Timestamp |