| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 3 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 4 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 5 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 6 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
|
| 7 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 8 |
NEXT_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Next Adjustment Line Sequence
|
| 9 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 10 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 11 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 12 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
|
| 13 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 14 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 15 |
GT_IDENTIFIER |
Character(12) |
VARCHAR2(12) NOT NULL |
New Field for Golden Tax Adapter
Prompt Table:
BI_GT_ID_VW
|
| 16 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 18 |
BI_MODEL |
Character(40) |
VARCHAR2(40) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 19 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 20 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 21 |
UNIT_CNY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price, used by GTA
|
| 22 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 23 |
GROSS_EXTENDED_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 24 |
GROSS_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended Amount Base
|
| 25 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 26 |
NET_EXTENDED_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt CNY, used by GTA
|
| 27 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount Base
|
| 28 |
TAX_DENOMINATION |
Character(4) |
VARCHAR2(4) NOT NULL |
New field for Golden Tax Adapter
Prompt Table:
BI_GTA_TX_DE_VW
|
| 29 |
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.
|
| 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 |
TAX_RATE_GTA |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Used by GTA
|
| 32 |
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.
|
| 33 |
VAT_AMT_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by GTA
|
| 34 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount Base
|
| 35 |
PRO_DSCNT_VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 36 |
PRO_DSCNT_VAT_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by GTA
|
| 37 |
PRO_DSCNT_VAT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 38 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 39 |
TOT_DISCOUNT_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 40 |
TOT_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount Base
|
| 41 |
PRO_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 42 |
PRO_DISCOUNT_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by GTA
|
| 43 |
PRO_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|
| 44 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 45 |
TOT_SURCHARGE_CNY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 46 |
TOT_SURCHARGE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount Base
|
| 47 |
IDENTIFIER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
New field for Golden Tax Adapter
N=No
Y=Yes
|
| 48 |
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
|
| 49 |
GTA_STG_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Used by GTA
CAL=Canceled
ERR=Error
GEN=Generated
IGN=Ignored
PRO=Prorated
RDY=Ready
REJ=Rejected
TRS=Transferred
Default Value: TRS
|
| 50 |
ERRORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates errors were found
N=No
Y=Yes
Default Value: N
|
| 51 |
ENTERED_DTTM |
DateTime(26) |
TIMESTAMP |
Entered Datetime
|
| 52 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 53 |
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.
|
| 54 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|