STX_FRMAUD_TEO3(SQL Table) |
Index Back |
---|---|
Audit India Forms TrackingCurrency 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 |