STX_FORM_SOURCEB=Bill Finalization
G=IUT Good Receipts
P=AP Voucher
R=AR Items
S=IUT Shipping
BUSINESS_UNITSTX_TRANSACTION_IDSTX_TRANSID_VW(SQL View) |
Index Back |
|---|
| SELECT STX_FORM_SOURCE ,BUSINESS_UNIT , STX_TRANSACTION_ID FROM PS_STX_FORM_REGSTR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | STX_TRANSACTION_ID |
Character(22) | VARCHAR2(22) NOT NULL | Form Transaction ID |