CS_CT_MISC_OB

(SQL Table)
Index Back

Cntrct Header Misc Charges

3/3/08 RMK F-AHAYT-S60K7 Version control enhancement to contract entry - added version_nbr field; record is used for syndication for current contract

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 MISC_CHARGE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Prompt Table: VCHR_MISC_CD_VW

6 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
7 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Y/N Table Edit

8 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
9 LC_COMP_CALC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
FL=Flat Amt
FR=Free
FRT=Freight
STX=Sales Tax
UNT=Unit Amt
UTX=Use Tax
VAL=% Value
VAT=VAT
VOL=Volume
WT=Weight
10 LC_COMP_ALLOC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
11 LC_COMP_ON_PO Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier

Y/N Table Edit

12 CHARGE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: CNTRCT_HDR.CURRENCY_CD

14 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID

Prompt Table: SP_SETID_NONVW

15 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier

Prompt Table: VENDOR_VW1
Set Control Field: SETID

16 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location

Prompt Table: VENDOR_LOC_X_VW

17 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
18 PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate

Y/N Table Edit

19 FLAT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
20 PCT_VALUE Signed Number(9,2) DECIMAL(7,2) NOT NULL Percentage of Value
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 LC_ACCRUAL_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.

Y/N Table Edit

Default Value: N

23 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit

Y/N Table Edit

Default Value: N

24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance