DLV_INBU_AET

(SQL Table)
 Index Back

INBU SETID State Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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. "
4 DELIVERY_OPT Character(1) VARCHAR2(1) NOT NULL 10/20/08 EGS: Created
1=Yes
2=Manual
3=No

Default Value: 3

5 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
6 FRT_BY_QTY Character(1) VARCHAR2(1) NOT NULL Freight by Order Quantity
7 FRT_BY_VALUE Character(1) VARCHAR2(1) NOT NULL Freight by Order Value
8 FRT_BY_VOL Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Volume
9 FRT_BY_WT Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Weight
10 IN_FRT_AUTO_SO Character(1) VARCHAR2(1) NOT NULL 10/29/07 EGS: Created

Y/N Table Edit

Default Value: N

11 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
12 IN_CHANGE_STATE Character(2) VARCHAR2(2) NOT NULL Allow INV Changes Thru
13 OM_CHANGE_STATE Character(2) VARCHAR2(2) NOT NULL Allow OM Changes Thru
14 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
15 RATE_DATE Date(10) DATE Exchange Rate Date
16 SETID_AUTO_NUM Character(5) VARCHAR2(5) NOT NULL Customer SetID
17 SETID_CARRIER Character(5) VARCHAR2(5) NOT NULL Carrier Setid
18 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
19 SETID_FREIGHT Character(5) VARCHAR2(5) NOT NULL Freight Terms SETID
20 SETID_FRT_SRV Character(5) VARCHAR2(5) NOT NULL Setid Freight Services
21 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
22 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
23 SETID_MST_ITEM Character(5) VARCHAR2(5) NOT NULL Master Item SETID
24 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
25 SETID_SHIP_METHOD Character(5) VARCHAR2(5) NOT NULL Ship Method SetID
26 SETID_TRFT Character(5) VARCHAR2(5) NOT NULL SETID_TRFT
27 COMPLETED_FLG Character(1) VARCHAR2(1) NOT NULL Completed
N=Not Completed
Y=Complete

Default Value: N