STX_FORM_REGSTR

(SQL Table)
Index Back

Stx Form Register

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STX_SER_NBR Number(18,0) DECIMAL(18) NOT NULL Serial Number
2 STX_TRANSACTION_ID Character(22) VARCHAR2(22) NOT NULL Form Transaction ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 STX_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
5 STX_FORM_NAME Character(8) VARCHAR2(8) NOT NULL Form Name
6 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
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 EXS_TAX_RATE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Tax Rate Amount
10 EXS_TAX_RATE_PCT Number(8,4) DECIMAL(7,4) NOT NULL Tax Rate Percentage
11 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code
12 STX_CST_VNDR_FLG Character(1) VARCHAR2(1) NOT NULL Customer Supplier Indicator
C=Customer
V=Supplier
13 STX_CST_VNDR_ID Character(15) VARCHAR2(15) NOT NULL Customer/Supplier ID
14 TRANSACTION_DATE Date(10) DATE Transaction Date
15 STX_TRANSACTION_RF Character(22) VARCHAR2(22) NOT NULL Transaction Referance
16 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

17 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.
18 STX_FORM_STATUS Character(1) VARCHAR2(1) NOT NULL Form Status
C=Cancel
D=Deleted
N=Closed
O=Open
19 STX_FORM_NO Character(20) VARCHAR2(20) NOT NULL Form Number
20 STX_FORM_DATE Date(10) DATE Form Date
21 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
22 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
23 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
24 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
25 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
26 DD_ID Character(15) VARCHAR2(15) NOT NULL Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
27 STX_SHIPID_REF Character(10) VARCHAR2(10) NOT NULL Shipping ID Reference
28 STX_RECEIPT_DATE Date(10) DATE Receipt Date
29 STX_RECEIPT_NBR Character(10) VARCHAR2(10) NOT NULL Receipt Number
30 SHIP_DATE Date(10) DATE Item Shipping Date
31 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
32 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
33 BUSINESS_UNIT_EXS Character(5) VARCHAR2(5) NOT NULL Excise Business Unit