ACTNUMST | char(75) | Yes | Account String - | IN |
ACTALIAS | char(21) | No | Account Alias | IN |
ACCTTYPE | smallint | No | Account Type - 1 = Posting & 2 = Unit Account & 3 = Posting Allocation & 4 = Unit Allocation | IN |
ACTDESCR | char(50) | No | Account Description - Will default from segment setup if not passed in | IN |
PSTNGTYP | smallint | No | Posting Type - 0 = Balance Sheet & 1 = Profit & Loss Account | IN |
CATEGORY | char(50) | Yes | Account Category - | IN |
ACTIVE | tinyint | No | Active - 0 = Inactive & 1 = Active | IN |
TPCLBLNC | smallint | No | Typical Balance - 0 = Debit and 1 = Credit | IN |
DECPLACS | smallint | No | Decimal Places - only used for Unit Accounts | IN |
FXDORVAR | smallint | No | Fixed or Variable Allocation - 1 = Fixed & 2 = Variable | IN |
BALFRCLC | smallint | No | Based On Flag - - 0 = Year to Date & 1 = Trx Period | IN |
USERDEF1 | char(20) | No | User Defined 1 | IN |
USERDEF2 | char(20) | No | User Defined 2 | IN |
PostSlsIn | smallint | No | Post Sales In - 1 = Detail & 2 = Summary | IN |
PostIvIn | smallint | No | Post Inventory In - 1 = Detail & 2 = Summary | IN |
PostPurchIn | smallint | No | Post Purchasing In - 1 = Detail & 2 = Summary | IN |
PostPRIn | smallint | No | Post Payroll In - 1 = Detail & 2 = Summary | IN |
ACCTENTR | tinyint | No | Allow Account Entry - 0 = False & 1 = True | IN |
USRDEFS1 | char(30) | No | User Defined 3 | IN |
USRDEFS2 | char(30) | No | User Defined 4 | IN |
UpdateIfExists | tinyint | No | Flag to allow Account data to be updated if it exists: 0 = No & 1 = Yes | IN |
NOTETEXT | varchar(8000) | No | Notes field | IN |
DSPLKUPSSALES | tinyint | No | Include in Lookup option for Sales: 0 = False; 1 = True | IN |
DSPLKUPSIV | tinyint | No | Include in Lookup option for Inventory Control: 0 = False; 1 = True | IN |
DSPLKUPSPURCH | tinyint | No | Include in Lookup option for Purchasing: 0 = False; 1 = True | IN |
DSPLKUPSPR | tinyint | No | Include in Lookup option for Payroll: 0 = False; 1 = True | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Create Custom Business Logic | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |