STX_FORM_AUDIT

(SQL Table)
Index Back

Audit Indian Form Track

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
2 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code
3 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
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 STX_FORM_NAME Character(8) VARCHAR2(8) NOT NULL Form Name
6 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code
7 STX_FORM_DIRECTION Character(1) VARCHAR2(1) NOT NULL Form Direction
1=Buyer to Seller
2=Seller to Buyer
8 STX_TRANSACTION_ID Character(22) VARCHAR2(22) NOT NULL Form Transaction ID
9 TRANSACTION_DATE Date(10) DATE Transaction Date
10 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.
11 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. "

Prompt Table: CURRENCY_CD_TBL

12 STX_FORM_NO Character(20) VARCHAR2(20) NOT NULL Form Number
13 STX_FORM_DATE Date(10) DATE Form Date
14 STX_CANCEL_DT Date(10) DATE Cancel Date