STX_FRMAUD_TEO1

(SQL Table)
Index Back

Audit India Forms Tracking

Currency Conversion Utility temp record for India Forms Tracking

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code
4 STX_FORM_SOURCE Character(1) VARCHAR2(1) NOT NULL Form Source
B=Bill Finalization
G=IUT Good Receipts
P=AP Voucher
R=AR Items
S=IUT Shipping
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 STX_FORM_NAME Character(8) VARCHAR2(8) NOT NULL Form Name
7 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code
8 STX_FORM_DIRECTION Character(1) VARCHAR2(1) NOT NULL Form Direction
1=Buyer to Seller
2=Seller to Buyer
9 STX_TRANSACTION_ID Character(22) VARCHAR2(22) NOT NULL Form Transaction ID
10 TRANSACTION_DATE Date(10) DATE Transaction Date
11 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.
12 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. "
13 STX_FORM_NO Character(20) VARCHAR2(20) NOT NULL Form Number
14 STX_FORM_DATE Date(10) DATE Form Date
15 STX_CANCEL_DT Date(10) DATE Cancel Date
16 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code