| # |
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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 7 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 8 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 9 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 10 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 11 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 12 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 13 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 14 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 15 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 16 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 17 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 18 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 19 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 20 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 21 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 22 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 23 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 24 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 25 |
MAX_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
max_tax_flg = 'Y' implies that max taxes were applied
Y/N Table Edit
|
| 26 |
TAX_JUR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax jurisdiction indicator
1=Ship-To Location
2=Ship-From Location
3=Order Acceptance Location
4=Order Origin Location
|
| 27 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 28 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 29 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 30 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 31 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 32 |
EXD_INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Excise Invoice Line Number
|
| 33 |
EXD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
|
| 34 |
STX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
|
| 35 |
STX_TAX_AUTH_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Code
Prompt Table:
STX_TAX_AUTH
|
| 36 |
EXD_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Tax Calculation Code
Prompt Table:
EXS_TAX_RATE
|
| 37 |
STX_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
Prompt Table:
EXS_TAX_RATE
|
| 38 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
INV_ITEMS
|
| 39 |
ORG_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization SetID.
|
| 40 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 41 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 42 |
EXD_CONVERSION_RT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 43 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 44 |
EXS_TAX_TXN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
|
| 45 |
EXD_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Customer Category Code
Prompt Table:
EXS_TAX_CAT_VW2
|
| 46 |
STX_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Customer Category Code
Prompt Table:
EXS_TAX_CAT_VW2
|
| 47 |
EXD_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Item Category Code
Prompt Table:
EXS_TAX_CAT_VW1
|
| 48 |
STX_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Item Category Code
Prompt Table:
EXS_TAX_CAT_VW1
|
| 49 |
EXS_SERV_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax
Y=Service Tax
Y/N Table Edit
|
| 50 |
EXD_ASSESS_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Assessable Value
|
| 51 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 52 |
EXD_USE_AV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Use Av Flag
|
| 53 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 54 |
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. "
|
| 55 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
Prompt Table:
CURRENCY_CD_TBL
|
| 56 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 57 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 58 |
EXD_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty Amt In Rpt Curr
|
| 59 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 60 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 61 |
STX_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN REPORT CURR
|
| 62 |
STX_FORM_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Form Code
Prompt Table:
STX_FORM_CD_VW
|
| 63 |
LOAD_STATUS_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Interface Load Status
DON=Done (Complete)
ERR=Error
NEW=New
RDY=Ready
UPD=Updating
|
| 64 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 65 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 66 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 67 |
USETAX_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis Amount
|
| 68 |
USETAX_BASIS_AMT_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis in Base Curr
|
| 69 |
TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount (base)
|
| 70 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 71 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 72 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 73 |
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.
|