BUSINESS_UNITINV_ITEM_IDDT_TIMESTAMPSEQ_NBR0=Conversion
1=Regular
2=Mid Period
3=Simulate
4=Resimulate
5=Make Live
L=Live
S=Simulated
N=Doesn't Qualify for Purging
Y=Qualifies for Purging
Default Value: N
N=Not Posted
X=Don't Post
Y=Posted
CM_SHIPONBEHALF(SQL Table) |
Index Back |
|---|---|
Shipments on Behalf07/99 GMG CN800-9.0: Shipments on Behalf of another bu. 08/10/01 DMW : R-CMORSE-DQ7K6 / R-MSUBBA-3F5MV Performance Enhancement - add index A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP NOT NULL | Date Timestamp |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 6 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 7 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 8 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 9 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 10 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 11 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 13 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
| 14 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 15 | CM_BU_SOURCE_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 16 | CM_BU_DESTIN_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 17 | CM_COST_RUN_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Costing Run Mode
0=Conversion 1=Regular 2=Mid Period 3=Simulate 4=Resimulate 5=Make Live |
| 18 | CM_COST_MODE | Character(1) | VARCHAR2(1) NOT NULL |
07/99 GMG CN800-9.0:
L=Live S=Simulated |
| 19 | CM_PURGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Purge Okay Flag
N=Doesn't Qualify for Purging Y=Qualifies for Purging Default Value: N |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | 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 |