wsiWSTransactionHeaderCreate
Table Name: WS10801
Other stored procedures called: wsiWSTransactionHeaderCreatePre, wsiWSTransactionHeaderCreatePost, taGLTransactionHeaderInsert
Description:
This procedure will insert new WS transaction header records into the WS10801 table.
| Element Name | Data Type | Length | Required | Default | Description |
|---|---|---|---|---|---|
@I_vBatchNumber | char | 15 | Yes |
| Validated |
@I_vBatchSource | char | 15 | Yes | GL_Normal' |
|
@I_vJournalEntry | int | 10 | Yes |
| Validated |
@I_vRecurringTRXSequence | numeric | 19,5 | No |
|
|
@I_vSourceDocument | char | 11 | No | GJ' | Validated |
@I_vReference | char | 31 | No | None' |
|
@I_vTRXDate | datetime |
| Yes |
| Validated |
@I_vReversingDate | datetime |
| No | 1/1/1900' |
|
@I_vRecurringTRX | tinyint | 3 | No | 0 |
|
@I_vBalanceForCalculation | smallint | 5 | No | 0 |
|
@I_vLastUser | char | 15 | No | ' |
|
@I_vLastDateEdited | datetime |
| No | 1/1/1900' |
|
@I_vTransactionType | smallint | 2 | No | 0 |
|
@I_vSequenceLine | numeric | 19,5 | No | 0 |
|
@I_vGLHDRMessages | binary | 4 | No |
|
|
@I_vGLHDRMessages2 | binary | 4 | No |
|
|
@I_vTRXSource | char | 13 | No | ' |
|
@I_vOriginatingTRXType | smallint | 5 | No | 0 |
|
@I_vOriginatingControlNumber | char | 21 | No | ' |
|
@I_vOriginatingMasterID | char | 31 | No | ' |
|
@I_vOriginatingMasterName | char | 65 | No | ' |
|
@I_vOriginatingDocumentNumber | char | 21 | No | ' |
|
@I_vOriginatingPostedDate | datetime |
| No | 1/1/1900' |
|
@I_vOriginatingTRXSource | char | 13 | No | ' |
|
@I_vCurrencyID | char | 15 | No | Z-US$' |
|
@I_vClosedYear | smallint | 5 | No | 0 |
|
@I_vHistoryTRX | tinyint | 3 | No | 0 |
|
@I_vReversingPeriodID | smallint | 5 | No | 0 |
|
@I_vReversingYear | smallint | 5 | No | 0 |
|
@I_vReversingClosedYear | smallint | 5 | No | 0 |
|
@I_vReversingHistoryTRX | tinyint | 3 | No | 0 |
|
@I_vICTRX | tinyint | 3 | No | 0 |
|
@I_vUserDefine1 | char | 31 | No | ' |
|
@I_vUserDefine2 | char | 31 | No | ' |
|
@I_vUserDefined1 | char | 21 | No | ' |
|
@I_vUserDefined2 | char | 21 | No | ' |
|
@I_vUserDefinedInteger1 | int | 10 | No | 0 |
|
@I_vUserDefinedInteger2 | int | 10 | No | 0 |
|
@I_vUserDefinedInteger3 | int | 10 | No | 0 |
|
@I_vUserDefinedInteger4 | int | 10 | No | 0 |
|
@I_vUserDefinedDollar1 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar2 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar3 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar4 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDate1 | datetime |
| No | 1/1/1900' |
|
@I_vUserDefinedDate2 | datetime |
| No | 1/1/1900' |
|
@I_vUserDefinedDate3 | datetime |
| No | 1/1/1900' |
|
@I_vUserDefinedDate4 | datetime |
| No | 1/1/1900' |
|
@I_vUserDefinedCB1 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB2 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB3 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB4 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB1 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB2 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB3 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB4 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB5 | tinyint | 3 | No | 0 |
|
@I_vWennSoftTablesOnly | tinyint | 3 | No | 0 |
|
@I_vOnlyValidate | tinyint | 3 | No | 0 |
|
@I_vUSRDEFND1 | char | 50 | No | ' |
|
@I_vUSRDEFND2 | char | 50 | No | ' |
|
@I_vUSRDEFND3 | char | 50 | No | ' |
|
@I_vUSRDEFND4 | varchar | 8000 | No | ' |
|
@I_vUSRDEFND5 | varchar | 8000 | No | ' |
|
@I_vReturnErrorText | tinyint | 1 | No | 1 |
|
@O_iErrorState | int | 10 | No | 0 |
|
@oErrString | varchar | 255 | No | ' |
|