IU_XFER_BI_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
4 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
5 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
6 TRANS_TYPE_BI Character(4) VARCHAR2(4) NOT NULL Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
7 TRANS_TYPE_BI_SEQ Number(3,0) SMALLINT NOT NULL Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
8 CREATE_NEW_BILL Character(1) VARCHAR2(1) NOT NULL Create New Bill
9 TMP_BILL_FLG Character(1) VARCHAR2(1) NOT NULL Temporary Bill
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
12 RANGE_SELECTION_ID Character(30) VARCHAR2(30) NOT NULL Range Selection ID
13 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
14 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
15 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
16 LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
17 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
19 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
20 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
21 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
22 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
23 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num
24 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
25 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
26 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
27 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
28 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
29 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
30 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
31 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
32 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
33 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
34 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
35 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
36 SHIP_DATE Date(10) DATE Item Shipping Date
37 SHIP_TIME Time(15) TIMESTAMP Ship Time
38 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
39 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
40 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
41 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
42 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
43 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
44 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
45 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

46 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

47 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

48 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

49 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

50 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

51 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

52 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

53 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

54 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

55 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

56 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

57 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

58 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

59 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

60 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

61 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

62 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

63 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

64 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

65 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
66 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
67 PRODUCT_KIT_ID Character(18) VARCHAR2(18) NOT NULL Product Kit Number
68 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
69 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
70 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
71 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
72 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
73 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
74 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
75 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
76 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
77 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

78 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
79 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
80 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
81 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
82 CITY Character(30) VARCHAR2(30) NOT NULL City
83 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
84 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
85 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
86 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
87 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
88 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
89 COUNTY Character(30) VARCHAR2(30) NOT NULL County
90 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

91 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
92 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
93 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit