Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS20001
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS_Payables_TRX_OPEN Group Display Name: WS Shared
Physical Name: WS20001
Technical Name: WS_Payables_TRX_OPEN
Group Technical Name: WS Shared
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | WS_Job_Number ![]() | WS Job Number | STR17_LBAU | String | 18 | 17 |
2 | Job_TRX_Number ![]() | Job TRX Number | STR20 | String | 22 | 20 |
3 | APTVCHNM ![]() | Apply To Voucher Number | STR20_LBAU | String | 22 | 20 |
4 | LNSEQNBR ![]() | Line SEQ Number | Sequence_Number | Currency | 10 | 19 |
5 | CNTRLTYP ![]() | Control Type | INT1 | Integer | 2 | 1 |
6 | Product_Indicator ![]() | Product Indicator | DDL_Product_Indicator | Integer | 2 | 0 |
7 | Wennsoft_Affiliate ![]() | Wennsoft Affiliate | STR15_LBAU | String | 16 | 15 |
8 | Wennsoft_Region ![]() | Wennsoft Region | STR15_LBAU | String | 16 | 15 |
9 | Wennsoft_Branch ![]() | Wennsoft Branch | STR15_LBAU | String | 16 | 15 |
10 | Project_Number ![]() | WS Project Number | STR170 | String | 18 | 17 |
11 | Cost_Code_Number_1 ![]() | Cost Code Number:CC_Phase | STR6_CC_Phase | String | 8 | 6 |
12 | Cost_Code_Number_2 ![]() | Cost Code Number:CC_Step | STR6_CC_Steps | String | 8 | 6 |
13 | Cost_Code_Number_3 ![]() | Cost Code Number:CC_Detail | STR6_CC_Detail | String | 8 | 6 |
14 | Cost_Code_Number_4 ![]() | Cost Code Number:CC_Component | STR6_CC_Component | String | 8 | 6 |
15 | Cost_Element ![]() | Cost Element | INT3_RB0_U | Integer | 2 | 3 |
16 | WS_Cost_Code ![]() | WS Cost Code | LI8_U0 | Long Integer | 4 | 8 |
17 | WS_Other_Cost_Sub_Code ![]() | WS Other Cost Sub Code | LI8_U0 | Long Integer | 4 | 8 |
18 | Cost_Code_Description ![]() | Cost Code Description | STR30 | String | 32 | 30 |
19 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 16 | 15 |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].CUSTNMBR AS 'WS_Payables_TRX_OPEN-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['WS_Payables_TRX_OPEN'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
20 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 16 | 15 |
21 | ACTINDX ![]() | Account Index | LI_14 | Long Integer | 4 | 14 |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].ACTINDX AS 'WS_Payables_TRX_OPEN-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['WS_Payables_TRX_OPEN'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
22 | DISTTYPE ![]() | Distribution Type | DDL | Integer | 2 | 0 |
23 | DOCNUMBR ![]() | Document Number | STR20_Document_Number | String | 22 | 20 |
24 | TRXDSCRN ![]() | Transaction Description | STR30 | String | 32 | 30 |
25 | WS_Credit_Amount ![]() | WS Credit Amount | DLR14_STR | Currency | 10 | 14 |
26 | WS_Debit_Amount ![]() | WS Debit Amount | DLR14_STR | Currency | 10 | 14 |
27 | WS_Originating_Credit ![]() | WS Originating Credit | DLR14_STR | Currency | 10 | 14 |
28 | WS_Originating_Debit ![]() | WS Originating Debit | DLR14_STR | Currency | 10 | 14 |
29 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 16 | 15 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].CURNCYID AS 'WS_Payables_TRX_OPEN-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_Payables_TRX_OPEN'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
30 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].CURRNIDX AS 'WS_Payables_TRX_OPEN-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_Payables_TRX_OPEN'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
31 | Profit_Type_Number ![]() | Profit Type Number | INT2 | Integer | 2 | 2 |
32 | Profit_Amount ![]() | Profit Amount | DLR14_TS | Currency | 10 | 14 |
33 | TRXQTY ![]() | TRX QTY | DLR17_QTY_RBS0_STR | Currency | 10 | 17 |
34 | DOCDATE ![]() | Document Date | DT | Date | 4 | 8 |
35 | DOCTYPE ![]() | Document Type | DDL_Document_Type | Integer | 2 | 0 |
36 | Document_Source ![]() | Document Source | STR3 | String | 4 | 3 |
37 | GLPOSTDT ![]() | GL Posting Date | DT | Date | 4 | 8 |
38 | DOCAMNT ![]() | Document Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
39 | Job_Type ![]() | Job Type | STR7_LBAU | String | 8 | 7 |
40 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 16 | 15 |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].VENDORID AS 'WS_Payables_TRX_OPEN-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['WS_Payables_TRX_OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
41 | BACHNUMB ![]() | Batch Number | STR15_LBAU | String | 16 | 15 |
42 | BCHSOURC ![]() | Batch Source | STR15 | String | 16 | 15 |
43 | PSTGSTUS ![]() | Posting Status | INT | Integer | 2 | 0 |
44 | SPCLDIST ![]() | Specialized Distribution | INT4 | Integer | 2 | 4 |
45 | PORDNMBR ![]() | Purchase Order Number | Purchase Order Number | String | 22 | 20 |
46 | VCHNUMWK ![]() | Voucher Number - WORK | STR17_LBAU | String | 18 | 17 |
47 | Billing_Amount ![]() | Billing Amount | DLR14_RBS0_STR$ | Currency | 10 | 14 |
48 | Equipment_ID ![]() | Equipment ID | STR30 | String | 32 | 30 |
49 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 32 | 30 |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].ITEMNMBR AS 'WS_Payables_TRX_OPEN-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
IV00101 AS ['Item Master']
ON
['WS_Payables_TRX_OPEN'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
50 | ITEMDESC ![]() | Item Description | STR100 | String | 102 | 100 |
51 | Call_Invoice_Number ![]() | Call Invoice Number | STR17_LBAU | String | 18 | 17 |
52 | RTCLCMTD ![]() | Rate Calculation Method | GB | Integer | 2 | 0 |
53 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
54 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
55 | DECPLACS ![]() | Decimal Places | DDL_Decimal_Places | Integer | 2 | 0 |
56 | INTERID ![]() | Intercompany ID | STR5_IC_ID | String | 6 | 5 |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].INTERID AS 'WS_Payables_TRX_OPEN-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['WS_Payables_TRX_OPEN'].INTERID = ['Company Master'].INTERID | ||||||
57 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 15 |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].RATETPID AS 'WS_Payables_TRX_OPEN-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['WS_Payables_TRX_OPEN'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
58 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 16 | 15 |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].EXGTBLID AS 'WS_Payables_TRX_OPEN-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['WS_Payables_TRX_OPEN'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
59 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 4 | 6 |
60 | TIME1 ![]() | Time | TM6 | Time | 4 | 6 |
61 | EXPNDATE ![]() | Expiration Date | DT_Date | Date | 4 | 6 |
62 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 2 | 1 |
63 | UOFM ![]() | U Of M | U_Of_M | String | 10 | 8 |
64 | ICCURRID ![]() | ICCurrencyID | STR15_Currency_ID | String | 16 | 15 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].ICCURRID AS 'WS_Payables_TRX_OPEN-ICCurrencyID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_Payables_TRX_OPEN'].ICCURRID = ['Currency Setup'].CURNCYID | ||||||
65 | ICCURRIX ![]() | ICCurrencyIndex | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].ICCURRIX AS 'WS_Payables_TRX_OPEN-ICCurrencyIndex'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_Payables_TRX_OPEN'].ICCURRIX = ['Currency Setup'].CURRNIDX | ||||||
66 | Tax_Date ![]() | Tax Date | DT | Date | 4 | 8 |
67 | USERID ![]() | User ID | STR15_User_ID | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].USERID AS 'WS_Payables_TRX_OPEN-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_Payables_TRX_OPEN'].USERID = ['Users Master'].USERID | ||||||
68 | User_Define_1 ![]() | User Define 1 | STR30 | String | 32 | 30 |
69 | User_Define_2 ![]() | User Define 2 | STR30 | String | 32 | 30 |
70 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 22 | 20 |
71 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 22 | 20 |
72 | User_Def_Integer_1 ![]() | User Defined Integer 1 | LI6_S2 | Long Integer | 4 | 6 |
73 | User_Def_Integer_2 ![]() | User Defined Integer 2 | LI6_S2 | Long Integer | 4 | 6 |
74 | User_Defined_Integer_3 ![]() | User Defined Integer 3 | LI6_S2 | Long Integer | 4 | 6 |
75 | User_Defined_Integer_4 ![]() | User Defined Integer 4 | LI6_S2 | Long Integer | 4 | 6 |
76 | User_Defined_Dollar_1 ![]() | User Defined Dollar 1 | DLR14_RBS0_STR$ | Currency | 10 | 14 |
77 | User_Defined_Dollar_2 ![]() | User Defined Dollar 2 | DLR14_RBS0_STR$ | Currency | 10 | 14 |
78 | User_Defined_Dollar_3 ![]() | User Defined Dollar 3 | DLR14_RBS0_STR$ | Currency | 10 | 14 |
79 | User_Defined_Dollar_4 ![]() | User Defined Dollar 4 | DLR14_RBS0_STR$ | Currency | 10 | 14 |
80 | USRDAT01 ![]() | User Defined Date 1 | DT | Date | 4 | 8 |
81 | USRDAT02 ![]() | User Defined Date 2 | DT | Date | 4 | 8 |
82 | User_Defined_Date_3 ![]() | WS User Defined Date 3 | DATE | Date | 4 | 6 |
83 | User_Defined_Date_4 ![]() | WS User Defined Date 4 | DATE | Date | 4 | 6 |
84 | User_Defined_CB_1 ![]() | User Defined CB 1 | CB | Boolean | 2 | 0 |
85 | User_Defined_CB_2 ![]() | User Defined CB 2 | CB | Boolean | 2 | 0 |
86 | User_Defined_CB_3 ![]() | User Defined CB 3 | CB | Boolean | 2 | 0 |
87 | User_Defined_CB_4 ![]() | User Defined CB 4 | CB | Boolean | 2 | 0 |
88 | MODIFDT ![]() | Modified Date | DT | Date | 4 | 8 |
89 | Modified_Time ![]() | Modified Time | TM6 | Time | 4 | 6 |
90 | MDFUSRID ![]() | Modified User ID | STR15 | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['WS_Payables_TRX_OPEN'].MDFUSRID AS 'WS_Payables_TRX_OPEN-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS20001 AS ['WS_Payables_TRX_OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_Payables_TRX_OPEN'].MDFUSRID = ['Users Master'].USERID | ||||||
91 | SV_Language_ID ![]() | SV Language ID | INT2 | Integer | 2 | 2 |
92 | Time_Zone ![]() | Time Zone | STR3 | String | 4 | 3 |
93 | WSReserved_CB1 ![]() | WSReserved CB1 | CB | Boolean | 2 | 0 |
94 | WSReserved_CB2 ![]() | WSReserved CB2 | CB | Boolean | 2 | 0 |
95 | WSReserved_CB3 ![]() | WSReserved CB3 | CB | Boolean | 2 | 0 |
96 | WSReserved_CB4 ![]() | WSReserved CB4 | CB | Boolean | 2 | 0 |
97 | WSReserved_CB5 ![]() | WSReserved CB5 | CB | Boolean | 2 | 0 |
98 | WSReserved_CB6 ![]() | WSReserved CB6 | CB | Boolean | 2 | 0 |
99 | WSReserved_CB7 ![]() | WSReserved CB7 | CB | Boolean | 2 | 0 |
100 | WSReserved_CB8 ![]() | WSReserved CB8 | CB | Boolean | 2 | 0 |
101 | WSReserved_CB9 ![]() | WSReserved CB9 | CB | Boolean | 2 | 0 |
102 | WSReserved_STR1 ![]() | WSReserved STR1 | STR10 | String | 12 | 10 |
103 | WSReserved_STR2 ![]() | WSReserved STR2 | STR10 | String | 12 | 10 |