| # |
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 |
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
|
| 4 |
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
|
| 5 |
LOAD_STATUS_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Interface Load Status
DON=Done (Complete)
ERR=Error
NEW=New
RDY=Ready
UPD=Updating
|
| 6 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 7 |
EXS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
|
| 8 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 9 |
EXS_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Rate Code
Prompt Table:
EXS_TAX_RATE
|
| 10 |
EXS_TAX_CMPNT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code
Prompt Table:
EXS_TAX_CMPNT
|
| 11 |
EXS_TAX_DEP_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Dependency Code
Prompt Table:
EXS_TAX_DPNDNCY
|
| 12 |
EXS_CALC_SCHEME |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount
P=Percentage
Q=Quantity
|
| 13 |
EXS_TAX_RATE_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Rate Percentage
|
| 14 |
EXS_TXRTAMT_TRC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Currency
|
| 15 |
EXS_CURRENCY_TRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Curreny Tax Rate
|
| 16 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 17 |
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. "
|
| 18 |
EXS_TAXRT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 19 |
EXS_TAXRT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 20 |
EXS_TAXRT_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 21 |
EXS_TAX_RATE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
Prompt Table:
UNITS_TBL
|
| 22 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 24 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 25 |
EXS_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Reporting Currency
|
| 26 |
EXS_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount
|
| 27 |
EXS_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Base Currency
|
| 28 |
EXS_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Reporting Currency
|
| 29 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 30 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 31 |
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.
|