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 |